public async Task <IActionResult> Edit(long id, [Bind("Id,Availability,SparepartRequestId,WoId,WoDesc,Date,Status,SiteId,Qty,Notes")] SparepartRequestTbl sparepartRequestTbl) { if (id != sparepartRequestTbl.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(sparepartRequestTbl); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SparepartRequestTblExists(sparepartRequestTbl.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(sparepartRequestTbl)); }
public async Task <IActionResult> Create([Bind("Id,Availability,SparepartRequestId,WoId,WoDesc,Date,Status,SiteId,Qty,Notes")] SparepartRequestTbl sparepartRequestTbl) { if (ModelState.IsValid) { _context.Add(sparepartRequestTbl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(sparepartRequestTbl)); }
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); }