public List <WayNodeModel> getPrimaryWayEdgeForScreenshots() { string query = "SELECT a.way_id, a.node_id, c.latitude, c.longitude, b.v as way_name FROM way_nodes a, way_tags b, nodes c WHERE a.way_id = b.way_id and a.node_id = c.node_id and b.k = 'name' GROUP BY b.v"; //Create a list to store the result List <WayNodeModel> mainWays = new List <WayNodeModel>(); //Open connection if (this.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { WayNodeModel model = new WayNodeModel(); model.setWayId(dataReader["way_id"].ToString()); model.setNodeId(dataReader["node_id"].ToString()); model.setLatitude(Convert.ToDouble(dataReader["latitude"].ToString())); model.setLongitude(Convert.ToDouble(dataReader["longitude"].ToString())); model.setWayName(dataReader["way_name"].ToString()); mainWays.Add(model); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); //return list to be displayed return(mainWays); } else { return(mainWays); } }
public WayNodeModel getWayNodeDataAttribute(String name) { string query = "SELECT a.way_id, a.node_id, c.latitude, c.longitude, b.v as way_name FROM way_nodes a, way_tags b, nodes c WHERE a.way_id = b.way_id and a.node_id = c.node_id and b.k = 'name' and b.v = '" + name + "' group by b.way_id limit 1"; //Create a list to store the result WayNodeModel wayModel = new WayNodeModel(); //Open connection if (this.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { wayModel.setWayId(dataReader["way_id"].ToString()); wayModel.setNodeId(dataReader["node_id"].ToString()); wayModel.setLatitude(Convert.ToDouble(dataReader["latitude"].ToString())); wayModel.setLongitude(Convert.ToDouble(dataReader["longitude"].ToString())); wayModel.setWayName(dataReader["way_name"].ToString()); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); //return way to be displayed return(wayModel); } else { return(wayModel); } }
public List <WayNodeModel> getWayNodeData() { string query = "SELECT a.way_id, a.node_id, c.latitude, c.longitude, b.v as way_name FROM way_nodes a, way_tags b, nodes c WHERE a.way_id = b.way_id and a.node_id = c.node_id and b.k = 'name' group by b.v"; //Create a list to store the result List <WayNodeModel> list = new List <WayNodeModel>(); //Open connection if (this.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { WayNodeModel wayModel = new WayNodeModel(); wayModel.setWayId(dataReader["way_id"].ToString()); wayModel.setNodeId(dataReader["node_id"].ToString()); wayModel.setWayName(dataReader["way_name"].ToString()); list.Add(wayModel); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); //return list to be displayed return(list); } else { return(list); } }