// Return number of records inserted or found
public static int HandleSiteInfo(SqlConnection sqlConn, WaterML11.SiteInfoResponseType rt)
{
SitesTableAdapter stAdapter = new SitesTableAdapter();
stAdapter.Connection = sqlConn;
WaterML11.SiteInfoType stinfo;
OD_1_1_DataSet.SitesDataTable tblSites = new OD_1_1_DataSet.SitesDataTable();
Console.WriteLine("Parsing and inserting site info.");
for (int i = 0; i < rt.site.Count(); i++)
{
stinfo = rt.site[i].siteInfo;
try
{
if (InsertOneSite(tblSites, stinfo, sqlConn))
{
stAdapter.Update(tblSites);
}
}
catch (Exception e)
{
Console.WriteLine("Failed to insert site {0}, completed {1} of {2}: {3}.",
stinfo.siteCode, i, rt.site.Count(), e.Message);
return(i);
}
}
// PrintTable(stAdapter, tblSites);
return(rt.site.Count());
}
static bool InsertOneSite(OD_1_1_DataSet.SitesDataTable sitesTable,
WaterML11.SiteInfoType stinfo, SqlConnection sqlConn)
{
OD_1_1_DataSet.SitesRow row = sitesTable.NewSitesRow();
row.SiteCode = stinfo.siteCode[0].Value;
string cond = "SiteCode = '" + row.SiteCode + "'";
if (OD_Utils.Exists(row.Table.TableName, cond, sqlConn))
{
return(false);
}
row.SiteName = stinfo.siteName;
WaterML11.LatLonPointType glt = (WaterML11.LatLonPointType)stinfo.geoLocation.geogLocation;
row.Latitude = glt.latitude;
row.Longitude = glt.longitude;
row.LatLongDatumID = 0;
row.Elevation_m = stinfo.elevation_m;
row.VerticalDatum = stinfo.verticalDatum;
//row.LocalX = 0;
//row.LocalY = 0;
//row.LocalProjectionID = 0;
//row.PosAccuracy_m = 0;
for (int i = 0; i < stinfo.note.Count(); i++)
{
NoteType note = stinfo.note[i];
switch (note.title)
{
case "State":
row.State = note.Value;
break;
case "County":
row.County = note.Value;
break;
case "agency":
row.Comments = note.Value;
break;
}
}
sitesTable.AddSitesRow(row);
return(true);
}
static void PrintTable(SitesTableAdapter stAdapter, OD_1_1_DataSet.SitesDataTable dt)
{
stAdapter.Fill(dt);
// Print out the column names.
for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
{
Console.Write(dt.Columns[curCol].ColumnName + "\t");
}
Console.WriteLine("\n----------------------------------");
// Print the DataTable.
for (int curRow = 0; curRow < dt.Rows.Count; curRow++)
{
for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
{
Console.Write(dt.Rows[curRow][curCol].ToString() + "\t");
}
Console.WriteLine();
}
}
