public ActionResult Assign(DefaultTicketSettingsViewModel defaultTicketSettingsViewModel) { SessionHandler sessionHandler = new SessionHandler(); if (ModelState.IsValid) { DefaultTicketSettings defaultTicketSettings = new DefaultTicketSettings(); if (defaultTicketSettingsViewModel.DefaultTicketId == null) { defaultTicketSettings.DefaultTicketId = 0; } else { defaultTicketSettings.DefaultTicketId = defaultTicketSettingsViewModel.DefaultTicketId; } defaultTicketSettings.UserId = Convert.ToInt64(sessionHandler.UserId); defaultTicketSettings.TicketsCount = defaultTicketSettingsViewModel.TicketsCount; defaultTicketSettings.AutoTicketsCloseHour = defaultTicketSettingsViewModel.AutoTicketsCloseHour; _iDefaultTicketSettings.AddDefaultTicketCount(defaultTicketSettings); } TempData["TicketSettingsMessages"] = "DefaultTicket Saved Successfully"; return(RedirectToAction("Assign", "Assignmentload")); }
public int?AddDefaultTicketCount(DefaultTicketSettings defaultTicket) { if (defaultTicket.DefaultTicketId != null) { using (var dbContextTransaction = _context.Database.BeginTransaction()) { var defaultTicketsModel = (from defaultTickets in _context.DefaultTicketSettings where defaultTickets.DefaultTicketId == defaultTicket.DefaultTicketId select defaultTickets).FirstOrDefault(); try { int?result = -1; if (defaultTicketsModel != null) { defaultTicketsModel.AutoTicketsCloseHour = defaultTicket.AutoTicketsCloseHour; defaultTicketsModel.TicketsCount = defaultTicketsModel.TicketsCount; defaultTicketsModel.UpdatedDate = DateTime.Now; _context.Entry(defaultTicketsModel).State = EntityState.Modified; } result = _context.SaveChanges(); dbContextTransaction.Commit(); return(result); } catch (Exception) { dbContextTransaction.Rollback(); return(0); } } } else { using (var dbContextTransaction = _context.Database.BeginTransaction()) { try { defaultTicket.CreateDate = DateTime.Now; _context.DefaultTicketSettings.Add(defaultTicket); _context.SaveChanges(); dbContextTransaction.Commit(); return(1); } catch (Exception) { dbContextTransaction.Rollback(); return(0); } } } }