/// <summary>
/// Mapeia o datareader para um objeto CisternConfig
/// </summary>
public static CisternConfig MapCisternConfig(MySqlDataReader dataReader)
{
CisternConfig config = new CisternConfig(
dataReader.GetInt32("config_id"),
dataReader.GetInt32("time_of_rain"),
dataReader.GetInt32("min_water_level"),
dataReader.GetInt32("min_level_action")
);
return(config);
}
/// <summary>
/// Atualiza as configurações da cisterna
/// </summary>
public static int UpdateCisternConfig(string connectionString, CisternConfig config)
{
using (var conn = new MySqlConnection(connectionString))
using (var cmd = conn.CreateCommand())
{
try
{
conn.Open();
cmd.CommandText = "UPDATE cistern_config SET time_of_rain = " + config.TimeOfRain +
", min_water_level = " + config.MinWaterLevel +
", min_level_action = " + config.MinLevelAction +
" WHERE config_id='" + config.ConfigId + "'";
return(cmd.ExecuteNonQuery());
}
catch (MySqlException e)
{
throw e;
}
}
}
/// <summary>
/// Adiciona uma nova configuração da cisterna ao banco de dados
/// </summary>
public static int InsertCisternConfig(string connectionString, CisternConfig config)
{
using (var conn = new MySqlConnection(connectionString))
using (var cmd = conn.CreateCommand())
{
try
{
conn.Open();
cmd.CommandText = "INSERT INTO cistern_config (time_of_rain, min_water_level, min_level_action) values(" +
config.TimeOfRain +
"," + config.MinWaterLevel +
"," + config.MinLevelAction + ")";
return(cmd.ExecuteNonQuery());
}
catch (MySqlException e)
{
throw e;
}
}
}