public ActionResult GetSelectedCity(int id) { var db = new GccSytemEntities(); var polygons = db.zimcities.Where(p => p.CITY_ID == id); var polygonFeature = new List <Feature>(); if (polygons != null) { foreach (var results in polygons) { if (results.geom != null) { SqlGeometry simplepolygon = SqlGeometry.Parse(new SqlString(results.geom.AsText())); var polygonGeometry = SqlGeometry.STPolyFromText(new SqlChars(results.geom.AsText()), 4326); var simplepolygonGeometry = simplepolygon.ToGeoJSONObject <Polygon>(); var geojsonGeometry = polygonGeometry.ToGeoJSONObject <Polygon>(); var properties = new Dictionary <string, object> { { "id", results.CITY_NAME }, { "province", results.PROVINCE }, { "province_code", results.PROV_CODE }, }; var feature = new Feature(geojsonGeometry, properties); var simplePolygonFeature = new Feature(simplepolygonGeometry, properties); //polygonFeature.Add(feature); polygonFeature.Add(simplePolygonFeature); } } } return(Json(polygonFeature, JsonRequestBehavior.AllowGet)); }
// GET: CascadingDropdown public JsonResult GetCascadeProvinces() { var db = new GccSytemEntities(); return(Json(db.zimprovinces.Select(c => new { ProvinceCode = c.PROV_CODE, ProvinceName = c.PROVINCE }), JsonRequestBehavior.AllowGet)); }
public ActionResult GetSelectedTown(int id) { var db = new GccSytemEntities(); var polygons = db.zimtownships.Where(p => p.id == id); var polygonFeature = new List <Feature>(); if (polygons != null) { foreach (var results in polygons) { if (results.geom != null) { SqlGeometry simplepolygon = SqlGeometry.Parse(new SqlString(results.geom.AsText())); var polygonGeometry = SqlGeometry.STPolyFromText(new SqlChars(results.geom.AsText()), 4326); var simplepolygonGeometry = simplepolygon.ToGeoJSONObject <Polygon>(); var geojsonGeometry = polygonGeometry.ToGeoJSONObject <Polygon>(); var properties = new Dictionary <string, object> { { "id", results.Name } }; var feature = new Feature(geojsonGeometry, properties); var simplePolygonFeature = new Feature(simplepolygonGeometry, properties); polygonFeature.Add(simplePolygonFeature); } } } return(Json(polygonFeature, JsonRequestBehavior.AllowGet)); }
public JsonResult GetCascadeCities(int provinces) { var db = new GccSytemEntities(); var cities = db.zimcities.AsQueryable(); if (provinces != null) { cities = cities.Where(p => p.PROV_CODE == provinces); } return(Json(cities.Select(p => new { CityID = p.CITY_ID, CityName = p.CITY_NAME }), JsonRequestBehavior.AllowGet)); }
public JsonResult GetCascadeTownships(int cities) { var db = new GccSytemEntities(); var townships = db.zimtownships.AsQueryable(); if (cities != null) { townships = townships.Where(t => t.cityid == cities); } return(Json(townships.Select(t => new { TownshipID = t.id, TownshipName = t.Name }), JsonRequestBehavior.AllowGet)); }