public TimeSeriesDatabaseDelete(TimeSeriesDatabase db, PiscesObject o)
{
this.m_db = db;
sdi = o.ID;
catalog = m_db.GetFilteredCatalog();
m_seriesProperties = m_db.GetSeriesProperties();
//catalog.PrimaryKey = new DataColumn[] { catalog.Columns["id"]};
}
/// <summary>
/// Set property directly to database
/// </summary>
public static void Set(string name, string value, int seriesID, BasicDBServer svr)
{
var tbl = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
var sql = "Select * from seriesproperties where name='" + name + "' and seriesid = " + seriesID;
svr.FillTable(tbl, sql);
if (tbl.Rows.Count == 0)
{
tbl.AddseriespropertiesRow(svr.NextID("seriesproperties", "id"), seriesID, name, value);
}
else
{
tbl.Rows[0]["value"] = value;
}
svr.SaveTable(tbl);
}
/// <summary>
/// Set property directly to database
/// </summary>
public static void Set(string name, string value, int seriesID, BasicDBServer svr)
{
var tbl = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
var sql = "Select * from seriesproperties where name='" + name + "' and seriesid = " + seriesID;
svr.FillTable(tbl, sql);
if (tbl.Rows.Count == 0)
{
tbl.AddseriespropertiesRow(svr.NextID("seriesproperties", "id"), seriesID, name, value);
}
else
{
tbl.Rows[0]["value"] = value;
}
svr.SaveTable(tbl);
}
public SeriesProperties(int seriesID, TimeSeriesDatabase db)
{
m_seriesID = seriesID;
m_seriesProperties = db.GetSeriesProperties(true);
m_db = db;
}
public SeriesProperties(int seriesID)
{
m_seriesID = seriesID;
m_seriesProperties = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
}
/// <summary>
/// Manage rows from the SeriesProperties table
/// </summary>
/// <param name="seriesid">series id</param>
/// <param name="useCache"></param>
/// <returns></returns>
public TimeSeriesDatabaseDataSet.seriespropertiesDataTable GetSeriesProperties(bool useCache=false)
{
if (m_seriesProperties != null && useCache )
return m_seriesProperties;
m_seriesProperties = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable(this);
m_seriesProperties.ExtendedProperties.Add("datetime", DateTime.Now.ToString());
return m_seriesProperties;
}
public SeriesProperties(int seriesID, TimeSeriesDatabase db)
{
m_seriesID = seriesID;
m_seriesProperties = db.GetSeriesProperties(true);
m_db = db;
}
public SeriesProperties(int seriesID)
{
m_seriesID = seriesID;
m_seriesProperties = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
}
