private Dictionary <Sensor, ISensor> ReadSensors(SensorsContext db)
{
var sensors = new Dictionary <Sensor, ISensor>();
var deviceSensors = SensorsManager.Sensors.ToList();
Sensor dbSensor = null;
foreach (var sensor in deviceSensors)
{
dbSensor = db.Sensors.FirstOrDefault(sens =>
sens.SensorId == sensor.SensorId);
if (dbSensor == null)
{
//TODO: improve error management
Console.WriteLine("Error while reading sensor: sensor not found " + sensor.SensorId);
continue;
}
if (dbSensor.Name != sensor.Name || dbSensor.Unit != sensor.Unit)
{
dbSensor.Name = sensor.Name;
dbSensor.Unit = sensor.Unit;
db.SaveChanges();
}
sensors.Add(dbSensor, sensor);
}
return(sensors);
}
private void Measurement(SensorsContext db, Dictionary <Sensor, ISensor> sensors)
{
var dateTime = DateTime.Now;
foreach (var sensor in sensors.Keys)
{
var value = sensors[sensor].Value;
if (double.IsNormal(value))
{
sensor.Measures.Add(new Measure
{
Value = value,
DateTime = dateTime
});
}
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Error while saving new values: " + ex.Message);
Console.WriteLine("Values saved: ");
foreach (var sensor in sensors.Keys)
{
var value = sensors[sensor].Value;
if (double.IsNormal(value))
{
Console.WriteLine("\t--Value: " + value + " / DateTime: " + dateTime);
}
}
}
}
public static int GetNewSensorId(string sensorName)
{
Device device;
var db = new SensorsContext();
string deviceName = Environment.MachineName;
if (!db.Devices.Any(dev => dev.Name == deviceName))
{
device = new Device
{
Name = deviceName
};
db.Devices.Add(device);
db.SaveChanges();
}
else
{
device = db.Devices.FirstOrDefault(dev => dev.Name == deviceName);
}
var dbSensor = new Sensor
{
Name = sensorName
};
device.Sensors.Add(dbSensor);
db.SaveChanges();
return(dbSensor.SensorId);
}
private void PeriodicMesureTask(int intervalInMS, CancellationToken cancellationToken)
{
Task.Run(async() =>
{
while (!cancellationToken.IsCancellationRequested)
{
try
{
using var db = new SensorsContext();
var sensors = ReadSensors(db);
Measurement(db, sensors);
}
catch (Exception ex)
{
Console.WriteLine("DB exception: " + ex);
}
await Task.Delay(intervalInMS, cancellationToken);
}
});
}