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