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()); }