public void AddEntry(WeatherEntry entry)
{
var cmd = new SqlCommand(@"Insert Into WeatherEntries (Temperature, Humidity, Pressure, RainGauge, SoilMoisture, SoilTemperature, TimeStamp, WindDirection, WindSpeed) Values (@Temperature, @Humidity, @Pressure, @RainGauge, @SoilMoisture, @SoilTemperature, @TimeStamp, @WindDirection, @WindSpeed)", new SqlConnection(_connectionString));
cmd.Parameters.Add(new SqlParameter("@Temperature", entry.Temperature));
cmd.Parameters.Add(new SqlParameter("@Humidity", entry.Humidity));
cmd.Parameters.Add(new SqlParameter("@Pressure", entry.Pressure));
cmd.Parameters.Add(new SqlParameter("@RainGauge", entry.RainGauge));
cmd.Parameters.Add(new SqlParameter("@SoilMoisture", entry.SoilMoisture));
cmd.Parameters.Add(new SqlParameter("@SoilTemperature", entry.SoilTemperature));
cmd.Parameters.Add(new SqlParameter("@TimeStamp", entry.TimeStamp));
cmd.Parameters.Add(new SqlParameter("@WindDirection", entry.WindDirection));
cmd.Parameters.Add(new SqlParameter("@WindSpeed", entry.WindSpeed));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public void AddEntry(WeatherEntry entry)
{
var entries = JsonConvert.DeserializeObject<List<WeatherEntry>>(File.ReadAllText(_dataPath));
entries.Add(entry);
File.WriteAllText(_dataPath, JsonConvert.SerializeObject(entries));
}