public async Task <IActionResult> Edit(long id, [Bind("EntityId,SiteId,EntityCode,EntityName,CompanyName,Address,Contact,Pic,CreatedAtEntity,ModifyAtEntity,CreatedBy,ModifyBy")] EntityTbl entityTbl) { if (id != entityTbl.EntityId) { return(NotFound()); } if (ModelState.IsValid) { try { entityTbl.ModifyAtEntity = DateTime.Now; _context.Update(entityTbl); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EntityTblExists(entityTbl.EntityId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(entityTbl)); }
public async Task <IActionResult> Create([Bind("EntityId,SiteId,EntityCode,EntityName,CompanyName,Address,Contact,Pic,CreatedAtEntity,ModifyAtEntity,CreatedBy,ModifyBy")] EntityTbl entityTbl) { if (ModelState.IsValid) { String idrunning = ""; idrunning = generateRunningNumber(idrunning); entityTbl.EntityCode = idrunning; _context.Add(entityTbl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(entityTbl)); }
//==================================================================================================================== //GENERATE RUNNING NUMBER private String generateRunningNumber(string id) { EntityTbl data = _context.EntityTbl.Where(x => x.EntityCode == "ET" + DateTime.Now.ToString("yyMM") + "0001").FirstOrDefault(); string tempSubId = ""; int tempId; if (data == null) { id = "ET" + DateTime.Now.ToString("yyMM") + "0001"; } else { var xx = (from a in _context.EntityTbl where a.EntityCode.Substring(0, 6) == "ET" + DateTime.Now.ToString("yyMM") select a).Max(a => a.EntityCode); tempSubId = xx.Substring(6, 4); tempId = Convert.ToInt32(tempSubId); tempId = tempId + 1; if (tempId.ToString().Length == 1) { id = "ET" + DateTime.Now.ToString("yyMM") + "000" + tempId; } else if (tempId.ToString().Length == 2) { id = "ET" + DateTime.Now.ToString("yyMM") + "00" + tempId; } else if (tempId.ToString().Length == 3) { id = "ET" + DateTime.Now.ToString("yyMM") + "0" + tempId; } else if (tempId.ToString().Length == 4) { id = "ET" + DateTime.Now.ToString("yyMM") + tempId; } } return(id); }