private void button2_Click(object sender, EventArgs e)
{
XtraReport1 report = new XtraReport1();
XtraReport2 report2 = new XtraReport2();
report.CreateDocument(false);
report2.CreateDocument(false);
report.ExportToXlsx("test1.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "report1"
});
report2.ExportToXlsx("test2.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "report2"
});
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument("test1.xlsx");
Workbook workbook2 = new DevExpress.Spreadsheet.Workbook();
workbook2.LoadDocument("test2.xlsx");
workbook.Worksheets.Insert(1, "report2");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.SaveDocument("test3.xlsx");
Process.Start("test3.xlsx");
}
static void Main()
{
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.ReplaceService <IObjectDataSourceValidationService>(new MyObjectDataSourceValidationService());
workbook.LoadDocument("EmployeesMailMergeTemplate.xlsx");
var result = workbook.GenerateMailMergeDocuments();
result[0].SaveDocument("result.xlsx");
System.Diagnostics.Process.Start("result.xlsx");
}
void ProcessExcel(string fileName, Dictionary <int, int> data)
{
//fileName = @"C:\Users\Mushfikur Rahman\Downloads\Technical-Adaptive Assessment.xlsx";
//Microsoft.Office.Interop.Excel.Application excelAppObj = new Microsoft.Office.Interop.Excel.Application();
//excelAppObj.DisplayAlerts = false;
//Open the excel work book
//Microsoft.Office.Interop.Excel.Workbook workBook = excelAppObj.Workbooks.Open(fileName, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, false, false);
//Get the first sheet of the selected work book
//Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets.get_Item(1);
//ExcelWorkbook workBook = ExcelWorkbook.ReadXLSX(fileName);
//var worksheet = workBook.Worksheets[0];
//Book workbook = new BinBook();
//workbook.load(fileName);
//var worksheet = workbook.getSheet(0);
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(fileName);
Worksheet worksheet = workbook.Worksheets[0];
//Write 20 in Cell - C3
//worksheet.Cells[4, 4].Value = txtName.Text;
//worksheet.Cells[30, 3].Value = txtCompany.Text + ", " + txtEmail.Text;
//worksheet.writeStr(4, 4, txtName.Text);
//worksheet.writeStr(30, 3, txtCompany.Text + ", " + txtEmail.Text);
worksheet.Cells[4, 2].Value = txtName.Text;
//worksheet.Cells[29, 2].Value = txtCompany.Text + ", " + txtEmail.Text;
int technical = 0;
int adaptive = 0;
var technicalResult = 0D;
var adaptiveResult = 0D;
var curRow = 6;
foreach (var item in data)
{
if (item.Value == 0)
{
worksheet.Cells[curRow, 3].Value = 1;
//technical++;
}
//worksheet.writeNum(curRow, 5, 1);
else if (item.Value == 1)
{
worksheet.Cells[curRow + 1, 3].Value = 1;
//adaptive++;
}
else if (item.Value == 2)
{
worksheet.Cells[curRow + 2, 3].Value = 1;
}
else
{
worksheet.Cells[curRow + 3, 3].Value = 1;
}
//worksheet.writeNum(curRow + 1, 5, 1);
curRow += 4;
}
//technicalResult = (technical / 12) * 100;
//adaptiveResult = (adaptive / 12) * 100;
//Save work book (.xlsx format)
//workBook.SaveAs(fileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, null, null, false,
//false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);
//excelAppObj.Quit();
//workBook.WriteXLSX(fileName);
//workbook.save(fileName);
workbook.AddService(typeof(IChartControllerFactoryService), new ChartControllerFactoryService());
workbook.AddService(typeof(IChartImageService), new ChartImageService());
workbook.SaveDocument(fileName);
var pdfFileName = fileName.Replace(".xlsx", ".pdf");
workbook.ExportToPdf(pdfFileName);
Session["ReportFilePath"] = pdfFileName;
//workbook.ExportToHtml(fileName + ".pdf", 1);
//Save to downloads//
var reportID = ins.SaveDownloads(int.Parse(Session["userId"].ToString()), "Leadership Complexities", pdfFileName);
Session["ReportID"] = reportID;
string errorFileName = Server.MapPath("~") + @"\Files\Docx\EmailError.txt";
var res = 1; Basics.email_send(fileName.Replace(".xlsx", ".pdf"), string.Format("Leadership Complexities Assessment - {0}-{1}", txtName.Text, txtCompany.Text), "Your assessment report is ready to download.", txtEmail.Text, errorFileName);
var CurrentPage = GetCurrentPageName();
ins.DeleteHolt(int.Parse(Session["userId"].ToString()), CurrentPage);
ins.DeleteAnsState(CurrentPage, int.Parse(Session["userId"].ToString()));
if (res == 1)
{
Response.Redirect("Home.aspx");
}
else
{
Response.Redirect("Error.aspx");
}
}
void ProcessExcel(string fileName, Dictionary <int, int> data)
{
//fileName = @"C:\Users\Mushfikur Rahman\Downloads\Technical-Adaptive Assessment.xlsx";
//Microsoft.Office.Interop.Excel.Application excelAppObj = new Microsoft.Office.Interop.Excel.Application();
//excelAppObj.DisplayAlerts = false;
//Open the excel work book
//Microsoft.Office.Interop.Excel.Workbook workBook = excelAppObj.Workbooks.Open(fileName, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, false, false);
//Get the first sheet of the selected work book
//Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets.get_Item(1);
//ExcelWorkbook workBook = ExcelWorkbook.ReadXLSX(fileName);
//var worksheet = workBook.Worksheets[0];
//Book workbook = new BinBook();
//workbook.load(fileName);
//var worksheet = workbook.getSheet(0);
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(fileName);
Worksheet worksheet = workbook.Worksheets[0];
//Write 20 in Cell - C3
//worksheet.Cells[4, 4].Value = txtName.Text;
//worksheet.Cells[30, 3].Value = txtCompany.Text + ", " + txtEmail.Text;
//worksheet.writeStr(4, 4, txtName.Text);
//worksheet.writeStr(30, 3, txtCompany.Text + ", " + txtEmail.Text);
worksheet.Cells[3, 3].Value = txtName.Text;
worksheet.Cells[29, 2].Value = txtCompany.Text + ", " + txtEmail.Text;
int technical = 0;
int adaptive = 0;
var technicalResult = 0D;
var adaptiveResult = 0D;
var curRow = 5;
foreach (var item in data)
{
if (item.Value == 0)
{
worksheet.Cells[curRow, 4].Value = 1;
technical++;
}
//worksheet.writeNum(curRow, 5, 1);
else
{
worksheet.Cells[curRow + 1, 4].Value = 1;
adaptive++;
}
//worksheet.writeNum(curRow + 1, 5, 1);
curRow += 2;
}
technicalResult = (technical / 12) * 100;
adaptiveResult = (adaptive / 12) * 100;
//Save work book (.xlsx format)
//workBook.SaveAs(fileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, null, null, false,
//false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);
//excelAppObj.Quit();
//workBook.WriteXLSX(fileName);
//workbook.save(fileName);
workbook.SaveDocument(fileName);
workbook.ExportToPdf(fileName + ".pdf");
var res = Basics.email_send(fileName, string.Format("Technical Adaptive Assessment Submission - {0}-{1}", txtName.Text, txtCompany.Text), "A new assessment has been submitted.");
if (res == 1)
{
Response.Redirect("Home.aspx");
}
else
{
Response.Redirect("Error.aspx");
}
}
protected void comboReports_SelectedIndexChanged(object sender, EventArgs e)
{
var SelectedReport = comboReports.Value.ToString();
if (SelectedReport == "rep_pro_essa")
{
MemoryStream reportStream1 = new MemoryStream();
MemoryStream reportStream2 = new MemoryStream();
MemoryStream reportStream3 = new MemoryStream();
MemoryStream reportStream4 = new MemoryStream();
XtraReport ReportObject1 = common_services.GetSourcedReport("rep_pro_essa1");
ReportObject1.ExportToXlsx(reportStream1, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "BA-Scorecard"
});
XtraReport ReportObject2 = common_services.GetSourcedReport("rep_pro_essa2");
ReportObject2.ExportToXlsx(reportStream2, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "IA-Scorecard"
});
XtraReport ReportObject3 = common_services.GetSourcedReport("rep_pro_essa3");
ReportObject3.ExportToXlsx(reportStream3, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "TA-Scorecard"
});
XtraReport ReportObject4 = common_services.GetSourcedReport("rep_pro_essa4");
ReportObject4.ExportToXlsx(reportStream4, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "S&C Scorecard"
});
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(reportStream1);
Workbook workbook2 = new DevExpress.Spreadsheet.Workbook();
workbook2.LoadDocument(reportStream2);
Workbook workbook3 = new DevExpress.Spreadsheet.Workbook();
workbook3.LoadDocument(reportStream3);
Workbook workbook4 = new DevExpress.Spreadsheet.Workbook();
workbook4.LoadDocument(reportStream4);
workbook.Worksheets.Insert(1, "IA-Scorecard");
workbook.Worksheets.Insert(2, "TA-Scorecard");
workbook.Worksheets.Insert(3, "S&C Scorecard");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
MemoryStream st = new MemoryStream();
workbook.SaveDocument(st, DocumentFormat.Xlsx);
Response.Clear();
Response.ContentType = "application/force-download";
Response.AddHeader("content-disposition", "attachment; filename=Scorecard_Templates_Ohio2015SS-A.xlsx");
Response.BinaryWrite(st.ToArray());
Response.End();
reportViewer.OpenReport(ReportObject1);
}
else if (SelectedReport == "rep_pro_cms_checlist")
{
var projectId = System.Web.HttpContext.Current.Session["projectID"].ToString();
comboChecklistName.DataSource = rtm_services.GetRTMCheckList(projectId);
comboChecklistName.DataBind();
comboChecklistName.Visible = true;
}
else
{
comboChecklistName.Visible = false;
comboChecklistName.Value = null;
XtraReport ReportObject = common_services.GetSourcedReport(SelectedReport, null, null, null, Page.Request);
reportViewer.OpenReport(ReportObject);
}
}
protected void comboChecklistName_SelectedIndexChanged(object sender, EventArgs e)
{
string path = null;
string guidancepath = null;
string MITApath = null;
string report = comboReports.SelectedItem.ToString();
string reportname = comboReports.Value.ToString();
if (reportname == "rep_pro_cms_checlist")
{
string SelectedChecklisID = comboChecklistName.Value.ToString();
string SelecteChecklist = comboChecklistName.Text.ToString();
string checklist = SelectedChecklisID;
MemoryStream reportStream5 = new MemoryStream();
MemoryStream reportStream6 = new MemoryStream();
//MemoryStream reportStream7 = new MemoryStream();
//MemoryStream reportStream8 = new MemoryStream();
XtraReport ReportObject1 = common_services.GetSourcedReport("rep_pro_cms_checlist", checklist);
ReportObject1.ExportToXlsx(reportStream5, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = SelecteChecklist
});
XtraReport ReportObject2 = common_services.GetSourcedReport("rep_pro_cms_checklist_criticalsuccessfactors", checklist);
ReportObject2.ExportToXlsx(reportStream6, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "Critical Success Factor"
});
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
Workbook workbook2 = new DevExpress.Spreadsheet.Workbook();
Workbook workbook3 = new DevExpress.Spreadsheet.Workbook();
Workbook workbook4 = new DevExpress.Spreadsheet.Workbook();
Workbook workbook5 = new DevExpress.Spreadsheet.Workbook();
switch (SelecteChecklist)
{
case "Provider Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Provider Management Checklist.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "2.2 Standards and Conditions":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Standards and Conditions.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Standards and Conditions.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Integration and Utility":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Integration and Utility.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Integration and Utility.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Plan Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Plan Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Information Architecture":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Information Architure Checklist.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Inforamtion Achitecture.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Contractor Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Contractor Management Checklist.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Member Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Member Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Care Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/CMS_CareManagement.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Operations Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Operations Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Financial Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Financial Management Checklist.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Access and Delivery":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Access and Delivery Checklist.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Access and Delivery.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Intermediary and Interface":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Intermediary and Interface.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Intermediary and Interface.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Performance Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Performance Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Standards and Conditions":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Standards and Conditions.xlsx");
guidancepath = Server.MapPath("~/Content/SpreadSheetTemplate/Guidance Standards and Conditions.xlsx");
MITApath = Server.MapPath("~/Content/SpreadSheetTemplate/MITA Business Process Access and Delivery.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(guidancepath);
workbook4.LoadDocument(MITApath);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "MITA Business Processes");
workbook.Worksheets.Insert(3, "Guidance");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
break;
case "Eligibility and Enrollment":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Eligibility and Enrollment Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
case "Business Relationship Management":
path = Server.MapPath(@"~/Content/SpreadSheetTemplate/Eligibility and Enrollment Management.xlsx");
workbook.LoadDocument(path);
workbook2.LoadDocument(reportStream5);
workbook3.LoadDocument(reportStream6);
workbook.Worksheets.Insert(1, SelecteChecklist);
workbook.Worksheets.Insert(2, "Critical Success Factor");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
break;
}
MemoryStream st = new MemoryStream();
workbook.SaveDocument(st, DocumentFormat.Xlsx);
var state = System.Web.HttpContext.Current.Session["EnterpriseName"].ToString();
string filename = SelecteChecklist + " Checklist (MITA Module)" + state + ".xlsx";
Response.Clear();
Response.ContentType = "application/force-download";
Response.AddHeader("content-disposition", "attachment; filename=" + filename);
Response.BinaryWrite(st.ToArray());
Response.End();
reportViewer.OpenReport(ReportObject1);
}
else
{
comboChecklistName.Visible = false;
comboChecklistName.Value = null;
}
}
protected void button2_Click(object sender, EventArgs e)
{
rep_pro_essa1 report = new rep_pro_essa1();
rep_pro_essa2 report2 = new rep_pro_essa2();
rep_pro_essa3 report3 = new rep_pro_essa3();
rep_pro_essa4 report4 = new rep_pro_essa4();
report.CreateDocument(false);
report2.CreateDocument(false);
//report.DataSource = common_services.GetSourcedReport("rep_pro_essa1");
MemoryStream reportStream1 = new MemoryStream();
MemoryStream reportStream2 = new MemoryStream();
MemoryStream reportStream3 = new MemoryStream();
MemoryStream reportStream4 = new MemoryStream();
report.ExportToXlsx(reportStream1, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "BA-Scorecard"
});
report2.ExportToXlsx(reportStream2, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "IA-Scorecard"
});
report3.ExportToXlsx(reportStream3, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "TA-Scorecard"
});
report4.ExportToXlsx(reportStream4, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "S&C Scorecard"
});
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(reportStream1);
Workbook workbook2 = new DevExpress.Spreadsheet.Workbook();
workbook2.LoadDocument(reportStream2);
Workbook workbook3 = new DevExpress.Spreadsheet.Workbook();
workbook3.LoadDocument(reportStream3);
Workbook workbook4 = new DevExpress.Spreadsheet.Workbook();
workbook4.LoadDocument(reportStream4);
workbook.Worksheets.Insert(1, "IA-Scorecard");
workbook.Worksheets.Insert(2, "TA-Scorecard");
workbook.Worksheets.Insert(3, "S&C Scorecard");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
workbook.Worksheets[3].CopyFrom(workbook4.Worksheets[0]);
//workbook.SaveDocument("C:/Users/Mohan Babu/Desktop/ReadycertXLS/Scorecard_Templates_Ohio2015SS-A.xlsx");
MemoryStream st = new MemoryStream();
workbook.SaveDocument(st, DocumentFormat.Xlsx);
Response.Clear();
Response.ContentType = "application/force-download";
Response.AddHeader("content-disposition", "attachment; filename=Scorecard_Templates_Ohio2015SS-A.xlsx");
Response.BinaryWrite(st.ToArray());
Response.End();
//System.Diagnostics.Process.Start("C:/Users/Mohan Babu/Desktop/ReadycertXLS/Scorecard_Templates_Ohio2015SS-A.xlsx");
}
protected void comboIVV_SelectedIndexChanged(object sender, EventArgs e)
{
string SelectedReport = comboReports.Value.ToString();
if (SelectedReport == "rep_pro_ivv_progress")
{
string SelectedID = comboIVV.Value.ToString();
string SelecteChecklist = comboIVV.Text.ToString();
string StateProject = SelectedID;
MemoryStream reportStream1 = new MemoryStream();
MemoryStream reportStream2 = new MemoryStream();
XtraReport ReportObject1 = common_services.GetSourcedReport("rep_pro_ivv_progress", StateProject);
ReportObject1.ExportToXlsx(reportStream1, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "IV&V"
});
XtraReport ReportObject2 = common_services.GetSourcedReport("rep_pro_ivv_checklist_rtm");
ReportObject2.ExportToXlsx(reportStream2, new DevExpress.XtraPrinting.XlsxExportOptions()
{
SheetName = "Programmatic"
});
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(reportStream1);
Workbook workbook2 = new DevExpress.Spreadsheet.Workbook();
workbook2.LoadDocument(reportStream2);
var path = Server.MapPath(@"~/Content/SpreadSheetTemplate/IVV CMS Response.xlsx");
Workbook workbook3 = new DevExpress.Spreadsheet.Workbook();
workbook3.LoadDocument(path);
workbook.Worksheets.Insert(1, "Programmatic");
workbook.Worksheets.Insert(2, "CMS Response");
workbook.Worksheets[1].CopyFrom(workbook2.Worksheets[0]);
workbook.Worksheets[2].CopyFrom(workbook3.Worksheets[0]);
MemoryStream st = new MemoryStream();
workbook.SaveDocument(st, DocumentFormat.Xlsx);
var state = System.Web.HttpContext.Current.Session["EnterpriseName"].ToString();
string filename = " 05 MECT 2_2 Appendix D_MMIS IVV Progress Report Template.xlsx";
Response.Clear();
Response.ContentType = "application/force-download";
Response.AddHeader("content-disposition", "attachment; filename=" + filename);
Response.BinaryWrite(st.ToArray());
Response.End();
reportViewer.OpenReport(ReportObject1);
}
else
{
comboIVV.Visible = false;
comboIVV.Value = null;
}
}