/// <summary>
/// Fetches all the agencies in the table.
/// </summary>
/// <returns>Returns a list of agencies.</returns>
public static List<AgencyItem> FetchDataAgencies()
{
try
{
List<AgencyItem> list = new List<AgencyItem>();
string sql = "SELECT DISTINCT Agency FROM Bid";
SetConnectionString();
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = new SqlCommand(sql, connection))
{
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
do
{
//sets the value from the reader
AgencyItem item = new AgencyItem();
item.Value = (string)reader["Agency"];
list.Add(item);
item = null;
} while (reader.Read());
}
}
}
}
return list;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Fetches all the agencies in the table.
/// </summary>
/// <returns>Returns a list of agencies.</returns>
public static List <AgencyItem> FetchDataAgencies()
{
try
{
List <AgencyItem> list = new List <AgencyItem>();
string sql = "SELECT DISTINCT Agency FROM Bid";
SetConnectionString();
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = new SqlCommand(sql, connection))
{
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
do
{
//sets the value from the reader
AgencyItem item = new AgencyItem();
item.Value = (string)reader["Agency"];
list.Add(item);
item = null;
} while (reader.Read());
}
}
}
}
return(list);
}
catch (Exception)
{
throw;
}
}
