private void Form1_Load(object sender, EventArgs e) { this.BackColor = System.Drawing.Color.FromArgb(245, 246, 247); this.GetMainWindowsPos(); try { if (RedmineReportsConfigDataHelper.ConnectionStringEncrypted(connString)) { _dataAccess = new RedmineMySqlDataAccess(); } else { if (RedmineReportsConfigDataHelper.ConnectionStringIsPlain(connString)) { _dataAccess = new RedmineMySqlDataAccess(null, RedmineReportsConfigDataHelper.ConnectionStringIsPlain(connString)); } else { //open config form for sql data ConfigureMySqlDataBaseConnection(); } } _lL = new ListLabel(); // Add your License Key _lL.LicensingInfo = "Insert license key here"; // fill project listbox if (_dataAccess != null) { lstbProjects.DataSource = _dataAccess.GetRedmineProjects(Convert.ToBoolean(ConfigurationManager.AppSettings["UseAllProjects"])); } lstbProjects.DisplayMember = "display_name"; lstbProjects.ValueMember = "id"; // check or uncheck checkbox for subprojects cbAllProjects.Checked = Convert.ToBoolean(ConfigurationManager.AppSettings["UseAllProjects"]); DesignerFunction fct = new DesignerFunction(); fct.FunctionName = "GetStatusNameFromId"; fct.GroupName = "RedmineFunctions"; fct.ResultType = LlParamType.String; fct.MinimalParameters = 1; fct.MaximumParameters = 1; fct.Parameter1.Type = LlParamType.Double; fct.EvaluateFunction += new EvaluateFunctionHandler(fct_EvaluateFunction); _lL.DesignerFunctions.Add(fct); lstbTrackers.Enabled = !AllLstBoxItemsSelected(lstbTrackers); chkBox_All_Trackers.Checked = AllLstBoxItemsSelected(lstbTrackers); } catch (NullReferenceException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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; }