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