public async Task <FileResult> GetInventorySkuUsageReportFile([FromQuery] string from, [FromQuery] string to, [FromQuery] string skuids, [FromQuery] string invskuids) { var dFrom = from.GetDateFromQueryStringInPst(TimeZoneHelper.PstTimeZoneInfo); var dTo = to.GetDateFromQueryStringInPst(TimeZoneHelper.PstTimeZoneInfo); if (!dFrom.HasValue || !dTo.HasValue) { return(null); } InventorySkuUsageReportFilter filter = new InventorySkuUsageReportFilter() { From = dFrom.Value, To = dTo.Value, SkuIds = !string.IsNullOrEmpty(skuids) ? skuids.Split(',').Select(Int32.Parse).ToList() : new List <int>(), InvSkuIds = !string.IsNullOrEmpty(invskuids) ? invskuids.Split(',').Select(Int32.Parse).ToList() : new List <int>(), }; filter.To = filter.To.AddDays(1); var result = await _inventorySkuService.GetInventorySkuUsageReportForExportAsync(filter); var data = _inventorySkuUsageReportItemForExportCSVExportService.ExportToCsv(result); var contentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = String.Format(FileConstants.INVENTORY_SKUS_REPORT, DateTime.Now) }; Response.Headers.Add("Content-Disposition", contentDisposition.ToString()); return(File(data, "text/csv")); }
public async Task <Result <ICollection <InventorySkuUsageReportItem> > > GetInventorySkuUsageReport([FromBody] InventorySkuUsageReportFilter filter) { filter.To = filter.To.AddDays(1); var toReturn = await _inventorySkuService.GetInventorySkuUsageReportAsync(filter); return(toReturn.ToList()); }