public List <Airplane> GetAllPlanes()
{
using (var context = new AirportProjectDb())
{
return(context.Airplanes.ToList());
}
}
public List <FlightsArchive> GetAllArchivedFlights()
{
using (var context = new AirportProjectDb())
{
return(context.FlightsArchives.Include(s => s.Station).Include(a => a.Airplane).ToList());
}
}
public List <Airplane> GetDeparturedAirplanes()
{
using (var context = new AirportProjectDb())
{
return(context.Airplanes.Where(p => p.FlightState == FlightState.Departuring).ToList());
}
}
public List <Station> GetAllStations()
{
using (var context = new AirportProjectDb())
{
return(context.Stations.Include(a => a.Airplane).Include(s => s.NextStation).ToList());
}
}
public List <Station> GetDeparturingStations()
{
using (var context = new AirportProjectDb())
{
return(context.Stations.Where(s => s.TypeOfStation == Station.StationType.StationForDeparture).ToList());
}
}
public void AddStations(List <Station> stations)
{
using (var context = new AirportProjectDb())
{
context.Stations.AddRange(stations.ToArray());
context.SaveChanges();
}
}
public void AddStation(Station station)
{
using (var context = new AirportProjectDb())
{
context.Stations.Add(station);
context.SaveChanges();
}
}
public void UpdateAirplane(Airplane airplane)
{
using (var context = new AirportProjectDb())
{
context.Airplanes.AddOrUpdate(airplane);
context.SaveChanges();
}
}
public void AddAirplaneToArchive(FlightsArchive AirplaneArchive)
{
using (var context = new AirportProjectDb())
{
FlightsArchive fl = JsonConvert.DeserializeObject <FlightsArchive>(JsonConvert.SerializeObject(AirplaneArchive));
fl.AirplaneId = AirplaneArchive.Airplane.Id;
fl.StationId = AirplaneArchive.Station.Id;
fl.Station = null;
fl.Airplane = null;
context.FlightsArchives.Add(fl);
context.SaveChanges();
}
}
public void UpdateStations(Station[] stations)
{
using (var context = new AirportProjectDb())
{
for (int i = 0; i < stations.Length; i++)
{
if (stations[i].Airplane != null)
{
context.Airplanes.Attach(stations[i].Airplane);
}
var newStation = stations[i];
var oldStation = context.Stations.First(s => s.Id == newStation.Id);
oldStation.Airplane = newStation.Airplane;
context.Entry(oldStation).State = EntityState.Modified;
}
context.SaveChanges();
}
}
