public PresenceDto GetSensorPresence(int sensorId)
{
using (var context = new ClientSensorLocationEntities())
{
return(context.SensorPresences.Find(sensorId).Convert());
}
}
public RoomDto GetRoom(int roomId)
{
using (var context = new ClientSensorLocationEntities())
{
return(context.Rooms.Find(roomId).Convert());
}
}
public IEnumerable <SensorDto> GetAllRegisteredSensors()
{
using (var context = new ClientSensorLocationEntities())
{
foreach (var sensor in context.Sensors)
{
yield return(sensor.Convert());
}
}
}
public IEnumerable <RoomDto> GetRooms()
{
var result = new List <RoomDto>();
using (var context = new ClientSensorLocationEntities())
{
foreach (var room in context.Rooms)
{
result.Add(room.Convert());
}
}
return(result);
}
public void CreateSensorPresence(SensorPresence presence, Sensor sensor)
{
using (var context = new ClientSensorLocationEntities())
{
//Check if sensor doesn't exist
if (context.Sensors.Find(sensor.sensorId) == null)
{
context.Sensors.Add(sensor);
}
// Check if sensor is present elsewhere
if (context.SensorPresences.Find(sensor.sensorId) != null)
{
context.SensorPresences.Remove(context.SensorPresences.Find(sensor.sensorId));
}
context.SensorPresences.Add(presence);
context.SaveChanges();
}
}
