public ActionResult Create(Lite <QueryEntity> query, string prefix)
{
ExcelReportEntity report = new ExcelReportEntity {
Query = query.Retrieve()
};
return(this.DefaultConstructResult(report, prefix));
}
private static void AsserExtension(ExcelReportEntity report)
{
string extension = Path.GetExtension(report.File.FileName);
if (extension != ".xlsx")
{
throw new ApplicationException(ExcelMessage.ExcelTemplateMustHaveExtensionXLSXandCurrentOneHas0.NiceToString().FormatWith(extension));
}
}
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));
}
