public bool AddSensorMeasurement(Guid deviceId, double?pm25, double?pm10, double?temperature, double?humidity, double?pressure, double?heaterTemperature, double?heaterHumidity, double?rssi, double?cellVoltage) { _logger.LogInformation($"In Add sensor measurement for device id: {deviceId}"); try { var measurement = new Measurements() { DeviceId = deviceId, Pm25 = pm25, Pm10 = pm10, HeaterHumidity = heaterHumidity, HeaterTemperature = heaterTemperature, Humidity = humidity, InsertDateTime = DateTimeOffset.Now, Pressure = pressure, Temperature = temperature, CellVoltage = cellVoltage, WifiRssi = rssi }; //_jsonUpdatesRepository.SaveUpdate(deviceId, measurement); _context.Measurements.Add(measurement); return(_context.SaveChanges() >= 1); } catch (Exception ex) { _logger.LogError(ex, "Error when saving measurement data!"); return(false); } }
public bool SaveUpdate <T>(Guid deviceId, T data) { _logger.LogInformation("Save JSON DATA"); try { var jsonData = JsonConvert.SerializeObject(data, Formatting.None, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); _context.JsonUpdates.Add(new Database.Models.JsonUpdates() { DeviceId = deviceId, InsertDateTime = DateTimeOffset.Now, JsonValue = jsonData }); return(_context.SaveChanges() > 0); } catch (Exception ex) { _logger.LogError(ex, "Error when Save JSON DATA"); return(false); } }