private SparepartRequestTbl createSPR2(ScheduleSparepartLinesTbl spline, long woId, long?Qtys) { var lookWo = _db.ScheduleMaintenanceTbl.Where(x => x.ScheduleMainId == spline.ScheduleMainId).First().MaintenanceId; 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 async Task <IActionResult> CreateSchedulParts(ScheduleSparepartLinesTbl partLines) { var t = partLines.ScheduleMainId; var a = _context.ScheduleMaintenanceTbl.Where(x => x.ScheduleMainId == t).First().ScheduleMainId; if (ModelState.IsValid) { _context.Add(partLines); await _context.SaveChangesAsync(); //mengarahkan ke method laen dengan nama TaskLines dan dengan value id return(RedirectToAction("ScheduleSpareparts", new { id = a })); } return(View(partLines)); }