private void btnBook_Click_1(object sender, RoutedEventArgs e)
{
foreach (var customer in Reservation.Customers)
{
if (string.IsNullOrEmpty(customer.SeatNumber))
{
MessageBox.Show("Please assign seats to all passengers");
return;
}
}
foreach (var customer in Reservation.Customers)
{
ReservationTicket resTicket = new ReservationTicket();
resTicket.PassengerId = customer.Id;
//resTicket.MealId = customer.MealPreference.Id;
resTicket.SeatId = Reservation.Seats.Where(p => p.SeatNumber == customer.SeatNumber).Single().Id;
resTicket.PricePaid = Reservation.SelectedFlightLeg.Fare;
resTicket.FlightLegId = Reservation.SelectedFlightLeg.Id;
customer.Ticket = resTicket;
new FlightManager().BookTicket(customer.Id, resTicket);
}
NavigationService.Navigate(new OrderSummaryPage(Reservation));
}
public void BookTicket(int customerId, ReservationTicket ticket)
{
new AirlineRepository().BookTicket(customerId, ticket);
}
public void BookTicket(int customerId, ReservationTicket ticket)
{
using (var context = new Model1Container())
{
if (ticket.MealId == 0)
{
ticket.MealId = 1;
}
var cusomter = context.Passengers.Where(p => p.Id == customerId).Single();
var ticket_table = new Ticket
{
IsCancelled = false,
MealId = ticket.MealId,
PricePaid = ticket.PricePaid,
SeatId = ticket.SeatId,
TicketedTime = DateTime.Now,
PassengerId = customerId
};
ticket_table.Meal_Preference = new Meal_Preference { Id = ticket.MealId, MealType = "Veg" };
cusomter.Tickets.Add(ticket_table);
var seat = context.Fligt_Leg_Seat_Assignment.Where(p => p.Id == ticket.SeatId).Single();
seat.IsAvailable = false;
var flightLeg = context.Flight_Leg.Where(p => p.Id == ticket.FlightLegId).Single();
flightLeg.AvailableSeats = flightLeg.AvailableSeats - 1;
context.SaveChanges();
}
}
