/// <summary> /// Asseses whether data has been downloaded for the specified day. /// </summary> /// <param name="day">The day to check for.</param> /// <returns></returns> public bool HasDataForDay(DateTime day) { using (var context = new WeatherDataDataContext()) { // check if there is data for today return context.WeatherEntries.Where(entry => entry.Timestamp.Date == day.Date).Any(); } }
public IEnumerable<ChimetDataRecord> GetDataForDay(DateTime day) { using (var context = new WeatherDataDataContext()) { // get the data from the data base return (from entry in context.WeatherEntries.Where(entry => entry.Timestamp.Date == day.Date) select new ChimetDataRecord // map to chimet data record { AverageWindSpeed = entry.WindSpeed, MaximumWindSpeed = entry.WindGust, Time = entry.Timestamp, WindBearing = entry.WindBearing }).AsEnumerable(); } }