public static byte[] ExecuteExcelReport(Lite <ExcelReportEntity> excelReport, QueryRequest request)
{
ResultTable queryResult = QueryLogic.Queries.ExecuteQuery(request);
ExcelReportEntity report = excelReport.RetrieveAndForget();
AsserExtension(report);
return(ExcelGenerator.WriteDataInExcelFile(queryResult, report.File.BinaryFile));
}
public static async Task <byte[]> ExecuteExcelReportAsync(Lite <ExcelReportEntity> excelReport, QueryRequest request, CancellationToken token)
{
ResultTable queryResult = await QueryLogic.Queries.ExecuteQueryAsync(request, token);
ExcelReportEntity report = excelReport.RetrieveAndForget();
AsserExtension(report);
return(ExcelGenerator.WriteDataInExcelFile(queryResult, report.File.BinaryFile));
}
public static byte[] WriteDataInExcelFile(ResultTable queryResult, byte[] template)
{
using (MemoryStream ms = new MemoryStream())
{
ms.WriteAllBytes(template);
ms.Seek(0, SeekOrigin.Begin);
ExcelGenerator.WriteDataInExcelFile(queryResult, ms);
return(ms.ToArray());
}
}
