public async Task <IActionResult> Edit(int id, [FromForm] TaxCode taxCode) { if (ModelState.IsValid) { try { bool isCodeExist = _context.TaxCode.Any(m => m.Code.Equals(taxCode.Code) && !m.Id.Equals(id)); if (isCodeExist) { ModelState.AddModelError("Code", "Code Already Exists!"); return(View(taxCode)); //return RedirectToAction(nameof(Index), new { error = "Code exists" }); } TaxCode db_taxCode = _context.TaxCode.FirstOrDefault(m => m.Id.Equals(taxCode.Id)); if (taxCode == null || id != taxCode.Id) { return(NotFound()); } OldDataTax oldData = new OldDataTax(); oldData.Code = db_taxCode.Code; oldData.Name = db_taxCode.Name; oldData.ChartOfAccount = db_taxCode.ChartOfAccount; oldData.Rate = Convert.ToString(db_taxCode.Rate); oldData.Remark = db_taxCode.Remark; oldData.Status = db_taxCode.Status; string oldJson = JsonConvert.SerializeObject(oldData); string newJson = JsonConvert.SerializeObject(taxCode); db_taxCode.Code = taxCode.Code; db_taxCode.Name = taxCode.Name; db_taxCode.ChartOfAccount = taxCode.ChartOfAccount; db_taxCode.Rate = taxCode.Rate; db_taxCode.Status = taxCode.Status; db_taxCode.Remark = taxCode.Remark; db_taxCode.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Createdby"); db_taxCode.ModifiedDatetime = DateTime.UtcNow; AuditService.InsertActionLog(db_taxCode.CompanyId, db_taxCode.CreatedBy, "Edit", "Tax Code", oldJson, newJson); _context.Update(db_taxCode); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Tax_CodeExists(taxCode.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(taxCode)); }
private bool UpdateDm(string code, string name, string chartofaccount, string rate, string remark, bool status) { bool res = false; try { TaxCode taxCode = _context.TaxCode.FirstOrDefault(m => m.Code.Equals(code)); OldDataTax oldData = new OldDataTax(); oldData.Code = taxCode.Code; oldData.Name = taxCode.Name; oldData.ChartOfAccount = chartofaccount; oldData.Rate = rate; oldData.Remark = taxCode.Remark; oldData.Status = taxCode.Status; string oldJson = JsonConvert.SerializeObject(oldData); string newJson = JsonConvert.SerializeObject(taxCode); if (taxCode != null) { taxCode.Name = name; taxCode.Code = code; taxCode.ChartOfAccount = chartofaccount; taxCode.Rate = Convert.ToDecimal(rate); taxCode.Status = status; taxCode.Remark = remark; taxCode.ModifiedDatetime = DateTime.UtcNow; taxCode.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Modifiedby"); AuditService.InsertActionLog(taxCode.CompanyId, taxCode.CreatedBy, "Edit", "Tax Code", oldJson, newJson); _context.SaveChanges(); res = true; } } catch (Exception ex) { res = false; } return(res); }