Today, am posting a demo version of a Hotel Management System. This software is a demo version of a complete Hotel Management System developed by Kinsware Technologies.
The Software is a windows desktop program developed with .Net Framework 3.5 and SQL Server Express 2005.
Features Includes:
Checking in of guests
Checking our of guests
Room Administration
User Access Control/Authentication (Available in the full version)
Reporting System (Available in the full version )
Bill Printing (Available in the full version)
Room Monitoring
Guest check out reminder( Available in the full version)

System Requirement

SQL Server Express ( This and .Net Framework 3.5 will be installed upon running of the installer file, provided it is not installed already).
.Net Framework 3.5
Windows Operating System (This system was tested using windows 7 please share your experience on other version of Windows at the comment section. ).
How to Install

Download and run the Hotel Management System installer file. If you do not have SQL SERVER Express 2005 installed already, the installer file should help you download and install it (Note that you need an active internet connection for this to be successful).
Once everything is ok (i.e. if everything is installed) including the Hotel Management System, Browse to your C:\ProgramData\Kinsware Technologies\Hotel Management System and ensure the file named HotelReserveDB.mdf and HotelReserveDB.ldf are both there.
To confirm your SQL Server data directory
Open cmd. From the Start menu, click All Programs, Accessories, Command Prompt.
Open a connection to a local SQL Server Express instance by typing or copying the following command into the command line:




SQLCMD -S (local)\sqlexpress -E



Press Enter.
At the prompt, type or copy the following commands.


select physicalname from sys.databasefiles where name = 'master'
go



This query returns the location of the file master.mdf, confirming the SQL Server data directory where you will place the HotelReserveDB.mdf database files.
To attach HotelReserveDB.mdf to your SQL Server
At the 1> prompt, call the spattachdb stored procedure to attach the HotelReserveDB database in the data directory determined in the previous step. Type or copy and paste the following statement into the command window (the statement must not have line breaks).

exec spattachdb @dbname=N'AdventureWorks', @filename1=N'C:\ProgramData\Kinsware Technologies\Hotel Management ', @filename2=N'C:\ProgramData\Kinsware Technologies\Hotel Management '


Type go.
Press ENTER. You may see a series of messages about converting and upgrading the database.



To verify HotelReserveDB is attached

.Run this command:
select name from sys.databases
Type go.
Press ENTER.
If the HotelReserveDB is listed, then the database is attached.
Type Exit to exit.
Modifying the connection string
Browse to C:\Program Files and grant your username a full control access. (If you don't know how to do this, please browse around the web to find out as I have not written any post concerning this yet).
Browse to C:\Program Files\Kinsware Technologies\Hotel Management System (Demo)
Look for a file named "Hotel Reservation System.exe.config" and open it with notepad.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="HotelReservationSystem.Properties.Settings.HotelReserveDBConnectionString"
connectionString="Data Source=USER-PC\SQLEXPRESS;Initial Catalog=HotelReserveDB;Integrated Security=True;Pooling=False"
providerName="System.Data.SqlClient" />

</connectionStrings>
</configuration>

Replace the underlined with your computer's name. We are assuming your sql instance name is SQLEXPRESS.
If your SQL server instance name is different, replace the SQLEXPRESS with your SQL Server Instance name.
Once this is done, Press Ctrl+S to save (Note that you need Admin right to perform this operation).
Now open the Hotel Management System Application and start using it.
That's it, if you encounter any problem while going through this process, please talk about it at the comment section, thanks and God bless you!
Screen Shots




















Warning: This computer program is protected by copyright law and international treaties. Unauthorized reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under the law.

Last edited Nov 27, 2014 at 11:00 AM by Kelvinkins, version 1