public ShefSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
m_location = ConnectionStringUtility.GetToken(ConnectionString, "ShefLocation", "");
m_pecode = ConnectionStringUtility.GetToken(ConnectionString, "ShefCode", "");
m_filename = ConnectionStringUtility.GetToken(ConnectionString, "File", "");
InitTimeSeries(null, "", this.TimeInterval, true);
}
public void SiteInfoDesignTest()
{
var fn = FileUtility.GetTempFileName(".pdb");
SQLiteServer svr = new SQLiteServer(fn);
var db = new TimeSeriesDatabase(svr, false);
var siteCatalog = db.GetSiteCatalog();
siteCatalog.AddsitecatalogRow("BOII", "Boise station", "ID");
svr.SaveTable(siteCatalog);
var sc = db.GetSeriesCatalog();
var s = new Series();
s.SiteID = "BOII";
sc.AddSeriesCatalogRow(s, sc.NextID(), db.GetRootObjects()[0].ID);
sc.Save();
var si = db.SiteInfo("BOII");
bool idaho = si.state == "ID"; //idaho
var timezone = si.timezone;
TimeSeriesDatabaseDataSet.SeriesCatalogDataTable d = si.SeriesList();
TimeSeriesDatabaseDataSet.SeriesCatalogRow row = d[0];
row.Parameter = "Asce ET #5";
d.Save();
Console.WriteLine(si.SeriesList()[0].Parameter);
//var goodStats = (si.Parameters()[0].statistic == "Avg");
}
public NrcsSnotelSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
siteNumber = ConnectionStringUtility.GetToken(ConnectionString, "SiteNumber", "");
parameterName = ConnectionStringUtility.GetToken(ConnectionString, "ParameterName", "");
//State = LookupState(siteNumber);
}
public HDBWebSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
string str = ConnectionStringUtility.GetToken(ConnectionString, "server", "");
m_server = (HDBServer)Enum.Parse(typeof(HDBServer), str);
m_sdi = ConnectionStringUtility.GetIntFromConnectionString(ConnectionString, "sdi");
}
public OwrdSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
var str_dataset = ConnectionStringUtility.GetToken(this.ConnectionString, "DataSet", "MDF");
dataset = (OwrdDataSet)System.Enum.Parse(typeof(OwrdDataSet), str_dataset);
m_includeProvisional = ConnectionStringUtility.GetBoolean(this.ConnectionString, "Provisional", false);
station_nbr = ConnectionStringUtility.GetToken(this.ConnectionString, "StationNumber", "");
}
public SnotelSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
m_triplet = ConnectionStringUtility.GetToken(ConnectionString, "Triplet", "");
var p = ConnectionStringUtility.GetToken(ConnectionString, "SnotelParameter", "");
m_parameter = (SnotelParameterCodes)Enum.Parse(typeof(SnotelParameterCodes), p);
TimeInterval = TimeSeries.TimeInterval.Daily;
}
public UsgsDailyValueSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
m_parameter = UsgsDailyParameter.DailyMeanDischarge;
string str = ConnectionStringUtility.GetToken(ConnectionString, "UsgsDailyParameter", "");
if (Enum.IsDefined(typeof(UsgsDailyParameter), str))
{
m_parameter = (UsgsDailyParameter)Enum.Parse(typeof(UsgsDailyParameter), str);
}
m_site_no = ConnectionStringUtility.GetToken(ConnectionString, "site_no", "");
}
public BasicRating(TimeSeriesDatabase db,
TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(sr)
{
this.m_db = db;
this.m_sr = sr;
int id = Convert.ToInt32(ConnectionStringToken("id", "-1"));
Console.WriteLine("ctor BasicRating id =" + id);
var tbl = m_db.Hydrography.GetRatingTables();
m_rating_tablesRow = tbl.FindByid(id);
}
public BasicMeasurement(TimeSeriesDatabase db,
TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(sr)
{
this.m_db = db;
this.m_sr = sr;
int id = Convert.ToInt32(ConnectionStringToken("id", "-1"));
Console.WriteLine("ctor BasicMeasurement id ="+id);
var tbl = m_db.Hydrography.GetMeasurements();
m_measurementRow = tbl.FindByid(id);
}
/// <summary>
/// Creates UrgsimSeries from TimeSeriesDatabase
/// </summary>
/// <param name="sdi"></param>
/// <param name="db"></param>
/// <param name="sr"></param>
public UrgsimSeries(int sdi, TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
this.ExternalDataSource = true;
m_path = ConnectionStringUtility.GetToken(ConnectionString, "Path", "");
m_projection = ConnectionStringUtility.GetToken(ConnectionString, "Projection", "");
m_variable = Parameter;
ScenarioName = m_projection;
Appearance.LegendText = ScenarioName;
Units = GetUrgsimUnits(Parameter);
}
private CalculationSeries CreateCalcSeries(TimeSeriesDatabaseDataSet.SeriesCatalogRow r, string name, TimeSeriesName tn, string expression)
{
var s = new CalculationSeries(name)
{
Parameter = tn.pcode,
SiteID = r.siteid,
Expression = expression
};
s.Table.TableName = tn.GetTableName();
s.TimeInterval = tn.GetTimeInterval();
sw.WriteLine("Created: " + tn.GetTableName() + " = " + expression);
return(s);
}
/// <summary>
/// Creates RiverWareSeries from TimeSeriesDatabase
/// </summary>
/// <param name="sdi"></param>
/// <param name="db"></param>
public RiverWareSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
m_filename = ConnectionStringUtility.GetFileName(ConnectionString, m_db.DataSource);
this.ExternalDataSource = true;
m_objectName = ConnectionStringUtility.GetToken(ConnectionString, "ObjectName", "");
m_slotName = ConnectionStringUtility.GetToken(ConnectionString, "SlotName", "");
int.TryParse(ConnectionStringUtility.GetToken(ConnectionString, "ScenarioNumber", ""), out m_scenarioNumber);
bool.TryParse(ConnectionStringUtility.GetToken(ConnectionString, "IsSnapShot", ""), out m_isSnapShot);
InitTimeSeries(null, this.Units, this.TimeInterval, this.ReadOnly, false, true);
ScenarioName = "Run " + m_scenarioNumber;
Appearance.LegendText = Name;
}
public HydrometDailySeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr) : base(db, sr)
{
HydrometInfoUtility.ParseConnectionString(ConnectionString, out server, out cbtt, out pcode);
}
string m_path; // //CHJ/YT//IR-MONTH/IRVZZBZD/
public UsaceSeries(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
m_path = ConnectionStringUtility.GetToken(sr.ConnectionString, "DssPath", "");
ExternalDataSource = true;
}
