void loadSiteSensor(vwSiteDegree site)
{
MapApplication.Web.DbContext db = new Web.DbContext();
string site_id = site.SITE_ID;
if (sensorsCollection != null)
sensorsCollection.Clear();
EntityQuery<vwSensorDegree> qry = from n in db.GetVwSensorDegreeQuery() where n.SITE_ID == site_id select n;
LoadOperation<vwSensorDegree> lo = db.Load<vwSensorDegree>(qry);
lo.Completed += (s, a) =>
{
if (lo.Error != null)
{
MessageBox.Show(lo.Error.Message);
return;
}
dictSensors.Clear();
sensorsCollection = new ObservableCollection<vwSensorDegree>(lo.Entities);
this.lstMenu.ItemTemplate = this.Resources["SITE_VIEW_TEMPLATE"] as DataTemplate;
this.lstMenu.ItemsSource = sensorsCollection;
foreach (vwSensorDegree sensorInfo in sensorsCollection)
{
ElementLayer lyr = this.map1.Layers["sensorLyr"] as ElementLayer;
Sensor sensor = new Sensor();
MapPoint mp = ConvertMapPointTo102100(new MapPoint((double)sensorInfo.X, (double)sensorInfo.Y));
sensor.DataContext = sensorInfo;
ElementLayer.SetEnvelope(sensor, new Envelope(mp, mp));
dictSensors.Add(sensorInfo.SENSOR_ID, sensor);
lyr.Children.Add(sensor);
}
};
}
void loadSiteSensor(vwSiteDegree site)
{
MapApplication.Web.DbContext db = new Web.DbContext();
string site_id = site.SITE_ID;
if (sensorsCollection != null)
sensorsCollection.Clear();
EntityQuery<vwSensorDegree> qry = from n in db.GetVwSensorDegreeQuery() where n.SITE_ID == site_id select n;
LoadOperation<vwSensorDegree> lo = db.Load<vwSensorDegree>(qry);
lo.Completed += (s, a) =>
{
if (lo.Error != null)
{
MessageBox.Show(lo.Error.Message);
return;
}
dictSensors.Clear();
sensorsCollection = new ObservableCollection<vwSensorDegree>(lo.Entities);
this.lstMenu.ItemTemplate = this.Resources["SITE_VIEW_TEMPLATE"] as DataTemplate;
this.lstMenu.ItemsSource = sensorsCollection;
foreach (vwSensorDegree sensorInfo in sensorsCollection)
{
ElementLayer lyr = this.map1.Layers["sensorLyr"] as ElementLayer;
Sensor sensor = new Sensor();
MapPoint mp = ConvertMapPointTo102100(new MapPoint((double)sensorInfo.X, (double)sensorInfo.Y));
sensor.DataContext = sensorInfo;
ElementLayer.SetEnvelope(sensor, new Envelope(mp, mp));
dictSensors.Add(sensorInfo.SENSOR_ID, sensor);
lyr.Children.Add(sensor);
}
};
EntityQuery<tblTC> qBA = from n in db.GetTblTCQuery() where n.SITE_ID == this.CURRENT_SITE_ID && n.DEVICE_TYPE == "BA" select n;
LoadOperation<tblTC> loBA = db.Load<tblTC>(qBA);
loBA.Completed += (s, a) =>
{
if (loBA.Error != null)
{
MessageBox.Show(lo.Error.Message);
return;
}
if (loBA.Entities.Count() == 0)
txtBA.Visibility = System.Windows.Visibility.Collapsed;
else
{
txtBA.Visibility = System.Windows.Visibility.Visible;
if (loBA.Entities.FirstOrDefault().ISCONNECTED == "N")
txtBA.Foreground = new SolidColorBrush(Colors.Gray);
else
txtBA.Foreground = new SolidColorBrush(Colors.Green);
}
};
}