public async Task <IActionResult> InitiativesAddEdit(int Id) { var model = new ProjectInititativeViewModel() { }; if (Id > 0) { var rec = _context.ProjectInitiatives.Where(e => e.Id == Id).Select(k => new ProjectInititativeViewModel() { Id = k.Id, // InitiativeType = k.InitiativeType, Initiative = k.Initiative, Title = k.Title, }).FirstOrDefault(); if (model != null) { model = rec; } } await SetUserData(); return(View(model)); }
public async Task <IActionResult> SaveI(ProjectInititativeViewModel model) { //await SetUserData(); var user = await _userManager.GetUserAsync(User); if (ModelState.IsValid) { using (var transaction = _context.Database.BeginTransaction()) { try { if (model.Id > 0) { var rec = _context.ProjectInitiatives.Where(e => e.Id == model.Id).FirstOrDefault(); if (rec == null) { throw new Exception("Record not found."); } rec.ModifiedBy = user.Id; rec.ModifiedOn = DateTime.UtcNow; rec.Title = model.Title; rec.Initiative = model.Initiative; // rec.InitiativeType = model.InitiativeType; _context.Update(rec); _context.SaveChanges(); transaction.Commit(); return(RedirectToAction("ABDinitiatives")); } else { _context.ProjectInitiatives.Add(new ProjectInitiative() { CreatedBy = user.Id, CreatedOn = DateTime.UtcNow, Initiative = model.Initiative, Title = model.Title, InitiativeType = Enums.InitiativeType.ABD }); _context.SaveChanges(); transaction.Commit(); return(RedirectToAction("ABDinitiatives")); } } catch (Exception e) { transaction.Rollback(); ModelState.AddModelError("", e.Message); return(View("InitiativesAddEdit", model)); // return Json(new { success = false, message = e.Message }); } } } return(View("InitiativesAddEdit", model)); }