public ProviderSearchResultsViewModel SearchProviders(ProviderSearchViewModel searchViewModel) { var viewModel = new ProviderSearchResultsViewModel { SearchViewModel = searchViewModel }; if (!searchViewModel.PerformSearch) { return(viewModel); } var searchParameters = new ProviderSearchParameters { Id = searchViewModel.Id, Ukprn = searchViewModel.Ukprn, Name = searchViewModel.Name }; var providers = _providerService.SearchProviders(searchParameters); viewModel.Providers = providers.Select(p => p.Convert()).ToList(); return(viewModel); }
public IEnumerable <Provider> Search(ProviderSearchParameters searchParameters) { var sql = "SELECT * FROM dbo.Provider WHERE "; if (!string.IsNullOrEmpty(searchParameters.Id)) { sql += "ProviderId = @Id "; } if (!string.IsNullOrEmpty(searchParameters.Ukprn)) { sql += "UKPRN = @ukprn "; } if (!string.IsNullOrEmpty(searchParameters.Name)) { sql += "FullName LIKE '%' + @name + '%' OR TradingName LIKE '%' + @name + '%' "; } sql += "ORDER BY FullName"; var providers = _getOpenConnection.Query <Entities.Provider>(sql, searchParameters); return(providers.Select(MapProvider)); }
public IEnumerable <Provider> SearchProviders(ProviderSearchParameters searchParameters) { return(_providerReadRepository.Search(searchParameters)); }