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