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