public ActionResult SaveUpdatedItem(Item updatedItem)
{
//1 ORM
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//2 Locate customer to update
Item OldItemRecord = ORM.Items.Find(updatedItem.ItemName);
if (OldItemRecord != null && ModelState.IsValid)
{
//3 Update the Customer
OldItemRecord.ItemName = updatedItem.ItemName;
OldItemRecord.ItemDescription = updatedItem.ItemDescription;
OldItemRecord.ItemQuantity = updatedItem.ItemQuantity;
OldItemRecord.ItemPrice = updatedItem.ItemPrice;
//4 This line tells ORM to update
ORM.Entry(OldItemRecord).State = System.Data.Entity.EntityState.Modified;
//5 Save to database
ORM.SaveChanges();
return(RedirectToAction("Admin"));
}
else
{
ViewBag.ErrorMessage = "Item Not Updated";
return(View("Error"));
}
}
public void AddInfo(User newUser)
{
CoffeeShopDBEntities1 database = new CoffeeShopDBEntities1(); // Object Relational Mapping
database.Users.Add(newUser);
database.SaveChanges();
}
public ActionResult AddNewItem(Item NewItem)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
ORM.Items.Add(NewItem);
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EditItem(string ItemName)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
Item toUpdate = ORM.Items.Find(ItemName);
return(View(toUpdate));
}
public ActionResult SearchByItemName(string itemname)
{
//1 create the ORM
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
ViewBag.ItemList = ORM.Items.Where(c => c.ItemName.Contains(itemname)).ToList();
return(View("SearchByItemName"));
}
public ActionResult Index()
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
List <Item> myList = ORM.Items.ToList();
ViewBag.ItemList = myList;
return(View());
}
public ActionResult Index()
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
ViewBag.ItemList = ORM.Items.ToList();
ViewBag.Message = "GC Coffee Products";
return(View());
}
public ActionResult Admin()
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
ViewBag.ItemList = ORM.Items.ToList();
ViewBag.Message = "Administrator Page";
return(View());
}
public ActionResult DeleteItem(string name)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
Item ItemToDelete = ORM.Items.Find(name);
ORM.Items.Remove(ItemToDelete);
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult SaveItemChanges(Item NewItem)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
Item oldItem = ORM.Items.Find(NewItem.Name);
oldItem.Description = NewItem.Description;
oldItem.Price = NewItem.Price;
oldItem.Quantity = NewItem.Quantity;
ORM.Entry(oldItem).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult FindItem(string name)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//find item
Item ItemToEdit = ORM.Items.Find(name);
if (ItemToEdit == null)
{
return(RedirectToAction("Index"));
}
ViewBag.ItemToEdit = ItemToEdit;
return(View());
}
public ActionResult DeleteItem(string name)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
Item ItemToDelete = ORM.Items.Find(name); //Find() is a method that is used to find objects by the primary key
//remove item
ORM.Items.Remove(ItemToDelete);
//Save changes to DB
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddNewUser(User newUser)
{
if (ModelState.IsValid)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
ORM.Users.Add(newUser);
ORM.SaveChanges();
ViewBag.Message = $"Welcome {newUser.firstname}";
return(RedirectToAction("Confirm"));
}
else
{
ViewBag.Message = "Invalid input";
return(View());
}
}
public ActionResult EditItem(string Name)
{
if (Name == null || Name == "")
{
return(View("Index"));
}
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
Item found = ORM.Items.Find(Name);
if (found != null)
{
ViewBag.Item = found;
return(View());
}
return(View());
}
public ActionResult AddNewUser(User newuser)
{
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//Validation
if (ModelState.IsValid)
{
ORM.Users.Add(newuser);
ORM.Entry(newuser).CurrentValues["SignUpDate"] = DateTime.Now;
ORM.SaveChanges();
ViewBag.Message = $"Thank you for registering {newuser.FirstName}";
return(View("confirm"));
}
else
{
ViewBag.Address = Request.UserHostAddress;
return(View("Error"));
}
}
public ActionResult ShowItemDetails(string ItemName)
{
//1 ORM
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//2 Locate an item
Item Found = ORM.Items.Find(ItemName);
//3 Show Item
if (Found != null)
{
return(View(Found));//return view as model
//or
//Viewbag.Found = Found;
//return View;
}
else
{
ViewBag.ErrorMessage = "Item not Found";
return(View("Error"));
}
}
public ActionResult DeleteItem(string ItemName)
{
//1 ORM
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//2 Locate customer to delete
Item Found = ORM.Items.Find(ItemName);
//3 Remove customer
if (Found != null)
{
//4Delete Orders
ORM.Items.Remove(Found);
//5 Save to database
ORM.SaveChanges();
return(RedirectToAction("Admin"));
}
else
{
ViewBag.ErrorMessage = "Customer Not Found";
return(View("Error"));
}
}
public ActionResult AddNewItem(Item n)
{
//1 create the ORM
CoffeeShopDBEntities1 ORM = new CoffeeShopDBEntities1();
//2 Validation
if (ModelState.IsValid)
{
//3 add the new object to the Item list
ORM.Items.Add(n);
//4 save changes to database
ORM.SaveChanges();
ViewBag.Message = "Item Added Succesfully";
ViewBag.ItemList = ORM.Items.ToList();
return(View("Admin"));
}
//return RedirectToAction("About");
else
{
ViewBag.ErrorMessage = "Item Not Added";
return(View("Error"));
}
}
