1000 Projects

Join Internshala Certified Online Trainings with Live Projects on Web Development, VLSI, Java, .NET, Hacking, Robotics & more

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

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

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
 

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 != "" && 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


The following two tabs change content below.
Hi, We kasarla shanthan and Ramesh Gavva graduated Btech from VTU / JNTU & former employees of Infrotrack / Wipro Technologies . We basically interested on web development from the graduation period. We are interested to write blogs on Projects and technology. By that initiation we created several websites including 1000projects.org. Our Hobbies are poetry, reading books, story writing writing, and web development.

Latest posts by Kasarla shanthan/Ramesh Gavva (see all)



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

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

Custom Search

18 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

Leave Your Comment

 
Powered by 1000Projects.org , All rights Reserved, Copyright Policy