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