public void AddNewAirport(Airport airport)
{
using (var context = new SkySkannerContext())
{
context.Airports.Add(airport);
context.SaveChanges();
}
}
public void AddNewPlaneModel(PlaneModel planeModel)
{
using (var context = new SkySkannerContext())
{
context.PlaneModels.Add(planeModel);
context.SaveChanges();
}
}
public void AddNewAirConnection(AirConnection airConnection)
{
using (var context = new SkySkannerContext())
{
context.AirConnections.Add(airConnection);
context.SaveChanges();
}
}
public Airport GetAirportByName(string airportName)
{
var airport = new Airport();
using (var context = new SkySkannerContext())
{
airport = context.Airports.FirstOrDefault(x => x.Name == airportName);
}
return(airport); //może dać nulla!
}
public PlaneModel GetPlaneModelByName(string planeModelName)
{
PlaneModel planeModel = new PlaneModel();
using (var context = new SkySkannerContext())
{
planeModel = context.PlaneModels.FirstOrDefault(x => x.Name.Equals(planeModelName));
}
return(planeModel); //ten planeModel może być nullem, jeśli zostanie podany nieistniejący w bazie parametr planeModelName
}
public List <AirConnection> GetListOfExsistingAirConnections()
{
List <AirConnection> listOfAirConnections;
using (var context = new SkySkannerContext())
{
listOfAirConnections = context.AirConnections.ToList();
}
return(listOfAirConnections);
}
public AirConnection GetAirConnectionById(int id)
{
AirConnection airConnection;
using (var context = new SkySkannerContext())
{
airConnection = context.AirConnections.FirstOrDefault(x => x.Id == id);
}
return(airConnection);
}
public void DeleteAirConnectionById(int id)
{
using (var context = new SkySkannerContext())
{
//Podawane jest po Id, a nie jako obiekt, bo jest to robione w osobnym połączeniu (usingu)
//i DB może się po drodze zmienić.
var airConnection = context.AirConnections.First((x => x.Id == id));
context.AirConnections.Remove(airConnection);
context.SaveChanges();
}
}
