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;
}
}
