public async Task <FileResult> Handle(GetFilteredTransactionsQuery query, CancellationToken cancellationToken) { var transactionList = await _context.Transactions.ToListAsync(); if (!String.IsNullOrEmpty(query.ClientName)) { transactionList = transactionList.Where(a => a.ClientName == query.ClientName).ToList(); } if (!String.IsNullOrEmpty(query.Type)) { transactionList = transactionList.Where(a => a.Type == query.Type).ToList(); } if (!String.IsNullOrEmpty(query.Status)) { transactionList = transactionList.Where(a => a.Status == query.Status).ToList(); } if (transactionList == null) { return(null); } ExcelFileCreator.CreateExcelFile(transactionList); return(new PhysicalFileResult("Excel.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = "export.xlsx" }); }
public IHttpActionResult Create() { var userId = User.Identity.GetUserId(); ExcelFileCreator.ExportReportToXlsxFile(this.data, userId); GoogleDriveFileExporter.UploadFile(); return(Ok()); }
public async Task <FileResult> Handle(GetAllTransactionsQuery query, CancellationToken cancellationToken) { var transactionList = await _context.Transactions.ToListAsync(); if (transactionList == null) { return(null); } ExcelFileCreator.CreateExcelFile(transactionList); return(new VirtualFileResult("Excel.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = "export.xlsx" }); }