the reception can get all information about specific guest. He/ she can know the guest's first name, last name, telephone, email, address, his/her
reservation room and payment statue by inserting a booking number and clicking on detail button. Also, the web site has a text boxes for enabling the reception to do update or delete the guest’s detail.
Figure 24: Guest Setting Form
Figure 25: Finding information about specific guest
Figure 26: Finding all Guests' information by clicking the all button
When the delete button is clicked message will show up to ask the user if he/she is sure that he/she want to delete, if he/she clicks Yes the delete will be done. But if he/she clicks No, nothing will be happen.
Figure 27: Confirmation Message
5.5 Log in
the administrator who is responsible for doing rooms setting. but before doing the room setting the administrator has to log in. the system has a authentication for the administrator when he/she log in will be in the home page but if he/she try to use the room setting page without log in the system will transfer him/her to the log in page.
Figure 28: Login Form
If the administrator inserts wrong username or password the system will notify the user by the mistake.
Figure 29: Log in Error Message
If the login is done successfully, the web page will transfer to the home page or to application that wanted to use before login. If the page transfer to the home page, the home page will has the name of the username and the log out.
Figure 30: Login
Report
The web site has two different types for financial report. One views the financial report for one day. And the other is viewing financial report for specific period of time.
Reminder
The web site will send an email to the guests before there check in date by two days.
Part VI Challenges
The real difficulty was that we do not know how to start with a language that we do not know anything about. We did not know if we need to write the codes or to drags things, what are the properties and features of this
language. What functions and keywords that can help in this project; such as, in printing a table of the wanted date, taking the value from the text box and uses it in functions, taking a single value from the data base(end back) and uses it in the interface (end front).
The first challenge that we faced is how to deal with ASP.net and what we shall use with a Sql server or a C#. we did a search for finding a solution to this, and most of the website shows how to write a ASP codes and Sql serveror C# codes without saying where we have to write and because Dr.Ammar talked with us in data base theory about web developer with Visual basic, we try to search this software and we find that we can use a Visual Studio that has a web site developer with ASP. But until that time we do not know where we can use the VB codes or the C# code and with
keeping search and trying we find where to put the VB or C# codes.
After that we keep searching about VB and C# to decide which support language we are going to choose. We have tried some codes with VB and C#
and the first one that worked with us which is the VB we have depended it.
The most important step is how to connect the web with the data base (Sql server). We found the following way:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\ MymdbFile.mdb;User ID=Admin;JetOLEDB:Database Password=You'rePassword;
Most of the web site used this which is for Microsoft Access while our project is Sql server data base. For that, we search for a compatible provider with Sql server. We have tried this providers OraOLEDB.Sql server and SQLOLEDB but the solution was OraOLEDB.Sql server.1 but even with this we got an error and we found the solution that we have to add a reference in config page. YouTube showed as how to add this reference which is a System.Data.Sql serverClinet.
Most big challenge is the date. We need the date for inserting check in date
and check out date to find the available room. And the problem was when we insert the date by using the calendar extender, the date is inserted as mm/dd/yyyy, while the Sql server accepts it as yyyy/mm/dd. the first solution came to our mind to do conversion to the text box’s value from string to date. We have used this following code
Date.FromOADate(Val(txtStartDate.Text)
The insertion works well with this codes but when we do the comparing between the current date and this conversion date, it does not work well.
After a weeks, we find that we got another problem which is this conversion converse the date to 1900 year not as the current year. So we try to find another solution; such as,
Date.FromFileTimeUtc(Val(TextEndDate.Text)
and even this has same problem as the first one. After long searching, we found two solutions for this problem. One is that we can change the format of the date by using the form attribute in the calendar extender. This can be shown in the following codes
<asp:CalendarExtenderID="CalendarExtender1"
TargetControlID="txtStartDate"
runat="server" Format="yyyy/MM/dd"
OnClientDateSelectionChanged="checkDate" />
the other solution is putting a commend like date_to inside the insertion the following codes clarify this commend:
INSERT INTO booking (CHECKIN) VALUES (TO_DATE('12/31/2001','YYYY/MM/DD’)
In our project we have chose the first solution which is with calendar extender.
The other challenge is how to transfer form one page to another page without losing specific value or with transfer specific value form one page to other page. After searching, we found that Microsoft has several solutions to this problem and our chose was by using the session.
Session("field88") = txtStartDate.Text
one of the most important challenges is how to generate data from the data base to the interface. (in the grid view).
We did not know exactly what feature in ASB and VB can help us. With searching we found that we can use the data set but how we can write the SQL commend. The solution was by using a variable with type
OleDbCommand.
In our data some field most not is null. So, when we insert the data from the interface to the data base we must check if the text box that is going to insert to these field is null or not. One of the solutions that we have tried is
Dim c As Control
For Each c In form1.Controls If c.Text = String.Empty Then
MsgBox("Please Enter the " &c.Name, MsgBoxStyle.Information, "Note") c.Focus()
End If Next
With the above code the web will check all text box even if there is no need to check. Also, we have tried these
CheckIn.Text<>vbNullString CheckIn.Text.Length = 0
and the solution was If TextBox2.Text = "".
For completing our data in data base we have to get some single value from the data base to the inter face. Then, applies it in some function or
commend to insert it a gain in different field. For example, when we want to calculate the total cost we have to get the price from the data base to the VB. First we used an ExecuteScalar (); but it does not work with us. So, we have tried to solve the problem with the data set. The following codes is the used solution;
price = myDataSet.Tables("R").Rows(0).Item("Rprice")
Part VII Conclusion
The ability to search about specific information or detail before and after doing hotel reservation or to organize hotel's room in easy way with customizing customer detail and checking the valid credit card are some
purpose to build system which makes dealing with these requirement possible with easy and fast way. Hotel management system is built to find
suitable solution for reservation and customization of rooms, customers, payments and credit cards. This system deal with the database as a end back which based on Sql server and its interface based on ASP and Visual basic. The interface aims to make reservation and using other tools easy to
every one without needing to learn how to use. The Sql serverhas the responsibility of checking valid credit card, exist of customer ID , finding
the available room .
CODING
5. CODING
public partial class Default2 : System.Web.UI.Page {
int k= 0,l=0;
protected void Page_Load(object sender, EventArgs e) {
}
protected void TextBox1_TextChanged(object sender, EventArgs e) {
}
protected void TextBox3_TextChanged(object sender, EventArgs e) {
protected void TextBox4_TextChanged(object sender, EventArgs e) {
}
protected void Button2_Click(object sender, EventArgs e) {
}
protected void RadioButton1_CheckedChanged(object sender, EventArgs e) {
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) {
}
protected void CheckBox1_CheckedChanged(object sender, EventArgs e) {
l = l + 1;
}
String constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button1_Click(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
Label9.Text = "user";
cmd.CommandText = "select Loginname from Login";
SqlDataAdapter da = new SqlDataAdapter();
if (ds.Tables["emp"].Rows[i]["Loginname"].ToString() == TextBox2.Text) {
cmd.CommandText = "insert into
Login(Loginname,Password,Name,Gender,Location,Phno,Type) values('" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox1.Text + "','" +
RadioButtonList1.Text + "','" + DropDownList1.Text + "','" + TextBox4.Text + "','" + Label9.Text + "')";
}
protected void TextBox2_TextChanged1(object sender, EventArgs e) {
}
protected void TextBox5_TextChanged(object sender, EventArgs e) {
public partial class login : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) {
}
protected void Button2_Click(object sender, EventArgs e) {
}
protected void TextBox2_TextChanged(object sender, EventArgs e) {
}
protected void TextBox1_TextChanged(object sender, EventArgs e) {
}
String constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button2_Click1(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "select Loginname,Type from Login where Loginname='" + TextBox1.Text + "'and Password='" + TextBox2.Text + "'and
Type='"+DropDownList1.Text+"'";
Session["Loginname"] = ds.Tables["emp"].Rows[0]["Loginname"].ToString();
Response.Redirect("Home.aspx");
using System.Collections;
public partial class MasterPage : System.Web.UI.MasterPage {
protected void Page_Load(object sender, EventArgs e) {
protected void Menu2_MenuItemClick(object sender, MenuEventArgs e) {
}
protected void LinkButton2_Click(object sender, EventArgs e) {
Session["Type"] = null;
Response.Redirect("login.aspx");
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e) {
}
protected void Menu3_MenuItemClick(object sender, MenuEventArgs e) {
}
protected void Linkbutton1_Click(object sender, EventArgs e) {
Session.RemoveAll();
Response.Redirect("Home.aspx");
}
public partial class Default2 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
String constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button1_Click1(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "insert into
Ticketbooking(Passengername,Flightname,Sourcestation,Destinationstation,Numberofpa ssengers) values('" + Session["Loginname"] + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + DropDownList3.Text + "','"+DropDownList4.Text+"')";
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = cmd;
int i = cmd.ExecuteNonQuery();
cmd.CommandText = "update Scheduling set
Seats=Seats-'"+DropDownList4.Text+"' where FlightName='" + DropDownList1.Text +
"'";
protected void Button2_Click(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "select Ticketno from Ticketbooking where PassengerName='" + Session["Loginname"] + "'";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "emp");
if (ds.Tables["emp"].Rows.Count!=0 )
{
public partial class Default2 : System.Web.UI.Page {
String constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button1_Click(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "select Numberofpassengers from Ticketbooking where Ticketno='" + TextBox2.Text + "'";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "emp");
int a = Convert.ToInt16(ds.Tables["emp"].Rows[0]["Numberofpassengers"]);
cmd.CommandText = "delete from Ticketbooking where Passengername='" + Session["Loginname"] + "'and Flightname='" + DropDownList1.Text + "' and Ticketno='" + TextBox2.Text + "'";
int i = cmd.ExecuteNonQuery();
da.DeleteCommand = cmd;
if (i == 1) {
cmd.CommandText = "update scheduling set Seats=Seats+'"+a+"' where Flightname='" + DropDownList1.Text + "'";
int j = cmd.ExecuteNonQuery();
using System.Data;
public partial class Default3 : System.Web.UI.Page {
string constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button1_Click(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand(); TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text +
"','" + TextBox5.Text + "','" + TextBox6.Text + "')";
SqlDataAdapter da = new SqlDataAdapter();
Label7.Text = "not added";
}
con.Close();
} }
Timings.aspx
public partial class Default3 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) {
GridView1.Visible = true;
}
protected void Button1_Click1(object sender, EventArgs e) {
} }
Scheduling.aspx
public partial class Default2 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) {
Response.Redirect("AddnewFlight.aspx");
} }
customerlist.aspx
public partial class Default3 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) {
public partial class Default3 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
String constring =
ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
protected void Button1_Click1(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "insert into Feedback(Name,Email,Subject,Message) values('"
+ TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text +
"')";
TESTING
6. TESTING
SYSTEM TESTING
Testing is a set of activities that can be planned in advance and conducted systematically. The proposed system is tested in parallel with the software that consists of its own phases of analysis, implementation, testing and maintenance. Following are the tests conducted on the system.
UNIT TESTING:
During the implementation of the system each module of the system was tested separately to uncover errors with in its boundaries. User interface was used as a guide in the process.
MODULE TESTING
A module is composed of various programs related to that module. Module testing is done to check the module functionality and interaction between units within a module.
It checks the functionality of each program with relation to other programs within the same module. It then tests the overall functionality of each module.
INTEGRATION TESTING
Integration testing is a systematic technique for constructing the program structure while conducting tests to uncover errors associated with interfacing. The objective is to take unit-tested module and build a program structures that has been dictated by design.
ACCEPTANCE TESTING
The software has been tested with the realistic data given by the client and produced fruitful results. The client satisfying all the requirements specified by them has also developed the software within the time limitation specified. A demonstration has been given to the client and the end-user giving all the operational features.
IMPLEMENTATION PHASE
The implementation is the final and important phase. It involves user training, system testing and successful running of the developed system. The users test the developed system when changes are made according to the needs. The testing phase involves the testing of the developed system using various kinds of data. An elaborate testing of data is prepared and system is tested using the tests data.
Implementation is the stage where theoretical design turned into a working system. Implementation is planed carefully to propose system to avoid unanticipated problems. Many preparations involved before and during the implementation of proposed system. The system needed to be plugged in to the organization’s network then it could be accessed from anywhere, after a user logins into the portal. The tasks that had to be done to implement the system were to create the database tables in the organization database domain. Then the administrator was granted his role so that the system could be accessed.
The next phase in the implementation was to educate the system. A demonstration of all the functions that can be carried out by the system was given to examination department person, who will make extensive use of the system.
CONCLUSION
8.CONCLUSION
Getting accurate information about what visas or permits you need is an important part of preparing for a trip or stay abroad. To help you with this task we have provided
information about embassies and consulates abroad, and we have also included companies that provide visa and passport services.
We offer documentation processing, application & filing services for those interested in applying for a visa.A strong research team ensures that cases are evaluated and processed as per the latest updated rules and regulations.
BIBILOGRAPHY
10. BIBILOGRAPHY
References:
SOFTWARE ENGINEERING - By Roger’s.Pressman
SQL FOR PROFESSIONALS - ByJain
ASP.NET with C# - By Wrox Publications
MSDN 2002 - By Microsoft
Websites:
1. www.support.microsoft.com 2. www.asp.net
3. www.w3schools.com 4. www.freetutes.com