private void button2_Click(object sender, EventArgs e) { if (cbDatabaza.SelectedItem.ToString() == "MSSQL") { string text1 = ""; string text2 = ""; text1 = "server=" + db1Server.Text + ";database=" + db1Name.Text + ";uid=" + db1Username.Text + ";pwd=" + db1Pass.Text + ";MultipleActiveResultSets=True;"; text2 = "server=" + db2Server.Text + ";database=" + db2Name.Text + ";uid=" + db2Username.Text + ";pwd=" + db2Pass.Text + ";MultipleActiveResultSets=True;"; ConnectionMSSQL con1 = new ConnectionMSSQL(text1); ConnectionMSSQL con2 = new ConnectionMSSQL(text2); if (com.createConnections(con1, con2)) { MessageBox.Show("Connection succesfull"); DBsyncTreeview strom = com.vyrobStromA(); main.aktualizujIkonky(strom); main.getTvDb1().Nodes.Add(strom); DBsyncTreeview strom2 = com.vyrobStromB(); main.aktualizujIkonky(strom2); main.getTvDb2().Nodes.Add(strom2); this.Close(); } else { MessageBox.Show("Connection was not succesfull"); } } }
public void aktualizujIkonky(DBsyncTreeview tv) { if (tv.Nodes != null && tv.Nodes.Count > 0) { foreach (DBsyncTreeview dbtv in tv.Nodes) { //dbtv.ImageIndex = 1; dbtv.ImageIndex = dbtv.getTypIkony(); dbtv.SelectedImageIndex = dbtv.getTypIkony(); if (dbtv.Azvyraznene) dbtv.BackColor = Color.Red; aktualizujIkonky(dbtv); } } }
private void Akt_vypis2(object sender, EventArgs e) { tvDb1.Nodes.Clear(); tvDb2.Nodes.Clear(); //comp.refreshConnections(); DBsyncTreeview strom = comp.vyrobStromA(); aktualizujIkonky(strom); getTvDb1().Nodes.Add(strom); DBsyncTreeview strom2 = comp.vyrobStromB(); aktualizujIkonky(strom2); getTvDb2().Nodes.Add(strom2); }
public void aktualizujIkonky(DBsyncTreeview tv) { if (tv.Nodes != null && tv.Nodes.Count > 0) { foreach (DBsyncTreeview dbtv in tv.Nodes) { //dbtv.ImageIndex = 1; dbtv.ImageIndex = dbtv.getTypIkony(); dbtv.SelectedImageIndex = dbtv.getTypIkony(); if (dbtv.Azvyraznene) { dbtv.BackColor = Color.Red; } aktualizujIkonky(dbtv); } } }
private void button4_Click(object sender, EventArgs e) { comp.DatabaseDifferences = new DbSyncDataBaseDiff(comp.db1, comp.db2); comp.fullfillLists(); Console.WriteLine(); tvDb1.Nodes.Clear(); tvDb2.Nodes.Clear(); DBsyncTreeview strom = comp.vyrobStromA(); aktualizujIkonky(strom); tvDb1.Nodes.Add(strom); DBsyncTreeview strom2 = comp.vyrobStromB(); aktualizujIkonky(strom2); tvDb2.Nodes.Add(strom2); }
private void buttonSQLTextClick(object sender, EventArgs e) { FrmSQLCode2 ff; DBsyncTreeview n1 = (DBsyncTreeview)tvDb1.SelectedNode; DBsyncTreeview n2 = (DBsyncTreeview)tvDb2.SelectedNode; if (n1 != null && n2 != null) { ff = new FrmSQLCode2(n1.SqlTextList.getText(), n2.SqlTextList.getText()); } else if (n1 != null) { ff = new FrmSQLCode2(n1.SqlTextList.getText(), null); } else { ff = new FrmSQLCode2(null, n2.SqlTextList.getText()); } ff.Show(); }
private void tvDb2_AfterSelect(object sender, TreeViewEventArgs e) { if (canRunAfterselect) { canRunAfterselect = false; DBsyncTreeview n = (DBsyncTreeview)e.Node; if (sender != null) { otvorRovnakyNodeVstrome(e.Node, tvDb1, false); } lvExDb2.Items.Clear(); if (n.ObjectAtributesList != null) { foreach (ObjectAtribute o in n.ObjectAtributesList) { ListViewItem lv = new ListViewItem(o.NameOfAtribute); lv.SubItems.Add(o.AtributeValue); if (o.IsHighlited) { lv.BackColor = Color.Red; } lvExDb2.Items.Add(lv); if (o.IsSql) { Button b = new Button(); b.Text = "..."; b.BackColor = SystemColors.Control; b.Font = new System.Drawing.Font(this.Font.FontFamily, 6); b.Height = 5; b.Width = 20; b.Click += new EventHandler(buttonSQLTextClick); lvExDb2.AddEmbeddedControl(b, 1, 1, DockStyle.Right); } } } canRunAfterselect = true; } }