public SiteInfo(TimeSeriesDatabase db, string siteID)
{
m_db = db;
m_siteID = siteID;
var a = db.GetSiteCatalog("siteid = '" + m_siteID + "'");
if (a.Rows.Count == 0)
m_siteRow = a.NewsitecatalogRow();
else
{
m_siteRow = a[0];
}
}
public SiteInfo(TimeSeriesDatabase db, string siteID)
{
m_db = db;
m_siteID = siteID;
var a = db.GetSiteCatalog("siteid = '" + m_siteID + "'");
if (a.Rows.Count == 0)
{
m_siteRow = a.NewsitecatalogRow();
}
else
{
m_siteRow = a[0];
}
}
private string AddSiteData(string rval)
{
// check for %site%.elevation or other lookups in sitecatalog table
// abei.latitude
if (SiteID == "")
{
return(rval);
}
rval = rval.Replace("%site%", SiteID); // TO DO.. SiteID
string pattern = "(?<!\")(?<siteid>" + SiteID + ")\\.(?<column>[a-zA-Z]+)";
var m = Regex.Match(rval, pattern);
while (m.Success && m_db != null)
{
TimeSeriesDatabaseDataSet.sitecatalogRow site;
if (s_prevSiteRow != null && s_prevSiteRow.siteid == SiteID)
{
site = s_prevSiteRow; // save DB call
}
else
{
site = m_db.GetSiteRow(SiteID);
s_prevSiteRow = site;
}
string colName = m.Groups["column"].Value;
if (site != null && site.Table.Columns.IndexOf(colName) >= 0)
{
rval = rval.Replace(m.Groups[0].Value, site[colName].ToString());
}
else
{
// Logger.WriteLine("Error (ExpressionPreprocessor) doing lookup on " + site + "." + colName);
break;
}
m = Regex.Match(rval, pattern);
}
return(rval);
}
private void textBoxSiteID_TextChanged(object sender, EventArgs e)
{
if (textBoxdescription.Text.Trim() == "" && textBoxSiteID.Text.Trim().Length > 2)
{
if (m_siteCatalog == null)
{
m_siteCatalog = m_db.GetSiteCatalog();
}
m_siteRow = m_siteCatalog.FindBysiteid(textBoxSiteID.Text.Trim());
if (m_siteRow != null)
{
this.textBoxdescription.Text = m_siteRow.description;
this.textBoxElevation.Text = m_siteRow.elevation;
this.textBoxlatitude.Text = m_siteRow.latitude;
this.textBoxlongitude.Text = m_siteRow.longitude;
this.textBoxInstall.Text = m_siteRow.install;
this.textBoxTimezone.Text = m_siteRow.timezone;
this.textBoxState.Text = m_siteRow.state;
}
}
}
private void textBoxSiteID_TextChanged(object sender, EventArgs e)
{
if (textBoxdescription.Text.Trim() == "" && textBoxSiteID.Text.Trim().Length >2)
{
if (m_siteCatalog == null)
{
m_siteCatalog = m_db.GetSiteCatalog();
}
m_siteRow = m_siteCatalog.FindBysiteid(textBoxSiteID.Text.Trim());
if (m_siteRow != null)
{
this.textBoxdescription.Text = m_siteRow.description;
this.textBoxElevation.Text = m_siteRow.elevation.ToString();
this.textBoxlatitude.Text = m_siteRow.latitude.ToString();
this.textBoxlongitude.Text = m_siteRow.longitude.ToString();
this.textBoxInstall.Text = m_siteRow.install;
this.textBoxTimezone.Text = m_siteRow.timezone;
this.textBoxState.Text = m_siteRow.state;
}
}
}
