private IQueryable <Entities.orders.OrderAuto> SearchRequestOrdersAuto(SearchCriteriaOrderAuto criteria) { var query = _ctx.orders_auto.Where(x => true); query = query.Where(x => x.season_id == criteria.season_id); if (criteria.orderAuto_id != null) { query = query.Where(x => x.id == criteria.orderAuto_id); } if (criteria.description != null) { query = query.Where(x => (x.description != null) ? x.description.ToLower().Contains(criteria.description) : false); } if (criteria.section_id != null) { query = query.Where(x => x.restriction_section_id == criteria.section_id); } if (criteria.activity_id != null) { query = query.Where(x => x.restriction_activity_id == criteria.activity_id); } if (criteria.category_id != null) { query = query.Where(x => x.restriction_category_id == criteria.category_id); } return(query); }
public List <Objects.orders.OrderAuto> SearchOrdersAuto(SearchCriteriaOrderAuto criteria, int limit = 10, int page = 1) { var query = SearchRequestOrdersAuto(criteria); query = query.OrderBy(x => x.date_from).ThenBy(x => x.date_to); query = query.Skip(((page < 0 ? 0 : page) - 1) * limit); query = query.Take(limit); return(Mapper.Map <List <Objects.orders.OrderAuto> >(query.ToList())); }
public int SearchCountOrdersAuto(SearchCriteriaOrderAuto criteria) { var query = SearchRequestOrdersAuto(criteria); return(query.Count()); }