RE: Mobile Phone Based Attendance Tracking System
November 15, 2011 by Thousand Projects
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();
}
}
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
‹‹‹ Payroll Management System CSE .Net Major Project With Code
Condo Management System C# SQL CSE Project With Code ›››
Custom Search
biral vihangam wrote:
thnks
Link | December 7th, 2011 at 11:50 am
hana wrote:
tanx.realy tanx
Link | June 1st, 2012 at 11:05 am
vishakha wrote:
its fantastic. thnx a lottt….
Link | June 21st, 2012 at 8:07 am
farhana wrote:
can any bdy tel me how to get the complte details of this project
Link | July 8th, 2012 at 11:58 am
GT wrote:
thanks for your project help
Link | August 26th, 2012 at 8:22 am
kk wrote:
Hi
the project i downloaded does not run, can somebody assist pls
Link | September 11th, 2012 at 2:40 pm
EE wrote:
thanks for u r help………..
Link | September 27th, 2012 at 1:04 pm
pardeep wrote:
the project i downloaded does not run, can somebody assist pls
Link | December 10th, 2012 at 10:52 am
Vaishali wrote:
can anybody pls provide me the project on hotel management system in java .Its urgent
Link | January 20th, 2013 at 2:16 am
Karua wrote:
very nice system study. congratz ya.
Link | March 2nd, 2013 at 7:55 am
Karua wrote:
hello sir, i cant find this project SQL database. Please send that details.
Link | March 2nd, 2013 at 7:59 am
Aathi wrote:
useful thanks.. vaishali..this project also available in java..
Link | April 5th, 2013 at 9:51 am
Visitor wrote:
Plz provide Database script
Link | April 16th, 2013 at 6:31 am