createres.aspx.cs

民航订票系统,实现自助订票,方便快捷!请大家放心下载!

			txtFltNo.Enabled=true;
			lstClass.Enabled=true;
			Cal1.Enabled=true;
		}

		private void txtCreate_Click(object sender, System.EventArgs e)
		{
			if (txtName.Text=="" || txtName.Text==null)
			{
				lblMessage.Text="Invalid user name";
				return;
			}
			string TicketNo, DateOfRes, DateOfJourney, FltNo, ClassOfRes, Name, EMail;
			int TicketConf, Status, Fare;
			try
			{
				FltNo=txtFltNo.Text.Trim();
				ClassOfRes=lstClass.SelectedItem.Text;
				Name=txtName.Text;
				DateOfRes=DateTime.Today.Date.ToShortDateString();
				DateOfJourney=Cal1.SelectedDate.ToShortDateString();
				TicketConf=0;
				Fare=Convert.ToInt32(txtFare.Text.Trim());
				dataSet11.Clear();
				sqlConnection1.Open();
				sqlDataAdapter2.SelectCommand.Parameters[0].Value=txtFltNo.Text.Trim();
				sqlDataAdapter2.SelectCommand.Parameters[1].Value=Cal1.SelectedDate.ToShortDateString();
				sqlDataAdapter2.SelectCommand.Parameters[2].Value=lstClass.SelectedItem.Text;
				sqlDataAdapter2.Fill(dataSet11, "FltStatus");
				if (dataSet11.Tables["FltStatus"].Rows.Count==0)
				{
					//fill in the flight details
					sqlDataAdapter1.Fill(dataSet11, "FltDetails");
					string strTotSeats;
					int intTotSeats;
					foreach (DataRow myRow in dataSet11.Tables["FltDetails"].Rows)
					{
						if (myRow[0].ToString().Trim().ToLower()==txtFltNo.Text.ToLower())
						{
							if(lstClass.SelectedIndex==0)
							{
								strTotSeats=myRow[6].ToString();
							}
							else
							{
								strTotSeats=myRow[7].ToString();
							}
							intTotSeats=Convert.ToInt32(strTotSeats);
							sqlDataAdapter2.InsertCommand.Parameters[0].Value=txtFltNo.Text.Trim();
							sqlDataAdapter2.InsertCommand.Parameters[1].Value=Cal1.SelectedDate.ToShortDateString();
							sqlDataAdapter2.InsertCommand.Parameters[2].Value=lstClass.SelectedItem.Text;
							sqlDataAdapter2.InsertCommand.Parameters[3].Value=intTotSeats-1;
							sqlDataAdapter2.InsertCommand.ExecuteNonQuery();
						}
					}
					//set status as avaialnle
					Status=1;
				}
				else
				{
					int val=Convert.ToInt32(dataSet11.Tables["FltStatus"].Rows[0][3]);
					if (val<=0)
					{
						Status=val-1;
					}
					else
					{
						Status=1;
					}
					sqlDataAdapter2.UpdateCommand.Parameters[0].Value=txtFltNo.Text.Trim();
					sqlDataAdapter2.UpdateCommand.Parameters[1].Value=Cal1.SelectedDate.ToShortDateString();
					sqlDataAdapter2.UpdateCommand.Parameters[2].Value=lstClass.SelectedItem.Text;
					sqlDataAdapter2.UpdateCommand.ExecuteNonQuery();
				}
				//generate a ticket number
				sqlDataAdapter3.Fill(dataSet11, "TicketNos");
				int count, maxno, ticketno;
				if (dataSet11.Tables["TicketNos"].Rows.Count>0)
				{
					maxno=Convert.ToInt32(dataSet11.Tables["TicketNos"].Rows[0][0].ToString());
					for (count=1; count < dataSet11.Tables["TicketNos"].Rows.Count; count++)
					{
						if (maxno < Convert.ToInt32(dataSet11.Tables["TicketNos"].Rows[count][0].ToString()))
							maxno=Convert.ToInt32(dataSet11.Tables["TicketNos"].Rows[count][0].ToString());
					}
				}
				else
				{
					maxno=0;
				}
				ticketno=maxno+1;
				TicketNo=Convert.ToString(ticketno);
				EMail=txtEMail.Text;
				if (EMail==null || EMail=="")
				{
					EMail="NotSpecified";
				}
				else
				{
					sqlDataAdapter4.SelectCommand.Parameters[0].Value=EMail;
					sqlDataAdapter4.Fill(dataSet11,"FreqFl");
					if (dataSet11.Tables["FreqFl"].Rows.Count==0)
					{
						//do nothing to the fare
					}
					else
					{
						int discount;
						discount=Convert.ToInt32(dataSet11.Tables["FltStatus"].Rows[0][0]);
						discount=(100-discount)/100;
						Fare=Fare-discount;
					}
				}
				sqlDataAdapter3.InsertCommand.Parameters[0].Value=TicketNo;
				sqlDataAdapter3.InsertCommand.Parameters[1].Value=FltNo;
				sqlDataAdapter3.InsertCommand.Parameters[2].Value=DateOfJourney;
				sqlDataAdapter3.InsertCommand.Parameters[3].Value=ClassOfRes;
				sqlDataAdapter3.InsertCommand.Parameters[4].Value=Name;
				sqlDataAdapter3.InsertCommand.Parameters[5].Value=EMail;
				sqlDataAdapter3.InsertCommand.Parameters[6].Value=Fare;
				sqlDataAdapter3.InsertCommand.Parameters[7].Value=Status;
				sqlDataAdapter3.InsertCommand.Parameters[8].Value=Session["usrName"].ToString();
				sqlDataAdapter3.InsertCommand.Parameters[9].Value=DateOfRes;
				sqlDataAdapter3.InsertCommand.Parameters[10].Value=TicketConf;
				sqlDataAdapter3.InsertCommand.ExecuteNonQuery();
				sqlConnection1.Close();
				lblMessage.Text="Reservation complete. Fare is US$ "+ Fare.ToString();
				txtFltNo.Text="";
				lstClass.SelectedIndex=0;
				Cal1.SelectedDate=DateTime.Today;
				txtTNo.Text="";
				txtFare.Text="";
				txtStatus.Text="";
				txtOrg.Text="";
				txtDest.Text="";
				txtDepTime.Text="";
				txtName.Text="";
				txtEMail.Text="";
				txtFltNo.Enabled=true;
				lstClass.Enabled=true;
				Cal1.Enabled=true;
				Response.Redirect("Ticket.aspx?TNo=" + TicketNo);
			}
			catch (Exception ex)
			{
				lblMessage.Text=ex.Message;
				sqlConnection1.Close();
				txtFltNo.Enabled=true;
				lstClass.Enabled=true;
				Cal1.Enabled=true;
			}

		}
	}
}