internal FacilityData[] GetFacilities()
{
List<FacilityData> result = new List<FacilityData>();
try
{
using (SqlConnection dbConn = new SqlConnection(connectionString))
{
string qsGetAreas = @"SELECT [ID], [ADDRESS] FROM [FACILITY]";
SqlCommand dbCommand = new SqlCommand(qsGetAreas, dbConn);
dbConn.Open();
SqlDataReader dbReader = dbCommand.ExecuteReader();
while (dbReader.Read())
{
try
{
FacilityData fd = new FacilityData();
fd.Id = dbReader.GetInt64(0);
fd.Address = dbReader.GetString(1);
result.Add(fd);
}
catch (Exception rowExc)
{
Debug.WriteLine("Error reading facility row: " + rowExc.Message);
}
}
dbReader.Close();
dbCommand.Connection.Close();
}
}
catch (Exception areaDataExc)
{
Debug.WriteLine("Error getting facilities: " + areaDataExc.Message);
}
return result.ToArray();
}
public FacilityData[] Backend_GetFacilities()
{
Trace.WriteLine("Backend_GetFacilities");
FacilityData[] result = new FacilityData[0];
DataManager dataMan = new DataManager();
result = dataMan.GetFacilities();
return result;
}
