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(); } }