public base_risk GetRiskSite(DbGeometry inLocation)
{
base_risk br = null;
using (DataMapsEntities me = new DataMapsEntities())
{
br = me.base_risk.Where(f => f.geom.Contains(inLocation)).FirstOrDefault() as base_risk;
}
return(br);
}
public void loadRiskFiles(string inFileName)
{
List <base_risk> myRiskSites = new List <base_risk>();
IFeatureSet fs = FeatureSet.Open(inFileName);
DataTable dt = fs.DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
base_risk risk = new base_risk();
IFeature f = fs.Features[i];
risk.geom = DbGeometry.FromText(f.BasicGeometry.ToString());
risk.RISK = GetNullableDouble(dt.Rows[i], "RISK");
// risk.LABEL = dt.Rows[i]["LABEL"];
myRiskSites.Add(risk);
}
using (me = new MapEntites())
{
me.Database.ExecuteSqlCommand("Truncate Table [base_risk]");
me.base_risk.AddRange(myRiskSites);
me.SaveChanges();
}
}
