public bool InsertFlightScheduld(BO_FlightScheduld BOFlight)
{
DL_FlightScheduld dl = new DL_FlightScheduld();
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_InsertFlightScheduld", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FlightId", BOFlight.FlightId);
cmd.Parameters.AddWithValue("@Date", BOFlight.Date);
cmd.Parameters.AddWithValue("@Time", BOFlight.Time);
cmd.Parameters.AddWithValue("@SourceId", BOFlight.Source);
cmd.Parameters.AddWithValue("@DestinationId", BOFlight.Destination);
cmd.Parameters.AddWithValue("@BFare", BOFlight.BFare);
cmd.Parameters.AddWithValue("@EFare", BOFlight.EFare);
cmd.Parameters.AddWithValue("@EXFare", BOFlight.EXFare);
int result = cmd.ExecuteNonQuery();
dl.insert(BOFlight);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
public bool DeleteFlightTarrif(BOFlightTarrif BOFlight)
{
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_DeleteFlightTarrif", con.Connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", BOFlight.Id);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
con.CloseConnection();
}
return(true);
}
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 bool userinsert(Register reg)
{
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_userinsert", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", reg.FirstName);
cmd.Parameters.AddWithValue("@LastName", reg.LastName);
cmd.Parameters.AddWithValue("@MobileNo", reg.Mobile);
cmd.Parameters.AddWithValue("@Email", reg.Email);
cmd.Parameters.AddWithValue("@Address", reg.City);
cmd.Parameters.AddWithValue("@Gender", reg.Gender);
cmd.Parameters.AddWithValue("@Password", reg.Password);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
public DataTable GetAllFlightTarrifInfo()
{
AirlineConnect con = new AirlineConnect();
try
{
DataTable dt = new DataTable();
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_GetAllFlightTarrifInfo", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
public bool InsertFlightTarrif(BOFlightTarrif BOFlight)
{
DALFlightTarrif dal = new DALFlightTarrif();
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_InsertFlightTarrif", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flight", BOFlight.Flight);
cmd.Parameters.AddWithValue("@Class", BOFlight.Class);
cmd.Parameters.AddWithValue("@Seats", BOFlight.Seats);
cmd.Parameters.AddWithValue("@Fare", BOFlight.Fare);
dal.insert(BOFlight);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
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();
}
}
