private static void NCDCSitesXMLReader(List <SiteInfoNCDC> sites, XmlReader xmlReader)
{
xmlReader.ReadToDescendant("site");
while (xmlReader.IsStartElement())
{
XmlReader siteReader = xmlReader.ReadSubtree();
SiteInfoNCDC site = new SiteInfoNCDC();
siteReader.ReadStartElement();
while (siteReader.IsStartElement())
{
switch (siteReader.Name)
{
case "datasetid":
site.DatasetID = siteReader.ReadString();
break;
case "stationid":
site.StationID = siteReader.ReadString();
break;
case "name":
site.SiteName = siteReader.ReadString();
break;
case "lat":
site.SetLatitude(siteReader.ReadString());
break;
case "lon":
site.SetLongitude(siteReader.ReadString());
break;
case "lowdate":
site.SetBeginDate(siteReader.ReadString());
break;
case "highdate":
site.SetEndDate(siteReader.ReadString());
break;
case "elev":
site.SetElevation(siteReader.ReadString());
break;
default:
log.Error("New Node name in site " + siteReader.Name);
siteReader.ReadString();
break;
}
siteReader.ReadEndElement();
//siteReader.ReadStartElement();
}
sites.Add(site);
xmlReader.ReadEndElement();
}
}
public void SetEndDateTest()
{
SiteInfoNCDC target = new SiteInfoNCDC();
string DateYYYYmm = null; // TODO: Initialize to an appropriate value
target.SetEndDate(DateYYYYmm);
Assert.Ignore("A method that does not return a value cannot be verified.");
}
public void AddToDBTest()
{
string connectionString = "Data Source=localhost;Initial Catalog=ASOS;Integrated Security=True;"; // TODO: Initialize to an appropriate value
string tableName = "siteInfo$";
SitesToDb target = new SitesToDb(connectionString);
SiteInfoNCDC site = new SiteInfoNCDC();
site.StationID = "09999999";
site.SiteName = "TEst";
site.SetLongitude("179");
site.SetLatitude("80");
site.SetBeginDate("200601");
site.SetEndDate("200801");
site.Elevation = 0;
site.DatasetID = "-1";
target.AddToDB(site, ExportType.ALL, tableName);
SqlConnection con = new SqlConnection();
con.ConnectionString = connectionString;
con.Open();
SqlCommand comm = con.CreateCommand();
comm.CommandText = "Select count(SiteID) from " + tableName + " where SiteID ='" + site.StationID + "'";
int numROws = (int)comm.ExecuteScalar();
Assert.LessOrEqual(numROws, 1, "Retrned more than one row");
// Assert.Inconclusive("A method that does not return a value cannot be verified.");
}