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; }