public async Task <IActionResult> SecondaryAdminDownloadAssetDeploy(DownloadAssetDeploy model)
{
byte[] reportBytes;
using (var package = await _assetDeployService.DownloadAssetDeploy(model))
{
reportBytes = package.GetAsByteArray();
}
return(File(reportBytes, XlsxContentType, "report.xlsx"));
}
public async Task <ExcelPackage> DownloadAssetDeploy(DownloadAssetDeploy model)
{
var deploys = _assetDeployRepository.GetAll(it => it.AuthorizeOrgInfo.OrgId == _user.OrgId &&
it.CreateDateTime >= model.StartDate &&
it.CreateDateTime <= model.EndDate);
if (model.ImportOrgId != null)
{
deploys = deploys.Where(it => it.ImportOrgInfo.OrgId == model.ImportOrgId.Value);
}
if (model.ExportOrgId != null)
{
deploys = deploys.Where(it => it.ExportOrgInfo.OrgId == model.ExportOrgId.Value);
}
var dtos = await _mapper.ProjectTo <AssetDeployDto>(deploys).ToListAsync();
return(CreateAssetDeployExcelPackage(dtos));
}