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);
}
}
private void buttonRouting_Click(object sender, EventArgs e)
{
if (!textBoxFrom.Text.Equals("") && !textBoxDestination.Text.Equals(""))
{
String nodeFromName = textBoxFrom.Text;
String nodeDestinationName = textBoxDestination.Text;
WayNodeModel mFrom = dbConnection.getWayNodeDataAttribute(nodeFromName);
WayNodeModel mDestination = dbConnection.getWayNodeDataAttribute(nodeDestinationName);
String lat1 = Convert.ToString(mFrom.getLatitude());
String lon1 = Convert.ToString(mFrom.getLongitude());
String lat2 = Convert.ToString(mDestination.getLatitude());
String lon2 = Convert.ToString(mDestination.getLongitude());
// create valid latitude & longitude type from database, ex : -69097867 to -6.9097867 and 1076106278 to 107.6106278
lat1 = lat1.Insert(2, ".");
lon1 = lon1.Insert(3, ".");
lat2 = lat2.Insert(2, ".");
lon2 = lon2.Insert(3, ".");
Console.WriteLine("Lat1:" + lat1 + " Lon1:" + lon1);
Console.WriteLine("Lat2:" + lat2 + " Lon2:" + lon2);
// add marker for source
GMapOverlay markersOverlayFrom = new GMapOverlay(mFrom.getWayName());
GMarkerGoogle markerFrom = new GMarkerGoogle(new PointLatLng(Convert.ToDouble(lat1), Convert.ToDouble(lon1)), GMarkerGoogleType.green);
markersOverlayFrom.Markers.Add(markerFrom);
gMapControl.Overlays.Add(markersOverlayFrom);
// add marker for destination
GMapOverlay markersOverlayDest = new GMapOverlay(mDestination.getWayName());
GMarkerGoogle markerDest = new GMarkerGoogle(new PointLatLng(Convert.ToDouble(lat2), Convert.ToDouble(lon2)), GMarkerGoogleType.red);
markersOverlayDest.Markers.Add(markerDest);
gMapControl.Overlays.Add(markersOverlayDest);
// getCenterMap from 2 location
PointLocation centerMapLocation = new PointLocation();
MapUtils mapUtil = new MapUtils();
centerMapLocation = mapUtil.calculateMidPointLocations(Convert.ToDouble(lat1), Convert.ToDouble(lon1), Convert.ToDouble(lat2), Convert.ToDouble(lon2));
double bearing = mapUtil.calculateBearing(Convert.ToDouble(lat1), Convert.ToDouble(lon1), Convert.ToDouble(lat2), Convert.ToDouble(lon2));
double distance = mapUtil.calculateDistanceKM(Convert.ToDouble(lat1), Convert.ToDouble(lon1), Convert.ToDouble(lat2), Convert.ToDouble(lon2));
Console.WriteLine("Lat3:" + centerMapLocation.getLatitude() + " Lon3:" + centerMapLocation.getLongitude());
Console.WriteLine("Bearing:" + bearing);
Console.WriteLine("Distance:" + distance);
Console.WriteLine("Pixel Distance:" + CentimeterToPixel(distance * 10));
// get route result
string jsonResultPath = getRoutePath(mFrom.getNodeId(), mDestination.getNodeId());
JObject results = JObject.Parse(jsonResultPath);
List <NodeModel> listNode = new List <NodeModel>();
foreach (var result in results["path"])
{
NodeModel node = new NodeModel();
string nodeId = (string)result["node_id"];
string lat = (string)result["latitude"];
string lon = (string)result["longitude"];
// create valid latitude & longitude type from database, ex : -69097867 to -6.9097867 and 1076106278 to 107.6106278
lat = lat.Insert(2, ".");
lon = lon.Insert(3, ".");
node.setNodeId(nodeId);
node.setLatitude(Convert.ToDouble(lat));
node.setLongitude(Convert.ToDouble(lon));
listNode.Add(node);
//Console.WriteLine("NodeId: {0}, Latitude: {1}, Longitude: {2}", nodeId, lat, lon);
}
// draw path
GMapOverlay routeOverlay = new GMapOverlay("path");
List <PointLatLng> points = new List <PointLatLng>();
// path point
for (int i = 0; i < listNode.Count; i++)
{
points.Add(new PointLatLng(listNode[i].getLatitude(), listNode[i].getLongitude()));
Console.WriteLine("NodeId: {0}, Latitude: {1}, Longitude: {2}", listNode[i].getNodeId(), listNode[i].getLatitude(), listNode[i].getLongitude());
}
// draw line
GMapRoute gRoute = new GMapRoute(points, "route");
gRoute.Stroke.Width = 7;
//gRoute.Stroke.Color = Color.SeaGreen;
//gRoute.Stroke = new Pen(Color.Blue, 7);
routeOverlay.Routes.Add(gRoute);
gMapControl.Overlays.Add(routeOverlay);
// show getCenterMap from 2 location
gMapControl.Position = new GMap.NET.PointLatLng(centerMapLocation.getLatitude(), centerMapLocation.getLongitude());
gMapControl.Zoom = 16;
int width = gMapControl.Width;
int height = gMapControl.Height;
Console.WriteLine("[MapControl] Width: " + width + " Height:" + height);
/*
* // AStar calculation
* AStar astar = new AStar();
* astar.calcuateShortestPath(mFrom.getNodeId(), mDestination.getNodeId());
*/
/*
* // test take 5 screenshots
* List<WayNodeModel> listWays = dbConnection.getWayNodeData();
* for(int i = 0; i < 5; i++){
* createMapTileScreenshots(listWays[i].getNodeId(), Convert.ToString(listWays[i].getLatitude()), Convert.ToString(listWays[i].getLongitude()));
* }*/
/*String pathScreenshots = System.IO.Path.GetDirectoryName(System.AppDomain.CurrentDomain.BaseDirectory) + Path.DirectorySeparatorChar + "screenshots" + Path.DirectorySeparatorChar;
* Console.WriteLine("Screenshots Path: " + pathScreenshots);
* try
* {
* // setting for proxy
* //PhantomJSOptions phOptions = new PhantomJSOptions();
* //phOptions.AddAdditionalCapability(CapabilityType.Proxy, "cache.itb.ac.id");
*
* // hide cmd windows of phantomsjs
* var driverService = PhantomJSDriverService.CreateDefaultService();
* driverService.HideCommandPromptWindow = true;
*
* // initiate phantomjs driver
* PhantomJSDriver phantom;
* phantom = new PhantomJSDriver(driverService);
* // setting the default timeout to 30 seconds
* phantom.Manage().Timeouts().ImplicitlyWait(new TimeSpan(0, 0, 30));
* string screenshotUrl = "http://localhost/bsts_routing/tilegen/v2/index.php?latitude=-6.9131786&longitude=107.6474137";
* phantom.Navigate().GoToUrl(screenshotUrl);
*
* // grab the snapshot
* Screenshot sh = phantom.GetScreenshot();
* sh.SaveAsFile(pathScreenshots + "test.png", ImageFormat.Png);
* phantom.Quit();
*
* } catch (Exception error) {
* Console.WriteLine(error.Message);
* }*/
}
else
{
MessageBox.Show("Please input address first!");
}
}
