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."); }