public async Task <IActionResult> Create(SparepartTbl sparepart) { if (ModelState.IsValid) { String idrunning = ""; idrunning = generateRunningNumber(idrunning); sparepart.SparepartCode = idrunning; sparepart.CreatedAtSupp = DateTime.Now; sparepart.ModifyAtSupp = DateTime.Now; _db.Add(sparepart); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(sparepart)); }
public async Task <IActionResult> Edit(long id, SparepartTbl sparepart) { // var create = _db.SiteMasterTbl.Where(m => m.SiteId == siteMaster.SiteId).First().CreatedAtSite; if (id != sparepart.SparepartId) { return(NotFound()); } if (ModelState.IsValid) { // //siteMaster.CreatedAtSite = create; sparepart.ModifyAtSupp = DateTime.Now; _db.Update(sparepart); _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(sparepart)); }
//========================================================================================================= //GENERATE RUNNING NUMBER private String generateRunningNumber(string id) { SparepartTbl data = _db.SparepartTbl.Where(x => x.SparepartCode == "SC" + DateTime.Now.ToString("yyMM") + "0001").FirstOrDefault(); string tempSubId = ""; int tempId; if (data == null) { id = "SC" + DateTime.Now.ToString("yyMM") + "0001"; } else { var xx = (from a in _db.SparepartTbl where a.SparepartCode.Substring(0, 6) == "SC" + DateTime.Now.ToString("yyMM") select a).Max(a => a.SparepartCode); tempSubId = xx.Substring(6, 4); tempId = Convert.ToInt32(tempSubId); tempId = tempId + 1; if (tempId.ToString().Length == 1) { id = "SC" + DateTime.Now.ToString("yyMM") + "000" + tempId; } else if (tempId.ToString().Length == 2) { id = "SC" + DateTime.Now.ToString("yyMM") + "00" + tempId; } else if (tempId.ToString().Length == 3) { id = "SC" + DateTime.Now.ToString("yyMM") + "0" + tempId; } else if (tempId.ToString().Length == 4) { id = "SC" + DateTime.Now.ToString("yyMM") + tempId; } } return(id); }