// GET: Tenant public ActionResult Index(int id) { if (id == 0) { return(HttpNotFound()); } using (var db = new RentalDBContext()) { Rental rental = db.Rentals.Find(id); if (rental == null) { return(HttpNotFound()); } var tenants = db.Tenants.Where(p => p.RentalID == id).ToList(); TenantsViewModel vModel = new TenantsViewModel() { //1 Rental = rental, //2 RentalName = rental.Name, RentalId = rental.Id, RentalName = rental.Name, Tenants = tenants }; return(View(vModel)); } }
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)); }
// GET: Rental public ActionResult Index() { using (var db = new RentalDBContext()) { var rentals = db.Rentals.ToList(); return(View(rentals)); } }
// GET: Tenant/Edit/5 public ActionResult Edit(int id) { using (var db = new RentalDBContext()) { Tenant tenant = db.Tenants.Find(id); if (tenant == null) { return(HttpNotFound()); } return(View(tenant)); } }
public ActionResult Delete(int id = 0) { using (var db = new RentalDBContext()) { Rental rental = db.Rentals.Find(id); if (rental == null) { return(HttpNotFound()); } return(View(rental)); } }
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)); }
public ColorsController(RentalDBContext context) { _context = context; }
public BikeRentalController(RentalDBContext rentalDbContext) { rentalDBContext = rentalDbContext; }