public FlightEntity SaveFlightEntity(FlightEntity flight)
{
using (var context = new TUIAssessmentDALContext(_options))
{
context.Flights.Add(flight);
context.SaveChanges();
}
return(flight);
}
public bool RemoveFlightEntityByID(int Id)
{
var count = 0;
using (var context = new TUIAssessmentDALContext(_options))
{
var flight = context.Flights.Single(f => f.Id == Id);
if (flight != null)
{
context.Flights.Remove(flight);
count = context.SaveChanges();
}
}
return(count == 1);
}
public FlightEntity UpdateFlightEntity(FlightEntity flight)
{
using (var context = new TUIAssessmentDALContext(_options))
{
var flightInDB = context.Flights.Single(f => f.Id == flight.Id);
if (flightInDB != null)
{
flightInDB.ArrivalAirportId = flight.ArrivalAirportId;
flightInDB.DepartureAirportId = flight.DepartureAirportId;
flightInDB.Distance = flight.Distance;
flightInDB.FuelQuantity = flight.FuelQuantity;
flightInDB.TimeOfFlight = flight.TimeOfFlight;
flightInDB.Update = DateTime.Now;
}
context.SaveChanges();
}
return(GetFlightEntityByID(flight.Id));
}
