public ConfiguracionDTO getConfiguracion()
{
ConfiguracionDTO config = new ConfiguracionDTO();
try {
connection.Open();
MySqlCommand myCommand = new MySqlCommand();
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
DataTable myData = new DataTable();
myCommand.Connection = connection;
myCommand.CommandText = "SELECT cantidadcorreos,ruta FROM configuracion";
myAdapter.SelectCommand = myCommand;
myAdapter.Fill(myData);
connection.Close();
if (myData.Rows.Count != 0) {
for (int i = 0; i <= myData.Rows.Count - 1; i++) {
config.CantidadCorreos = Int16.Parse(myData.Rows[i].ItemArray.GetValue(0).ToString());
config.Patch = myData.Rows[i].ItemArray.GetValue(1).ToString();
//config.Patch = config.Patch.Replace("\\\\", "\\");
//config.Patch = config.Patch.Remove(config.Patch.Length - 1);
}
}
}
catch (MySqlException ex) { }
return config;
}
public void modificarConfiguracion(ConfiguracionDTO config)
{
try
{
MySqlCommand myCommand = new MySqlCommand();
myCommand.Connection = connection;
myCommand.CommandText = "UPDATE tConfiguracion (val1,val2) VALUES (?cantcorreos,?rutaarchivos)";
//myCommand.CommandText = "INSERT INTO tCorreo (cuenta,asunto,detalle,leido,tipo,fecha,numserver) VALUES " +
// "(?cuenta,?asunto,?detalle,?leido,?tipo,?fecha,?numserver)";
//myCommand.Parameters.Add("?cuenta", MySqlDbType.VarChar).Value = correo.IdCuenta;
//myCommand.Parameters.Add("?asunto", MySqlDbType.VarChar).Value = correo.Asunto;
//myCommand.Parameters.Add("?detalle", MySqlDbType.VarChar).Value = correo.Detalle;
//myCommand.Parameters.Add("?leido", MySqlDbType.VarChar).Value = correo.Read;
//myCommand.Parameters.Add("?tipo", MySqlDbType.VarChar).Value = correo.TipoCorreo;
//myCommand.Parameters.Add("?fecha", MySqlDbType.VarChar).Value = correo.Fecha;
//myCommand.Parameters.Add("?numserver", MySqlDbType.VarChar).Value = correo.NumeroServidorCorreo;
myCommand.Parameters.Add("?cantcorreos", MySqlDbType.Int16).Value = config.CantidadCorreos;
myCommand.Parameters.Add("?rutaarchivos", MySqlDbType.VarChar).Value = config.Patch;
myCommand.ExecuteNonQuery();
}
catch (MySqlException ex) { }
}
/// <summary>
/// Modifica la configuración actual.
/// </summary>
/// <param name="config">Nueva Configuración</param>
public void cambiarConfiguracion(ConfiguracionDTO config)
{
factory.startConnection();
factory.getConfiguracion().modificarConfiguracion(config);
factory.closeConnection();
}
