//######################## private void iterateOverProfiles(bool singleFire) { toolStripButton1.Enabled = false; richTextBox1.Enabled = false; MainView.Controls.Clear(); sqlProgress.Visible = true; listViewExports = new List <ListView>(); listLabelExports = new List <string>(); sqlProgress.Maximum = databasesListView.Items.Count; runningMaxEvents = 0; runningCurrentEvents = 0; for (int i = 0; i < databasesListView.Items.Count; i++) { if (databasesListView.Items[i].Checked) { currentProfileName = databasesListView.Items[i].Text; profil.changeProfil(databasesListView.Items[i].Text); toolStrip1.Refresh(); statusLabel.Text = "Running SQL @ " + currentProfileName + " " + i + " / " + (databasesListView.Items.Count - 1); //fireSql(profil, richTextBox1.Text); if (runAsync.Checked) { fireAsyncQuery(profil, richTextBox1.Text, singleFire); } else { sqlProgress.Value = i + 1; Application.DoEvents(); fireSql(profil, richTextBox1.Text); } } } statusLabel.Text = "Idle"; if (!runAsync.Checked) { sqlProgress.Visible = false; toolStripButton1.Enabled = true; richTextBox1.Enabled = true; } /* * if (lvExporter != null) * { * lvExporter.GenerateDynamicExcelSheet(); * lvExporter = null; * } */ }
private void selectExistsTables() { Profil dbProf = new Profil(); ColorCalc cCalc = new ColorCalc(); string groupId = groupName.Text; if (this.currentGroups.Contains(groupId)) { groupName.ForeColor = Color.DarkGreen; groupName.BackColor = Color.LightSeaGreen; List <string> members = Config.getListWidthDefault(PConfig.KEY_GROUPS_MEMBERS + "." + groupId, new List <string>()); for (int i = 0; i < this.GroupedDatabases.Items.Count; i++) { this.GroupedDatabases.Items[i].Checked = (members.Contains(this.GroupedDatabases.Items[i].Text)); dbProf.changeProfil(this.GroupedDatabases.Items[i].Text); if (dbProf.getProperty("set_bgcolor") != null && dbProf.getProperty("set_bgcolor").Length > 2) { Color rowCol = Color.FromArgb(int.Parse(dbProf.getProperty("set_bgcolor"))); cCalc.setBaseColor(rowCol); this.GroupedDatabases.Items[i].BackColor = cCalc.LightenBy(50); this.GroupedDatabases.Items[i].ForeColor = cCalc.DarkenBy(50); } } manipulateBtn.Image = Projector.Properties.Resources.delete_16; GroupedDatabases.Enabled = true; } else { groupName.ForeColor = Color.DarkRed; groupName.BackColor = Color.LightYellow; manipulateBtn.Image = Projector.Properties.Resources.add16; for (int i = 0; i < this.GroupedDatabases.Items.Count; i++) { this.GroupedDatabases.Items[i].Checked = false; } GroupedDatabases.Enabled = false; } }