public IReadOnlyCollection <City> GetAll()
{
using (var ctx = new BusTransportationContext())
{
return(ctx.Cities.ToList());
}
}
public void Create(Destination model)
{
using (var ctx = new BusTransportationContext())
{
ctx.Destinations.Add(model);
ctx.SaveChanges();
}
}
public void Create(City model)
{
using (var ctx = new BusTransportationContext())
{
ctx.Cities.Add(model);
ctx.SaveChanges();
}
}
public Trip GetById(int id)
{
using (var ctx = new BusTransportationContext())
{
var trip = ctx.Trips.Include(x => x.Passengers).Include(x => x.Bus).First(x => x.Id == id);
return(trip);
}
}
public IReadOnlyCollection <Trip> GetAll()
{
using (var ctx = new BusTransportationContext())
{
var trips = ctx.Trips.Include(x => x.Passengers).Include(x => x.Driver);
return(trips.ToList());
}
}
public void PutPassangerOnTrip(int tripId, int passengerId)
{
using (var ctx = new BusTransportationContext())
{
var trip = ctx.Trips.First(x => x.Id == tripId);
trip.Passengers.Add(ctx.Passengers.First(x => x.Id == passengerId));
ctx.SaveChanges();
}
}
public void PutDriverOnTrip(int tripId, int driverId)
{
using (var ctx = new BusTransportationContext())
{
var trip = ctx.Trips.First(x => x.Id == tripId);
trip.DriverId = driverId;
ctx.SaveChanges();
}
}
