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