public ActionResult Delete(int id) { //try { Reservation res = _context.Reservation.Find(id); List <PetReservation> petRes = _context.PetReservation.Where(pr => pr.ReservationId == id).ToList(); List <PetReservationService> servs = new List <PetReservationService>(); foreach (var item in petRes) { List <PetReservationService> servsTemp = _context.PetReservationService.Where(prs => prs.PetReservationId == item.PetReservationId).ToList(); foreach (var serv in servsTemp) { servs.Add(serv); } } List <Medication> meds = new List <Medication>(); foreach (var item in petRes) { List <Medication> medsTemp = _context.Medication.Where(prs => prs.PetReservationId == item.PetReservationId).ToList(); foreach (var med in medsTemp) { meds.Add(med); } } if (meds.Count() > 0) { foreach (var med in meds) { _context.Medication.Remove(med); } } foreach (var serv in servs) { _context.PetReservationService.Remove(serv); } foreach (var item in petRes) { _context.Remove(item); } _context.Remove(res); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public ActionResult Delete(int id, IFormCollection collection) { try { Pet pet = _context.Pet.Find(id); _context.Remove(pet); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }