public ActionResult Add(SlaPoliciesViewModel slaPoliciesViewModel) { if (ModelState.IsValid) { bool flag; int stage; StringBuilder message; ValidateSla(slaPoliciesViewModel, out flag, out stage, out message); if (flag == true) { TempData["MessageErrorPolicies"] = message.ToString(); } else { if (_slaPolicies.CheckPoliciesExists(slaPoliciesViewModel.PriorityId)) { ModelState.AddModelError("", "Priority already exists Delete Older One to Add New One"); } else { SlaPolicies slaPolicies = new SlaPolicies() { PriorityId = slaPoliciesViewModel.PriorityId, CreateDate = DateTime.Now, ResolutionResponseMins = slaPoliciesViewModel.ResolutionResponseMins, FirstResponseDay = slaPoliciesViewModel.FirstResponseDay, EveryResponseDay = slaPoliciesViewModel.EveryResponseDay, ResolutionResponseHour = slaPoliciesViewModel.ResolutionResponseHour, FirstResponseHour = slaPoliciesViewModel.FirstResponseHour, EveryResponseMins = slaPoliciesViewModel.EveryResponseMins, FirstResponseMins = slaPoliciesViewModel.FirstResponseMins, ResolutionResponseDay = slaPoliciesViewModel.ResolutionResponseDay, EveryResponseHour = slaPoliciesViewModel.EveryResponseHour, EscalationDay = slaPoliciesViewModel.EscalationDay, EscalationHour = slaPoliciesViewModel.EscalationHour, EscalationMins = slaPoliciesViewModel.EscalationMins, SlaPoliciesId = 0, UserId = 0 }; var result = _slaPolicies.AddSlaPolicies(slaPolicies); TempData["MessagePolicies"] = "Policy Added Successfully"; } } } slaPoliciesViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); return(View(slaPoliciesViewModel)); }
public int?AddSlaPolicies(SlaPolicies slaPolicies) { using (var dbContextTransaction = _context.Database.BeginTransaction()) { try { _context.SlaPolicies.Add(slaPolicies); _context.SaveChanges(); dbContextTransaction.Commit(); return(1); } catch (Exception) { dbContextTransaction.Rollback(); return(0); } } }