Hotel Management System

Dear All,


I am offering Hotel Management System for your Hotel Reservation, Restaurant. There are satisfied clients of this HMS using this system from 2 Years.

Hotel Management System is available for Sales in Pakistan and outside Pakistan for international Clients.

Hotel Management System with source code in C-sharp is also available in affordable price. now you can get source code and build the application by own.

Please contact
Skype: khalid.rafique84
Mobile # +923335761509
Features:

•Room Reservation

•Reservation Inquiries

•Room Services Records

•Guest/Customer Registration

•Companies Registration

•Room Registration/Settings

•Room Availability

•System Users and Roles

•Point Of Sale

•Stock Management

•Reports

  Room Rent and Taxes Report

  Services Report

  Booking By Statuses Report

  Cash Collection Report by Date

  Invoice Report Multiple

  Reservation Invoice

  Daily Sales Report By Date

  Paid Amount Report By Date

  Police Report

  Tax Reports

  Stock Report (Daily Issuances, Balance Report, Daily Purchase, Daily Cost Report

Hotel Management System .. Booking Screen

SQL Job for Backup Database MDF/Log File Detaching.. Copying and Attaching Files

SQL Job for Backup Database MDF/Log File Detaching.. Copying and Attaching Files

declare @cmdstring varchar(1000)

declare @cmdstring1 varchar(1000)

declare @BkpFromPath varchar(1000)

declare @BkpToPath varchar(1000)

declare @DbName varchar(100)

declare @i int

Set @DBName = 'CableBilling_DB' -- Database Name

Set @BkpFromPath = 'H:\LibraCables\Database\' -- DataBase Files location

Set @BkpToPath = 'H:\data11\' -- Destination Folder

Set @i = 15 -- back up Days

--

EXEC master.dbo.sp_detach_db @dbname = @DBName

set @cmdstring = 'copy '+@BkpFromPath+''+@DBName+'.mdf '+@BkpToPath+''+@DBName+'bkp'+

convert(varchar,datepart(year,getdate()))+convert(varchar,datepart(month,getdate()))+convert(varchar,datepart(day,getdate()))+'.mdf'

exec master..xp_cmdshell @cmdstring

set @cmdstring1 = 'copy '+@BkpFromPath+''+@DBName+'_log.ldf '+@BkpToPath+''+@DBName+'bkp'+convert(varchar,datepart(year,getdate()))+convert(varchar,datepart(month,getdate()))+convert(varchar,datepart(day,getdate()))+'_log.ldf'

exec master..xp_cmdshell @cmdstring1

declare @delmdfString varchar(1000)

declare @delmdfString1 varchar(1000)

WHILE @i < 50

BEGIN

    SET @i = @i + 1

  

    set @delmdfString = 'del H:\data\CableBilling_DBbkp'+convert(varchar,datepart(year,DATEADD(day,-@i,getdate())))

    +convert(varchar,datepart(month,DATEADD(day,-@i,getdate())))+convert(varchar,datepart(day,DATEADD(day,-@i,getdate())))+'.mdf'

      set @delmdfString1 = 'del H:\data\CableBilling_DBbkp'+convert(varchar,datepart(year,DATEADD(day,-@i,getdate())))

      +convert(varchar,datepart(month,DATEADD(day,-@i,getdate())))+convert(varchar,datepart(day,DATEADD(day,-@i,getdate())))+'_log.ldf'

      exec master..xp_cmdshell @delmdfString

      exec master..xp_cmdshell @delmdfString1

END

--declare @DbName varchar(100)

--declare @BkpFromPath varchar(100)

declare @PathWithFileNamemdf varchar(100)

declare @pathwithFileNameldf varchar(100)

--Set @DBName = 'CableBilling_DB'

--Set @BkpFromPath = 'H:\LibraCables\Database\'

Set @PathWithFileNamemdf = ''+@BkpFromPath+@DBName+'.mdf'

Set @pathwithFileNameldf = ''+@BkpFromPath+@DBName+'_log.ldf'

Set @DBName = @DbName

EXEC sp_attach_db @dbname = @DBName,

   @filename1 = @PathWithFileNamemdf,

   @filename2 = @pathwithFileNameldf