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;
}
}
