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);
}
}