public ActionResult SaveChanges(item UpdatedItem) { lab24Entities ORM = new lab24Entities(); // find the old record item OldRecord = ORM.Items.Find(UpdatedItem.itemID); //To Do: check for null if (OldRecord == null) { return(RedirectToAction("Index")); } OldRecord.Name = UpdatedItem.Name; OldRecord.Description = UpdatedItem.Description; OldRecord.Quantity = UpdatedItem.Quantity; OldRecord.Price = UpdatedItem.Price; ORM.Entry(OldRecord).State = System.Data.Entity.EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Index() { lab24Entities ORM = new lab24Entities(); ViewBag.Items = ORM.Items.ToList(); return(View()); }
public ActionResult SearchItemByName(string name) { lab24Entities ORM = new lab24Entities(); // x.Name.ToLower = Name from Database table // contains(name.ToLower() = name from search method in index.cshtml ViewBag.Items = ORM.Items.Where(x => x.Name.ToLower().Contains(name.ToLower())).ToList(); return(View("Index")); }
public ActionResult SaveNewItem(item newItem) { lab24Entities ORM = new lab24Entities(); //To Do: Validation! ORM.Items.Add(newItem); ORM.SaveChanges(); // sync with the database return(RedirectToAction("Index")); }
public ActionResult DeleteItem(int itemID) { lab24Entities ORM = new lab24Entities(); // for loop to find the id // find is a method that is used to find objects by using the primary key item ItemToDelete = ORM.Items.Find(itemID); // remove ORM.Items.Remove(ItemToDelete); ORM.SaveChanges(); // To Do: use try catch return(RedirectToAction("Index")); }
public ActionResult ItemDetails(int itemID) { //this action will show the old data lab24Entities ORM = new lab24Entities(); // find the item item ItemToEdit = ORM.Items.Find(itemID); if (ItemToEdit == null) { return(RedirectToAction("Index")); } // send it back to the view ViewBag.ItemToEdit = ItemToEdit; return(View()); }