public void PrintTicket() { BO_Booking BalObj = (BO_Booking)Session["PrintObj"]; lblClass.Text = BalObj.Class; lblDate.Text = BalObj.DepartureDate.ToShortDateString(); lblDestination.Text = BalObj.Destination; LblFlightName.Text = BalObj.FlightName; lblFlightNumber.Text = BalObj.FlightNumber; lblNoofPassangers.Text = BalObj.NoOfPassangers.ToString(); lblSeatNo.Text = "10C"; lblSource.Text = BalObj.Source; lblTicketNo.Text = BalObj.TicketNo; lblTotalAmount.Text = BalObj.AmountPayable.ToString(); lblTime.Text = BalObj.Departuretime; }
public bool BookTickets(BO_Booking BalObj) { DAL_BookedTicket DalObj = new DAL_BookedTicket(); AirlineConnect con = new AirlineConnect(); try { con.GetConnection(); SqlCommand cmd = new SqlCommand("usp_BookTicket", con.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FlightId", BalObj.FlightId); cmd.Parameters.AddWithValue("@FlightName", BalObj.FlightName); cmd.Parameters.AddWithValue("@FlightNumber", BalObj.FlightNumber); cmd.Parameters.AddWithValue("@Date", BalObj.DepartureDate); cmd.Parameters.AddWithValue("@Time", BalObj.Departuretime); cmd.Parameters.AddWithValue("@SourceId", BalObj.Source); cmd.Parameters.AddWithValue("@DestinationId", BalObj.Destination); cmd.Parameters.AddWithValue("@Class", BalObj.Class); cmd.Parameters.AddWithValue("@Passangers", BalObj.NoOfPassangers); cmd.Parameters.AddWithValue("@Amount", BalObj.AmountPayable); cmd.Parameters.AddWithValue("@TicketNo", BalObj.TicketNo); cmd.Parameters.AddWithValue("@UserId", BalObj.UserId); DalObj.insert(BalObj); int result = cmd.ExecuteNonQuery(); if (result == 1) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } finally { con.CloseConnection(); } }
public void insert(BO_Booking Flig) { DAL(); try { MongoCollection <BO_FlightScheduld> collection = emptbl.GetCollection <BO_FlightScheduld>("BookedTicket"); BsonDocument citycol = new BsonDocument { { "FlightName", Flig.FlightName }, { "FlightNumber", Flig.FlightNumber }, { "Date", Flig.DepartureDate }, { "Time", Flig.Departuretime.ToString() }, { "Source", Flig.Source }, { "Destination", Flig.Destination.ToString() }, { "Passangers", Flig.NoOfPassangers.ToString() }, { "Class", Flig.Class.ToString() }, { "Amount", Flig.AmountPayable.ToString() }, { "TicketNo", Flig.TicketNo.ToString() } }; collection.Insert(citycol); } catch { }; }
public bool CancelTicket(BO_Booking BoObj) { AirlineConnect con = new AirlineConnect(); try { con.GetConnection(); SqlCommand cmd = new SqlCommand("usp_CancelTicket", con.Connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TicketNo", BoObj.TicketNo); cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { con.CloseConnection(); } return(true); }
public DataSet GetFlightInfo(BO_Booking BalObj) { AirlineConnect con = new AirlineConnect(); try { DataSet ds = new DataSet(); con.GetConnection(); SqlCommand cmd = new SqlCommand("usp_FlightInfoForBook", con.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FlightId", BalObj.FlightId); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } finally { con.CloseConnection(); } }
public DataTable GetUpdateData(BO_Booking BALObj) { AirlineConnect con = new AirlineConnect(); try { DataTable dt = new DataTable(); con.GetConnection(); SqlCommand cmd = new SqlCommand("usp_GetBookedTickts", con.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", BALObj.UserId); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(dt); } catch (Exception ex) { throw ex; } finally { con.CloseConnection(); } }