public IEnumerable <AirQualityStation> GetAirQuality()
{
var quality = new List <AirQualityStation>();
var stations = GetAllStations();
using (var cmd = new NpgsqlCommand("SELECT * FROM air_quality", connection))
{
using (var reader = cmd.ExecuteReader())
while (reader.Read())
{
var t = new AirQualityStation()
{
AirQualityIndex = reader.GetDouble(13),
};
int stationId = reader.GetInt32(12);
var station = stations.FirstOrDefault(x => x.Id == stationId);
t.Position = new LatLng()
{
Lat = Convert.ToDouble(station.Latitude),
Lng = Convert.ToDouble(station.Longitude)
};
quality.Add(t);
}
}
return(quality);
}
public static AirQualityStation[] GetAirQualityStations(float lat, float lng)
{
var stations = new List <AirQualityStation>();
var station = new AirQualityStation
{
AirQualityIndex = 49.1f,
Position = GrunewaldAirStation,
Source = "http://aqicn.org/?city=Germany/Berlin/Grunewald%283.5m%29"
};
stations.Add(station);
return(stations.ToArray());
}
