public List <HHAXAgency> GetAgencies(Connections connections)
{
List <HHAXAgency> agencies = new List <HHAXAgency>();
string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};";
string queryString = QueryHHAX.GetQueryStringHHAXAgencies();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var agency = new HHAXAgency(Convert.ToInt32(reader["HHAX_AGENCY_ID"]), reader["AGENCY_NAME"].ToString());
agencies.Add(agency);
}
reader.Close();
connection.Close();
return(agencies);
}
catch (Exception ex)
{
connection.Close();
Console.WriteLine(ex.ToString());
return(null);
}
}
}
public List <HHAXTransStatus> GetTransStatuses(Connections connections)
{
List <HHAXTransStatus> transStatuses = new List <HHAXTransStatus>();
string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};";
string queryString = QueryHHAX.GetQueryStringHHAXTransStatuses();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var transStatus = new HHAXTransStatus(reader["STATUS_ID"].ToString(), reader["STATUS_DESC"].ToString());
transStatuses.Add(transStatus);
}
reader.Close();
connection.Close();
return(transStatuses);
}
catch (Exception ex)
{
connection.Close();
Console.WriteLine(ex.ToString());
return(null);
}
}
}
