private JObject GetTicketsHistory(HttpContext context) { JObject responseJObj = new JObject(); try { UDC.Ticket ticket = new UDC.Ticket(); ticket.Mode = context.Request["mode"] != null?Convert.ToInt32(context.Request["mode"]) : 0;; ticket.AccountId = accountId; //ticket.AgentId = agentId; ticket.RoleId = roleId; if (roleId == 1) { ticket.AgentId = agentId; ticket.SelectedAgentId = agentId; } else { ticket.AgentId = agentId; ticket.SelectedAgentId = context.Request["agentId"] != null?Convert.ToInt32(context.Request["agentId"]) : 0; } //ticket.SelectedAgentId = context.Request["agentId"] != null ? Convert.ToInt32(context.Request["agentId"]) : 0; ticket.Id = context.Request["ticketId"] != null?Convert.ToInt64(context.Request["ticketId"]) : 0; ticket.Subject = context.Request["subject"]; ticket.StatusIds = context.Request["statusIds"]; ticket.PriorityIds = context.Request["priorityIds"]; ticket.TicketType = context.Request["ticketType"] != null?Convert.ToInt32(context.Request["ticketType"]) : 0; ticket.OverDueType = context.Request["overDueType"] != null?Convert.ToInt32(context.Request["overDueType"]) : 0; ticket.DurationType = context.Request["durationType"] != null?Convert.ToInt32(context.Request["durationType"]) : 0; ticket.CustomerId = context.Request["customerId"] != null?Convert.ToInt32(context.Request["customerId"]) : 0; ticket.FromDate = context.Request["fromDate"]; ticket.ToDate = context.Request["toDate"]; ticket.PageIndex = Convert.ToInt32(context.Request["pageIndex"]); ticket.PageSize = Convert.ToInt32(context.Request["pageSize"]); ticket.IsStarred = context.Request["isStarred"] != null?Convert.ToBoolean(Convert.ToInt16(context.Request["isStarred"])) : Convert.ToBoolean(Convert.ToInt16(0)); //Convert.ToBoolean(Convert.ToInt16(context.Request["isStarred"])); ticket.CategoryId = context.Request["CategoryId"] != "0" ? Convert.ToInt32(context.Request["CategoryId"]) : 0; Press3.BusinessRulesLayer.Ticket ticketObj = new Press3.BusinessRulesLayer.Ticket(); responseJObj = ticketObj.GetTicketsHistory(MyConfig.MyConnectionString, ticket); } catch (Exception ex) { Logger.Error(ex.ToString()); } return(responseJObj); }
public void DownloadTicketExcelReports_Click(object sender, EventArgs e) { DataSet responseDataSet = new DataSet(); UDC.Ticket ticket = new UDC.Ticket(); ticket.Mode = 1; if (roleId == 1) { ticket.AgentId = agentId; ticket.SelectedAgentId = agentId; } else { ticket.AgentId = agentId; ticket.SelectedAgentId = Convert.ToInt32(hdnAgentId.Value); } ticket.AccountId = accountId; ticket.RoleId = roleId; ticket.Id = hdnTicketId.Value != null?Convert.ToInt32(hdnTicketId.Value) : 0; ticket.Subject = hdnTicketSubject.Value; ticket.StatusIds = hdnTicketStatuses.Value; ticket.PriorityIds = hdnTicketPriorities.Value; ticket.TicketType = hdnTicketType.Value != null?Convert.ToInt32(hdnTicketType.Value) : 0; ticket.OverDueType = hdnDueType.Value != null?Convert.ToInt32(hdnDueType.Value) : 0; ticket.DurationType = hdnDurationType.Value != null?Convert.ToInt32(hdnDurationType.Value) : 0; ticket.CustomerId = 0; ticket.FromDate = hdnFromDate.Value; ticket.ToDate = hdnToDate.Value; ticket.PageIndex = Convert.ToInt32(hdnPageIndex.Value); ticket.PageSize = Convert.ToInt32(hdnPageSize.Value); ticket.IsStarred = Convert.ToBoolean(Convert.ToInt16(hdnIsStarred.Value)); ticket.CategoryId = hdnCategoryId.Value != "0" ? Convert.ToInt32(hdnCategoryId.Value) : 0; Press3.BusinessRulesLayer.Ticket ticketObj = new Press3.BusinessRulesLayer.Ticket(); responseDataSet = ticketObj.DownloadTicketsHistory(MyConfig.MyConnectionString, ticket); int temp = responseDataSet.Tables.Count; int temp2 = responseDataSet.Tables[0].Rows.Count; int temp3 = responseDataSet.Tables[1].Rows.Count; if (responseDataSet != null) { if (responseDataSet.Tables.Count > 0) { string file_name = ""; try { var book = new XSSFWorkbook(); var sheet = book.CreateSheet("Sheet1"); Logger.Info("DownloadExcelReports started 1"); dynamic headerRow = sheet.CreateRow(0); headerRow.CreateCell(0).SetCellValue("Agent Name"); headerRow.CreateCell(1).SetCellValue("Ticket Number"); headerRow.CreateCell(2).SetCellValue("Status"); headerRow.CreateCell(3).SetCellValue("Type Of Service"); headerRow.CreateCell(4).SetCellValue("Priority"); headerRow.CreateCell(5).SetCellValue("Ticket Created Time"); headerRow.CreateCell(6).SetCellValue("Ticket Updated Time"); headerRow.CreateCell(7).SetCellValue("Ticket Updated by"); headerRow.CreateCell(8).SetCellValue("Due Date"); if (responseDataSet.Tables[0].Rows.Count > 0) { var _with1 = responseDataSet.Tables[0]; for (int i = 0; i <= _with1.Rows.Count - 1; i++) { dynamic row = sheet.CreateRow(i + 1); for (int c = 0; c <= responseDataSet.Tables[0].Columns.Count - 1; c++) { row.CreateCell(c).SetCellValue(_with1.Rows[i][c].ToString()); } } } string folderPath = ""; folderPath = HttpContext.Current.Server.MapPath("~/TicketHistory/"); // floderName = "ScriptFileUpload"; if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } string path = System.Web.HttpContext.Current.Server.MapPath("~"); file_name = "TicketHistory_" + DateTime.Now.ToString("ddMMyyyyHHmmssfff") + ".xlsx"; FileStream exportData = new FileStream(path + "/TicketHistory/" + file_name, FileMode.CreateNew); book.Write(exportData); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", file_name)); System.IO.FileInfo Dfile = new System.IO.FileInfo(path + "/TicketHistory/" + file_name); HttpContext.Current.Response.WriteFile(Dfile.FullName); exportData.Close(); HttpContext.Current.Response.Flush(); System.IO.File.Delete(path + "/TicketHistory/" + file_name); HttpContext.Current.Response.End(); } catch (Exception ex) { Logger.Info("DownloadExcelReports " + ex.ToString()); } } } }