public void setWeather()
{
AESSmartEntities db = new AESSmartEntities();
DateTime tempDate = (DateTime.UtcNow).AddMinutes(-5);
var myQuery = (from s in db.PowerWeatherStationHistorys
where s.recordTime >= tempDate
orderby s.recordTime descending
select s).Take(1);
if (myQuery.Count() > 0)
{
/*
* IF A WEATHER RECORD EXISTS IN THE THE DATABASE NO OLDER
* THAN 5 MINUTES THEN USE THAT INFORMATION
*/
}
else
{
/*
* IF A RECORD DOES NOT EXIST IN THE THE DATABASE NO OLDER
* THAN 5 MINUTES THEN GET WEATHER INFORMATION FROM WUNDERGRAOUND API
* THEN SAVE IN DATABASE
*/
saveWeather();
}
}
public void saveWeather()
{
AESSmartEntities db = new AESSmartEntities();
db.PowerWeatherStationHistorys.Add(WeatherStationHistory);
db.SaveChanges();
}
