private void CompleteBoxes()
{
ConfigurationManager.RefreshSection("combit.RedmineReports.Properties.Settings.RedmineConnectionString");
string convertString = ConfigurationManager.ConnectionStrings["combit.RedmineReports.Properties.Settings.RedmineConnectionString"].ConnectionString;
if (RedmineReportsConfigDataHelper.ConnectionStringEncrypted(convertString))
{
//decrypt connectionstring
convertString = RedmineReportsConfigDataHelper.DecryptData(convertString);
}
Match m = Regex.Match(convertString, "server=([^;]*);uid=([^;]*);pwd=([^;]*);database=([^;]*);port=([^;]*);");
ipAddressTextBox.Text = m.Groups[1].Value;
mySQLLogTextBox.Text = m.Groups[2].Value;
mySQLPasssTextBox.Text = m.Groups[3].Value;
dbNameTextBox.Text = m.Groups[4].Value;
mySqlPortTextBox.Text = m.Groups[5].Value;
}
public RedmineMySqlDataAccess(string ConnectionString)
{
// create connection
_connection = new MySqlConnection();
if (String.IsNullOrEmpty(ConnectionString))
{
string convertString = ConfigurationManager.ConnectionStrings["combit.RedmineReports.Properties.Settings.RedmineConnectionString"].ConnectionString;
//decrypt connectionstring
_connection.ConnectionString = RedmineReportsConfigDataHelper.DecryptData(convertString);
}
else
{
_connection.ConnectionString = ConnectionString;
}
try
{
_connection.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
}