public async Task <IEnumerable <UserInfo> > Search(Expression <Func <UserInfo, bool> > whereExpressions, PageOptions page)
{
var query = whereExpressions.IsNull() ? UserDb.AsQueryable() : UserDb.AsQueryable().Where(whereExpressions);
var results = new List <UserInfo>();
if (!page.IsNull() && page.IsValidate)
{
results = await query.ToPageListAsync(page.PageIndex, page.PageSize);
page.TotalCount = query.Count();
}
else
{
results = await query.ToListAsync();
}
return(results);
}
public async Task <UserInfo> GetByName(string name)
{
var user = await UserDb.AsQueryable().FirstAsync(u => string.Equals(u.UserName, name, StringComparison.InvariantCultureIgnoreCase));
return(user);
}
public async Task <UserInfo> GetById(Guid id)
{
return(await UserDb.AsQueryable().FirstAsync(u => u.UserId == id));
}
