public ActionResult AddNewUser(User newUser) { //validation! if (ModelState.IsValid) { // 1. Create the ORM Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); // 3. Add the new object to the Customer List ORM.Users.Add(newUser); // 4. Save Changes to the Database ORM.SaveChanges(); ViewBag.Message = $"Welcome {newUser.UserName}"; return(View("Confirm")); } // to insert the newUser into the Database! else { ViewBag.Address = Request.UserHostAddress; return(View("Error")); } }
public ActionResult DeleteName(string Name) { //1. Connect to the ORM (Model.Context.cs page) Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); //2. Find the item you want to delete Item Found = ORM.Items.Find(Name); //2.1 Validation if (Found != null) { //3. Remove the item ORM.Items.Remove(Found); //4. Save to the Database ORM.SaveChanges(); return(RedirectToAction("Admin")); // execute the About Action again } else { ViewBag.ErrorMessage = "User not found!"; return(View("Errors")); } }
public ActionResult SaveUpdatedItem(Item updatedItem) { //1. Create the ORM Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); //2. Find the Item OldItemRecord = ORM.Items.Find(updatedItem.Name); // Validation if (OldItemRecord != null && ModelState.IsValid) { //3. Update the existing customer OldItemRecord.Name = updatedItem.Name; OldItemRecord.Description = updatedItem.Description; OldItemRecord.Price = updatedItem.Price; // flip state to "modified" ORM.Entry(OldItemRecord).State = System.Data.Entity.EntityState.Modified; // 4. Save back to the Database ORM.SaveChanges(); return(RedirectToAction("Admin")); } else { ViewBag.ErrorMessage = "Oops! Something went wrong!"; return(View("Error")); } }
public ActionResult Admin() { Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); ViewBag.ItemList = ORM.Items.ToList(); return(View()); }
public ActionResult EditItemDetails(string Name) { Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); ViewBag.Item = ORM.Items.Find(Name); return(View()); }
public ActionResult AddNewItem(Item NewItem) { // 1. Create the ORM Coffee_Shop_DBEntities ORM = new Coffee_Shop_DBEntities(); ORM.Items.Add(NewItem); // 4. Save Changes to the Database ORM.SaveChanges(); return(RedirectToAction("Admin")); }