public void ReadAll_GetsData() { // initial data workbook has 4492 records var data = PrecipitationData.ReadAll("data.xlsx"); Assert.IsNotNull(data, "data != null"); // Current version of data may have more results Assert.GreaterOrEqual(data.Count, 4492, "data.Count < 4492"); Console.WriteLine("Has {0} results, expected at least 4492.", data.Count); }
public void ReadForMonthDay_GetsData() { // initial data workbook has 9 entries for august 17th var data = PrecipitationData.ReadForMonthDay("data.xlsx", 8, 17); Assert.IsNotNull(data, "data != null"); // Current version of data may have more results Assert.GreaterOrEqual(data.Count, 9, "data.Count < 9"); Console.Write("Has {0} results, expected at least 9.", data.Count); }
private void AddData(string dt, float value, ref List <PrecipitationData> data) { var pd = new PrecipitationData { Station = "TestStation", DateString = dt, PrecipitationString = value.ToString(CultureInfo.InvariantCulture) }; data.Add(pd); }
static void process() { try { IPrecipitationData p = new PrecipitationData(inputfilestoprocess); DataTable dt = p.parseInputFile(); IDAL sqldal = new DAL(sqldbConn); sqldal.bulkSQLInsert(dt, destinationTableName); } catch (Exception ex) { } }
public static void GenerateWeatherFromDateTime(this DateTime dateTime, WeatherNotesWindow window, RoutedEventArgs e) { DayData day; WeatherData[] weatherDatas = null; if (window.CalendarData.ContainsKey(dateTime)) { day = window.CalendarData[dateTime]; if (!day.WeatherGenerated) { weatherDatas = WeatherGenerator.GenerateWeather(dateTime, day.Weather); day.Weather = weatherDatas[0]; } } else { weatherDatas = WeatherGenerator.GenerateWeather(dateTime); day = new DayData(dateTime, window.TbxSelectedDayNotes.Text, weatherDatas[0]); window.CalendarData.Add(dateTime, day); } DateTime prevDate = dateTime.AddDays(-1); if (!day.WeatherGenerated && window.CalendarData.ContainsKey(prevDate)) { DayData prevDay = window.CalendarData[prevDate]; if (prevDay.WeatherGenerated) { day.Weather.Temperature = (day.Weather.Temperature + prevDay.Weather.Temperature) / 2.0; day.Weather.Precipitation.SnowAccumulation = day.Weather.Precipitation.SnowAccumulation + prevDay.Weather.Precipitation.SnowAccumulation; PrecipitationData.MeltSnowOverDay(day.Weather); } } day.WeatherGenerated = true; window.CalendarData.SetDictionaryWeatherDatas(dateTime, weatherDatas); //dateTime.SetSelectedDayWeatherNotes(window.CalendarData, window.TbxSelectedDayNotes, window.LblSelectedDayWeather); e.Handled = true; }
public static WeatherData[] GenerateWeather(DateTime?equivalentDateTime, WeatherData weather = null) { if (equivalentDateTime.HasValue) { DateTime dateTime = equivalentDateTime.Value; int monthIdx = dateTime.Month - 1; if (weather == null) { weather = new WeatherData(); } List <WeatherData> weatherDatas = WeatherData.GenerateTemperature(dateTime, weather); weatherDatas = FogData.GenerateFog(dateTime, weatherDatas); weatherDatas = WindData.GenerateWind(dateTime, weatherDatas); weatherDatas = PrecipitationData.GeneratePrecipitation(dateTime, weatherDatas); return(weatherDatas.ToArray()); } return(null); }
private void SetChart() { //extrema bepalen int TRangeMax = TemperatureData.Max() >= PrecipitationData.Max() / 2 ? (int)Math.Round(TemperatureData.Max() * 1.5 / 5) * 5 : (int)Math.Round(PrecipitationData.Max() * 1.5 / 5) * 5 / 2; int PRangeMax = TemperatureData.Max() < PrecipitationData.Max() / 2 ? (int)Math.Round(TemperatureData.Max() * 1.5 / 5) * 10 : (int)Math.Round(PrecipitationData.Max() * 1.5 / 5) * 5; int TRangeMin = TemperatureData.Min() < 0 ? (int)Math.Round(TemperatureData.Min() * 1.5 / 5) * 5 : 0; int PRangeMin = TRangeMin * 2; Chart = new Highcharts("Climatogram") .SetTitle(new Title { Text = Location.Name + " (" + Country.Name + ") - station " + Location.Station }) .SetSubtitle(new Subtitle { Text = Location.CoordinateDegreeLat(Location.CoordinateLat)[0] + "° " + Location.CoordinateDegreeLat(Location.CoordinateLat)[1] + "\" " + Location.CoordinateDegreeLat(Location.CoordinateLat)[2] + " " + //Location.CoordinateDegreeLat(Location.CoordinateLat)[3] + " " + Location.CoordinateDegreeLong(Location.CoordinateLong)[0] + "° " + Location.CoordinateDegreeLong(Location.CoordinateLong)[1] + "\" " + Location.CoordinateDegreeLong(Location.CoordinateLong)[2] + " " + //Location.CoordinateDegreeLong(Location.CoordinateLong)[3] + " " + Location.Height + "m" }) .SetXAxis(new[] { new XAxis() { Categories = MonthLabels } }) .SetYAxis(new [] { new YAxis() { Title = new YAxisTitle { Text = "Neerslag (mmN)" }, Min = PRangeMin, Max = PRangeMax, TickInterval = 10, }, new YAxis() { Title = new YAxisTitle { Text = "Temperatuur (°C)" }, Min = TRangeMin, Max = TRangeMax, TickInterval = 5, Opposite = true }, }) .SetSeries(new [] { new Series() { Name = "Neerslag (mmN)", Type = ChartTypes.Column, YAxis = "0", Data = new Data(PrecipitationData.Cast <object>().ToArray()) }, new Series() { Name = "Temperatuur (°C)", Type = ChartTypes.Spline, Color = Color.Red, YAxis = "1", Data = new Data(TemperatureData.Cast <object>().ToArray()) } }); }
public void ReadForMonthDay_WithInvalidPath() { var data = PrecipitationData.ReadForMonthDay("invalid.xlsx", 8, 17); Assert.IsNull(data); }
public void ReadAll_WithInvalidPath() { var data = PrecipitationData.ReadAll("invalid.xlsx"); Assert.IsNull(data); }