public ActionResult Delete(int itemID)
{
Lab22Entities DB = new Lab22Entities();
Item ToDelete = DB.Items.Find(itemID);
if (ToDelete == null)
{
ViewBag.ErrorMessage = "Unable to delete.";
ViewBag.ErrorDetails = "ItemID not found.";
return(View("Error"));
}
DB.Items.Remove(ToDelete);
try
{
DB.SaveChanges();
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "Oops! Something odd just happened...";
ViewBag.ErrorDetails = ex.StackTrace;
return(View("Error"));
}
return(RedirectToAction("Inventory"));
}
public ActionResult UpdateItem(Item updatedItem)
{
Lab22Entities DB = new Lab22Entities();
Item originalItem = DB.Items.Find(updatedItem.ItemID);
if (originalItem == null)
{
ViewBag.ErrorMessage = "Unable to update item.";
ViewBag.ErrorDetails = "ItemID not found.";
return(View("Error"));
}
DB.Entry(originalItem).CurrentValues.SetValues(updatedItem);
//DB.Entry(originalItem).State = System.Data.Entity.EntityState.Modified;
try
{
DB.SaveChanges();
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "Oops! Something odd just happened...";
ViewBag.ErrorDetails = ex.StackTrace;
return(View("Error"));
}
return(RedirectToAction("Inventory"));
}
public ActionResult Update(int itemID)
{
Lab22Entities DB = new Lab22Entities();
Item ToFind = DB.Items.Find(itemID);
if (ToFind == null)
{
ViewBag.ErrorMessage = "Unable to update item.";
ViewBag.ErrorDetails = "ItemID not found.";
return(View("Error"));
}
return(View(ToFind));
}
public ActionResult AddUser(User newUser)
{
Lab22Entities DB = new Lab22Entities();
DB.Users.Add(newUser);
try
{
DB.SaveChanges();
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "Oops! Something odd just happened...";
ViewBag.ErrorDetails = ex.StackTrace;
return(View("Error"));
}
return(RedirectToAction("Index"));
}
public List <Item> GetItemList()
{
Lab22Entities DB = new Lab22Entities();
return(DB.Items.ToList());
}
