public IActionResult PlanEdit(TSPlanning planning, string actionType) { int?Pid = planning.PlanSupId; if (actionType == "Update") { if (ModelState.IsValid) { try{ _dbContext.TSPlannings.Update(planning); _dbContext.SaveChanges(); } catch {} } else { CreateViewBags(Pid, planning.PlanProdId); return(View(planning)); } } var model = _dbContext.TSupliers .SingleOrDefault(u => u.SupId.Equals(Pid)); string sName = model.SupRasoc + " " + model.SupNif; ViewData["sName"] = sName; ViewData["SupId"] = Pid; CreateViewBags(Pid, planning.PlanProdId); ViewData["panel"] = 3; return(RedirectToAction("Edit", new{ id = Pid, panel = 3, move = 0, prod = planning.PlanProdId })); }
private void ValidateReqs(DateTime?F1, DateTime?F2, bool accStock) { //graba Planning data por proveedor,po, material, cantidad //actualiza material stock Location en transito con lo que lo //tendra en cuenta en el proximo calculo MRP CreateVB_cMRP(F1, F2, accStock); List <TExpMatd> mode_ = (List <TExpMatd>)ViewBag.ListMatPOT; foreach (TExpMatd rec in mode_) { int? _idmat = rec.expcomp; double?qtyreq = rec.SPoPcRequ; int? _idSup = rec.SupId; int? _idPo = rec.SPoId; //SpocprodId SporeferEx SposupId var qpo = (from po in _dbContext.TSPorders where po.SpocprodId == _idmat && po.SposupId == _idSup select po.SporeferEx).ToList(); int?_IdRe = qpo[0]; try{ TSPlanning modpl = new TSPlanning(); modpl.PlanSupId = _idSup; modpl.PlanProdId = _IdRe; modpl.PlanDateFrom = F1; modpl.PlanDateTo = F2; modpl.PlanQty = qtyreq; modpl.PlanFirmSt = "PLAN"; _dbContext.TSPlannings.Add(modpl); _dbContext.SaveChanges(); } catch {} try{ var query = (from ml in _dbContext.TMLocations join lo in _dbContext.TLocations on ml.MLocLodId equals lo.LocId where lo.LocType == "TRAN" && ml.MLocMatId == _idmat select ml.MLocId).ToList(); int _locId = query[0]; var modlo = _dbContext.TMLocations .SingleOrDefault(u => u.MLocId.Equals(_locId)); modlo.MLocStock += qtyreq; _dbContext.TMLocations.Update(modlo); _dbContext.SaveChanges(); } catch {} } }
public IActionResult PlanCreate(TSPlanning planning, int Pid, int prod, string actionType) { if (actionType == "Add") { if (ModelState.IsValid) { try{ _dbContext.TSPlannings.Add(planning); _dbContext.SaveChanges(); } catch { return(View("Error")); } } else { CreateViewBags(Pid, planning.PlanProdId); return(View(planning)); } } CreateViewBags(Pid, planning.PlanProdId); ViewData["panel"] = 3; return(RedirectToAction("Edit", new{ id = Pid, panel = 3, move = 0, prod = planning.PlanProdId })); }