public List <Company> GetCompanies(QueryOptions queryOptions, SearchObject searchObject, out int totalCount)
{
return
(_repository.Query(GetSearchCriteria(searchObject))
.Include(inc => inc.ParentCompany)
.OrderBy(GetOrder(queryOptions.SortField, queryOptions.SortOrder))
.SelectPage(queryOptions.CurrentPage, queryOptions.PageSize, out totalCount)
.ToList());
}
private Expression <Func <Company, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <Company, bool> > mainCriteria = c => c.IsActive == true;
if (!string.IsNullOrEmpty(searchObject.CompanyName))
{
mainCriteria = mainCriteria.And(c => c.CompanyName.StartsWith(searchObject.CompanyName));
}
//if (searchObject.FromDate.HasValue)
// mainCriteria = mainCriteria.And(c => c.CreatedDate.Value >= searchObject.FromDate.Value);
//if (searchObject.ToDate.HasValue)
// mainCriteria = mainCriteria.And(c => c.CreatedDate.Value <= searchObject.ToDate.Value);
return(mainCriteria);
}
