public int GetTotalRowsAuthorizations(Connections connections, HHAXAuthorizationsSearch authorizationsSearch)
{
QueryHHAXAuthorizations _query = new QueryHHAXAuthorizations();
int totalRows = 0;
string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};";
string queryString = _query.CrateQueryStringCountRowsAuthorizations(authorizationsSearch);
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection)
{
CommandTimeout = 100
};
command = _query.EmbedParameters(command, authorizationsSearch);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
totalRows = Convert.ToInt32(reader[0]);
}
reader.Close();
return(totalRows);
}
catch (Exception ex)
{
connection.Close();
Console.WriteLine(ex.ToString());
return(0);
}
}
}
public List <HHAXAuthorizationsResult> GetHHAXAuthorizationResults(Connections connections, HHAXAuthorizationsSearch authorizationsSearch, Paging paging)
{
QueryHHAXAuthorizations _query = new QueryHHAXAuthorizations();
string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};";
string queryString = _query.CreateQueryStringAuthorizations(authorizationsSearch, paging);
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection)
{
CommandTimeout = 100
};
command = _query.EmbedParameters(command, authorizationsSearch);
try
{
List <HHAXAuthorizationsResult> results = new List <HHAXAuthorizationsResult>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
HHAXAuthorizationsResult authorizationResult = new HHAXAuthorizationsResult();
authorizationResult.SetValuesFromReader(reader);
results.Add(authorizationResult);
}
reader.Close();
connection.Close();
return(results);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return(null);
}
finally
{
connection.Close();
}
}
}