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);
}
