internal void InsertUpdateTicketAuditForMaster(TicketAuditEntity obj, string PrimaryEmailAddress, string PrimaryContactNumber, string Files, string Title, int TicketType)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.InsertUpdateTicketAudit";
sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Status", obj.Status.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AssignedTo", obj.AssignedTo.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ChangedByUser", obj.ChangedByUser.ToString().Trim(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Priority", obj.Priority.ToString().Trim(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Notes", (obj.Notes != null) ? obj.Notes.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TicketId", obj.TicketId.ToString().Trim(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PrimaryEmailAddress", PrimaryEmailAddress != null ? PrimaryEmailAddress.Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PrimaryContactNumber", PrimaryContactNumber != null ? PrimaryContactNumber.Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Files", Files != null ? Files.Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Title", Title != null ? Title.Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TicketType", TicketType.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(TicketEntity model)
{
ModelState.Remove("AssignedTo");
if (ModelState.IsValid)
{
if (model != null)
{
TicketFacade tac = new TicketFacade(StringCipher.Decrypt(Helper.GetMasterConnctionstring(), General.passPhrase));
TicketAuditEntity auditmodel = new TicketAuditEntity();
TicketEntity model1 = tac.GetLastTicketAuditByTicketIdByClient(model.Id); // MP-846 Admin database cleanup and code cleanup.-CLIENT
auditmodel.AssignedTo = model.AssignedTo;
auditmodel.Priority = model.Priority;
auditmodel.Status = model1.CurrentStatus;// model.CurrentStatus;
auditmodel.Notes = model.Note;
auditmodel.TicketId = model.Id;
//Get Logged in User Name
auditmodel.ChangedByUser = Helper.UserName;
//Get Uploaded file name from tempdata
string Files = SessionHelper.ImageName;
//Save ticket data
tac.InsertUpdateTicketAuditForClient(auditmodel, model.PrimaryEmailAddress, model.PrimaryContactNumber, Files, model.Title, model.TicketType); // MP-846 Admin database cleanup and code cleanup.-CLIENT
SessionHelper.TicketMessage = CommonMessagesLang.msgCommanUpdateMessage;
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Edit", new { Parameters = StringCipher.Encrypt(model.Id.ToString(), General.passPhrase) }));
}
public ActionResult CloseTicket(int id, int pageNo, int pageSize)
{
TicketEntity objTicket = new TicketEntity();
TicketFacade tac = new TicketFacade(StringCipher.Decrypt(Helper.GetMasterConnctionstring(), General.passPhrase));
objTicket = tac.GetTicketByIDByClients(id); // MP-846 Admin database cleanup and code cleanup.-CLIENT
TicketAuditEntity objAudit = new TicketAuditEntity();
objAudit.Status = 102005; // 102005=Closed
objAudit.AssignedTo = 0;
objAudit.ChangedByUser = Helper.UserName;
objAudit.Priority = objTicket.Priority;
objAudit.Notes = objTicket.IssueDescription;
objAudit.TicketId = id;
tac.InsertUpdateTicketAuditForClient(objAudit, null, null, null, null, 0); // MP-846 Admin database cleanup and code cleanup.-CLIENT
int finalsortOrder = 12;
int totalCount = 0;
List <TicketEntity> model = new List <TicketEntity>();
//List all ticket
model = tac.GetTicketListByUser(Request.Url.Authority, Helper.UserName, finalsortOrder, pageNo, pageSize, out totalCount).ToList();
IPagedList <TicketEntity> pagedTicket = new StaticPagedList <TicketEntity>(model.ToList(), pageNo, pageSize, totalCount);
if (Request.IsAjaxRequest())
{
return(PartialView("_Index", pagedTicket));
}
else
{
return(View("Index", pagedTicket));
}
}
public void InsertUpdateTicketAuditForMaster(TicketAuditEntity obj, string PrimaryEmailAddress, string PrimaryContactNumber, string Files, string Title, int TicketType)
{
rep.InsertUpdateTicketAuditForMaster(obj, PrimaryEmailAddress, PrimaryContactNumber, Files, Title, TicketType);
}
public void InsertUpdateTicketAuditForMaster(TicketAuditEntity obj, string PrimaryEmailAddress, string PrimaryContactNumber, string Files, string Title, int TicketType)
{
TicketRepository rep = new TicketRepository(Connection);
rep.InsertUpdateTicketAuditForMaster(obj, PrimaryEmailAddress, PrimaryContactNumber, Files, Title, TicketType);
}
