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