private void fetchNodeData()
{
//Database Stuff
NpgsqlConnection conn = new NpgsqlConnection("Server=flick.cs.niu.edu;Port=5432;User Id=readonly;Database=aot;CommandTimeout=240");
conn.Open();
NpgsqlCommand command = new NpgsqlCommand("SELECT FORMAT('%s, %s', lat, lon) lat_lon, aot_node_id, address, start_timestamp, end_timestamp, lat, lon FROM aot_nodes WHERE project_id = 'AoT_Chicago' AND aot_node_id != '001e0610ef73';", conn);
try
{
NpgsqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
NodeLocations.Add(reader.GetString(0));
NodeIds.Add(reader.GetString(1));
NodeAddresses.Add(reader.GetString(2));
NodeStart.Add(reader.GetTimeStamp(3).ToString());
try
{
NodeEnd.Add(reader.GetTimeStamp(4).ToString());
}
catch (System.InvalidCastException icex)
{
NodeEnd.Add("");
}
NodeLat.Add(reader.GetString(5));
NodeLon.Add(reader.GetString(6));
}
}
catch (System.Exception ex)
{
print(ex.Message);
}
conn.Close();
}
public IDbDataParameter GetDbParameter()
{
return(NodeStart.GetDbParameter());
}
