//update
public ActionResult SaveUpdatedItem(Item UpdateItems)
{
//1.creat orm
AmazonesEntities1 ORM = new AmazonesEntities1();
//2.find the customer
Item oldItemRecord = ORM.Items.Find(UpdateItems.Name);
if (oldItemRecord != null && ModelState.IsValid)
{
//3.update the exiting customer
// oldCustomerRecord.CustomerID.Replace
//oldItemRecord.Name = UpdateItems.Name;
oldItemRecord.Price = UpdateItems.Price;
oldItemRecord.Quantity = UpdateItems.Quantity;
oldItemRecord.Origin = UpdateItems.Origin;
oldItemRecord.OrderNumber = UpdateItems.OrderNumber;
ORM.Entry(oldItemRecord).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
return(RedirectToAction("ListItems"));
}
else
{
ViewBag.ErrorMessage = "Oops! Something Went Wrong";
return(View("Error"));
}
}
//delete
public ActionResult DeleteItem(string Name)
{
AmazonesEntities1 ORM = new AmazonesEntities1();
Item founded = ORM.Items.Find(Name);
ORM.Items.Remove(founded);
ORM.SaveChanges();
return(RedirectToAction("ListItems"));
}
//adding items
public ActionResult AddItem(Item AddingItems)
{
AmazonesEntities1 ORM = new AmazonesEntities1();
if (ModelState.IsValid)
{
ORM.Items.Add(AddingItems);
ORM.SaveChanges();
ViewBag.Result = ORM.Items.ToList();
ViewBag.Message = $"{AddingItems.Name} has been added";
return(RedirectToAction("Swither"));
}
return(View());
}
//create user
public ActionResult AddNewUser(User newUser)
{
AmazonesEntities1 ORM = new AmazonesEntities1();
User foundinDB = ORM.Users.Find(newUser.LastName);
if (foundinDB == null)
{
ORM.Users.Add(newUser);
ORM.SaveChanges();
ViewBag.Result = newUser.LastName;
return(View("Result"));
}
else
{
ViewBag.Error = newUser.LastName;
return(View("Error"));
}
}