private IQueryable <Entities.orders.Order> SearchRequest(SearchCriteriaOrder criteria)
{
var query = _ctx.orders.Where(x => true);
query = query.Where(x => x.season_id == criteria.season_id);
return(query);
}
public List <Objects.orders.Order> Search(SearchCriteriaOrder criteria, int limit = 10, int page = 1)
{
var query = SearchRequest(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.Order> >(query.ToList()));
}
public int SearchCount(SearchCriteriaOrder criteria)
{
var query = SearchRequest(criteria);
return(query.Count());
}
