/// <summary>
/// The get default report data.
///
/// GET /umbraco/Merchello/ExportOrdersReportApi/GetOrderReportData/
///
/// </summary>
/// <returns>
/// The <see cref="QueryResultDisplay"/>.
/// </returns>
public QueryResultDisplay GetOrderReportData()
{
var dtStart = new DateTime(2014, 1, 1);
var dtEnd = new DateTime(2014, 12, 31);
var invoices = _invoiceService.GetInvoicesByDateRange(dtStart, dtEnd).ToArray();
var queryResultDisplay = new QueryResultDisplay();
try
{
var csvExport = new CvsExport();
foreach (var invoice in invoices)
{
csvExport.AddRow();
csvExport["Invoice Number"] = invoice.InvoiceNumber;
csvExport["PO Number"] = invoice.PoNumber;
csvExport["Order Date"] = invoice.InvoiceDate;
csvExport["Bill To Name"] = invoice.BillToName;
csvExport["Bill To Company"] = invoice.BillToCompany;
csvExport["Bill To Address"] = invoice.BillToAddress1;
csvExport["Bill To Address2"] = invoice.BillToAddress2;
csvExport["Email"] = invoice.BillToEmail;
csvExport["Phone"] = invoice.BillToPhone;
csvExport["City"] = invoice.BillToLocality;
csvExport["State"] = invoice.BillToRegion;
csvExport["Postal Code"] = invoice.BillToPostalCode;
csvExport["Total"] = invoice.Total;
csvExport["Status"] = invoice.InvoiceStatus.Name;
foreach (var invoiceItems in invoice.Items)
{
foreach (var invoiceItem in invoice.Items)
{
if (invoiceItem.LineItemType == LineItemType.Product)
{
csvExport["Name"] = invoiceItem.Name;
csvExport["Sku"] = invoiceItem.Sku;
csvExport["Quantity"] = invoiceItem.Quantity;
csvExport["Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Shipping)
{
csvExport["Ship Method"] = invoiceItem.Name;
csvExport["Ship Quantity"] = invoiceItem.Quantity;
csvExport["Ship Price"] = invoiceItem.Price;
var origin = invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingOriginAddress);
var destination = invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingDestinationAddress);
csvExport["Ship Origin"] = FormatAddress(origin);
csvExport["Ship Destination"] = FormatAddress(destination);
}
else if (invoiceItem.LineItemType == LineItemType.Tax)
{
csvExport["Tax"] = invoiceItem.Name;
csvExport["Tax Quantity"] = invoiceItem.Quantity;
csvExport["Tax Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Discount)
{
csvExport["Coupon"] = invoiceItem.Name;
csvExport["Coupon Quantity"] = invoiceItem.Quantity;
csvExport["Coupon Price"] = invoiceItem.Price;
}
}
}
}
string path = HttpContext.Current.Server.MapPath("/orders.csv");
csvExport.ExportToFile(path);
queryResultDisplay = new QueryResultDisplay {
Items = invoices, TotalItems = invoices.Count()
};
}
catch (SystemException e)
{
string ex = e.Message;
}
return(queryResultDisplay);
}
public HttpResponseMessage GetOrderReportData(QueryDisplay query)
{
HttpResponseMessage result = null;
var invoiceDateStart = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateStart");
var invoiceDateEnd = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateEnd");
DateTime dtStart;
DateTime dtEnd;
if (invoiceDateStart == null)
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "invoiceDateStart is a required parameter");
return(result);
}
var settings = _storeSettingService.GetAll().ToList();
var dateFormat = settings.FirstOrDefault(s => s.Name == "dateFormat");
if (dateFormat == null)
{
if (!DateTime.TryParse(invoiceDateStart.Value, out dtStart))
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Failed to convert invoiceDateStart to a valid DateTime");
return(result);
}
}
else if (!DateTime.TryParseExact(invoiceDateStart.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out dtStart))
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Failed to convert invoiceDateStart to a valid DateTime");
return(result);
}
dtEnd = invoiceDateEnd == null || dateFormat == null
? DateTime.MaxValue
: DateTime.TryParseExact(invoiceDateEnd.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out dtEnd)
? dtEnd.AddDays(1) // through end of day
: DateTime.MaxValue;
var invoices = _invoiceService.GetInvoicesByDateRange(dtStart, dtEnd).ToArray();
try
{
var csvExport = new CvsExport();
foreach (var invoice in invoices)
{
csvExport.AddRow();
csvExport["Invoice Number"] = invoice.InvoiceNumber;
csvExport["PO Number"] = invoice.PoNumber;
csvExport["Order Date"] = invoice.InvoiceDate;
csvExport["Bill To Name"] = invoice.BillToName;
csvExport["Bill To Company"] = invoice.BillToCompany;
csvExport["Bill To Address"] = invoice.BillToAddress1;
csvExport["Bill To Address2"] = invoice.BillToAddress2;
csvExport["Email"] = invoice.BillToEmail;
csvExport["Phone"] = invoice.BillToPhone;
csvExport["City"] = invoice.BillToLocality;
csvExport["State"] = invoice.BillToRegion;
csvExport["Postal Code"] = invoice.BillToPostalCode;
csvExport["Total"] = invoice.Total;
csvExport["Status"] = invoice.InvoiceStatus.Name;
foreach (var invoiceItems in invoice.Items)
{
foreach (var invoiceItem in invoice.Items)
{
if (invoiceItem.LineItemType == LineItemType.Product)
{
csvExport["Name"] = invoiceItem.Name;
csvExport["Sku"] = invoiceItem.Sku;
csvExport["Quantity"] = invoiceItem.Quantity;
csvExport["Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Shipping)
{
csvExport["Ship Method"] = invoiceItem.Name;
csvExport["Ship Quantity"] = invoiceItem.Quantity;
csvExport["Ship Price"] = invoiceItem.Price;
var origin = invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingOriginAddress);
var destination = invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingDestinationAddress);
csvExport["Ship Origin"] = FormatAddress(origin);
csvExport["Ship Destination"] = FormatAddress(destination);
}
else if (invoiceItem.LineItemType == LineItemType.Tax)
{
csvExport["Tax"] = invoiceItem.Name;
csvExport["Tax Quantity"] = invoiceItem.Quantity;
csvExport["Tax Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Discount)
{
csvExport["Coupon"] = invoiceItem.Name;
csvExport["Coupon Quantity"] = invoiceItem.Quantity;
csvExport["Coupon Price"] = invoiceItem.Price;
}
}
}
}
result = Request.CreateResponse(HttpStatusCode.OK);
result.Content = new StreamContent(csvExport.ExportToStream());
result.Content.Headers.ContentType = new MediaTypeHeaderValue("text/csv");
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = "Orders.csv"
};
}
catch (SystemException ex)
{
result = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
return(result);
}
return(result);
}
public HttpResponseMessage GetOrderReportData(QueryDisplay query)
{
HttpResponseMessage result = null;
var invoiceDateStart = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateStart");
var invoiceDateEnd = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateEnd");
DateTime dtStart;
DateTime dtEnd;
if (invoiceDateStart == null)
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "invoiceDateStart is a required parameter");
return result;
}
var settings = _storeSettingService.GetAll().ToList();
var dateFormat = settings.FirstOrDefault(s => s.Name == "dateFormat");
if (dateFormat == null)
{
if (!DateTime.TryParse(invoiceDateStart.Value, out dtStart))
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Failed to convert invoiceDateStart to a valid DateTime");
return result;
}
}
else if (!DateTime.TryParseExact(invoiceDateStart.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out dtStart))
{
result = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Failed to convert invoiceDateStart to a valid DateTime");
return result;
}
dtEnd = invoiceDateEnd == null || dateFormat == null
? DateTime.MaxValue
: DateTime.TryParseExact(invoiceDateEnd.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out dtEnd)
? dtEnd.AddDays(1) // through end of day
: DateTime.MaxValue;
var invoices = _invoiceService.GetInvoicesByDateRange(dtStart,dtEnd).ToArray();
try
{
var csvExport = new CvsExport();
foreach (var invoice in invoices)
{
csvExport.AddRow();
csvExport["Invoice Number"] = invoice.InvoiceNumber;
csvExport["PO Number"] = invoice.PoNumber;
csvExport["Order Date"] = invoice.InvoiceDate;
csvExport["Bill To Name"] = invoice.BillToName;
csvExport["Bill To Company"] = invoice.BillToCompany;
csvExport["Bill To Address"] = invoice.BillToAddress1;
csvExport["Bill To Address2"] = invoice.BillToAddress2;
csvExport["Email"] = invoice.BillToEmail;
csvExport["Phone"] = invoice.BillToPhone;
csvExport["City"] = invoice.BillToLocality;
csvExport["State"] = invoice.BillToRegion;
csvExport["Postal Code"] = invoice.BillToPostalCode;
csvExport["Total"] = invoice.Total;
csvExport["Status"] = invoice.InvoiceStatus.Name;
foreach (var invoiceItems in invoice.Items)
{
foreach (var invoiceItem in invoice.Items)
{
if (invoiceItem.LineItemType == LineItemType.Product)
{
csvExport["Name"] = invoiceItem.Name;
csvExport["Sku"] = invoiceItem.Sku;
csvExport["Quantity"] = invoiceItem.Quantity;
csvExport["Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Shipping)
{
csvExport["Ship Method"] = invoiceItem.Name;
csvExport["Ship Quantity"] = invoiceItem.Quantity;
csvExport["Ship Price"] = invoiceItem.Price;
var origin =invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingOriginAddress);
var destination =invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingDestinationAddress);
csvExport["Ship Origin"] = FormatAddress(origin);
csvExport["Ship Destination"] = FormatAddress(destination);
}
else if (invoiceItem.LineItemType == LineItemType.Tax)
{
csvExport["Tax"] = invoiceItem.Name;
csvExport["Tax Quantity"] = invoiceItem.Quantity;
csvExport["Tax Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Discount)
{
csvExport["Coupon"] = invoiceItem.Name;
csvExport["Coupon Quantity"] = invoiceItem.Quantity;
csvExport["Coupon Price"] = invoiceItem.Price;
}
}
}
}
result = Request.CreateResponse(HttpStatusCode.OK);
result.Content = new StreamContent(csvExport.ExportToStream());
result.Content.Headers.ContentType = new MediaTypeHeaderValue("text/csv");
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = "Orders.csv"
};
}
catch (SystemException ex)
{
result = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
return result;
}
return result;
}
/// <summary>
/// The get default report data.
///
/// GET /umbraco/Merchello/ExportOrdersReportApi/GetOrderReportData/
///
/// </summary>
/// <returns>
/// The <see cref="QueryResultDisplay"/>.
/// </returns>
public QueryResultDisplay GetOrderReportData()
{
var dtStart = new DateTime(2014,1,1);
var dtEnd = new DateTime(2014,12,31);
var invoices = _invoiceService.GetInvoicesByDateRange(dtStart,dtEnd).ToArray();
var queryResultDisplay = new QueryResultDisplay();
try
{
var csvExport = new CvsExport();
foreach (var invoice in invoices)
{
csvExport.AddRow();
csvExport["Number"] = invoice.InvoiceNumber;
csvExport["Date"] = invoice.InvoiceDate;
csvExport["Bill To Name"] = invoice.BillToName;
csvExport["Bill To Company"] = invoice.BillToCompany;
csvExport["Bill To Address"] = invoice.BillToAddress1;
csvExport["Bill To Address2"] = invoice.BillToAddress2;
csvExport["Email"] = invoice.BillToEmail;
csvExport["Phone"] = invoice.BillToPhone;
csvExport["City"] = invoice.BillToLocality;
csvExport["State"] = invoice.BillToRegion;
csvExport["Postal Code"] = invoice.BillToPostalCode;
csvExport["Total"] = invoice.Total;
csvExport["Status"] = invoice.InvoiceStatus.Name;
foreach (var invoiceItems in invoice.Items)
{
foreach (var invoiceItem in invoice.Items)
{
if (invoiceItem.LineItemType == LineItemType.Product)
{
csvExport["Name"] = invoiceItem.Name;
csvExport["Sku"] = invoiceItem.Sku;
csvExport["Quantity"] = invoiceItem.Quantity;
csvExport["Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Shipping)
{
csvExport["Ship Method"] = invoiceItem.Name;
csvExport["Ship Quantity"] = invoiceItem.Quantity;
csvExport["Ship Price"] = invoiceItem.Price;
var origin =invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingOriginAddress);
var destination =invoiceItem.ExtendedData.GetAddress(Constants.ExtendedDataKeys.ShippingDestinationAddress);
csvExport["Ship Origin"] = FormatAddress(origin);
csvExport["Ship Destination"] = FormatAddress(destination);
}
else if (invoiceItem.LineItemType == LineItemType.Tax)
{
csvExport["Tax"] = invoiceItem.Name;
csvExport["Tax Quantity"] = invoiceItem.Quantity;
csvExport["Tax Price"] = invoiceItem.Price;
}
else if (invoiceItem.LineItemType == LineItemType.Discount)
{
csvExport["Coupon"] = invoiceItem.Name;
csvExport["Coupon Quantity"] = invoiceItem.Quantity;
csvExport["Coupon Price"] = invoiceItem.Price;
}
}
}
}
string path = HttpContext.Current.Server.MapPath("/orders.csv");
csvExport.ExportToFile(path);
queryResultDisplay = new QueryResultDisplay { Items = invoices, TotalItems = invoices.Count() };
}
catch (SystemException e)
{
string ex = e.Message;
}
return queryResultDisplay;
}