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