public FileContentResult KrogerInvoiceExcelReport(int locationId, DateTime periodFrom, DateTime periodTo, Boolean breakdownByDepartment)
{
var location = locationRepository.FindById(locationId);
if (location == null)
{
throw new Exception("Location not found");
}
var workOrders = workOrderRepository.GetLoadsForKrogerInvoice(location, periodFrom, periodTo);
var invoiceReportModel = new KrogerUnloadingInvoiceModel(location, workOrders, periodFrom, periodTo, breakdownByDepartment);
var fileBytes = krogerExcelGenerator.Generate(invoiceReportModel);
var invoiceFileName = $"Invoice{invoiceReportModel.HeaderInfo.InvoiceNumber}.xlsx";
return(File(fileBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", invoiceFileName));
}
