public async Task <IActionResult> Download()
{
using (var package = new ExcelPackage())
{
var completeRegisterWorkSheet = package.Workbook.Worksheets.Add(CompleteRegisterWorksheetName);
var registerData = await _apiClient.GetCompleteRegister();
if (registerData != null && registerData.Any())
{
completeRegisterWorkSheet.Cells.LoadFromDataTable(_dataTableHelper.ToDataTable(registerData), true);
}
else
{
_logger.LogError("Unable to retrieve register data from RoATP API");
}
var auditHistoryWorksheet = package.Workbook.Worksheets.Add(AuditHistoryWorksheetName);
var auditHistoryData = await _apiClient.GetAuditHistory();
if (auditHistoryData != null && auditHistoryData.Any())
{
auditHistoryWorksheet.Cells.LoadFromDataTable(_dataTableHelper.ToDataTable(auditHistoryData), true);
}
else
{
_logger.LogError("Unable to retrieve audit history data from RoATP API");
}
return(File(package.GetAsByteArray(), "application/excel", $"{DateTime.Now.ToString("yyyyMMdd")}{ExcelFileName}"));
}
}