public ActionResult Delete(Rental rentalToDelete) { if (ModelState.IsValid) { using (var db = new RentalDBContext()) { // already have the Rental : Rental rentalToDelete = db.Rentals.Find(id); var rentalTenants = db.Tenants.Where(rt => rt.RentalID == rentalToDelete.Id).AsEnumerable(); foreach (var rt in rentalTenants) { var singleRt = rt; // this just detaches? db.Tenants.Remove(singleRt); db.Entry(singleRt).State = System.Data.Entity.EntityState.Deleted; } // db.Entry(rentalToDelete).State = System.Data.Entity.EntityState.Deleted; //db.Rentals.Remove(rentalToDelete); db.Rentals.Attach(rentalToDelete); db.Rentals.Remove(rentalToDelete); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(rentalToDelete)); }
public ActionResult Add(Tenant tenantFromView) { if (ModelState.IsValid) { using (var db = new RentalDBContext()) { db.Tenants.Add(tenantFromView); db.SaveChanges(); } return(RedirectToAction("Index", "Tenant", new { id = tenantFromView.RentalID })); } return(View(tenantFromView)); }
public ActionResult Add(Rental rentalFromView) { if (ModelState.IsValid) { using (var db = new RentalDBContext()) { db.Rentals.Add(rentalFromView); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(rentalFromView)); }
public ActionResult Edit(Tenant tenantToUpdate) { if (ModelState.IsValid) { using (var db = new RentalDBContext()) { db.Entry(tenantToUpdate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index", "Tenant", new { id = tenantToUpdate.RentalID })); } return(View(tenantToUpdate)); }
public ActionResult Edit(Rental rentalToUpdate) { if (ModelState.IsValid) { using (var db = new RentalDBContext()) { db.Entry(rentalToUpdate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(rentalToUpdate)); }