// 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); } }