public ActionResult Create([Bind(Include = "ReservationId,OwnerAssetId,LocationId,ReservationDate")] Reservation.DATA.EF.Reservation reservation) { if (ModelState.IsValid) { //this gives you the # of reservations there are currently int nbrRes = db.Reservations.Where(c => c.ReservationDate == reservation.ReservationDate && c.LocationId == reservation.LocationId).Count(); //this gives you the reservation limit at the location int resLimit = db.Locations.Where(x => x.LocationId == reservation.LocationId).FirstOrDefault().ReservationLimit; if (nbrRes < resLimit) { db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("CustomError", "Errors")); } } ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", reservation.LocationId); ViewBag.OwnerAssetId = new SelectList(db.OwnerAssets, "OwnerAssetId", "AssetName", reservation.OwnerAssetId); return(View(reservation)); }
public ActionResult DeleteConfirmed(int id) { Reservation.DATA.EF.Reservation reservation = db.Reservations.Find(id); db.Reservations.Remove(reservation); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ReservationId,OwnerAssetId,LocationId,ReservationDate")] Reservation.DATA.EF.Reservation reservation) { if (ModelState.IsValid) { db.Entry(reservation).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", reservation.LocationId); ViewBag.OwnerAssetId = new SelectList(db.OwnerAssets, "OwnerAssetId", "AssetName", reservation.OwnerAssetId); return(View(reservation)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Reservation.DATA.EF.Reservation reservation = db.Reservations.Find(id); if (reservation == null) { return(HttpNotFound()); } return(View(reservation)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Reservation.DATA.EF.Reservation reservation = db.Reservations.Find(id); if (reservation == null) { return(HttpNotFound()); } string userID = User.Identity.GetUserId(); ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", reservation.LocationId); if (User.IsInRole("User")) { ViewBag.OwnerAssetId = new SelectList(db.OwnerAssets.Where(ud => ud.OwnerId == userID), "OwnerAssetId", "AssetName", reservation.OwnerAssetId);//added so they can only edit their records } else { ViewBag.OwnerAssetId = new SelectList(db.OwnerAssets, "OwnerAssetId", "AssetName", reservation.OwnerAssetId); } return(View(reservation)); }