private static void LoadDailyUsbrCatalog(TimeSeriesDatabaseDataSet.SeriesCatalogDataTable sc, TimeSeriesDatabaseDataSet.SeriesCatalogDataTable sc_vm, string program) { for (int i = 0; i < sc.Rows.Count; i++) { if (i == 55) { return; } var row = sc[i]; string[] path = { "water.usbr.gov", "pn", program, row.siteid, "daily" }; var folderID = sc_vm.GetOrCreateFolder(path); TimeSeriesName tn = new TimeSeriesName(row.TableName); var newRow = sc_vm.NewSeriesCatalogRow(); newRow.ItemArray = row.ItemArray; newRow.id = sc_vm.NextID(); newRow.iconname = ""; newRow.Provider = "HydrometDailySeries"; newRow.ConnectionString = "server=PN;cbtt=" + tn.siteid + ";pcode=" + tn.pcode + ";"; newRow.TableName = "pnhydromet_" + row.TableName; newRow.Units = HydrometInfoUtility.LookupDailyUnits(tn.pcode); newRow.Parameter = HydrometInfoUtility.LookupDailyParameterName(tn.pcode); newRow.ParentID = folderID; sc_vm.Rows.Add(newRow); } }
private void AddDailyRow(string siteID, string units, string pcode, string expression = "") { var provider = "Series"; string iconName = ""; if (expression != "") { provider = "CalculationSeries"; iconName = "sum"; } m_seriesCatalog.AddSeriesCatalogRow(m_seriesCatalog.NextID(), 0, false, 1, iconName, siteID + "_" + pcode, siteID, units, "Daily", pcode, "daily_" + siteID + "_" + pcode, provider, "", expression, "", true); }
private static void LoadUpperSnakeHydromet(TimeSeriesDatabaseDataSet.SeriesCatalogDataTable sc_vm) { // load hydromet/upper snake var lines = upperSnakeDaily.Split('\n'); foreach (var item in lines) { var tokens = item.Trim().Split(' ', '\t'); var cbtt = tokens[0].Trim().ToLower(); var pcode = tokens[1].Trim().ToLower(); string[] path = { "water.usbr.gov", "pn", "hydromet", cbtt, "daily" }; var folderID = sc_vm.GetOrCreateFolder(path); HydrometDailySeries s = new HydrometDailySeries(cbtt, pcode); s.SiteID = cbtt; s.Parameter = HydrometInfoUtility.LookupDailyParameterName(pcode); sc_vm.AddSeriesCatalogRow(s, sc_vm.NextID(), folderID, "pnhydromet_" + s.Table.TableName); } }