private void CreateReportData(ReportGeneralModel model, Excel xls)
{
int rowIndexResume = 2;
int writeRowIndex = 6;
int i = 1;
using (DataSet ds = this.db.REPORT_GeneralDetalle(model.ClientID, model.DateStart, model.DateEnd, model.Folder, model.Record))
{
XSSFRow x = xls.NewRow(rowIndexResume);
this.CreateReportResumeRow(x, ds.Tables["Resumen"].Rows[0]);
foreach (DataRow row in ds.Tables["Detalle"].Rows)
{
XSSFRow y = xls.NewRow(writeRowIndex);
this.CreateReportDataRow(y, row, i);
writeRowIndex++;
i++;
}
}
}
private FileContentResult CreateReport(ReportGeneralModel model)
{
string path = Server.MapPath(ConfigurationManager.AppSettings["Excel.Template"]);
string fileName = String.Format("[{0}] Reporte.xlsx", DateTime.Now.ToString("yyyy-MM-dd"));
using (Excel xls = new Excel(path))
{
this.CreateReportData(model, xls);
MemoryStream ms = new MemoryStream();
xls._Workbook.Write(ms);
return File(ms.ToArray(), "application/vnd.ms-excel", fileName);
}
}
