public ActionResult EditSupplie(int id) { CATERING_INSUMO C = db.CATERING_INSUMO.Where(x => x.ID_CATERING_INSUMO == id).FirstOrDefault(); ViewBag.ID_INSUMO = new SelectList(db.INSUMOes.Where(X => X.ACTIVE == true), "ID_INSUMO", "NOMBRE", C.ID_INSUMO); return(PartialView("_editSupplie", C)); }
public ActionResult NewSupplie(int id) { CATERING_INSUMO pr = new CATERING_INSUMO(); pr.ID_CATERING = id; ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); return(PartialView("_editSupplie", new CATERING_INSUMO { ID_CATERING = id })); }
public ActionResult DeleteCateringSupplie(int id, int ID_CATERING) { CATERING_INSUMO m = db.CATERING_INSUMO.Find(id); m.ACTIVE = 0; db.Entry(m).State = EntityState.Modified; db.SaveChanges(); IEnumerable <CATERING_INSUMO> listaProductos = db.CATERING_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_CATERING == ID_CATERING && x.ACTIVE == 1).ToList(); return(PartialView("_listaInsumos", listaProductos)); }
public ActionResult AddCateringSupplie(int INSUMO, string QUANT_SUPPLIE, int ID_CATERING, int tipo) { CATERING_INSUMO cat_ins = new CATERING_INSUMO { ID_CATERING = ID_CATERING, ID_INSUMO = INSUMO, QUANTITY = Convert.ToDouble(QUANT_SUPPLIE) }; db.CATERING_INSUMO.Add(cat_ins); db.SaveChanges(); TempOrderViewModel tovm = GetCateringCost(ID_CATERING); return(PartialView("_itemsList", tovm)); }
public ActionResult EditSupplieP(int ID_CATERING_INSUMO, int QUANTITY, int ID_INSUMO, int ID_CATERING) { CATERING_INSUMO cat = db.CATERING_INSUMO.Where(x => x.ID_CATERING_INSUMO == ID_CATERING_INSUMO).FirstOrDefault(); //if (cat.ID_INSUMO == 0) //{ // ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); // return PartialView("_editSupplie", new CATERING_INSUMO { ID_CATERING_INSUMO = ID_CATERING_INSUMO }); //} CATERING_INSUMO cateringInsumo = db.CATERING_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_CATERING_INSUMO == ID_CATERING_INSUMO && x.ACTIVE == 1).FirstOrDefault(); if (cateringInsumo != null) { cateringInsumo.QUANTITY = QUANTITY; db.Entry <CATERING_INSUMO>(cateringInsumo).State = EntityState.Modified; } else { CATERING_INSUMO PR = new CATERING_INSUMO { ID_CATERING = ID_CATERING, QUANTITY = QUANTITY, ID_INSUMO = ID_INSUMO, ACTIVE = 1 }; db.CATERING_INSUMO.Add(PR); } db.SaveChanges(); IEnumerable <CATERING_INSUMO> listaInsumos = db.CATERING_INSUMO.Include(x => x.INSUMO).Where(x => x.ID_CATERING == ID_CATERING && x.ACTIVE == 1).ToList(); ViewBag.ID_INSUMO = new SelectList(db.INSUMOes, "ID_INSUMO", "NOMBRE"); return(PartialView("_listaInsumos", listaInsumos)); }