public ActionResult CreateExcelFile(string fileName, string ExcelGridName) { Search searchcriteria = Session["searchcriteria"] as Search; Session.Remove("searchcriteria"); //get dataset as required using Session["searchcriteria"] as parameter DataTable dt = new DataTable(); byte[] file = null; if (ExcelGridName == "gridTCEPDIE8" || ExcelGridName == "gridTCEPIE8" || ExcelGridName == "gridTCEPQIE8" || ExcelGridName == "gridTCSTDIE8") { var teService = new TracerByEP(); file = teService.TracerByEPDataIE(searchcriteria); } else if (ExcelGridName == "gridTCQUESIE8" || ExcelGridName == "gridTCRESPIE8") { var tcService = new TracerComprehensive(); file = tcService.TracerComprehensiveDataIE(searchcriteria); } else if (ExcelGridName == "gridDCADATAIE8") { var teService = new DepartmentComparativeAnalysis(); file = teService.DepartmentComparativeAnalysisDataExcelIE8(searchcriteria); } else if (ExcelGridName == "gridDCAOPPIE8") { var teService = new DepartmentComparativeAnalysis(); file = teService.DepartmentComparativeAnalysisOppExcelIE8(searchcriteria); } else if (ExcelGridName == "gridTCCMSIE8") { var cmsService = new TracerByCMS(); file = cmsService.TracerByCMSIE(searchcriteria, 2); // 2 = Request By Data Detail version (1 = Graph version) } else if (ExcelGridName == "gridMQB") { var qmbService = new MonthlyBreakdownService(); file = qmbService.QuestionMonthlyBreakdownDataIE(searchcriteria); } else if (ExcelGridName == "gridMTB") { var tmbService = new MonthlyBreakdownService(); file = tmbService.TracerMonthlyBreakdownDataIE(searchcriteria); } //// Get the spreadsheet from seession. //replace file with the actual content // byte[] file = System.Text.Encoding.ASCII.GetBytes(dt.CreateCSVFile()); string filename = string.Format("{0}.xlsx", fileName); return(File(file, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename)); }
public ActionResult _TracerByEPGroupByEPExcel([DataSourceRequest] DataSourceRequest request, Search search) { var tcService = new TracerByEP(); DataSourceResult result = tcService.TracerByEPExcel(request, search); if (result.Errors != null && result.Errors.ToString() != "") { ModelState.AddModelError("Error", result.Errors.ToString()); } var val = Json(result, JsonRequestBehavior.AllowGet); val.MaxJsonLength = int.MaxValue; return(val); }
public PartialViewResult _TracerByEP(Search search, Email emailInput) { ReportViewer reportViewer = new ReportViewer(); try { var tcService = new TracerByEP(); if (emailInput.To != null) { ViewBag.FromEmail = true; ViewBag.FromEmailSuccess = WebConstants.Email_Success; } reportViewer = tcService.TracerByEPRDLC(search, emailInput); Session["MyReportViewer"] = reportViewer; } catch (Exception ex) { if (ex.Message.ToString() != "Email") { if (ex.Message.ToString() == "No Data") { ModelState.AddModelError("Error", WebConstants.NO_DATA_FOUND_RDLC_VIEW); } else { ViewBag.DataLimit = true; ModelState.AddModelError("Error", "Maximum limit of " + ConfigurationManager.AppSettings["ReportOutputLimit"].ToString() + " records reached. Refine your criteria to narrow the result."); } } else { ViewBag.FromEmail = true; ModelState.AddModelError("Error", WebConstants.Email_Failed); } } return(PartialView("_ReportViewer")); }
public ActionResult SendExcelEmailIE8(string ExcelGridName, Email email) { var emailService = new CommonService(); bool emailSuccess = true; var emailMessage = WebConstants.Excel_Email_Success; try { DataTable dt = new DataTable(); byte[] file = null; if (ExcelGridName == "gridTCEPDIE8" || ExcelGridName == "gridTCEPIE8" || ExcelGridName == "gridTCEPQIE8" || ExcelGridName == "gridTCSTDIE8") { var teService = new TracerByEP(); file = teService.TracerByEPDataIE(Session["searchcriteria"] as Search); } else if (ExcelGridName == "gridTCQUESIE8") { var tcService = new TracerComprehensive(); file = tcService.TracerComprehensiveDataIE(Session["searchcriteria"] as Search); } else if (ExcelGridName == "gridTCRESPIE8") { var tcService = new TracerComprehensive(); file = tcService.TracerComprehensiveDataIE(Session["searchcriteria"] as Search); } else if (ExcelGridName == "gridDCADATAIE8") { var teService = new DepartmentComparativeAnalysis(); file = teService.DepartmentComparativeAnalysisDataExcelIE8(Session["searchcriteria"] as Search); } else if (ExcelGridName == "gridCompQuesDetIE8") { var teService = new TracerComplianceQuestion(); file = teService.ReportComplianceQuestionDetailExcelIE8(Session["searchcriteria"] as TracerComplianceQuestionInput); } else if (ExcelGridName == "gridTCCMSIE8") { var cmsService = new TracerByCMS(); file = cmsService.TracerByCMSIE(Session["searchcriteria"] as Search, 2); // Request detail version } else if (ExcelGridName == "gridMQB") { var qmbService = new MonthlyBreakdownService(); file = qmbService.QuestionMonthlyBreakdownDataIE(Session["searchcriteria"] as Search); } else if (ExcelGridName == "gridMTB") { var tmbService = new MonthlyBreakdownService(); file = tmbService.TracerMonthlyBreakdownDataIE(Session["searchcriteria"] as Search); } if (email.MultipleAttachment) { email.AttachmentLocation[0] = emailService.SaveExcel(email.Title.ToString(), file); var teService = new DepartmentComparativeAnalysis(); file = teService.DepartmentComparativeAnalysisOppExcelIE8(Session["searchcriteria"] as Search); email.AttachmentLocation[1] = emailService.SaveExcel(email.Title.ToString() + " Details", file); email.FileContents = file; emailSuccess = emailService.SendExcelEmailAttachemnt(email); if (emailSuccess) { emailMessage = WebConstants.Excel_Email_Success; } else { emailMessage = WebConstants.Email_Failed; } } else { email.AttachmentLocation[0] = emailService.SaveExcel(email.Title.ToString(), file); email.FileContents = file; emailSuccess = emailService.SendExcelEmailAttachemnt(email); if (emailSuccess) { emailMessage = WebConstants.Excel_Email_Success; } else { emailMessage = WebConstants.Email_Failed; } } } catch (Exception) { emailMessage = WebConstants.Excel_Email_Failed; } finally { Session.Remove("searchcriteria"); } return(Json(emailMessage)); }