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 string LookupUnits(string pcode)
{
if (m_db == TimeInterval.Daily)
{
return(HydrometInfoUtility.LookupDailyUnits(pcode));
}
if (m_db == TimeInterval.Irregular)
{
return(HydrometInfoUtility.LookupDayfileUnits(pcode));
}
if (m_db == TimeInterval.Monthly)
{
return(HydrometMonthlySeries.LookupUnits(pcode));
}
return("");
}