protected PiscesObject()
{
catalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable();
row = catalog.NewSeriesCatalogRow();
row.id = -1;
// Catalog.Rows.Add(row);
// Console.WriteLine("PiscesObject()");
}
protected PiscesObject(TimeSeriesDatabaseDataSet.SeriesCatalogRow row)
{
if (row.RowState == System.Data.DataRowState.Detached)
{
catalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable();
}
else
{
catalog = (TimeSeriesDatabaseDataSet.SeriesCatalogDataTable)row.Table;//
}
this.row = row;
}
public void ChangeParent(PiscesObject piscesObject, PiscesFolder piscesFolder)
{
if (piscesObject.Parent.ID == piscesFolder.ID)
{
return; // nothing to do
}
TimeSeriesDatabaseDataSet.SeriesCatalogRow r = GetSeriesRow(piscesObject.ID);
r.ParentID = piscesFolder.ID;
SaveSeriesRow(r);
OnDatabaseChanged(GetPathArray(piscesObject.Parent));
OnDatabaseChanged(GetPathArray(piscesFolder));
}
public UrgwomSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
TimeInterval = TimeSeries.TimeInterval.Daily;
ExternalDataSource = true;
ReadOnly = true;
Provider = "UrgwomSeries";
ScenarioName = "ScenarioName";
xlsFilename = ConnectionStringUtility.GetFileName(ConnectionString, m_db.DataSource);
sheetName = ConnectionStringToken("SheetName");
dateColumn = ConnectionStringToken("DateColumn");
valueColumn = ConnectionStringToken("ValueColumn");
}
/// <summary>
/// define path based on root/sitecatalog.type/siteid/interval
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private List <string> GetDefaultPath(string root, TimeSeriesDatabaseDataSet.SeriesCatalogRow row)
{
var selectedPath = new List <string>();
selectedPath.Add(root);
var siteRow = m_siteCatalog.FindBysiteid(row.siteid);
if (siteRow != null)
{
selectedPath.Add(siteRow.type);
}
else
{
Console.WriteLine("no site defined... in sitecatalog.");
selectedPath.Add("unknown");
}
selectedPath.Add(row.siteid);
selectedPath.Add(GetIntervalPath(row));
return(selectedPath);
}
///// <summary>
///// determines if the child is inside the root
///// </summary>
///// <param name="selectedPath">root path </param>
///// <param name="rowPath"></param>
///// <returns></returns>
// private bool IsChildInRoot(List<string> root, List<string> child)
// {
// if (root.Count > child.Count)
// return false;
// for (int i = 0; i < root.Count; i++)
// {
// if (root[i] != child[i])
// return false;
// }
// return true;
// }
private static string GetIntervalPath(TimeSeriesDatabaseDataSet.SeriesCatalogRow row)
{
TimeSeriesName tn = new TimeSeriesName(row.TableName);
var interval = "instant";
if (row.TimeInterval == "Irregular" || row.TimeInterval == "Hourly")
{
interval = "instant";
}
else
{
interval = row.TimeInterval.ToLower();
}
if (TimeSeriesDatabase.IsQuality(tn.pcode))
{
interval = "quality";
}
return(interval);
}
public CalculationSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
m_parser = db.Parser;
m_db = db;
Init();
}
public PiscesFolder(TimeSeriesDatabase db,
TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(sr)
{
this.m_db = db;
}