public JsonResult RestoreTickets(string[] ticketlist) { try { if (ticketlist.Length != 0) { foreach (var ticketid in ticketlist) { var result = _iTickets.RestoreTicket(Convert.ToInt64(_sessionHandler.UserId), Convert.ToInt64(ticketid)); TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.TicketRestore(), ProcessDate = DateTime.Now, TicketId = Convert.ToInt64(ticketid), ActivitiesId = Convert.ToInt16(StatusMain.Activities.Restored) }; _ticketHistory.TicketHistory(ticketHistory); } return(Json(new { status = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "Fail" })); } } catch (Exception) { return(Json(new { status = "Fail" })); } }
public ActionResult DeleteAttachment(RequestAttachments requestAttachments) { try { var result = _attachments.DeleteAttachmentByAttachmentId(requestAttachments.AttachmentsId); if (result > 0) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.DeleteTicketAttachment(), ProcessDate = DateTime.Now, TicketId = requestAttachments.TicketId, ActivitiesId = Convert.ToInt16(StatusMain.Activities.DeletedAttachment) }; _ticketHistory.TicketHistory(ticketHistory); return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } catch (Exception) { throw; } }
public JsonResult DeleteTicket(string ticketid) { try { if (!string.IsNullOrEmpty(ticketid)) { var result = _iTickets.DeleteTicket(Convert.ToInt64(_sessionHandler.UserId), Convert.ToInt64(ticketid), Convert.ToInt16(StatusMain.Status.Deleted)); if (result > 0) { TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = ticketHistoryHelper.TicketDelete(), ProcessDate = DateTime.Now, TicketId = Convert.ToInt64(ticketid), ActivitiesId = Convert.ToInt16(StatusMain.Activities.DeleteTicket) }; _ticketHistory.TicketHistory(ticketHistory); } return(Json(new { Result = "OK" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Result = "ERROR", Message = string.Empty })); } } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }
public JsonResult AssignTickettoUser(string[] ticketlist, long userId) { try { if (ticketlist.Length != 0) { foreach (var ticketid in ticketlist) { var result = _iTickets.UpdateAssignTickettoUser(userId, Convert.ToInt64(ticketid)); if (result > 0) { var ticketnameassignedUserName = _userMaster.GetUserById(userId); if (ticketnameassignedUserName == null) { throw new ArgumentNullException(nameof(ticketnameassignedUserName)); } TicketHistory ticketHistory = new TicketHistory { UserId = Convert.ToInt32(_sessionHandler.UserId), Message = HistoryTicketCommonMessages.Message6 + " " + ticketnameassignedUserName.UserName, ProcessDate = DateTime.Now, TicketId = Convert.ToInt64(ticketid), ActivitiesId = Convert.ToInt16(StatusMain.Activities.ManuallyAssigedTicket) }; _ticketHistory.TicketHistory(ticketHistory); } } return(Json(new { status = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "Fail" })); } } catch (Exception) { return(Json(new { status = "Fail" })); } }
public void TicketHistory(TicketReplyModel ticketReplyModel, string resolved, string inprogress, string onHold, string replied) { try { string message = string.Empty; TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); var ticketHistory = new TicketHistory(); if (!string.IsNullOrEmpty(resolved)) { message = ticketHistoryHelper.ReplyMessage(Convert.ToInt16(StatusMain.Status.Resolved)); ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.Resolved); } else if (!string.IsNullOrEmpty(inprogress)) { message = ticketHistoryHelper.ReplyMessage(Convert.ToInt16(StatusMain.Status.InProgress)); ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.InProgress); } else if (!string.IsNullOrEmpty(onHold)) { message = ticketHistoryHelper.ReplyMessage(Convert.ToInt16(StatusMain.Status.OnHold)); ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.OnHold); } else if (!string.IsNullOrEmpty(replied)) { message = ticketHistoryHelper.ReplyMessage(Convert.ToInt16(StatusMain.Status.Replied)); ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.Replied); } TempData["TicketReplyMessage"] = CommonMessages.TicketSuccessReplyMessages; ticketHistory.UserId = Convert.ToInt32(_sessionHandler.UserId); ticketHistory.Message = message; ticketHistory.ProcessDate = DateTime.Now; ticketHistory.TicketId = ticketReplyModel.TicketId; ticketHistory.ActivitiesId = Convert.ToInt16(StatusMain.Activities.RepliedandChangedStatus); _ticketHistory.TicketHistory(ticketHistory); } catch (Exception) { throw; } }
public ActionResult Create(TicketsViewModel ticketsViewModel) { try { if (ModelState.IsValid) { if (ticketsViewModel.HiddenUserId == null) { ticketsViewModel.ListofCategory = _category.GetAllActiveSelectListItemCategory(); ticketsViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); ticketsViewModel.Message = string.Empty; ModelState.Remove("Message"); TempData["ErrorMessageTicket"] = "Name is AutoComplete field Don't Enter Name Choose."; return(View(ticketsViewModel)); } var file = Request.Files; var generate = new GenerateTicketNo(); var applicationNo = generate.ApplicationNo(_category.GetCategoryCodeByCategoryId(ticketsViewModel.CategoryId)); var tickets = AutoMapper.Mapper.Map <Tickets>(ticketsViewModel); tickets.TicketId = 0; tickets.CreatedDate = DateTime.Now; tickets.TrackingId = applicationNo; tickets.StatusAssigned = false; tickets.InternalUserId = Convert.ToInt64(_sessionHandler.UserId); var message = AppendSignature(ticketsViewModel.Message); var ticketDetails = new TicketDetails() { Subject = ticketsViewModel.Subject, Message = message, TicketDetailsId = 0 }; var attachments = new Attachments(); var attachmentdetails = new AttachmentDetails(); // ReSharper disable once CollectionNeverQueried.Local var listofattachments = new List <Attachments>(); // ReSharper disable once CollectionNeverQueried.Local var listofattachmentdetails = new List <AttachmentDetails>(); for (int i = 0; i <= file.Count - 1; i++) { if (file[i] != null && file[i].ContentLength > 0) { string extension = Path.GetExtension(file[i].FileName); attachments.UserId = Convert.ToInt64(_sessionHandler.UserId); attachments.AttachmentName = file[i].FileName; attachments.AttachmentType = extension; attachments.CreatedDate = DateTime.Now; var inputStream = file[i].InputStream; if (inputStream != null) { using (var binaryReader = new BinaryReader(inputStream)) { byte[] fileSize = binaryReader.ReadBytes(count: file[i].ContentLength); attachmentdetails.AttachmentBytes = fileSize; } } listofattachments.Add(attachments); listofattachmentdetails.Add(attachmentdetails); } } var ticketId = _tickets.AddTickets(ticketsViewModel.HiddenUserId, tickets, ticketDetails, listofattachments, listofattachmentdetails); if (ticketId != -1) { TempData["MessageTicket"] = applicationNo + ' ' + CommonMessages.TicketSuccessMessages; TicketHistoryHelper ticketHistoryHelper = new TicketHistoryHelper(); var ticketHistory = new TicketHistory(); ticketHistory.UserId = Convert.ToInt32(_sessionHandler.UserId); ticketHistory.Message = ticketHistoryHelper.CreateMessage(tickets.PriorityId, tickets.CategoryId); ticketHistory.CategoryId = tickets.CategoryId; ticketHistory.PriorityId = tickets.PriorityId; ticketHistory.StatusId = Convert.ToInt16(StatusMain.Status.Open); ticketHistory.ProcessDate = DateTime.Now; ticketHistory.TicketId = ticketId; ticketHistory.ActivitiesId = Convert.ToInt16(StatusMain.Activities.Created); _ticketHistory.TicketHistory(ticketHistory); } else { TempData["ErrorMessageTicket"] = CommonMessages.TicketErrorMessages; } return(RedirectToAction("Create", "TicketHOD")); } else { ticketsViewModel.ListofCategory = _category.GetAllActiveSelectListItemCategory(); ticketsViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem(); return(View(ticketsViewModel)); } } catch (Exception) { throw; } }