private void SelectTable() { hydrometRatingTable = new TimeSeriesDatabaseDataSet.RatingTableDataTable(); var f = new RatingTableSelector(); if (f.ShowDialog() == DialogResult.OK) { cbtt = f.cbtt; yparm = f.pcode; this.labelSiteName.Text = "Description: " + HydrometInfoUtility.LookupSiteDescription(cbtt); this.labelcbtt.Text = "cbtt: " + cbtt; string altid = HydrometInfoUtility.LookupAltID(cbtt).Trim(); if (altid.Length > 0) { labelcbtt.Text += " altid: " + altid; } this.labelyparm.Text = "y parameter: " + yparm; ReadTableFromInternet(cbtt, yparm, f.RatingName, altid); hydrometRatingTable.Name = f.RatingName + " -- " + HydrometInfoUtility.LookupSiteDescription(cbtt); hydrometRatingTable.EditDate = f.DateModified; this.labelDate.Text = "Modified " + f.DateModified; } }
private string GetHeaderTitle(out string subTitle) { subTitle = ""; var query = HydrometInfoUtility.ExpandQuery(this.comboBoxInputs.Text, TimeInterval.Daily); // single cbtt? var tokens = query.Split(','); var cbttList = new List <string>(); foreach (var item in tokens) { string s = item.Trim().Split(' ')[0]; if (!cbttList.Contains(s)) { cbttList.Add(s); } } if (cbttList.Count == 1) { subTitle = HydrometInfoUtility.LookupGroupDescription(cbttList[0]); return(HydrometInfoUtility.LookupSiteDescription(cbttList[0])); } return(""); }
public void SiteDescription() { Logger.EnableLogger(); string d = HydrometInfoUtility.LookupSiteDescription("ACAO"); Console.WriteLine(d); Assert.AreEqual("Ashland Creek Mouth, near Ashland", d); }
public void SiteDescription() { Logger.EnableLogger(); string d = HydrometInfoUtility.LookupSiteDescription("AFTY"); Console.WriteLine(d); Assert.AreEqual("Afton Wyoming Weather Station", d); }
private void buttonRefresh_Click(object sender, EventArgs e) { try { timeSeriesGraph1.AnnotationOnMouseMove = checkBoxAnnotate.Checked; Cursor = Cursors.WaitCursor; Application.DoEvents(); string pcodeOrig = DeterminePcode(); timeSeriesGraph1.Clear(); string cbttOrig = comboBoxCbtt.Text.Trim(); string cbtt = cbttOrig, pcode = pcodeOrig; var seriesList = new List <string>(); if ((cbttOrig.Trim() == "" || pcodeOrig.Trim() == "") && textBoxMultiple.Text == "") { return; } else { if (!checkBoxUseList.Checked) { UserPreference.Save("Snowgg->cbtt", cbttOrig); UserPreference.Save("Snowgg->pcode", comboBoxPcode.Text.Trim()); seriesList.Add(cbttOrig + "_" + pcodeOrig); } else { var seriesItems = textBoxMultiple.Text.Split(','); foreach (string item in seriesItems) { if (item.Trim().Split(' ').Length == 2) { seriesList.Add(item.Trim().Split(' ')[0] + "_" + item.Trim().Split(' ')[1]); } } } } int[] waterYears = this.yearSelector1.SelectedYears; SeriesList finalSeriesCollection = new SeriesList(); foreach (string series in seriesList) { cbtt = series.Split('_')[0]; comboBoxCbtt.Text = cbtt; pcode = series.Split('_')[1]; comboBoxPcode.Text = pcode; var server = HydrometInfoUtility.HydrometServerFromPreferences(); var range = monthRangePicker1.MonthDayRange; Series s = new HydrometDailySeries(cbtt, pcode, server); var sl = new SeriesList(); sl.Add(s); var wyList = PiscesAnalysis.WaterYears(sl, waterYears, false, 10, true); foreach (var item in wyList) { item.Name = cbtt + " " + pcode; } wyList = ApplyDeltas(wyList, waterYears); AddStatistics(wyList); if (checkBoxGP.Checked) { GPAverage(cbtt, server, range, wyList); } var mp = ReadMpollData(pcode, cbtt); mp.RemoveMissing(); if (mp.Count > 0) { wyList.Add(mp); } // remove months outside selected range var list = FilterBySelectedRange(range, wyList); finalSeriesCollection.Add(list); } // Set series line colors var uniqueSeriesNames = new List <string>(); var uniqueSeriesColors = new List <string>(); int colorCounter = 0; foreach (var item in finalSeriesCollection) { // set line color by year which is identified in the legendtext field if (!uniqueSeriesNames.Contains(item.Appearance.LegendText) && !item.Appearance.LegendText.Contains("%") && !item.Appearance.LegendText.Contains("avg") && !item.Appearance.LegendText.Contains("max") && !item.Appearance.LegendText.Contains("min")) { uniqueSeriesNames.Add(item.Appearance.LegendText);//.Name); uniqueSeriesColors.Add(snowGgColors[colorCounter]); colorCounter = (colorCounter + 1) % snowGgColors.Count; } } foreach (var item in finalSeriesCollection) { try { int colIdx = uniqueSeriesNames.IndexOf(item.Appearance.LegendText);//.Name); item.Appearance.Color = uniqueSeriesColors[colIdx]; } catch { item.Appearance.Color = "Black"; } } this.timeSeriesGraph1.AnalysisType = AnalysisType.WaterYears; this.timeSeriesGraph1.Series = finalSeriesCollection; if (seriesList.Count == 1) { this.timeSeriesGraph1.Title = HydrometInfoUtility.LookupSiteDescription(cbtt) + " Elevation:" + HydrometInfoUtility.LookupElevation(pcode); } //timeSeriesGraph1.GraphSettings = GetGraphSettings(); this.timeSeriesGraph1.Draw(true); comboBoxCbtt.Text = cbttOrig; comboBoxPcode.Text = pcodeOrig; timeSeriesGraph1.GraphSettings = GetGraphSettings(); } finally { Cursor = Cursors.Default; } }
private void buttonRefresh_Click(object sender, EventArgs e) { try { timeSeriesGraph1.AnnotationOnMouseMove = checkBoxAnnotate.Checked; Cursor = Cursors.WaitCursor; Application.DoEvents(); string pcode = DeterminePcode(); timeSeriesGraph1.Clear(); string cbtt = comboBoxCbtt.Text.Trim(); if (cbtt.Trim() == "" || pcode.Trim() == "") { return; } UserPreference.Save("Snowgg->cbtt", cbtt); UserPreference.Save("Snowgg->pcode", comboBoxPcode.Text.Trim()); int[] waterYears = this.yearSelector1.SelectedYears; var server = HydrometInfoUtility.HydrometServerFromPreferences(); var range = monthRangePicker1.MonthDayRange; Series s = new HydrometDailySeries(cbtt, pcode, server); var sl = new SeriesList(); sl.Add(s); var wyList = PiscesAnalysis.WaterYears(sl, waterYears, false, 10, true); AddStatistics(wyList); if (checkBoxGP.Checked) { GPAverage(cbtt, server, range, wyList); } var mp = ReadMpollData(pcode, cbtt); mp.RemoveMissing(); if (mp.Count > 0) { wyList.Add(mp); } // remove months outside selected range var list = FilterBySelectedRange(range, wyList); this.timeSeriesGraph1.AnalysisType = AnalysisType.WaterYears; this.timeSeriesGraph1.Series = list; this.timeSeriesGraph1.Title = HydrometInfoUtility.LookupSiteDescription(cbtt) + " Elevation:" + HydrometInfoUtility.LookupElevation(cbtt); this.timeSeriesGraph1.Draw(true); timeSeriesGraph1.GraphSettings = GetGraphSettings(); } finally { Cursor = Cursors.Default; } }
private void buttonRefresh_Click(object sender, EventArgs e) { try { timeSeriesGraph1.AnnotationOnMouseMove = checkBoxAnnotate.Checked; timeSeriesGraph1.AnnotationDateShift = !cySelected; Cursor = Cursors.WaitCursor; Application.DoEvents(); string pcodeOrig = DeterminePcode(); timeSeriesGraph1.Clear(); string cbttOrig = comboBoxCbtt.Text.Trim(); string cbtt = cbttOrig, pcode = pcodeOrig; var seriesList = new List <string>(); if ((cbttOrig.Trim() == "" || pcodeOrig.Trim() == "") && textBoxMultiple.Text == "") { return; } else { if (!checkBoxUseList.Checked) { UserPreference.Save("Snowgg->cbtt", cbttOrig); UserPreference.Save("Snowgg->pcode", comboBoxPcode.Text.Trim()); seriesList.Add(cbttOrig + "_" + pcodeOrig); } else { var seriesItems = textBoxMultiple.Text.Split(','); foreach (string item in seriesItems) { if (item.Trim().Split(' ').Length == 2) { seriesList.Add(item.Trim().Split(' ')[0] + "_" + item.Trim().Split(' ')[1]); } } } } int[] waterYears = this.yearSelector1.SelectedYears; SeriesList finalSeriesCollection = new SeriesList(); foreach (string series in seriesList) { cbtt = series.Split('_')[0]; comboBoxCbtt.Text = cbtt; pcode = series.Split('_')[1]; comboBoxPcode.Text = pcode; var server = HydrometInfoUtility.HydrometServerFromPreferences(); var range = monthRangePicker1.MonthDayRange; Series s; if (this.checkBoxUseInstant.Checked) { s = new HydrometInstantSeries(cbtt, pcode, server); } else { s = new HydrometDailySeries(cbtt, pcode, server); } var sl = new SeriesList(); sl.Add(s); // get wy data var wyList = new SeriesList(); if (cySelected) { wyList = PiscesAnalysis.WaterYears(sl, waterYears, false, 1, true); } else { wyList = PiscesAnalysis.WaterYears(sl, waterYears, false, 10, true); } foreach (Series item in wyList) { item.Name = cbtt + " " + pcode; // remove missing data points var missingItems = item.Table.Select("value = 998877"); foreach (var row in missingItems) { item.RemoveAt(item.IndexOf(Convert.ToDateTime(row.ItemArray[0]))); } } // apply deltas and add stats if toggled wyList = ApplyDeltas(wyList, waterYears); AddStatistics(wyList); if (checkBoxGP.Checked) { GPAverage(cbtt, server, range, wyList); } // remove months outside selected range var list = FilterBySelectedRange(range, wyList); finalSeriesCollection.Add(list); } // Set series line colors var uniqueSeriesNames = new List <string>(); var uniqueSeriesColors = new List <string>(); int colorCounter = 0; foreach (var item in finalSeriesCollection) { // set line color by year which is identified in the legendtext field if (!uniqueSeriesNames.Contains(item.Appearance.LegendText) && !item.Appearance.LegendText.Contains("%") && !item.Appearance.LegendText.Contains("avg") && !item.Appearance.LegendText.Contains("max") && !item.Appearance.LegendText.Contains("min")) { uniqueSeriesNames.Add(item.Appearance.LegendText);//.Name); uniqueSeriesColors.Add(snowGgColors[colorCounter]); colorCounter = (colorCounter + 1) % snowGgColors.Count; } } foreach (var item in finalSeriesCollection) { try { int colIdx = uniqueSeriesNames.IndexOf(item.Appearance.LegendText);//.Name); item.Appearance.Color = uniqueSeriesColors[colIdx]; } catch { item.Appearance.Color = "SlateGray"; //System.Drawing.KnownColor.SlateGray } } this.timeSeriesGraph1.AnalysisType = AnalysisType.WaterYears; this.timeSeriesGraph1.Series = finalSeriesCollection; if (seriesList.Count == 1) { this.timeSeriesGraph1.Title = HydrometInfoUtility.LookupSiteDescription(cbtt) + " Elevation:" + HydrometInfoUtility.LookupElevation(cbtt); } //timeSeriesGraph1.GraphSettings = GetGraphSettings(); this.timeSeriesGraph1.Draw(true); comboBoxCbtt.Text = cbttOrig; comboBoxPcode.Text = pcodeOrig; timeSeriesGraph1.GraphSettings = GetGraphSettings(); this.dataGridView1.DataSource = this.timeSeriesGraph1.Series.ToDataTable(true); this.dataGridView1.Columns[0].DefaultCellStyle.Format = "MMM-d"; this.linkLabelReport.Visible = true; } finally { Cursor = Cursors.Default; dataQueried = true; } }