public async Task <IActionResult> GetApprovedAgentPageAsync(int count = 10, int page = 0, string sEcho = null, string searchQuery = null, UserStatusTypeEntity status = UserStatusTypeEntity.Active) { var result = await _unitOfWork.UserRepository.GetPageAsync(count, page, searchQuery, (UserStatusTypeEntity)status.GetHashCode()); return(Ok(new ResponsePageResultModel <ViewUserModel>(_mapper.Map <List <ViewUserModel> >(result), sEcho, result.Count(), result.Count()))); }
public async Task <IEnumerable <User> > GetPageAsync(int count, int page, string searchQuery, UserStatusTypeEntity userStatusType) { var query = databaseContext.Set <UserEntity>().Where(x => x.Status == userStatusType && x.IsDeleted == false).AsQueryable(); if (searchQuery != null) { query = query.Where(x => x.UserName.ToUpper().Contains(searchQuery.ToUpper()) || x.LastName.ToUpper().Contains(searchQuery.ToUpper()) || x.FirstName.ToUpper().Contains(searchQuery.ToUpper())); } query = query.Skip(page * count).Take(count); return(_mapper.Map <List <User> >(await query.ToListAsync())); }