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 ActionResult DeleteTickets(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
else
{
string info;
if (ticketBuisnessLogic.DeleteTickets(id))
{
return(RedirectToAction("FindTickets", "Admin", new { id }));
}
info = "Помилка";
return(RedirectToAction("InfoAndErrors", "Admin", new { info }));
}
}