public IQueryable <Order> SearchOrders(SearchOrderOptions options) { if (options == null) { return(null); } var query = context_ .Set <Order>() .AsQueryable(); if (options.OrderId != null) { query = query.Where(c => c.OrderId == options.OrderId.Value); } if (options.CustomerId != null) { var customer = customerService_.SearchCustomers(new SearchCustomerOptions() { CustomerId = options.CustomerId }).SingleOrDefault(); query = query.Where(c => customer.Orders.Contains(c)); } //if (options.ProductIds.Any()) //{ // query = query.Where(c => !options.ProductIds.Except(c.OrderProducts.Pr).Any()); //} query = query.Take(500); return(query); }
public IQueryable <Order> SearchOrders(SearchOrderOptions options) { if (options == null) { return(null); } var query = context_ .Set <Order>() .AsQueryable(); if (options.DeliveryAddress != null) { query = query.Where(o => o.DeliveryAddress == options.DeliveryAddress); } if (options.PriceFrom != null) { query = query.Where(o => o.TotalAmount >= options.PriceFrom); } if (options.PriceTo != null) { query = query.Where(o => o.TotalAmount <= options.PriceTo); } return(query.AsQueryable()); }
public IQueryable <Order> SearchOrders( SearchOrderOptions options) { if (options == null) { return(null); } var query = context .Set <Order>() .AsQueryable(); if (options.OrderId != null) { query = query.Where(ord => ord.OrderId == options.OrderId); } if (options.CreatedFrom != null) { query = query.Where(ord => ord.Created >= options.CreatedFrom); } if (options.CreatedTo != null) { query = query.Where(ord => ord.Created <= options.CreatedTo); } if (!string.IsNullOrWhiteSpace(options.DeliveryAddress)) { query = query.Where(ord => ord.DeliveryAddress == options.DeliveryAddress); } return(query); }
// find for specific orders public List <Order> SearchOrders(SearchOrderOptions opt) { if (opt == null) { return(null); } var customers = db_.Set <Customer>() .Where(ord => opt.CustomerId == ord.CustomerId) .Include(c => c.Orders) .ToList(); if (customers.Count() > 0) { var orders = new List <Order>(); foreach (var c in customers) { foreach (var el in c.Orders) { orders.Add(el); } } return(orders); } else { return(null); } }
public List <Order> SearchOrder(SearchOrderOptions options) { if (options == null) { return(null); } var oResults = context_.Set <Customer>() .Where(o => o.CustomerId == options.CustomerId) .Include(c => c.Orders).SingleOrDefault(); return(oResults.Orders); }
public ApiResult <int> OrdersInEachStatus( SearchOrderOptions option) { if (option == null) { return(new ApiResult <int>( StatusCode.BadRequest, "null options")); } var status = option.OrderStatus; var result = order_.SearchOrder(option); var order = result.Data; var totalOrders = order.Count(); return(ApiResult <int> .CreateSuccessful( totalOrders)); }
public IQueryable <Order> SearchOrders(SearchOrderOptions options) { if (options == null) { return(null); } var query = context_ .Set <Order>() .AsQueryable(); if (!string.IsNullOrWhiteSpace(options.DeliveryAddress)) { query = query.Where(c => c.DeliveryAddress.Contains(options.DeliveryAddress)); } if (options.OrderId != null) { query = query.Where(c => c.OrderId == options.OrderId); } if (options.CreatedFrom != null) { query = query.Where(c => c.Created >= options.CreatedFrom); } if (options.CreatedTo != null) { query = query.Where(c => c.Created <= options.CreatedTo); } if (options.PriceFrom >= 0) { query = query.Where(c => c.TotalAmount >= options.PriceFrom); } if (options.PriceTo >= 0) { query = query.Where(c => c.TotalAmount <= options.PriceTo); } return(query); }
public ApiResult <IQueryable <Order> > SearchOrder( SearchOrderOptions options) { if (options == null) { return(ApiResult <IQueryable <Order> > .CreateUnsuccessful( StatusCode.BadRequest, "Null order")); } if (options.OrderId == null && options.CustomerId == null && options.VatNumber == null) { return(new ApiResult <IQueryable <Order> >( StatusCode.BadRequest, "Null order")); } var query = context_ .Set <Order>() .AsQueryable(); if (options.OrderId != null) {//check guid query = query.Where(o => o.Id.Equals(options.OrderId)); } if (options.CustomerId != null) { query = query.Where(o => o.CustomerId.Equals(options.CustomerId)); } if (options.VatNumber != null) { query = query.Where(o => o.Customer.VatNumber.Equals(options.VatNumber)); } return(ApiResult <IQueryable <Order> > .CreateUnsuccessful( StatusCode.BadRequest, "Null order")); }
//SearchOrder public IQueryable <Order> SearchOrder(SearchOrderOptions options) { throw new NotImplementedException(); }