public bool DeleteFlight(int flightId)
{
//flightsContext.Database.ExecuteSqlCommand("ALTER TABLE dbo.Tickets ADD CONSTRAINT Tickets_Flights FOREIGN KEY (FlightId) REFERENCES dbo.Flights (FlightId) ON DELETE SET NULL");
TicketBuisnessLogic ticketBuisnessLogic = new TicketBuisnessLogic();
Flight flightToDelet;
if (ticketBuisnessLogic.GetTickets(flightId).Count > 0)
{
try
{
ticketBuisnessLogic.DeleteTickets(flightId);
}
catch (Exception)
{
return(false);
}
flightsContext.SaveChanges();
flightToDelet = flightsContext.Flight.First(e => e.FlightId == flightId);
flightsContext.Flight.Remove(flightToDelet);
flightsContext.SaveChanges();
return(true);
}
else
{
flightToDelet = flightsContext.Flight.First(e => e.FlightId == flightId);
flightsContext.Flight.Remove(flightToDelet);
flightsContext.SaveChanges();
return(true);
}
}
public List <Passenger> ShowPassengers(int flightId)
{
TicketBuisnessLogic ticketBuisnessLogic = new TicketBuisnessLogic();
List <Ticket> tikcets = ticketBuisnessLogic.GetTickets(flightId);
var ticketsForPassangers = tikcets.Where(e => e.Status == "sold").ToList();
List <Passenger> pass = new List <Passenger>();
for (int i = 0; i < ticketsForPassangers.Count; i++)
{
int j = ticketsForPassangers[i].TicketId;
Passenger passenger = new Passenger();
passenger = flightsContext.Passengers.First(e => e.TicketId == j);
pass.Add(passenger);
}
return(pass);
}