internal static List <Order> FindOrdersByOrderNumber(int storeId, List <string> orderNumbers)
{
var q = new OrderQuery();
q.Where(q.StoreId == storeId, q.OrderNumber.In(orderNumbers.ToArray()));
q.OrderBy(q.OrderNumber.Ascending);
var collection = new OrderCollection();
collection.Load(q);
return(collection.ToList());
}
internal static List <Order> GetOrdersByIds(List <int> orderIds)
{
var q = new OrderQuery();
q.Where(q.Id.In(orderIds.ToArray()));
q.OrderBy(q.OrderNumber.Ascending);
var collection = new OrderCollection();
collection.Load(q);
return(collection.ToList());
}
public static List <Order> GetAllOrders(int?storeId)
{
OrderQuery q = new OrderQuery();
q.Where(q.StoreId == storeId);
q.Where(q.IsDeleted == false);
q.OrderBy(q.CreatedOn.Descending);
OrderCollection collection = new OrderCollection();
collection.Load(q);
return(collection.ToList());
}
internal static List <Order> GetCompletedOrders(int storeId)
{
OrderQuery q = new OrderQuery();
q.Where(q.StoreId == storeId);
q.Where(q.OrderStatusId == (short)OrderStatusName.Completed);
q.Where(q.IsDeleted == false);
q.OrderBy(q.CreatedOn.Descending);
OrderCollection collection = new OrderCollection();
collection.Load(q);
return(collection.ToList());
}
internal static List <Order> FindOrders(int storeId, DateTime?fromDate, DateTime?toDate, string customerFirstName, string customerLastName, string customerEmail, List <OrderStatusName> orderStatuses, int?maxResults)
{
OrderQuery q = new OrderQuery();
q.Where(q.StoreId == storeId);
if (maxResults.HasValue)
{
q.es.Top = maxResults.Value;
}
if (fromDate.HasValue)
{
q.Where(q.CreatedOn >= fromDate.Value);
}
if (toDate.HasValue)
{
q.Where(q.CreatedOn <= toDate.Value);
}
if (!string.IsNullOrEmpty(customerFirstName))
{
q.Where(q.CustomerFirstName.Like("%" + customerFirstName + "%"));
}
if (!string.IsNullOrEmpty(customerLastName))
{
q.Where(q.CustomerLastName.Like("%" + customerLastName + "%"));
}
if (!string.IsNullOrEmpty(customerEmail))
{
q.Where(q.CustomerEmail.Like("%" + customerEmail + "%"));
}
if (orderStatuses.Count > 0)
{
short[] orderStatusIds = orderStatuses.ConvertAll(x => (short)x).ToArray();
q.Where(q.OrderStatusId.In(orderStatusIds));
}
q.OrderBy(q.CreatedOn.Descending);
OrderCollection collection = new OrderCollection();
collection.Load(q);
return(collection.ToList());
}
internal static List <Order> GetOrdersForUser(int userId, int?storeId, bool includeDeleted)
{
OrderQuery q = new OrderQuery();
q.Where(q.UserId == userId);
if (storeId.HasValue)
{
q.Where(q.StoreId == storeId);
}
if (!includeDeleted)
{
q.Where(q.IsDeleted == false);
}
q.OrderBy(q.CreatedOn.Descending);
OrderCollection collection = new OrderCollection();
if (collection.Load(q))
{
return(collection.ToList());
}
return(new List <Order>());
}
