public void Init_Data() { using (TUIWebAppEntities dbContext = new TUIWebAppEntities()) { using (DbContextTransaction dbContextTransaction = dbContext.Database.BeginTransaction()) { flightsList = dbContext.PopulateFlights(); dbContextTransaction.Commit(); } } }
public void Dump_Data() { using (TUIWebAppEntities dbContext = new TUIWebAppEntities()) { if (flightsList != null) { dbContext.DumpFlight(flightsList); } dbContext.SaveChanges(); } }
/// <summary> /// Remove test data from database /// </summary> /// <param name="dbContext"></param> /// <param name="listeFlight"></param> public static void DumpFlight(this TUIWebAppEntities dbContext, List <Flight> listeFlight) { List <Flight> listToDelete = new List <Flight>(); listeFlight.ForEach(l => { Flight fl = dbContext.Flights.FirstOrDefault(elt => elt.Id == l.Id); if (fl != null) { listToDelete.Add(fl); } }); dbContext.Flights.RemoveRange(listToDelete); dbContext.SaveChanges(); }
/// <summary> /// Populate some flighs in database /// </summary> /// <param name="dbContext"></param> /// <returns></returns> public static List <Flight> PopulateFlights(this TUIWebAppEntities dbContext) { List <Flight> flights = dbContext.Flights.ToList(); flights.Add(new Flight { DepartureAirport_Id = 1, DestinationAirport_Id = 20, FlightDistance = 1000, AirCratfFuelComsumpDistance = 1200, FlightTime = 1, TakeOffEffort = 100, FuelNeeded = 200 }); flights.Add(new Flight { DepartureAirport_Id = 4, DestinationAirport_Id = 8, FlightDistance = 1500, AirCratfFuelComsumpDistance = 1000, FlightTime = 1, TakeOffEffort = 110, FuelNeeded = 250 }); flights.Add(new Flight { DepartureAirport_Id = 1, DestinationAirport_Id = 6, FlightDistance = 1200, AirCratfFuelComsumpDistance = 1300, FlightTime = 1, TakeOffEffort = 120, FuelNeeded = 220 }); flights.Add(new Flight { DepartureAirport_Id = 4, DestinationAirport_Id = 11, FlightDistance = 900, AirCratfFuelComsumpDistance = 1400, FlightTime = 1, TakeOffEffort = 90, FuelNeeded = 210 }); dbContext.Flights.AddRange(flights); dbContext.SaveChanges(); return(flights); }