public ActionResult Create([Bind(Include = "Id,OrdId,DishId,Status")] Meals meals)
{
if (ModelState.IsValid)
{
Ord CurrentOrder = db.Ord.Find(meals.OrdId);
if (CurrentOrder != null) {
ViewBag.IsOrdClosed = false;
if ( CurrentOrder.TimeEnd != null)
{
db.Meals.Add(meals);
CurrentOrder.TotalCost += db.Dish.Find(meals.DishId).Price;
db.Entry(CurrentOrder).State = EntityState.Modified;
db.SaveChanges();
ViewBag.IsOrdClosed = true;
}
}
//return RedirectToAction("Create", "Meals", new { ordId = meals.OrdId });
}
IEnumerable<Meals> MenuMeals = db.Meals.Where(u => u.OrdId == meals.OrdId).AsEnumerable();
ViewBag.dishes = MenuMeals;
ViewBag.DishId = new SelectList(db.Dish, "Id", "Name", meals.DishId);
return View(meals);
}
public virtual void Delete(TEntity entityToDelete)
{
if (context.Entry(entityToDelete).State == EntityState.Detached)
{
dbSet.Attach(entityToDelete);
}
dbSet.Remove(entityToDelete);
}
private long Save(long Id, ref Order orderToUpdate, StatusType statustype, FormCollection formcollection, OrderedProduct[] newItems, string Seats, OrderedProduct[] oldItems, int Status = 0)
{
//Alan for marketing System
//RestaurantEntities db = new RestaurantEntities();
//if (db.OrderedProducts.Count() > 200)
//{
// return db.Orders.Max(o => o.Id);
//}
long newId = 0;
MembershipUser user = Membership.GetUser(HttpContext.User.Identity.Name);
if (Id == 0)
{
orderToUpdate = new Order()
{
CreatedBy = (Guid)user.ProviderUserKey, CreatedDate = DateTime.Now
};
}
else
{
orderToUpdate = db.Orders.Where(i => i.Id == Id).Single();
}
//if (TryUpdateModel(orderToUpdate, "", new string[] { "Status", "Seats", "TotalAmount" }
// ))
//{
if (oldItems != null)
{
UpdateDeletedItem(oldItems, orderToUpdate);
}
if (newItems != null)
{
UpdateOrderedProducts(newItems, orderToUpdate);
}
orderToUpdate.Seats = Seats;
orderToUpdate.SetStatusType(statustype);
if (Id == 0)
{
db.Entry(orderToUpdate).State = EntityState.Added;
}
else
{
db.Entry(orderToUpdate).State = EntityState.Modified;
}
db.SaveChanges();
newId = db.Entry(orderToUpdate).Entity.Id;
//}
return(newId);
}
public ActionResult cookitem(int id)
{
var data = db.OrderItem.Find(id);
data.Status = "Cook";
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult CloseOrd(int id)
{
Ord ord = db.Ord.Find(id);
ord.TimeEnd = DateTime.Now;
db.Entry(ord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ResponseViewModel Pay(int id)
{
Bill bill = new Bill();
bill.OrderID = id;
bill.BillDate = DateTime.Now;
var orderitem = from a in db.OrderItem
where a.OrderID == id && a.IsDeleted != true && a.Status != "Cancel"
select a;
double total = 0;
foreach (var item in orderitem)
{
total = total + (item.Qty * Convert.ToDouble(item.Menu.MenuPrice));
item.Status = "Paid";
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
total = (total * 0.1) + total;
bill.TotalPrice = total.ToString();
bill.CreatedBy = "Admin";
bill.CreatedDate = DateTime.Now;
db.Bill.Add(bill);
var order = db.Order.Find(id);
order.Finish = true;
order.UpdateDate = DateTime.Now;
order.UpdatedBy = "Admin";
db.Entry(order).State = System.Data.Entity.EntityState.Modified;
if (order.Type.TypeName == "Order")
{
var tableid = (from a in db.Track
where a.OrderID == order.OrderID
select a.TableID).FirstOrDefault();
var table = db.Table.Find(tableid);
table.TableStatus = "NotOccupied";
db.Entry(table).State = System.Data.Entity.EntityState.Modified;
}
if (db.SaveChanges() > 0)
{
return(new ResponseViewModel
{
Status = true
});
}
else
{
return(new ResponseViewModel
{
Status = false
});
}
}
public ActionResult EditDish([Bind(Include = "Id,Name,Cost,CategoryId,Descriprion,ImagePath")] Dish dish)
{
if (ModelState.IsValid)
{
db.Entry(dish).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Dishes"));
}
ViewBag.CategoryId = new SelectList(db.DishCategories, "Id", "Name", dish.CategoryId);
return(View(dish));
}
public ActionResult Edit(ProductGroup productgroup)
{
if (ModelState.IsValid)
{
productgroup.ModifiedDate = DateTime.Now;
db.ProductGroups.Attach(productgroup);
//db.ObjectStateManager.ChangeObjectState(productgroup, EntityState.Modified);
db.Entry(productgroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productgroup));
}
public ActionResult Edit([Bind(Include = "CategoryID,CategoryName,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Category category)
{
if (ModelState.IsValid)
{
Category data = new Category();
data = db.Category.Find(category.CategoryID);
data.CategoryName = category.CategoryName;
data.UpdatedBy = "Admin";
data.UpdatedDate = DateTime.Now;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "StatusID,StatusName,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Status status)
{
if (ModelState.IsValid)
{
Status data = new Status();
data = db.Status.Find(status.StatusID);
data.StatusName = status.StatusName;
data.UpdatedBy = "Admin";
data.UpdatedDate = DateTime.Now;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(status));
}
public ActionResult Edit([Bind(Include = "TypeID,TypeName,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Type type)
{
if (ModelState.IsValid)
{
Type data = new Type();
data = db.Type.Find(type.TypeID);
data.TypeName = type.TypeName;
data.UpdatedBy = "Admin";
data.UpdatedDate = DateTime.Now;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(type));
}
public ActionResult Edit([Bind(Include = "MenuID,MenuName,MenuPrice,MenuDescription,Content,ContentType,CategoryID,StatusID,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Menu menu, HttpPostedFileBase upload)
{
if (ModelState.IsValid)
{
Menu data = new Menu();
data = db.Menu.Find(menu.MenuID);
data.MenuName = menu.MenuName;
data.MenuPrice = menu.MenuPrice;
data.MenuDescription = menu.MenuDescription;
data.UpdatedBy = "Admin";
data.UpdatedDate = DateTime.Now;
data.StatusID = menu.StatusID;
data.CategoryID = menu.CategoryID;
if (upload != null)
{
data.ContentType = upload.ContentType;
using (var reader = new System.IO.BinaryReader(upload.InputStream))
{
data.Content = reader.ReadBytes(upload.ContentLength);
}
}
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Category, "CategoryID", "CategoryName", menu.CategoryID);
ViewBag.StatusID = new SelectList(db.Status, "StatusID", "StatusName", menu.StatusID);
return(View(menu));
}
public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ProductId)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = product.ProductId }, product));
}
public ActionResult Edit([Bind(Include = "OrderID,OrderDate,TypeID,Finish,CreatedBy,CreatedDate,UpdatedBy,UpdateDate")] Order order)
{
if (ModelState.IsValid)
{
Order data = new Order();
data = db.Order.Find(order.OrderID);
data.UpdateDate = DateTime.Now;
data.UpdatedBy = "Admin";
data.TypeID = order.TypeID;
data.Finish = order.Finish;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TypeID = new SelectList(db.Type, "TypeID", "TypeName", order.TypeID);
return(View(order));
}
public ActionResult Edit(Product product)
{
ViewBag.ProductGroup = new SelectList(db.ProductGroups.Where(pg => pg.Status == true), "id", "Name");
ViewBag.Kitchen = new SelectList(db.Kitchens, "KitchenID", "KitchenName");
ViewBag.MasterProduct = new SelectList(db.Products.Where(x => x.MasterProductID == null && x.Status == true), "id", "Name");
if (ModelState.IsValid)
{
product.ModifiedDate = DateTime.Now;
db.Products.Attach(product);
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Edit([Bind(Include = "Id,Name")] RegUserRole regUserRole)
{
if (ModelState.IsValid)
{
db.Entry(regUserRole).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(regUserRole));
}
public ActionResult Edit([Bind(Include = "MenuID,Name")] Menu menu)
{
if (ModelState.IsValid)
{
db.Entry(menu).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menu));
}
public ActionResult Edit([Bind(Include = "ID,Name,Cost,Quantity,Category")] Ingredients ingredients)
{
if (ModelState.IsValid)
{
db.Entry(ingredients).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ingredients));
}
public ActionResult Edit([Bind(Include = "M_ID,M_P_ID,M_NAME,CONTROLLER_NAME,ACTION_NAME")] MENULISTA mENULISTA)
{
if (ModelState.IsValid)
{
db.Entry(mENULISTA).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mENULISTA));
}
public ActionResult Edit(CurrencyDenomination currencydenomination)
{
if (ModelState.IsValid)
{
db.Entry(currencydenomination).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(currencydenomination));
}
public ActionResult Edit([Bind(Include = "ID,Name,Quantity")] UpdateSales inventory)
{
if (ModelState.IsValid)
{
db.Entry(inventory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(inventory));
}
public ActionResult Edit([Bind(Include = "Id,Number,PlaceNumber")] Tabl tabl)
{
if (ModelState.IsValid)
{
db.Entry(tabl).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabl));
}
public ActionResult Edit(Kitchen kitchen)
{
if (ModelState.IsValid)
{
db.Entry(kitchen).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kitchen));
}
public static bool SetTableBusy(int masaID)
{
using (RestaurantEntities db = new RestaurantEntities())
{
var f = db.Masa.Find(masaID);
db.Entry(f).State = EntityState.Detached;
var x = f.ConvertToTableModel();
x.MasaDurumu = (int)Common.masaDurumu.Dolu;
db.Entry(x.ConvertToMasa()).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult Edit([Bind(Include = "Id,Name")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit(Printer printer)
{
if (ModelState.IsValid)
{
db.Entry(printer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(printer));
}
public ActionResult Edit(MenuCards menucards)
{
if (ModelState.IsValid)
{
_restaurantEntities.Entry(menucards).State = EntityState.Modified;
_restaurantEntities.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menucards));
}
[HttpPost] //ESTO SUCEDE CUANDO LA CONTROLLER RECIBE UN POST AL METODO EDIT
public ActionResult Edit(CLIENTE objCliente) //RECIBE EL OBJETO POR PARAMETROS
{
if (ModelState.IsValid)
{
db.Entry(objCliente).State = EntityState.Modified; //SI VIENE CON CAMBIOS, SE QUEDARÁ CON LOS CAMBIOS REALIZADOS
db.SaveChanges(); //CONSOLIDA EN LA BASE
return(RedirectToAction("Index")); //REDIRIGE A LA VISTA DE LISTADO
}
return(View(objCliente)); //NO ENCONTRÓ COINCIDENCIAS NO RETORNA NADA
}
public ActionResult Edit(INSUMO objInsumo)
{
if (ModelState.IsValid)
{
db.Entry(objInsumo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(objInsumo));
}
public ResponseViewModel ServedOrder(int id)
{
var orderitem = db.OrderItem.Find(id);
if (orderitem.IsDeleted != true)
{
orderitem.Status = "Served";
db.Entry(orderitem).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new ResponseViewModel {
Status = true
});
}
else
{
return(new ResponseViewModel {
Status = false
});;
}
}