static public void StoreSensor(Sensor sensor, Device device) { using (var context = new SensorDataContext()) { var _sensorEntity = new SensorEntity(); _sensorEntity.DeviceName = device.Name; _sensorEntity.LastSyncTime = DateTime.Now; _sensorEntity.Value = sensor.State; _sensorEntity.ModuleName = sensor.Name; context.SensorData.Add(_sensorEntity); context.SaveChanges(); } }
static public List <Tuple <DateTime, long> > GetSensorLog(Sensor sensor, Device device, DateTime start, DateTime finish) { var ret = new List <Tuple <DateTime, long> >(); using (var context = new SensorDataContext()) { var _res = context.SensorData.Where(d => (d.DeviceName == device.Name && d.ModuleName == sensor.Name && d.LastSyncTime > start && d.LastSyncTime < finish)).ToList <SensorEntity>(); foreach (var entry in _res) { var bufEntry = new Tuple <DateTime, long>(entry.LastSyncTime, entry.Value); ret.Add(bufEntry); } ret.Sort(); } return(ret); }