public IEnumerable <ProviderUser> Search(ProviderUserSearchParameters searchParameters) { var sql = ProviderUserSelect; var and = ""; if (!string.IsNullOrEmpty(searchParameters.Username)) { sql += "Username LIKE '%' + @Username + '%' "; and = "AND "; } if (!string.IsNullOrEmpty(searchParameters.Name)) { sql += and + "pu.Fullname LIKE '%' + @Name + '%' "; and = "AND "; } if (!string.IsNullOrEmpty(searchParameters.Email)) { sql += and + "Email LIKE '%' + @Email + '%' "; and = "AND "; } if (searchParameters.AllUnverifiedEmails) { sql += and + "(EmailVerificationCode IS NOT NULL OR ProviderUserStatusId != 20) "; } sql += "ORDER BY FullName"; var providerUsers = _getOpenConnection .Query <Entities.ProviderUser>(sql, searchParameters) .Select(MapProviderUser); return(providerUsers); }
public ProviderUserSearchResultsViewModel SearchProviderUsers(ProviderUserSearchViewModel searchViewModel) { var searchParameters = new ProviderUserSearchParameters { Username = searchViewModel.Username, Name = searchViewModel.Name, Email = searchViewModel.Email, AllUnverifiedEmails = searchViewModel.AllUnverifiedEmails }; var providerUsers = _userProfileService.SearchProviderUsers(searchParameters); var viewModel = new ProviderUserSearchResultsViewModel { SearchViewModel = searchViewModel, ProviderUsers = providerUsers.Select(Convert).ToList() }; return(viewModel); }
public IEnumerable <ProviderUser> SearchProviderUsers(ProviderUserSearchParameters searchParameters) { return(_providerUserReadRepository.Search(searchParameters)); }