// Map Ticket object to TicketDbContext object
public TicketDbContext MapTicketToTicketDb(Ticket OneTicket)
{
var RouteDAL = new RouteDAL();
using (var db = new DB())
{
List <PassengerDbContext> DBTicketPassengers = new List <PassengerDbContext>();
foreach (var Passenger in OneTicket.TicketPassengers)
{
var DBPassenger = new PassengerDbContext()
{
PassengerType = Passenger.PassengerType
};
DBTicketPassengers.Add(DBPassenger);
}
;
var OneRoute = db.Routes.Find(OneTicket.TicketRoute.RouteID);
var DBTicket = new TicketDbContext()
{
TicketDuration = OneTicket.TicketDuration,
TicketPrice = OneTicket.TicketPrice,
TicketPurchaseDate = OneTicket.TicketPurchaseDate,
TicketPurchaseTime = OneTicket.TicketPurchaseTime,
OrderedBy = OneTicket.OrderedBy,
StartStation = OneTicket.StartStation,
EndStation = OneTicket.EndStation,
TicketPassengers = DBTicketPassengers,
TicketRoute = OneRoute
};
return(DBTicket);
}
}
public async Task <IEnumerable <Passenger> > GetAllPassengers()
{
using (PassengerDbContext context = new PassengerDbContext())
{
List <Passenger> passengers = await context.Passengers.ToListAsync();
return(passengers);
}
}
public async Task <Passenger> GetPassenger(int passengerId)
{
using (PassengerDbContext context = new PassengerDbContext())
{
Passenger passenger = await context.Passengers.FirstOrDefaultAsync(b => b.PassengerId == passengerId);
return(passenger);
}
}
public async Task <Passenger> Update(Passenger passengerToUpdate)
{
using (PassengerDbContext context = new PassengerDbContext())
{
Passenger passenger = context.Passengers.Update(passengerToUpdate)?.Entity;
await context.SaveChangesAsync();
return(passenger);
}
}
public async void Delete(int passengerId)
{
using (PassengerDbContext context = new PassengerDbContext())
{
Passenger booking = context.Passengers.FirstOrDefault(b => b.PassengerId == passengerId);
if (booking != null)
{
context.Passengers.Remove(booking);
await context.SaveChangesAsync();
}
}
}
public async Task <Passenger> GetPassenger(int passengerId)
{
using (PassengerDbContext context = new PassengerDbContext())
{
Passenger passenger = await context.Passengers.FirstOrDefaultAsync(b => b.PassengerId == passengerId);
if (passenger == null)
{
throw new KeyNotFoundException();
}
return(passenger);
}
}
public async Task <Passenger> Add(Passenger newPassenger)
{
using (PassengerDbContext context = new PassengerDbContext())
{
Passenger passenger = (await context.Passengers.AddAsync(newPassenger))?.Entity;
if (passenger == null)
{
throw new TaskCanceledException();
}
await context.SaveChangesAsync();
return(passenger);
}
}
