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