public List <AuthorizationResult> GetAuthorizationResults(Connections connections, AuthorizationSearch authorizationSearch, Paging paging) { QueryWarehouseAuthorizations _query = new QueryWarehouseAuthorizations(); string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};"; string queryString = _query.CrateQueryStringAuthorization(authorizationSearch, paging); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command = _query.EmbedParameters(command, authorizationSearch); try { List <AuthorizationResult> results = new List <AuthorizationResult>(); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { AuthorizationResult authorizationResult = new AuthorizationResult(); authorizationResult.SetValuesFromReader(reader); results.Add(authorizationResult); } reader.Close(); return(results); } catch (Exception ex) { connection.Close(); Console.WriteLine(ex.ToString()); return(null); } } }