protected void Page_Load(object sender, EventArgs e)
{
GMap1.setCenter(new GLatLng(41, 3), 3);
GMap1.Add(new GControl(GControl.preBuilt.LargeMapControl));
GMarker m1 = new GMarker(new GLatLng(41, 3));
MarkerManager mManager = new MarkerManager();
mManager.Add(m1, 2);
List<GMarker> mks = new List<GMarker>();
List<GInfoWindow> iws = new List<GInfoWindow>();
Random r = new Random();
double ir1, ir2;
GMarker mkr;
for (int i = 0; i < 10; i++)
{
ir1 = (double)r.Next(40) / 10.0 - 2.0;
ir2 = (double)r.Next(40) / 10.0 - 2.0;
mkr = new GMarker(m1.point + new GLatLng(ir1, ir2));
mks.Add(mkr);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click, "function(){alert('" + i + "');}"));
}
for (int i = 0; i < 5; i++)
{
ir1 = (double)r.Next(40) / 20.0 - 1;
ir2 = (double)r.Next(40) / 20.0 - 1;
mkr = new GMarker(m1.point + new GLatLng(ir1, ir2));
GInfoWindow window = new GInfoWindow(mkr, i.ToString());
iws.Add(window);
}
mManager.Add(mks, 6, 8);
mManager.Add(iws, 7, 8);
GMap1.markerManager = mManager;
}
protected void Page_Load(object sender, EventArgs e)
{
GMap1.setCenter(new GLatLng(41, 3), 3);
GMap1.Add(new GControl(GControl.preBuilt.LargeMapControl));
GMarker m1 = new GMarker(new GLatLng(41, 3));
MarkerManager mManager = new MarkerManager();
mManager.Add(m1, 2);
List <GMarker> mks = new List <GMarker>();
List <GInfoWindow> iws = new List <GInfoWindow>();
Random r = new Random();
double ir1, ir2;
GMarker mkr;
for (int i = 0; i < 10; i++)
{
ir1 = (double)r.Next(40) / 10.0 - 2.0;
ir2 = (double)r.Next(40) / 10.0 - 2.0;
mkr = new GMarker(m1.point + new GLatLng(ir1, ir2));
mks.Add(mkr);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click, "function(){alert('" + i + "');}"));
}
for (int i = 0; i < 5; i++)
{
ir1 = (double)r.Next(40) / 20.0 - 1;
ir2 = (double)r.Next(40) / 20.0 - 1;
mkr = new GMarker(m1.point + new GLatLng(ir1, ir2));
GInfoWindow window = new GInfoWindow(mkr, i.ToString());
iws.Add(window);
}
mManager.Add(mks, 6, 8);
mManager.Add(iws, 7, 8);
GMap1.markerManager = mManager;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Redirect("Index.aspx");
}
string id = Request.QueryString["id"];
double lat = 0, lon = 0;
// SELECT Cab.Cab_ID, CabLocations.Latitude, CabLocations.Longitude FROM Cab INNER JOIN CabLocations ON Cab.Cab_ID=CabLocations.Cab_ID WHERE Cab.Cab_RegNo = 'VY-702';
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(@"Data Source=WALEED-PC;Initial Catalog=Cab9;Integrated Security=True");
connection.Open();
SqlCommand sqlCmd = new SqlCommand("SELECT Cab.Cab_ID, CabLocations.Latitude, CabLocations.Longitude FROM Cab INNER JOIN CabLocations ON Cab.Cab_ID=CabLocations.Cab_ID WHERE Cab.Cab_RegNo = '" + id + "'", connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
lat = Convert.ToDouble(dt.Rows[0]["Latitude"]);
lon = Convert.ToDouble(dt.Rows[0]["Longitude"]);
}
connection.Close();
GLatLng latlng = new GLatLng(lat, lon);
GMapType.GTypes mType = GMapType.GTypes.Normal;
GMap1.setCenter(latlng, 15, mType);
///////////////////////////////////////////////
GMap1.Add(new GControl(GControl.preBuilt.LargeMapControl));
GMarker m1 = new GMarker(new GLatLng(lat, lon));
MarkerManager mManager = new MarkerManager();
mManager.Add(m1, 10);
List<GMarker> mks = new List<GMarker>();
List<GInfoWindow> iws = new List<GInfoWindow>();
Random r = new Random();
GMarker mkr;
for (int i = 0; i < 5; i++)
{
double ir1 = r.Next(40) / 10.0 - 2.0;
double ir2 = r.Next(40) / 10.0 - 2.0;
mkr = new GMarker(m1.point + new GLatLng(lat, lon));
mks.Add(mkr);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click, "function(){alert('" + i + "');}"));
}
for (int i = 0; i < 5; i++)
{
double ir1 = r.Next(40) / 20.0 - 1;
double ir2 = r.Next(40) / 20.0 - 1;
mkr = new GMarker(m1.point + new GLatLng(lat, lon));
GInfoWindow window = new GInfoWindow(mkr, i.ToString());
iws.Add(window);
}
mManager.Add(mks, 5, 6);
mManager.Add(iws, 7, 8);
GMap1.markerManager = mManager;
///////////////////////////////////////////////////////////////////
string cab = "";
DataTable dt1 = new DataTable();
SqlConnection connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection1"].ConnectionString.ToString());
connection1.Open();
SqlCommand sqlCmd1 = new SqlCommand("Select Cab_ID from Cab where Cab_RegistrationNumber='" + id + "'", connection1);
SqlDataAdapter sqlDa1 = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt1);
if (dt.Rows.Count > 0)
{
cab = dt.Rows[0]["Cab_ID"].ToString();
}
connection.Close();
/////////////////////////////////////////////////////////////////
DataTable dt2 = new DataTable();
SqlConnection connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection1"].ConnectionString.ToString());
connection2.Open();
SqlCommand sqlCmd2 = new SqlCommand("Select SUM([Booking_Fare]) As Total from Booking where Cab_ID='" + cab + "'", connection2);
SqlDataAdapter sqlDa2 = new SqlDataAdapter(sqlCmd2);
sqlDa2.Fill(dt2);
string fare = "";
if (dt2.Rows.Count > 0)
{
fare = dt2.Rows[0]["Total"].ToString();
}
ASPxGaugeControl1.Value = fare;
connection.Close();
///////////////////////////////////////////////////////////////////////////////////////////////////////
//SELECT DISTINCT([Booking_Source]), COUNT([Booking_Source]) FROM [Booking] GROUP BY Booking_Source
SqlDataSource1.SelectCommand = "SELECT DISTINCT([Booking_Source]), COUNT([Booking_Source]) FROM [Booking] where Cab_ID='" + cab + "' GROUP BY Booking_Source ";
SqlDataSource2.SelectCommand = "SELECT DISTINCT([Booking_Destination]), COUNT([Booking_Destination]) FROM [Booking] where Cab_ID='" + cab + "' GROUP BY Booking_Destination ";
}
protected void Page_Load(object sender, EventArgs e)
{
MarkerManager mManager = new MarkerManager();
double lat = 0.0;
double longi = 0.0;
//reset listeners, necessary for marker listener to work between postback
GMap1.resetListeners();
//Create default marker
GIcon icon = new GIcon();
icon.image = "http://labs.google.com/ridefinder/images/mm_20_red.png";
icon.shadow = "http://labs.google.com/ridefinder/images/mm_20_shadow.png";
icon.iconSize = new GSize(20, 28);
icon.shadowSize = new GSize(30, 28);
icon.iconAnchor = new GPoint(10, 18);
icon.infoWindowAnchor = new GPoint(5, 1);
GMap1.mapType = GMapType.GTypes.Hybrid;
GMarkerOptions mOpts = new GMarkerOptions();
mOpts.clickable = false;
mOpts.icon = icon;
//GMap1.GZoom = 3; //set zoom level
GMap1.Key = ConfigurationSettings.AppSettings["GoogleMapKey"];
GMap1.enableDragging = true;
GMap1.enableGoogleBar = false;
GMap1.Language = "en";
GMap1.BackColor = Color.White;
//GMap1.enableHookMouseWheelToZoom = true;
GMap1.enableGKeyboardHandler = true;
//Add built-in control for selecting map type
GMap1.addControl(new GControl(GControl.preBuilt.MapTypeControl));
//Add built-in control for zoom and pan
//GMap1.addControl(new GControl(GControl.preBuilt.SmallZoomControl3D));
GMap1.addControl(new GControl(GControl.preBuilt.LargeMapControl3D));
//Custom cursor
GCustomCursor customCursor = new GCustomCursor(cursor.crosshair, cursor.text);
GMap1.addCustomCursor(customCursor);
//Mark centre with a "+"
GControl control = new GControl(GControl.extraBuilt.MarkCenter);
//Adds a textbox which gives the coordinates of the last click
GMap1.addControl(new GControl(GControl.extraBuilt.TextualOnClickCoordinatesControl,
new GControlPosition(GControlPosition.position.Bottom_Right)));
//Add all stops to GMAP
var stops =
from s in JUTCLinq.Stops
select s;
foreach (var s in stops)
{
lat = s.Lattitude;
longi = s.Longitude;
GMarker mkr = new GMarker(new GLatLng(lat, longi));
//GMap1.addGMarker(mkr);
mManager.Add(mkr, 10);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click,
"function(){prompt('Stop #: " + s.StopNo
+ ", Location: " + s.Location + ", Coordinates:"
+ "','" + s.Lattitude + "," + s.Longitude
+ "');"
+ "var hsn = document.getElementById('hidStopNo');"
+ "hsn.value = '" + s.StopNo + "';"
+ "}"));
}
GMap1.markerManager = mManager;
if (!IsPostBack)
{
GMap1.setCenter(hwttc, 18);
}
}
protected void ddlStopList_SelectedIndexChanged(object sender, EventArgs e)
{
MarkerManager mManager = new MarkerManager();
double lat = 0.0;
double longi = 0.0;
if (ddlStopList.SelectedValue == "All Stops")
{
//select all stops create the marker and event
//to show its info
var stops =
from s in JUTCLinq.Stops
select s;
foreach (var s in stops)
{
lat = s.Lattitude;
longi = s.Longitude;
GMarker mkr = new GMarker(new GLatLng(lat, longi));
//GMap1.addGMarker(mkr);
mManager.Add(mkr,10);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click,
"function(){prompt('Stop #: " + s.StopNo
+ ", Location: " + s.Location + ", Coordinates:"
+ "','" + s.Lattitude + "," + s.Longitude
+ "');"
+ "var hc = document.getElementById('hidCoords');"
+ "hc.value = '" + s.Lattitude + "," + s.Longitude + "';"
+ "var hsn = document.getElementById('hidStopNo');"
+ "hsn.value = '" + s.Lattitude + "," + s.Longitude + "';"
+ "var hsl = document.getElementById('hidStopsList');"
+ "hsl.value += '" + s.StopNo + ",';"
+ "}"));
}
}
else
{
//select stoplist for specified route
var stops =
from s in JUTCLinq.Routes
where s.RouteNo == ddlStopList.SelectedValue
select s;
string routelist = " ";
//get routestops
foreach (var s in stops)
{
routelist = s.RouteStops;
}
//parse route stops list
string[] stopsArr = routelist.Split(',');
//travers array and select each stop
foreach(string stp in stopsArr)
{
var stops2 =
from s2 in JUTCLinq.Stops
where s2.StopNo == stp
select s2;
//for each stop select the row and create the marker
//and event to show its info
foreach (var s2 in stops2)
{
lat = s2.Lattitude;
longi = s2.Longitude;
GMarker mkr = new GMarker(new GLatLng(lat, longi));
mManager.Add(mkr, 10);
GMap1.Add(new GListener(mkr.ID, GListener.Event.click,
"function(){prompt('Stop #: " + s2.StopNo
+ ", Location: " + s2.Location + ", Coordinates:"
+ "','" + s2.Lattitude + "," + s2.Longitude
+ "');"
+ "var hc = document.getElementById('hidCoords');"
+ "hc.value = '" + s2.Lattitude + "," + s2.Longitude + "';"
+ "var hsn = document.getElementById('hidStopNo');"
+ "hsn.value = '" + s2.Lattitude + "," + s2.Longitude + "';"
+ "var hsl = document.getElementById('hidStopsList');"
+ "hsl.value += '" + s2.StopNo + ",';"
+ "}"));
}
}
}
GMap1.markerManager = mManager;
}
private void showMap()
{
GridView gv = new GridView();
gv.DataSource = SqlDataSource1;
gv.DataBind();
int start = displayTable.PageIndex * 10;
string sMapKey = ConfigurationManager.AppSettings["googlemaps.subgurim.net"];
GeoCode geoCode;
GLatLng gLatLng = null;
GMarker oMarker;
string sStreetAddress;
MarkerManager mManager = new MarkerManager();
GMap1.Add(new GMapUI());
for (int i = 0; i < Math.Min(10, gv.Rows.Count - displayTable.PageIndex * 10); i++)
{
sStreetAddress = gv.Rows[start].Cells[2].Text + ", " + gv.Rows[start].Cells[6].Text + ", " + gv.Rows[start].Cells[7].Text;
geoCode = GMap.geoCodeRequest(sStreetAddress, sMapKey);
gLatLng = new GLatLng(geoCode.Placemark.coordinates.lat, geoCode.Placemark.coordinates.lng);
oMarker = new GMarker(gLatLng);
GInfoWindow window = new GInfoWindow(oMarker, gv.Rows[start].Cells[1].Text, false, GListener.Event.mouseover);
mManager.Add(oMarker, 0);
mManager.Add(window, 0);
start += 1;
}
GMap1.markerManager = mManager;
GMap1.setCenter(gLatLng, 10, Subgurim.Controles.GMapType.GTypes.Normal);
GMap1.enableHookMouseWheelToZoom = true;
}
