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));
}
