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