public void AddOfficeToMap(int office_id)
{
var office = db.Offices.FirstOrDefault(p => p.office_id == office_id);
GLatLng latlon = default(GLatLng);
GMarker marker = default(GMarker);
GInfoWindow window = default(GInfoWindow);
string winText = null;
winText = "<b>" + office.office_nm + "<br />" + office.street_addrs + "<br />" + office.city_st_zip + "<br />" + office.ph_no + "</b>";
latlon = new GLatLng((double)office.dec_lat_va, (double)office.dec_long_va);
marker = new GMarker(latlon);
window = new GInfoWindow(marker, winText, false, GListener.Event.click);
GMap.addInfoWindow(window);
}
public ActionResult LoadMap(GMap GMap1)
{
GMap1.Height = 450;
GMap1.Width = 800;
GMap1.enableDragging = true;
GMap1.Language = "es";
GMap1.enableHookMouseWheelToZoom = true;
GMap1.enableGKeyboardHandler = true;
GMap1.addControl(new GControl(GControl.preBuilt.GOverviewMapControl));
GMap1.addControl(new GControl(GControl.preBuilt.LargeMapControl3D));
GMap1.addControl(new GControl(new CarouselMapTypeControl()));
GMap1.setCenter(new GLatLng(18.8, -70.2), 8);
//Marker Santo Domingo
GMarker markerStoDgo = new GMarker(new GLatLng(18.5016629749131, -69.796600313872));
GInfoWindowOptions optionsStoDgo = new GInfoWindowOptions("Detalles Estadisticos de Santo Domingo", @"<div style='margin-top:60px'>
<table>
<tr>
<td style='width:450px'><b>Educacion</b></td>
<td style='width:450px'><b>Vivienda</b></td>
<td style='width:450px'><b>Empleo</b></td>
<td style='width:450px'><b>Salud</b></td>
<td style='width:450px'><b>Pobreza</b></td>
<td style='width:450px'><b>Poblacion</b></td>
</tr>
<tr>
<td style='width:450px'><a href='Home/Add/detalles.cshtml?provincia=SantoDomingo&tabla=Vacunacion'>a</a></td>
<td style='width:450px'><a href='http://google.com'>b</a></td>
<td style='width:450px'><a href='http://google.com'>c</a></td>
<td style='width:450px'><a href='http://google.com'>e</a></td>
<td style='width:450px'><a href='http://google.com'>f</a></td>
<td style='width:450px'><a href='http://google.com'>g</a></td>
</tr>
</table>
</div>");
GInfoWindow windowStoDgo = new GInfoWindow(markerStoDgo, "Santo Domingo", optionsStoDgo);
GMap1.addInfoWindow(windowStoDgo);
//GMarker markerStoDgo = new GMarker(new GLatLng(18.5016629749131, -69.796600313872));
//GInfoWindow windowStoDgo = new GInfoWindow(markerStoDgo, "<center><a href='Santo Domingo'>Prueba<a></center>", true);
//GMap1.addInfoWindow(windowStoDgo);
////Marker Samana
//GMarker markerSamana = new GMarker(new GLatLng(19.2449631444, -69.4505309779197));
//GInfoWindow windowSamana = new GInfoWindow(markerSamana, "<center><a href='Samana'>Prueba<a></center>", true);
//GMap1.addInfoWindow(windowSamana);
////Marker La Romana
//GMarker markerRomana = new GMarker(new GLatLng(18.5016629749131, -68.8957214076072));
//GInfoWindow windowRomana = new GInfoWindow(markerRomana, "<center><a href='Romana'>Prueba<a></center>", true);
//GMap1.addInfoWindow(windowRomana);
////Marker La San Cristobal
//GMarker markerSanCris = new GMarker(new GLatLng(18.5381238176514, -70.1976012904197));
//GInfoWindow windowsSanCris = new GInfoWindow(markerSanCris, "<center><a href='SanCristobal'>Prueba<a></center>", true);
//GMap1.addInfoWindow(windowsSanCris);
////Marker La San Barahona
//GMarker markerBarahona = new GMarker(new GLatLng(18.136629600166, -71.2193298060447));
//GInfoWindow windowsBarahona = new GInfoWindow(markerBarahona, "<center><a href='Barahona'>Prueba<a></center>", true);
//GMap1.addInfoWindow(windowsBarahona);
return View();
}
public void AddSitesToMap(int wsc_id, int office_id, int trip_id)
{
int rowCount = 0;
double lat = 0;
double latAvg = 0;
double latMin = 0;
double latMax = 0;
double latPrev = 0;
double lng = 0;
double lngAvg = 0;
double lngMin = 0;
double lngMax = 0;
double lngPrev = 0;
int MapZoomLevel = 0;
string site_tp_cd = null;
GLatLng latlon = default(GLatLng);
GMarker marker = default(GMarker);
GInfoWindow window = default(GInfoWindow);
string winText = "";
string trip_nm = "";
int i = 0;
var SiteList = db.vFieldTripSites.Where(p => p.trip_id == trip_id).ToList();
foreach (var site in SiteList)
{
string site_no = site.site_no.Trim();
if ((!object.ReferenceEquals(site.dec_lat_va, DBNull.Value)))
{
lat = (double)site.dec_lat_va;
}
if ((!object.ReferenceEquals(site.dec_long_va, DBNull.Value)))
{
lng = (double)site.dec_long_va;
}
if (lat == 0 | lng == 0)
{
i += 1;
}
else
{
site_tp_cd = site.site_tp_cd;
trip_nm = site.trip_full_nm;
if (lat != latPrev & lng != lngPrev)
{
winText = "";
}
else
{
winText = winText + "<hr />";
}
winText = winText + "<b>" + site_no + " " + site.station_nm + "<br />" +
trip_nm + "</b><br /><br />" +
"<a href=\"https://sims.water.usgs.gov/SIMS/StationInfo.aspx?site_id=" + site.site_id.ToString() + "\" target=\"_blank\">SIMS Station Information Page</a><br />" +
"<a href=\"http://waterdata.usgs.gov/nwis/nwisman/?site_no=" + site_no + "\" target=\"_blank\">NWIS Web</a>";
latAvg = latAvg + lat;
lngAvg = lngAvg + lng;
if (i == 0)
{
latMin = lat;
latMax = lat;
lngMin = lng;
lngMax = lng;
}
else
{
if (lat < latMin)
{
latMin = lat;
}
if (lat > latMax)
{
latMax = lat;
}
if (lng < lngMin)
{
lngMin = lng;
}
if (lng > lngMax)
{
lngMax = lng;
}
}
latlon = new GLatLng(lat, lng);
marker = new GMarker(latlon, GetMarkerOpts());
window = new GInfoWindow(marker, winText, false, GListener.Event.click);
GMap.addInfoWindow(window);
latPrev = lat;
lngPrev = lng;
i += 1;
}
}
rowCount = SiteList.Count();
if (rowCount == 0)
{
SetupBasicGMapDisplay(wsc_id);
}
else
{
//zoom/center map based on markers
latAvg = (latAvg / i);
lngAvg = (lngAvg / i);
MapZoomLevel = GetMapZoomLevel(latMin, latMax, lngMin, lngMax);
GMap.setCenter(new GLatLng(latAvg, lngAvg), MapZoomLevel);
}
lblResultsCount.Text = "Sites returned: " + rowCount.ToString();
}
