public ActionResult NewSupplie(int id) { MENU_INSUMO pr = new MENU_INSUMO(); pr.ID_MENU = id; ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); ViewBag.ID_MEDIDA = new SelectList(db.MEDIDAs, "ID_MEDIDA", "NOMBRE"); return(PartialView("_addSupplie", new MENU_INSUMO { ID_MENU = id })); }
public ActionResult DeleteMenuSupplie(int id, int ID_MENU) { MENU_INSUMO m = db.MENU_INSUMO.Find(id); m.ACTIVE = 0; db.Entry(m).State = EntityState.Modified; db.SaveChanges(); IEnumerable <MENU_INSUMO> listaProductos = db.MENU_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_MENU == ID_MENU && x.ACTIVE == 1).ToList(); return(PartialView("_menuInsumos", listaProductos)); }
public ActionResult EditMenuSupplie(int ID) { MENU_INSUMO menuInsumo = db.MENU_INSUMO.Find(ID); if (menuInsumo != null) { ViewBag.ID_MEDIDA = new SelectList(db.MEDIDAs, "ID_MEDIDA", "NOMBRE", menuInsumo.ID_MEDIDA); ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE", menuInsumo.ID_INSUMO); return(PartialView("_addSupplie", menuInsumo)); } else { ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "ame"); return(PartialView("_addSupplie", new MENU_INSUMO())); } }
public ActionResult AddSupplies(int?ID_INSUMO, int?QUANTITY, int ID_MENU) { if (ID_INSUMO == 0) { ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); return(PartialView("_addSupplie", new MENU_INSUMO { ID_MENU = ID_MENU })); } MENU_INSUMO menuInsumo = db.MENU_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_MENU == ID_MENU && x.ID_INSUMO == ID_INSUMO && x.ACTIVE == 1).FirstOrDefault(); if (menuInsumo != null) { menuInsumo.QUANTITY = QUANTITY; db.Entry <MENU_INSUMO>(menuInsumo).State = EntityState.Modified; } else { MENU_INSUMO PR = new MENU_INSUMO { ID_MENU = ID_MENU, QUANTITY = QUANTITY, ID_INSUMO = ID_INSUMO, ACTIVE = 1 }; db.MENU_INSUMO.Add(PR); } db.SaveChanges(); //IEnumerable<MENU_INSUMO> listaInsumos = db.MENU_INSUMO.Where(x => x.ID_MENU == ID_MENU && x.ACTIVE == true).ToList(); IEnumerable <MENU_INSUMO> listaInsumos = db.MENU_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_MENU == ID_MENU && x.ACTIVE == 1).ToList(); ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); return(PartialView("_menuInsumos", listaInsumos)); }