private SparepartRequestTbl createSPR(WoRequestSpartpartLineTbl spline, long woId, long?Qtys) { var lookWo = _db.WoRequestTbl.Where(x => x.Id == spline.WoRequestId).First().RequestId; bool exist = _db.SparepartRequestTbl.Any(x => x.WoId == woId); if (!exist) { SparepartRequestTbl newsp = new SparepartRequestTbl(); newsp.Availability = "Not Available"; newsp.SparepartRequestId = "SPR" + lookWo; newsp.WoId = woId; newsp.WoDesc = _db.WorkOrderTbl.Where(x => x.WoId == woId).First().WoDesc; newsp.Date = DateTime.Now; newsp.Status = "Pending"; newsp.SiteId = _db.WorkOrderTbl.Where(x => x.WoId == woId).First().SiteId; _db.SparepartRequestTbl.Add(newsp); _db.SaveChanges(); var idforline = _db.SparepartRequestTbl.Where(x => x.WoId == woId).First().Id; SparepartRequestLinesTbl newspline = new SparepartRequestLinesTbl(); newspline.SprId = idforline; newspline.SparepartId = spline.SparepartId; newspline.SparepartCode = _db.SparepartTbl.Where(x => x.SparepartId == spline.SparepartId).First().SparepartCode; newspline.WoId = woId; newspline.Quantity = (int)spline.Quantity - (int)Qtys; newspline.Quantity2 = (int)spline.Quantity; _db.SparepartRequestLinesTbl.Add(newspline); _db.SaveChanges(); } else { var idforline = _db.SparepartRequestTbl.Where(x => x.WoId == woId).First().Id; SparepartRequestLinesTbl newspline = new SparepartRequestLinesTbl(); newspline.SprId = idforline; newspline.SparepartId = spline.SparepartId; newspline.SparepartCode = _db.SparepartTbl.Where(x => x.SparepartId == spline.SparepartId).First().SparepartCode; newspline.WoId = woId; newspline.Quantity = (int)spline.Quantity - (int)Qtys; newspline.Quantity2 = (int)spline.Quantity; _db.SparepartRequestLinesTbl.Add(newspline); _db.SaveChanges(); } return(null); }
public ActionResult UpdateCustomer(List <string> listkey) { var t = listkey; string quant = t[0]; string spares = t[1]; string aidi = t[2]; string woaidi = t[3]; //WoExeSparepartTbl woExe = _context.WoExeSparepartTbl.Where(x => x.WoExeId == Convert.ToInt64(aidi) && x.SparepartCode == spares).First(); //woExe.Quantity = Convert.ToInt32(quant); //_context.Update(woExe); //_context.SaveChanges(); SparepartRequestLinesTbl spas = _context.SparepartRequestLinesTbl.Where(x => x.SprId == Convert.ToInt64(aidi) && x.SparepartCode == spares).First(); spas.Quantity = Convert.ToInt32(quant); _context.Update(spas); _context.SaveChanges(); return(new EmptyResult()); }