public ActionResult DeleteConfirmed(int id)
        {
            NewRequestTable newRequestTable = db.NewRequestTables.Find(id);

            db.NewRequestTables.Remove(newRequestTable);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,BookName,LocationName,Quantity,DateAdded,AddedBy")] NewRequestTable newRequestTable)
 {
     if (ModelState.IsValid)
     {
         db.Entry(newRequestTable).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(newRequestTable));
 }
        // GET: NewRequestTables/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NewRequestTable newRequestTable = db.NewRequestTables.Find(id);

            if (newRequestTable == null)
            {
                return(HttpNotFound());
            }
            return(View(newRequestTable));
        }
        public ActionResult Create([Bind(Include = "Id,BookName,LocationName,Quantity,DateAdded,AddedBy")] NewRequestTable newRequestTable)
        {
            if (!s.IsQuantityOk(newRequestTable.BookName, newRequestTable.Quantity))
            {
                return(RedirectToAction("Index"));
            }
            newRequestTable.DateAdded = DateTime.Now;
            newRequestTable.AddedBy   = User.Identity.Name;
            if (ModelState.IsValid)
            {
                db.NewRequestTables.Add(newRequestTable);
                db.SaveChanges();
                s.ReduceQuantity(newRequestTable.BookName, newRequestTable.Quantity);
                return(RedirectToAction("Index"));
            }

            return(View(newRequestTable));
        }