public int WriteData(Data data)
{
try
{
DB.City city = _ctx.Cities.FirstOrDefault(n => n.Id.Equals(data.Idx));
AQData aQData = new AQData();
aQData.PM10 = data.Iaqi.pm10.V;
aQData.PM25 = data.Iaqi.pm25.V;
aQData.Temperature = data.Iaqi.t.V;
aQData.Date = DateTime.Parse(data.Time.S);
aQData.Humidity = data.Iaqi.h.V;
if (city != null)
{
aQData.CityId = city.Id;
}
else
{
DB.City newCity = new DB.City();
newCity.Name = GetShortName(data.City.Name);
newCity.Id = data.Idx;
aQData.CityId = data.Idx;
_ctx.Cities.Add(newCity);
}
_ctx.AQDatas.Add(aQData);
return(_ctx.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
public List <DB.AQData> GetDataByCity(DB.City city)
{
List <DB.AQData> aQDatas = new List <AQData>();
aQDatas = _ctx.AQDatas.Include(c => c.City)
.Where(c => c.City.Equals(city))
.OrderBy(d => d.Date)
.ToList();
return(aQDatas);
}
