private static int AddPiscesSeries(string name, int scIndex, TimeSeriesDatabaseDataSet.SeriesCatalogDataTable sc, Forecast f, int parentID, string connectionString) { string folderName = f.IssueDate.ToString("yyyy-MM-dd"); int folderID = ++scIndex; sc.AddFolder(folderName, folderID, parentID); int memberCount = f.Ensemble.GetLength(0); for (int i = 0; i < memberCount; i++) { var scrow = sc.NewSeriesCatalogRow(); scrow.id = ++scIndex; scrow.Provider = "EnsembleSeries"; scrow.ConnectionString = connectionString.Replace("{member_index}", (i + 1).ToString()); scrow.ParentID = folderID; scrow.siteid = name; scrow.Name = name + " member" + (i + 1); scrow.TimeInterval = Reclamation.TimeSeries.TimeInterval.Hourly.ToString(); scrow.Units = "cfs"; scrow.Parameter = "flow"; sc.Rows.Add(scrow); } return(scIndex); }
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); } }
/// <summary> /// insert new tree row /// </summary> static void AddNewRow(int sdi, int parentID, bool isFolder, string modsimName, string displayName, string timeSeriesName) { var row = seriesCatalog.NewSeriesCatalogRow(); row.id = sdi; seriesCatalog.Rows.Add(row); row.ParentID = parentID; if (isFolder) { row.IsFolder = 1; row.Name = displayName; row.TableName = ""; } else { ModsimSeries s = new ModsimSeries(mi, modsimName, timeSeriesName); row.IsFolder = 0; row.ConnectionString = ConnectionStringUtility.MakeFileNameRelative(s.ConnectionString, s_db.DataSource); row.iconname = "Modsim"; row.Provider = s.Provider; row.Name = displayName; row.TimeInterval = s.TimeInterval.ToString(); //row.TableName = "empty" + Guid.NewGuid().ToString(); row.siteid = s.SiteID; row.Parameter = s.Parameter; row.Units = s.Units; //row.DisplayUnits = s.DisplayUnits; row.Expression = s.Expression; row.Notes = s.Notes; } }
private void AddRows(TimeSeriesDatabaseDataSet.SeriesCatalogDataTable tbl) { foreach (var item in tbl) { var r = m_seriesCatalog.NewSeriesCatalogRow(); r.ItemArray = item.ItemArray; m_seriesCatalog.AddSeriesCatalogRow(r); } }