public TrailSection(dynamic trail, string wkid)
{
Id = trail.attributes.FEATUREID;
ShortDescription = trail.attributes.TRLNAME;
Geography = DbGeography.FromText(GeoJSONTools.CreateWktFromJson(trail), Convert.ToInt32(wkid));
Status = trail.attributes.TRLSTATUS;
}
public ActionResult ManuallyAddJsonToDb(string trailNameInDb, string[] trailFeatureNames)
{
try
{
var Trail = db.Trails.Where(x => x.TrailName == trailNameInDb.Trim()).First();
foreach (var trailFeatureName in trailFeatureNames)
{
var newTrailFeatures = GeoJSONTools.GetTrailFromGeoJson(trailFeatureName.ToUpper(), out string wkid);
foreach (var feature in newTrailFeatures)
{
var ts = new TrailSection(feature, wkid);
Trail.TrailSections.Add(ts);
if (Trail.TrailSections.Count < 1)
{
Trail.Status = ts.Status;
}
}
}
db.SaveChanges();
return(Json(new { status = "ok" }));
}
catch (Exception e)
{
return(Json(new { status = "error", messages = new[] { e.Message } }));
}
}
public ActionResult ImportJSONtrail()
{
GeoJSONTools geoTools = new GeoJSONTools();
geoTools.ImportGeoJsonDataToDB();
return(new EmptyResult());
}
