private void DoDataBind() { GoogleMap1.Key = System.Web.Configuration.WebConfigurationManager.AppSettings["GMAPKEY"]; var territories = CurrentUser.CurrentAccount.TerritoryRecords(); bool centerSet = false; foreach (var territory in territories) { bool skipThisTerritory = false; if (territory.TerritoryNumber == 0 & !CheckBoxShowZero.Checked) { skipThisTerritory = true; } if (!skipThisTerritory) { if (!centerSet) { if (territory.CoordinatesCenter.Contains(",")) { GoogleMap1.Latitude = double.Parse(territory.CoordinatesCenter.Split(',')[1]); GoogleMap1.Longitude = double.Parse(territory.CoordinatesCenter.Split(',')[0]); centerSet = true; GoogleMap1.Markers.Add(new Artem.Web.UI.Controls.GoogleMarker(GoogleMap1.Latitude, GoogleMap1.Longitude)); } } string commaSeparatedPoligon = territory.CoordinatesPerimeter; var poligonObject = new Artem.Web.UI.Controls.GooglePolygon(); if (commaSeparatedPoligon != null & commaSeparatedPoligon != string.Empty) { var commaSeparatedPoints = commaSeparatedPoligon.Split(';'); foreach (var pointCouple in commaSeparatedPoints) { if (pointCouple.Trim() != string.Empty) { double lng = double.Parse(pointCouple.Split(',')[0]); double lat = double.Parse(pointCouple.Split(',')[1]); poligonObject.Points.Add(new Artem.Web.UI.Controls.GoogleLocation(lat, lng)); var marker = new Artem.Web.UI.Controls.GoogleMarker(); marker.Latitude = double.Parse(territory.CoordinatesCenter.Split(',')[1]); marker.Longitude = double.Parse(territory.CoordinatesCenter.Split(',')[0]); marker.IconUrl = MarkerHelper.GetMarkerUrl(territory.TerritoryNumber); marker.IconSize = new Artem.Web.UI.Controls.GoogleSize(20, 34); GoogleMap1.Markers.Add(marker); } } } // poligonObject.FillOpacity = 20; GoogleMap1.Polygons.Add(poligonObject); } GoogleMap1.Zoom = 11; } foreach (var poligon in GoogleMap1.Polygons) { poligon.FillColor = GetRandomColor(); } }
protected void Page_Load(object sender, EventArgs e) { try { InmueblesBLL bllInmuebles = new InmueblesBLL(); //12-12-12 //IdInmueble = Session["IdInmueble"].ToString(); IdInmueble = Request.QueryString["IdInmueble"]; dt = bllInmuebles.SeleccionaInmueblesPorID(Convert.ToInt32(IdInmueble)); if (dt.Rows.Count != 0) { Session["grd_ItemList2"] = dt; LlenarDetailsView(); DetailsView1.DataSource = dt; DetailsView1.DataBind(); DetailsView2.DataSource = dt; DetailsView2.DataBind(); GoogleMarker marker = new GoogleMarker(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString()); GoogleMap1.Markers.Add(marker); Coordinate coordinate = Geocode.GetCoordinates(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString()); decimal latitude = coordinate.Latitude; decimal longitude = coordinate.Longitude; if (latitude != 0 && longitude != 0) { GoogleMap1.Latitude = convert(latitude);//-32.9400639; GoogleMap1.Longitude = convert(longitude);//-60.6600255; } marker.Text = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString(); string g = marker.ToJsonString(); string strRutaFoto = Server.MapPath("~\\Image_Upload\\" + IdInmueble + "-" + "01" + "_thumb.jpg"); Boolean strFoto = (System.IO.File.Exists(strRutaFoto)); if (strFoto) { Image1.Visible = true; Image1.ImageUrl = this.Page.ResolveClientUrl("~\\Image_Upload\\" + IdInmueble + "-" + "01" + "_thumb.jpg"); } else { Image1.Visible = false; } //Googleimagen.ImageUrl = this.Page.ResolveUrl("http://maps.google.com/staticmap?zoom=15&size=320x342&markers=" + longitude + "," + latitude + "&key=ABQIAAAApU_iFCnQtFqCJz_RVHKf6hSIMON3V3yf7e-rtPXBV5YPjpYuCRQqSKQQMFkEFT-8V8ujIAr2-XcoIQ"); Googleimagen.ImageUrl = "http://maps.google.com/staticmap?zoom=15&size=259x250&markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&key=ABQIAAAApU_iFCnQtFqCJz_RVHKf6hSIMON3V3yf7e-rtPXBV5YPjpYuCRQqSKQQMFkEFT-8V8ujIAr2-XcoIQ"; } else if (dt.Rows.Count == 0) { } HiddenFielddireccion.Value = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString(); HiddenFieldzona.Value = dt.Rows[0]["Zona"].ToString(); HiddenFieldtipoinmueble.Value = dt.Rows[0]["TipoDeInmueble"].ToString(); HiddenFieldestadoinmueble.Value = dt.Rows[0]["Estado"].ToString(); HiddenFieldprovincia.Value = dt.Rows[0]["NombreProvincia"].ToString(); HiddenFieldlocalidad.Value = dt.Rows[0]["NombreLocalidad"].ToString(); HiddenFieldpiso.Value = dt.Rows[0]["Piso"].ToString(); HiddenFielddepartamento.Value = dt.Rows[0]["Departamento"].ToString(); HiddenFieldentrecalle.Value = dt.Rows[0]["Calle1"].ToString(); HiddenFieldycalle.Value = dt.Rows[0]["Calle2"].ToString(); HiddenFieldmetroscuadcubiertos.Value = dt.Rows[0]["MetroCuadrados"].ToString(); HiddenFieldmetroscuadsemicubiertos.Value = dt.Rows[0]["MetrosCuadradosSemiCub"].ToString(); HiddenFieldposicion.Value = dt.Rows[0]["Frente"].ToString(); HiddenFieldcochera.Value = dt.Rows[0]["Fondo"].ToString(); HiddenFieldposicion.Value = dt.Rows[0]["Posicion"].ToString(); HiddenFieldcochera.Value = dt.Rows[0]["Cocheras"].ToString(); HiddenFieldAntiguedad.Value = dt.Rows[0]["Antiguedad"].ToString(); HiddenFieldAntiguedadA.Value = dt.Rows[0]["AntiguedadA"].ToString(); HiddenFieldOperacion.Value = dt.Rows[0]["Operacion"].ToString(); HiddenFieldPrecioVenta.Value = dt.Rows[0]["PrecioVenta"].ToString() ; HiddenFieldPrecioVentaLabel.Value = precioVentaMoneda.ToString(); HiddenFieldPrecioVenta2.Value = dt.Rows[0]["PrecioVenta2"].ToString(); HiddenFieldPrecioVenta2Label.Value = precioVenta2Moneda.ToString(); HiddenFieldNombreInmobiliaria.Value = dt.Rows[0]["NombreInmobiliaria"].ToString(); HiddenFieldComision.Value = dt.Rows[0]["Comision"].ToString(); HiddenFieldFechaAlta.Value = dt.Rows[0]["FechaAlta"].ToString(); HiddenFieldFechaActualiza.Value = dt.Rows[0]["FechaActualiza"].ToString(); HiddenFieldMailUsuario.Value = dt.Rows[0]["MailUsuario"].ToString(); HiddenFieldObservaciones.Value = dt.Rows[0]["Observaciones"].ToString(); HiddenFieldimagen.Value = this.Page.ResolveClientUrl(IdInmueble + "-" + "01" + "_thumb.jpg"); HiddenFieldgooglemapsimage.Value = "http://maps.googleapis.com/maps/api/staticmap?markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&zoom=15&size=260x194&sensor=false"; } catch { } }
/// <summary> /// Applies the on marker. /// </summary> /// <param name="marker">The marker.</param> public virtual void ApplyOnMarker(GoogleMarker marker) { marker.AutoPan = this.AutoPan; marker.Bouncy = this.Bouncy; marker.Clickable = this.Clickable; marker.Draggable = this.Draggable; marker.DragCrossMove = this.DragCrossMove; if (marker.IconAnchor == GooglePoint.DefaultMarkerIconAnchor) marker.IconAnchor = this.IconAnchor; if (marker.IconSize == GoogleSize.DefaultMarkerIconSize) marker.IconSize = this.IconSize; if (string.IsNullOrEmpty(marker.IconUrl)) marker.IconUrl = this.IconUrl; marker.InfoWindowAnchor = this.InfoWindowAnchor; if (marker.OpenInfoBehaviour == OpenInfoBehaviour.Click) marker.OpenInfoBehaviour = this.OpenInfoBehaviour; if (marker.ShadowSize == GoogleSize.DefaultMarkerShadowSize) marker.ShadowSize = this.ShadowSize; if (string.IsNullOrEmpty(marker.ShadowUrl)) marker.ShadowUrl = this.ShadowUrl; if (string.IsNullOrEmpty(marker.Text)) marker.Text = this.Text; if (string.IsNullOrEmpty(marker.Title)) marker.Title = this.Title; }
/// <summary> /// When overridden in a derived class, binds data from the data source to the control. /// </summary> /// <param name="data">The <see cref="T:System.Collections.IEnumerable"/> list of data returned from a <see cref="M:System.Web.UI.WebControls.DataBoundControl.PerformSelect"/> method call.</param> protected override void PerformDataBinding(IEnumerable data) { base.PerformDataBinding(data); if (data != null) { bool hasAddressDataField = !string.IsNullOrEmpty(DataAddressField); bool hasLatitudeDataField = !string.IsNullOrEmpty(DataLatitudeField); bool hasLongitudeDataField = !string.IsNullOrEmpty(DataLongitudeField); bool hasTextDataField = !string.IsNullOrEmpty(DataTextField); GoogleMarker marker; foreach (object dataItem in data) { marker = new GoogleMarker(); if (hasAddressDataField) marker.Address = DataBinder.Eval(dataItem, DataAddressField, ""); if (hasLatitudeDataField) marker.Latitude = JsUtil.ToDouble(DataBinder.Eval(dataItem, DataLatitudeField, "")); if (hasLongitudeDataField) marker.Longitude = JsUtil.ToDouble(DataBinder.Eval(dataItem, DataLongitudeField, "")); if (hasTextDataField) marker.Text = DataBinder.Eval(dataItem, DataTextField, ""); this.Markers.Add(marker); } } }
public string getMarker() { StringBuilder bfMarker = new StringBuilder(); StringBuilder bfMarkerScript = new StringBuilder(); //bfMarker.AppendFormat("{0}.clearOverlays();", ); try { string unitID = Session["unitID"].ToString(); string deviceID = getDeviceID(unitID); string _comID = Session["trkCompany"].ToString(); GoogleMarker _currentMarker = new GoogleMarker(); double _lat = 0, _lng = 0; DataTable _dt = new DataTable(); string _strSQL = "SELECT unitName,lat,long,deviceID,city,state,country,CAST(velocity*0.621 AS INT) AS velocity," + "recTimeRevised,recTime,iconName FROM vwUnitRecords WHERE recTime IN " + "(SELECT MAX(recTime) FROM vwUnitRecords WHERE deviceID IN (SELECT deviceID FROM " + "vwUserWiseUnits WHERE uID = " + Session["trkUID"].ToString() + " AND deviceID = " + deviceID + ") GROUP BY deviceID) AND comID = " + _comID + " AND deviceID = " + deviceID + ";"; ExecuteSQL _exeSQL = new ExecuteSQL(); _dt = _exeSQL.ExecuteSQLQuery(_strSQL); if (_dt.Rows.Count > 0) { _lat = double.Parse(_dt.Rows[0]["lat"].ToString()); _lng = double.Parse(_dt.Rows[0]["long"].ToString()); bfMarker.Append("<script language=\"javascript\">"); //} if (_dt.Rows[0]["iconName"].ToString() != "") { bfMarkerScript.Append("cPoint=new GPoint(" + JsUtil.Encode(_lng) + "," + JsUtil.Encode(_lat) + ");"); bfMarkerScript.Append(" var icon0 = new GIcon();"); bfMarker.Append("icon0.image = '../Icon/" + _dt.Rows[0]["iconName"].ToString() + ".png';"); bfMarkerScript.Append(" icon0.iconSize = new GSize(" + iconHeight + "," + iconWidth + ");"); bfMarkerScript.Append("icon0.iconAnchor = new GPoint(" + iconHeight / 2 + "," + iconWidth / 2 + ");"); bfMarkerScript.Append("icon0.infoWindowAnchor = new GPoint(15, 15);"); bfMarkerScript.Append("icon0.infoShadowAnchor = new GPoint(18, 25);"); bfMarkerScript.Append(" var marker=new GMarker(cPoint,icon0);"); } bfMarkerScript.Append("myMap=new GMap2(document.getElementById(\\'map\\'));"); bfMarkerScript.Append("myMap.setCenter(new GLatLng(" + _lat + "," + _lng + "),5,G_HYBRID_MAP);"); bfMarkerScript.Append(" myMap.addOverlay(marker);"); bfMarker.Append(" setTimeout('evalMarker(\"" + bfMarkerScript.ToString() + "\")',100); "); bfMarker.Append("</script>"); Page.RegisterStartupScript("marker", bfMarker.ToString()); } } catch (Exception ex) { } return bfMarker.ToString(); }
private Coordinate getCoordinate(string calle, string numero, string nombrelocalidad, string nombredeprovincia) { GoogleMarker marker; if (nombredeprovincia != "Todas las Provincias") { marker = new GoogleMarker(dt.Rows[0][calle].ToString() + " " + dt.Rows[0][numero].ToString() + "," + dt.Rows[0][nombrelocalidad].ToString() + "," + dt.Rows[0][nombredeprovincia].ToString()); } else { marker = new GoogleMarker(dt.Rows[0][calle].ToString() + " " + dt.Rows[0][numero].ToString() + "," + dt.Rows[0][nombrelocalidad].ToString()); } GoogleMap1.Markers.Add(marker); Coordinate coordinate = Geocode.GetCoordinates(dt.Rows[0][calle].ToString() + " " + dt.Rows[0][numero].ToString() + "," + dt.Rows[0][nombrelocalidad].ToString()); return coordinate; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { rfvTxtNombre.IsValid = false; rfvTxtApellido.IsValid = false; rfvMail.IsValid = false; rfvTelefono.IsValid = false; try { InmueblesBLL bllInmuebles = new InmueblesBLL(); IdInmueble = Request.QueryString["IdInmueble"]; //Session["IdInmueble"] = IdInmueble; getInmueblePorID(bllInmuebles); if (dt.Rows[0]["Publica"].ToString() == "No" || dt.Rows[0]["Estado"].ToString() == "2") { if (dt.Rows[0]["IdUsuario"].ToString() != Membership.GetUser().ProviderUserKey.ToString()) { Response.Redirect("MapaPublico3.html"); } } DateTime FechaActualiza = Convert.ToDateTime(dt.Rows[0]["FechaActualiza"].ToString()); TimeSpan diferencia = DateTime.Now - FechaActualiza; if (diferencia.Days >= 90) { DetailsView1.BackColor = System.Drawing.Color.FromKnownColor(KnownColor.Red); DetailsView1.ForeColor = System.Drawing.Color.FromKnownColor(KnownColor.Red); } if (dt.Rows.Count != 0) { Session["grd_ItemList2"] = dt; LlenarDetailsView(); DetailsView1.DataSource = dt; DetailsView1.DataBind(); bindData(); //if (dt.Rows[0]["IdUsuario"].ToString() == Membership.GetUser().ProviderUserKey.ToString()) //{ //} if (dt.Rows[0]["NombreProvincia"].ToString() == "Todas las Provincias") { GoogleMarker marker = new GoogleMarker(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString()); GoogleMap1.Markers.Add(marker); Coordinate coordinate = Geocode.GetCoordinates(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString()); decimal latitude = coordinate.Latitude; decimal longitude = coordinate.Longitude; GoogleMap1.Latitude = convert(latitude);//-32.9400639; GoogleMap1.Longitude = convert(longitude);//-60.6600255; marker.Text = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString(); string g = marker.ToJsonString(); } else { GoogleMarker marker = new GoogleMarker(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString()); GoogleMap1.Markers.Add(marker); Coordinate coordinate = Geocode.GetCoordinates(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString()); decimal latitude = coordinate.Latitude; decimal longitude = coordinate.Longitude; GoogleMap1.Latitude = convert(latitude);//-32.9400639; GoogleMap1.Longitude = convert(longitude);//-60.6600255; marker.Text = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString(); string g = marker.ToJsonString(); } } else if (dt.Rows.Count == 0) { } HiddenFielddireccion.Value = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString(); HiddenFieldzona.Value = dt.Rows[0]["Zona"].ToString(); HiddenFieldtipoinmueble.Value = dt.Rows[0]["TipoDeInmueble"].ToString(); //HiddenFieldestadoinmueble.Value = dt.Rows[0]["Estado"].ToString(); HiddenFieldprovincia.Value = dt.Rows[0]["NombreProvincia"].ToString(); HiddenFieldlocalidad.Value = dt.Rows[0]["NombreLocalidad"].ToString(); HiddenFieldpiso.Value = dt.Rows[0]["Piso"].ToString(); //HiddenFieldSeccion.Value = dt.Rows[0]["Seccion"].ToString(); //HiddenFieldManzana.Value = dt.Rows[0]["Manzana"].ToString(); //HiddenFieldGrafico.Value = dt.Rows[0]["Grafico"].ToString(); //HiddenFieldSubdivision.Value = dt.Rows[0]["Subdivision"].ToString(); HiddenFielddepartamento.Value = dt.Rows[0]["Departamento"].ToString(); HiddenFieldentrecalle.Value = dt.Rows[0]["Calle1"].ToString(); HiddenFieldycalle.Value = dt.Rows[0]["Calle2"].ToString(); HiddenFieldmetroscuadcubiertos.Value = dt.Rows[0]["MetroCuadrados"].ToString(); HiddenFieldmetroscuadsemicubiertos.Value = dt.Rows[0]["MetrosCuadradosSemiCub"].ToString(); HiddenFieldcochera.Value = dt.Rows[0]["Fondo"].ToString(); HiddenFieldposicion.Value = dt.Rows[0]["Posicion"].ToString(); HiddenFieldcochera.Value = dt.Rows[0]["Cocheras"].ToString(); HiddenFieldFechaFinDeObra.Value = dt.Rows[0]["fechafinobra"].ToString(); HiddenFieldAntiguedad.Value = dt.Rows[0]["Antiguedad"].ToString(); HiddenFieldAntiguedadA.Value = dt.Rows[0]["AntiguedadA"].ToString(); HiddenFieldOperacion.Value = dt.Rows[0]["Operacion"].ToString(); //HiddenFieldPrecioVenta.Value = dt.Rows[0]["PrecioVenta"].ToString(); //HiddenFieldPrecioVenta2.Value = dt.Rows[0]["PrecioVenta2"].ToString(); //HiddenFieldPrecioAlquiler.Value = dt.Rows[0]["PrecioAlquiler"].ToString(); //HiddenFieldComision.Value = dt.Rows[0]["Comision"].ToString(); //HiddenFieldFechaAlta.Value = dt.Rows[0]["FechaAlta"].ToString(); //HiddenFieldFechaActualiza.Value = dt.Rows[0]["FechaActualiza"].ToString(); HiddenFieldMailUsuario.Value = dt.Rows[0]["MailUsuario"].ToString(); HiddenFieldMailAlternativoUsuario.Value = dt.Rows[0]["EmailAlternativo"].ToString(); HiddenFieldObservaciones.Value = dt.Rows[0]["Observaciones"].ToString(); //HiddenFieldObservaciones.Value = dt.Rows[0]["ObservacionesPrivadas"].ToString(); HiddenFieldimagen.Value = this.Page.ResolveClientUrl(IdInmueble + "-" + "01" + "_thumb.jpg"); HiddenFieldgooglemapsimage.Value = "http://maps.googleapis.com/maps/api/staticmap?markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&zoom=15&size=260x194&sensor=false"; } catch (Exception error) { if (!error.Message.Contains("403")) { Response.Redirect("MapaPublico3.html"); } } } }
private void DrawPoints() { if(ao_GoogleMap==null) ao_GoogleMap=(GoogleMap)CLSCOBO_FunctionsRepository.getElement("GoogleMap1", ao_WebPage); GoogleMarker vo_GoogleMarker; vo_GoogleMarker=new GoogleMarker(ao_ConsolidationProblem.OriginPoint.Latitude, ao_ConsolidationProblem.OriginPoint.Longitude); vo_GoogleMarker.Text=CLSCOBO_FunctionsRepository.CreateTag(ao_ConsolidationProblem.OriginPoint); vo_GoogleMarker.Title=ao_ConsolidationProblem.OriginPoint.ZipCode; ao_GoogleMap.Markers.Add(vo_GoogleMarker); foreach (CLSCOBO_DeliveryPoint po_DeliveryPoint in ao_ConsolidationProblem.Deliveries){ vo_GoogleMarker = new GoogleMarker(po_DeliveryPoint.Latitude,po_DeliveryPoint.Longitude); vo_GoogleMarker.Text=CLSCOBO_FunctionsRepository.CreateTag(po_DeliveryPoint); vo_GoogleMarker.Title=po_DeliveryPoint.ZipCode; ao_GoogleMap.Markers.Add(vo_GoogleMarker); } }