private void Client_MqttMsgPublishReceived(object sender, MqttMsgPublishEventArgs e) { string json = Encoding.UTF8.GetString(e.Message); Console.WriteLine(json); SensorMeasurement sensorMeasurement = JsonConvert.DeserializeObject <SensorMeasurement>(json); //Write to DB. database.Insert(sensorMeasurement); }
public void Insert(SensorMeasurement sensorMeasurement) { sqlConnection.Open(); SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.CommandText = "INSERT INTO Measurement (IDSensor, Datetime, Value) VALUES (@IDSensor, @Datetime, @Value)"; sqlCommand.Parameters.Add("@IDSensor", System.Data.SqlDbType.Int).Value = sensorMeasurement.IDSensor; sqlCommand.Parameters.Add("@Datetime", System.Data.SqlDbType.DateTime2).Value = sensorMeasurement.Datetime; sqlCommand.Parameters.Add("@Value", System.Data.SqlDbType.Float).Value = sensorMeasurement.Value; sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }