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