1000 Projects
<<<Classroom & Online Training's on android, Java, .Net, C, C++, Big Data Hadoop, SAP, SQL, Oracle, Sales Force>>>

Hotel Management System C#.Net & SQL CSE Final Year Project

November 15, 2011

Hotel Management System

 The ‘Hotel Management System‘ is developed to maintain the details of Customer booking information, trace the details of customer also maintain the information about the hotel room availability.

Using this project users may know all the details which is provided by the ‘Hotel Management System’. Users can view the availability of rooms and dates for booking in advance.

In the same way in this project one more user is involved he is most important person who is  able to controlling all the information and also make the  necessary changes when they raised is called ‘Administrator’ . He can do the updates and set the prices regarding the rooms and change the users name and password such type of all these things are made by the Administrator level 

        The Hotel Management System provides following features.  

1.Check In Details of Customer

2.Customer Booking Details  

3.Rooms Availability Information

4.Check Out details        

5.Searching the details of Customer.

This application is developed by using windows application in C#.Net .

Software and Hardware Requirements
 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class customer_CostomerRegistration : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmd;
SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{

}
}

protected void Button1_Click(object sender, EventArgs e)
{
if (Label1.Text == "Username is Available.")
{
if (TextBox1.Text != "" &amp;&amp; TextBox2.Text != "")
{
cmd = new SqlCommand("insert into tbl_login(uname,password,gender,email,status,type,cdate)values('"+TextBox1.Text+"','"+TextBox2.Text+"','"+DropDownList1.SelectedItem.ToString()+"','"+TextBox5.Text+"','Activate','Customer',getdate())", con);
con.Open();
int user = cmd.ExecuteNonQuery();
con.Close();
if (user == 1)
{
cmd = new SqlCommand("insert into tbl_contact(uid,country,state,city,contactno,cdate)values(" + Convert.ToInt32(GetUid(TextBox1.Text)) + ",'" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "',getdate())", con);
user = 0;
con.Open();
user = cmd.ExecuteNonQuery();
if (user == 1)
{
string s = "Your Registration successfully completed.";
Response.Redirect("~/customer/CustomerLogin.aspx?rconfirm=" + s.ToString());
}
}
}
}
else
{
Label2.Text = "The Username is already taken.Choose another Name.";
}

}

private int GetUid(string uname)
{
cmd = new SqlCommand("select uid from tbl_login where uname='" + uname.ToString() + "' and type='Customer' ", con);
con.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
int n = 0;
if (dr.Read())
{
n= Convert.ToInt32(dr[0].ToString());
}
dr.Close();
return n;
}

protected void TextBox1_TextChanged(object sender, EventArgs e)
{
cmd = new SqlCommand("select uname from tbl_login where uname='" + TextBox1.Text + "' and type='Customer' ", con);
con.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{
Label1.Text = "Username is not Available.";
Label1.BackColor = System.Drawing.Color.Red;
TextBox1.Focus();
}
else
{
Label1.Text = "Username is Available.";
Label1.BackColor = System.Drawing.Color.Green;
TextBox2.Focus();
}
dr.Close();
}
}

Software Requirements:

Operating System : Windows 2000/xp/Vista

Front End Software       :  Microsoft Visual studio 2005, C#.Net

Database              : Microsoft SQL Server 2005

Hardware Requirements:

Processor             : Pentium 4.0(1.6 GHz) and Higher

Memory               :  256 MB

Hard Disk            : 40 GB

Download Hotel Management System C#.Net & SQL CSE Final Year Project


posted in .Net Projects, C# Projects, CSE Projects, CSE Projects with Source Code, SQL Projects by Ramesh Gavva/Kasarla shanthan

Follow comments via the RSS Feed | Leave a comment | Trackback URL


‹‹‹ Payroll Management System CSE .Net Major Project With Code

Condo Management System C# SQL CSE Project With Code ›››

Custom Search

21 Comments to "Hotel Management System C#.Net & SQL CSE Final Year Project"

  1. biral vihangam wrote:

    thnks

  2. hana wrote:

    tanx.realy tanx

  3. vishakha wrote:

    its fantastic. thnx a lottt….

  4. farhana wrote:

    can any bdy tel me how to get the complte details of this project

  5. GT wrote:

    thanks for your project help

  6. kk wrote:

    Hi
    the project i downloaded does not run, can somebody assist pls

  7. EE wrote:

    thanks for u r help………..

  8. pardeep wrote:

    the project i downloaded does not run, can somebody assist pls

  9. Vaishali wrote:

    can anybody pls provide me the project on hotel management system in java .Its urgent

  10. Karua wrote:

    very nice system study. congratz ya.

  11. Karua wrote:

    hello sir, i cant find this project SQL database. Please send that details.

  12. Aathi wrote:

    useful thanks.. vaishali..this project also available in java..

  13. Visitor wrote:

    Plz provide Database script

  14. Abhinav wrote:

    This project is in vb using visual studio 2005
    Also, this project requires crystal reports, which is no longer included with the visual studio 2010..

  15. kabi wrote:

    hai can u explain me how to run this project.

  16. shivang wrote:

    thnq ………… :)

  17. gajendra wrote:

    get the project for finance management system in .net…foe windows based

  18. Shashi wrote:

    Hi sir,

    I am not able to find the project SQL could you please send me.

    Thanks

  19. peyman wrote:

    thanks for your project help

  20. vandna wrote:

    nice nd inspirational project

  21. vandna wrote:

    not bad but very bad project

Leave Your Comment

 
Copyright 2014 | Powered by 1000Projects.org | Developed by WikiHands.