private void buttonTestConnection_Click(object sender, EventArgs e)
{
string DatabaseEngine = this.database;
SolidoSettings _settings = new SolidoSettings();
ConfigFilePath configfilepath = new ConfigFilePath();
configfilepath.PathFileConfig = filepathconfig;
bool ok = false;
try
{
string databaseTypeXml;
appConfigurationDatabaseConnection _appConfigurationDB = _settings.GetConfigurationDatabaseConnection(configfilepath);
databaseTypeXml = _util.DecryptRijndael(_appConfigurationDB.DatabaseType, "");
if (databaseTypeXml == "sQLSource")
{
_connectionString = "Data Source=" + _util.DecryptRijndael(_appConfigurationDB.ServerName, "") +
";Initial Catalog=" + _util.DecryptRijndael(_appConfigurationDB.DatabaseName, "") +
";Persist Security Info=True" +
";User ID=" + _util.DecryptRijndael(_appConfigurationDB.User, "") +
";Password="******"") +
";Pooling=False" +
";Connect Timeout=" + _util.DecryptRijndael(_appConfigurationDB.ConnectionTimeout, "");
SqlConnection sqlconn = new SqlConnection(_connectionString);
sqlconn.Open();
sqlconn.Close();
sqlconn.Dispose();
ok = true;
}
else if (databaseTypeXml == "OracleSource")
{
_connectionString = "User ID=" + _util.DecryptRijndael(_appConfigurationDB.User, "") +
";Password="******"") +
";Data Source=" + _util.DecryptRijndael(_appConfigurationDB.ServerName, "");
OracleConnection Oraconn = new OracleConnection(_connectionString);
Oraconn.Open();
Oraconn.Close();
Oraconn.Dispose();
ok = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Error de Conexion: " + ex.Message.ToString(), "Validación de Conexión", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (ok)
{
textBoxCadenaSolido.Text = _connectionString;
MessageBox.Show("Conexion Exitosa!", "Validación de Conexión", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public appConfigurationDatabaseConnection GetConfigurationDatabaseConnection(ConfigFilePath configfilepath)
{
XmlDocument _xmlDocument = new XmlDocument();
_xmlDocument.Load(configfilepath.PathFileConfig);
appConfiguration _appConfiguration = (appConfiguration)Deserialize(_xmlDocument, typeof(appConfiguration));
return(_appConfiguration.Database.DatabaseConnection);
}
