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