526 Project 4 CREATING AN AIRLINE RESERVATION PORTAL
This procedure will retrieve the data stored in the fltno, origin, destination, dep-
time, fareexec, farebn, and launchdate columns of the dtFltDetails table. The
retrieved data is displayed in the DataGrid1 control. This procedure will be called from the Page_Load event of the wbFrmSkyShark.aspx page.
The View Ticket Status Option
This option will enable the customer to view the status of her ticket. To view the status,the customer needs to provide the ticket number and e-mail ID. These values are then validated against the values stored in the dtReservations table in the database. If either the ticket number or the e-mail ID provided is incorrect, then a suitable error will be displayed.
You will accept the values from the customer in the txtTicketNo and txtEMail text boxes contained on Panel3. Table 22-3 lists all the controls contained in Panel3.
Table 22-3 Controls in Panel3
Control Type |
ID |
Properties Changed |
TextBox |
txtTicketNo |
None |
TextBox |
txtEMail |
None |
Button |
btnSubmit |
Text=Submit |
|
|
|
The values entered in the text boxes are validated and the corresponding result is displayed on the click of the Submit button. The code for the Click event of the Submit button is given as follows.
private void btnSubmit_Click(object sender, System.EventArgs e)
{
string strSel; int status;
strSel = “Select email, status from dtReservations where TicketNo = @TN”; SqlCommand SelComm;
SelComm = new SqlCommand(strSel, sqlConnection1); sqlDataAdapter1.SelectCommand = SelComm; sqlDataAdapter1.SelectCommand.Parameters.Add(“@TN”, SqlDbType.Char, 10).Value
= txtTicketNo.Text ;
CREATING THE CUSTOMER TRANSACTION PORTAL |
Chapter 22 |
527 |
|
|
|
|
|
SqlDataReader rdrTicket; sqlConnection1.Open();
rdrTicket = sqlDataAdapter1.SelectCommand.ExecuteReader();
if( rdrTicket.Read())
{
if( rdrTicket.GetString(0).Trim() == txtEMail.Text )
{
status = rdrTicket.GetInt32(1);
}
else
{
lblStatus.ForeColor = Color.Red ; lblStatus.Text = “Incorrect EMail ID!!”; return;
}
}
else
{
lblStatus.ForeColor = Color.Red ; lblStatus.Text = “Incorrect Ticket Number!!”; return;
}
sqlConnection1.Close(); if(status >= 0)
{
lblStatus.ForeColor = Color.Blue ; lblStatus.Text = “Your ticket is confirmed”;
}
else
{
lblStatus.ForeColor = Color.Blue ;
lblStatus.Text = “Your ticket is overbooked by “ + Convert.ToString (status);
}
}
CREATING THE CUSTOMER TRANSACTION PORTAL |
Chapter 22 |
529 |
|
|
|
|
|
else
{
lblStatus.ForeColor = Color.Red ; lblStatus.Text = “Incorrect Flight Number!!”; return;
}
sqlConnection1.Close(); if(status >= 0)
{
lblStatus.ForeColor = Color.Blue ; lblStatus.Text = “Ticket is available”;
}
else
{
lblStatus.ForeColor = Color.Blue ; lblStatus.Text = “Flight is overbooked by “ +
Convert.ToString(status);
}
}
The Confirm Reservation Option
This option will enable the customer to confirm a reservation. To do so, the customer will need to provide the ticket number and the e-mail ID, which are then validated against the values stored in the dtReservations table of the database. If either of the two values is incorrect, an appropriate error message is displayed.
You will accept the values from the customer in the txtTktNo and txtEml text boxes contained on Panel4. Table 22-5 lists various controls present on Panel4.
530 Project 4 CREATING AN AIRLINE RESERVATION PORTAL
Table 22-5 Controls in Panel4
Control Type |
ID |
Properties Changed |
TextBox |
txtTktNo |
None |
TextBox |
txtEml |
None |
Button |
btnSubmit2 |
Text=Submit |
|
|
|
These values are validated and the corresponding result is displayed on the click of the Submit button. The code for the Click event of the Submit button is given as follows.
private void btnSubmit2_Click(object sender, System.EventArgs e)
{
string strSel; bool status;
strSel = “Select email, ticketconfirmed from dtReservations where TicketNo = @TN”;
SqlCommand SelComm;
SelComm = new SqlCommand(strSel, sqlConnection1); sqlDataAdapter1.SelectCommand = SelComm; sqlDataAdapter1.SelectCommand.Parameters.Add(“@TN”,
SqlDbType.Char, 10).Value = txtTktNo.Text ;
SqlDataReader rdrTicket;
sqlConnection1.Open();
rdrTicket = sqlDataAdapter1.SelectCommand.ExecuteReader(); if( rdrTicket.Read())
{
if( rdrTicket.GetString(0).Trim() == txtEml.Text )
{
status = rdrTicket.GetBoolean(1);
}
else
{
lblStatus.ForeColor = Color.Red ; lblStatus.Text = “Incorrect EMail ID!!”; return;
}
}
CREATING THE CUSTOMER TRANSACTION PORTAL |
Chapter 22 |
531 |
|
|
|
|
|
else
{
lblStatus.ForeColor = Color.Red ; lblStatus.Text = “Incorrect Ticket Number!!”; return;
}
sqlConnection1.Close(); if(status == true)
{
lblStatus.ForeColor = Color.Blue ;
lblStatus.Text = “Your ticket has already been confirmed!!”;
}
else
{
string UpdStr;
UpdStr= “Update dtReservations set ticketconfirmed = 1 where ticketno = @TN”;
SqlCommand UpdComm;
UpdComm = new SqlCommand(UpdStr, sqlConnection1); sqlDataAdapter1.UpdateCommand = UpdComm; sqlDataAdapter1.UpdateCommand.Parameters.Add(“@TN”,
SqlDbType.Char, 10).Value = txtTktNo.Text ; sqlConnection1.Open(); sqlDataAdapter1.UpdateCommand.ExecuteNonQuery (); sqlConnection1.Close ();
lblStatus.ForeColor = Color.Blue ;
lblStatus.Text = “Your ticket has been confirmed!!”;
}
}
This finishes the code for various options.These codes are executed after the page is loaded. Therefore, I will now list the code for the Page_Load event of the wbFrmSkyShark.aspx page.
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here Panel2.Style[“left”]=”222px”;
532 |
Project 4 |
CREATING AN AIRLINE RESERVATION PORTAL |
|
|
Panel2.Style[“Top”]=”152px”; |
|
|
|
|
|
Panel3.Style[“left”]=”222px”; |
|
|
Panel3.Style[“Top”]=”152px”; |
|
|
Panel4.Style[“left”]=”222px”; |
|
|
Panel4.Style[“Top”]=”152px”; |
|
|
if(Request.QueryString.Count == 0) |
|
|
{ |
|
|
return; |
|
|
} |
|
|
else |
|
|
{ |
|
|
string param; |
|
|
param = Request.QueryString.Get(0).ToString(); |
|
|
switch(param) |
|
|
{ |
case “VNF”: Display_NewFlights(); break;
case “VTS”: Panel3.Visible = true; break;
case “VFS”: Panel2.Visible = true; break;
case “CR”: Panel4.Visible = true; break;
case “H”: break; default: break;
}
}
}