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