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