public async Task <Result <string> > RequestGiftCertificatesReportFile([FromBody] GCFilter filter) { filter.Paging = null; var data = (await GCService.GetGiftCertificatesAsync(filter)).Items. Select(p => new GCListItemModel(p, LookupHelper.GetGCTypeName(p.GCType))).ToList(); var result = _gCListItemModelExportCSVExportService.ExportToCsv(data); var guid = Guid.NewGuid().ToString().ToLower(); _cache.SetItem(String.Format(CacheKeys.ReportFormat, guid), result); return(guid); }
public async Task <FileResult> GetGiftCertificatesWithOrderInfoReportFile([FromQuery] string from, [FromQuery] string to, [FromQuery] int?type = null, [FromQuery] int?status = null, [FromQuery] string billinglastname = null, [FromQuery] string shippinglastname = null, [FromQuery] bool notzerobalance = false) { DateTime?dFrom = !string.IsNullOrEmpty(from) ? from.GetDateFromQueryStringInPst(TimeZoneHelper.PstTimeZoneInfo) : null; DateTime?dTo = !string.IsNullOrEmpty(to) ? to.GetDateFromQueryStringInPst(TimeZoneHelper.PstTimeZoneInfo) : null; GCFilter filter = new GCFilter() { From = dFrom, To = dTo?.AddDays(1) ?? dTo, Type = type.HasValue ? (GCType?)type.Value : null, StatusCode = status.HasValue ? (RecordStatusCode?)status.Value : null, BillingAddress = !String.IsNullOrEmpty(billinglastname) ? new CustomerAddressFilter() { LastName = billinglastname }: null, ShippingAddress = !String.IsNullOrEmpty(shippinglastname) ? new CustomerAddressFilter() { LastName = shippinglastname } : null, NotZeroBalance = notzerobalance, }; filter.Paging = null; var data = await GCService.GetGiftCertificatesWithOrderInfoAsync(filter); foreach (var item in data.Items) { item.Created = TimeZoneInfo.ConvertTime(item.Created, TimeZoneInfo.Local, TimeZoneHelper.PstTimeZoneInfo); } var result = _gCWithOrderListItemModelCsvMapCSVExportService.ExportToCsv(data.Items); var contentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = String.Format(FileConstants.GIFT_CERTIFICATES_REPORT_STATISTIC, DateTime.Now) }; Response.Headers.Add("Content-Disposition", contentDisposition.ToString()); return(File(result, "text/csv")); }
public async Task <Result <PagedList <GCListItemModel> > > GetGiftCertificates([FromBody] GCFilter filter) { var result = await GCService.GetGiftCertificatesAsync(filter); var toReturn = new PagedList <GCListItemModel> { Items = result.Items.Select(p => new GCListItemModel(p, LookupHelper.GetGCTypeName(p.GCType))).ToList(), Count = result.Count, }; return(toReturn); }
public async Task <Result <GCStatisticModel> > GetGiftCertificatesWithOrderInfo([FromBody] GCFilter filter) { filter.To = filter.To?.AddDays(1) ?? filter.To; GCStatisticModel toReturn = await GCService.GetGiftCertificatesWithOrderInfoAsync(filter); return(toReturn); }