public List <ApplicationUser> GetUsers(QueryOptions queryOptions, SearchObject searchObject, out int totalCount)
{
return
(_repository.Query(GetSearchCriteria(searchObject))
.OrderBy(GetOrder(queryOptions.SortField, queryOptions.SortOrder))
.SelectPage(queryOptions.CurrentPage, queryOptions.PageSize, out totalCount)
.ToList());
}
public List <ApplicationRole> GetRoles(QueryOptions queryOptions, SearchObject searchObject, out int totalCount)
{
totalCount = 0;
return
(_repository.Query(GetSearchCriteria(searchObject))
//.Include(inc => inc.ProduceItems)
//.Include(inc => inc.SupplierDepartment.Supplier)
.OrderBy(GetOrder(queryOptions.SortField, queryOptions.SortOrder))
.SelectPage(queryOptions.CurrentPage, queryOptions.PageSize, out totalCount)
.ToList());
}
private Expression <Func <ApplicationRole, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <ApplicationRole, bool> > mainCriteria = x => true;
if (!string.IsNullOrEmpty(searchObject.CommonSearchCriteria))
{
mainCriteria =
mainCriteria.And(c =>
c.Name.StartsWith(searchObject.CommonSearchCriteria) ||
c.Description.StartsWith(searchObject.CommonSearchCriteria)
);
}
//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);
}
private Expression <Func <ApplicationUser, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <ApplicationUser, bool> > mainCriteria = x => true;
if (!string.IsNullOrEmpty(searchObject.CommonSearchCriteria))
{
mainCriteria =
mainCriteria.And(x =>
x.UserName.StartsWith(searchObject.CommonSearchCriteria) ||
x.Firstname.StartsWith(searchObject.CommonSearchCriteria) ||
x.Lastname.StartsWith(searchObject.CommonSearchCriteria)
);
}
if (searchObject.FromDate.HasValue)
{
mainCriteria = mainCriteria.And(x => x.LastLoggedOn.Value >= searchObject.FromDate.Value);
}
if (searchObject.ToDate.HasValue)
{
mainCriteria = mainCriteria.And(x => x.LastLoggedOn.Value <= searchObject.ToDate.Value);
}
return(mainCriteria);
}
