public async Task <IActionResult> GenerateXls([FromQuery] int unitId, [FromQuery] DateTimeOffset date)
{
try
{
VerifyUser();
var data = await _service.GetBudgetCashflowUnit(unitId, date);
//var unit = _units.FirstOrDefault(element => element.Id == unitId);
var unit = await _service.GetUnitAccountingById(unitId);
var stream = CashflowUnitExcelGenerator.Generate(unit, date, _identityService.TimezoneOffset, data);
var bytes = stream.ToArray();
return(File(bytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Laporan Budget Cashflow.xlsx"));
}
catch (Exception e)
{
var result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, result));
}
}