public async Task <Role> GetRoleLoadRelatedAsync(string roleName)
{
var role = await AllAsQueryable.Include(r => r.Claims)
.Include(r => r.Users)
.Where(r => r.Name == roleName)
.FirstOrDefaultAsync();
return(role);
}
public async Task <User> GetUserByIdAsync(int userId)
{
var user = await AllAsQueryable
.Include(u => u.Roles)
.FirstOrDefaultAsync(u => u.Id == userId);
if (user == null)
{
return(null);
}
return(user);
}
public virtual IQueryable <TEntity> Filter(
Expression <Func <TEntity, bool> > filter,
Func <IQueryable <TEntity>,
IOrderedQueryable <TEntity> > orderBy,
out int total,
int index = 0,
int size = 25)
{
int skipCount = index * size;
IQueryable <TEntity> resetSet =
orderBy(filter != null ? AllAsQueryable.Where(filter) : AllAsQueryable);
total = resetSet.Count();
resetSet = skipCount == 0 ? resetSet.Take(size) : resetSet.Skip(skipCount).Take(size);
return(resetSet);
}
public virtual IQueryable <TEntity> Filter(Expression <Func <TEntity, bool> > predicate)
{
return(AllAsQueryable.Where(predicate));
}
