/// <summary>
/// Saves given data item.
/// </summary>
/// <param name="growDataItem">Data item to be saved</param>
/// <returns>Saved data item.</returns>
public GrowDataItem Save(GrowDataItem growDataItem)
{
using (MySqlConnection conn = GetConnection())
{
try
{
conn.Open();
}
catch (Exception ex)
{
Console.WriteLine("Exception while opening mysql connection: " + ex.Message);
return(growDataItem);
}
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into grow_data_item(timestamp, " +
"soil_temperature, air_temperature, " +
"soil_humidity, air_humidity)" +
"values(@timestamp, @soilTemperature, @airTemperature, @soilHumidity, @airHumidity)";
cmd.Parameters.AddWithValue("timestamp", growDataItem.Timestamp);
cmd.Parameters.AddWithValue("soilTemperature", growDataItem.SoilTemperature);
cmd.Parameters.AddWithValue("airTemperature", growDataItem.AirTemperature);
cmd.Parameters.AddWithValue("soilHumidity", growDataItem.SoilHumidity);
cmd.Parameters.AddWithValue("airHumidity", growDataItem.AirHumidity);
cmd.ExecuteNonQuery();
}
return(growDataItem);
}
public void Post([FromBody] GrowDataItem dataItem)
{
_logger.LogInformation("Saving new data time for {timestamp}", dataItem.Timestamp);
try
{
GetDbContext().Save(dataItem);
} catch (Exception ex)
{
_logger.LogError("Unexpected exception when saving new data item: {exception}", ex.Message);
_logger.LogError("Stack trace: {stackTrace}", ex.StackTrace);
}
}
