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