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