private void btn_CheckConnection_Click(object sender, EventArgs e)
{
try
{
MysqlModel dbSettings = new MysqlModel();
dbSettings.Host = txt_ip.Text;
dbSettings.Port = Convert.ToUInt16(txt_port.Text);
dbSettings.User = txt_user.Text;
dbSettings.Password = txt_pass.Text;
dbSettings.Database = txt_authdb.Text;
using (Mysql databaseConnection = new Mysql(dbSettings))
{
if (databaseConnection.OpenConnection())
{
if (databaseConnection.IsValidDatabase())
MessageBox.Show("Database connection successful.", RBACManagerModel.GetApplicationTitle());
else
MessageBox.Show("Database connection successful but the selected database does not contain alle needed tables with the needed columns. \n\nUpdate the database or change the settings to connect to a valid database.", RBACManagerModel.GetApplicationTitle());
databaseConnection.CloseConnection();
}
else
MessageBox.Show("Can not connect to database.", RBACManagerModel.GetApplicationTitle());
}
}
catch(Exception)
{
MessageBox.Show("An error occured. Check your settings.", RBACManagerModel.GetApplicationTitle());
}
}
public SecurityLevelDBFunctions(Mysql mysqlConnection)
{
this.connection = mysqlConnection;
mysqlConnection.OpenConnection();
}
public RoleDBFunctions(Mysql mysqlConnection)
{
connection = mysqlConnection;
connection.OpenConnection();
}
public AccountDBFunctions(Mysql mysqlConnection)
{
this.connection = mysqlConnection;
connection.OpenConnection();
}