public QueryResultDisplay SearchByDateRange(QueryDisplay query)
{
var invoiceDateStart = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateStart");
var invoiceDateEnd = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateEnd");
DateTime startDate;
DateTime endDate;
if (invoiceDateStart == null)
{
throw new NullReferenceException("invoiceDateStart is a required parameter");
}
if (!DateTime.TryParse(invoiceDateStart.Value, out startDate))
{
throw new InvalidCastException("Failed to convert invoiceDateStart to a valid DateTime");
}
endDate = invoiceDateEnd == null
? DateTime.MaxValue
: DateTime.TryParse(invoiceDateEnd.Value, out endDate)
? endDate
: DateTime.MaxValue;
var invoices = _merchello.Query.Invoice.Search(
startDate,
endDate,
1,
long.MaxValue,
query.SortBy,
query.SortDirection);
var result = new QueryResultDisplay();
if (!invoices.Items.Any())
{
return(result);
}
// Use a visitor to build the collection of report data
var vistor = new SalesByItemVisitor(_merchello);
foreach (var invoice in invoices.Items)
{
((InvoiceDisplay)invoice).Accept(vistor);
}
result.TotalItems = vistor.Results.Count();
result.ItemsPerPage = vistor.Results.Count();
result.CurrentPage = 0;
result.TotalPages = 1;
result.Items = vistor.Results;
return(result);
}
public QueryResultDisplay SearchByDateRange(QueryDisplay query)
{
var invoiceDateStart = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateStart");
var invoiceDateEnd = query.Parameters.FirstOrDefault(x => x.FieldName == "invoiceDateEnd");
DateTime startDate;
DateTime endDate;
if (invoiceDateStart == null)
{
throw new NullReferenceException("invoiceDateStart is a required parameter");
}
var settings = _storeSettingService.GetAll().ToList();
var dateFormat = settings.FirstOrDefault(s => s.Name == "dateFormat");
if (dateFormat == null)
{
if (!DateTime.TryParse(invoiceDateStart.Value, out startDate))
{
throw new InvalidCastException("Failed to convert invoiceDateStart to a valid DateTime");
}
}
else if (!DateTime.TryParseExact(invoiceDateStart.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out startDate))
{
throw new InvalidCastException("Failed to convert invoiceDateStart to a valid DateTime");
}
endDate = invoiceDateEnd == null || dateFormat == null
? DateTime.MaxValue
: DateTime.TryParseExact(invoiceDateEnd.Value, dateFormat.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out endDate)
? endDate
: DateTime.MaxValue;
var invoices = _merchello.Query.Invoice.Search(
startDate,
endDate.AddDays(1), // through end of day
1,
long.MaxValue,
query.SortBy,
query.SortDirection);
var result = new QueryResultDisplay();
if (!invoices.Items.Any())
{
return(result);
}
// Use a visitor to build the collection of report data
var vistor = new SalesByItemVisitor(_merchello);
foreach (var invoice in invoices.Items)
{
((InvoiceDisplay)invoice).Accept(vistor);
}
result.TotalItems = vistor.Results.Count();
result.ItemsPerPage = vistor.Results.Count();
result.CurrentPage = 0;
result.TotalPages = 1;
result.Items = vistor.Results;
return(result);
}
