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();
}
}
