public Context.Room UpdateRoom(Context.Room room) { var entity = context.Room.FirstOrDefault(item => item.RoomId == room.RoomId); if (entity != null) { entity.Name = room.Name; context.Room.Update(entity); context.SaveChanges(); } Context.Room newRoom = context.Room.FirstOrDefault(item => item.RoomId == room.RoomId); return(newRoom); }
public bool InitRoom(string deviceEUI) { Context.Measurement measurement = null; try { measurement = context.Measurement.AsEnumerable().Where(r => r.DeviceEui.Equals(deviceEUI)).Last(); } catch (InvalidOperationException e) { } if (measurement != null) { Context.Room roomForDevice = null; try { roomForDevice = context.Room.AsEnumerable().Where(r => r.DeviceEui.Equals(deviceEUI)).Last(); } catch (InvalidOperationException e) { } if (roomForDevice == null) { Context.Settings newSettings = new Context.Settings(); newSettings.TemperatureSetpoint = temperatureSetPoint; newSettings.PpmMax = ppmMax; newSettings.PpmMin = ppmMin; newSettings.LastUpdated = DateTime.UtcNow; context.Settings.Add(newSettings); context.SaveChanges(); Context.Room newRoom = new Context.Room(); newRoom.DeviceEui = deviceEUI; newRoom.Name = "New device"; newRoom.SettingsId = newSettings.SettingsId; context.Room.Add(newRoom); context.SaveChanges(); } return(true); } return(false); }
public Context.Settings GetSettings(string deviceEUI) { Context.Room roomWithId = context.Room.Where(m => m.DeviceEui.Equals(deviceEUI)).Single(); Context.Settings settings = context.Settings.Find(roomWithId.SettingsId); return(settings); }