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