public ActionResult ManageFoodItems(FoodItemViewModel obj)
{
try
{
FoodItem food = new FoodItem();
food.Name = obj.Name;
food.Price = obj.Price;
food.Category = obj.Category;
db.FoodItems.Add(food);
db.SaveChanges();
return(RedirectToAction("ManageFoodItems"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult CancelOrder()
{
foreach (OrderProduct OP in db.OrderProducts)
{
if (OP.OrderId == 2)
{
try
{
db.OrderProducts.Remove(OP);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
db.SaveChanges();
db.Orders.Remove(db.Orders.Find(2));
db.SaveChanges();
ViewBag.listProduct = db.FoodItems.ToList();
return(View("Index"));
}
public ActionResult DeleteFoodItem(int ID)
{
try
{
CanteenAutomationSystemDbEntities cas = new CanteenAutomationSystemDbEntities();
FoodItem F = cas.FoodItems.Find(ID);
cas.FoodItems.Remove(F);
cas.SaveChanges();
return(RedirectToAction("ManageFoodItems"));
}
catch
{
return(View());
}
}
public ActionResult AddFoodItems(Additem f)
{
try
{
FoodItem f1 = new FoodItem();
f1.FoodId = f.FoodId;
f1.Category = f.Category;
f1.Name = f.Name;
f1.Price = f.Price;
CanteenAutomationSystemDbEntities cas = new CanteenAutomationSystemDbEntities();
cas.FoodItems.Add(f1);
cas.SaveChanges();
return(RedirectToAction("ManageFoodItems"));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult CompleteOrderList(int Id)
{
Order f = db.Orders.Find(Id);
f.Status = "Completed";
db.SaveChanges();
List <Order> po = new List <Order>();
foreach (Order p in db.Orders)
{
if (p.Status == "Completed")
{
Order p1 = new Order();
p1.OrderId = p.OrderId;
p1.Date = p.Date;
p1.Items = p.Items;
p1.Status = p.Status;
po.Add(p1);
}
}
ViewBag.listProduct = po;
return(View());
}