public DataTable GetDataBySD(BO_FlightScheduld BALObj)
{
AirlineConnect con = new AirlineConnect();
try
{
DataTable dt = new DataTable();
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_GetDataBySD", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SourceId", BALObj.Source);
cmd.Parameters.AddWithValue("@DestinationId", BALObj.Destination);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
//UpdateAccountGroup
public bool UpdateFlightScheduld(BO_FlightScheduld BOFlight)
{
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_UpdateFlightScheduld", 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);
cmd.Parameters.AddWithValue("@Id", BOFlight.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
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 void insert(BO_FlightScheduld Flig)
{
DAL();
try
{
MongoCollection <BO_FlightScheduld> collection = emptbl.GetCollection <BO_FlightScheduld>("FlightScheduld");
BsonDocument citycol = new BsonDocument {
{ "Flight", Flig.FlightId },
{ "Date", Flig.Date },
{ "Time", Flig.Time },
{ "Source", Flig.Source.ToString() },
{ "Destination", Flig.Destination },
{ "BFare", Flig.BFare.ToString() },
{ "ExFare", Flig.EXFare.ToString() },
{ "EcFare", Flig.EFare.ToString() }
};
collection.Insert(citycol);
}
catch { };
}
public bool DeleteFlightScheduld(BO_FlightScheduld BOFlight)
{
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_DeleteFlightScheduld", con.Connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", BOFlight.Id);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
con.CloseConnection();
}
return(true);
}
