public void TestPKRename()
{
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true");
DbStructure structure = new DbStructure();
structure.FillStructure(conn);
Table t = structure.Tables.FirstOrDefault(x => x.Name == "Door");
t.RenameColumnPK("Door_ID", conn);
}
private void buttonChangedColumn_Click(object sender, RoutedEventArgs e)
{
int index_table = ListTables.SelectedIndex;
int index_column = ListColums.SelectedIndex;
structure.Tables[index_table].RenameColumn(structure.Tables[index_table].Columns[index_column],
textBoxChangedColumn.Text, structure.Connection);
ListTables.UnselectAll();
ListColums.UnselectAll();
ListTables.Items.Clear();
ListColums.Items.Clear();
structure.FillStructure(structure.Connection);
for (int i = 0; i < structure.Tables.Count; i++)
{
ListTables.Items.Add(structure.Tables[i].Name);
}
ListTables.SelectedIndex = index_table;
ListColums.SelectedIndex = index_column;
}
public void TestStructureInitialization()
{
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true");
DbStructure structure = new DbStructure();
structure.FillStructure(conn);
Console.WriteLine(structure.DataBaseName + "\n");
foreach (var tab in structure.Tables)
{
Console.WriteLine(tab.Name);
}
}
private void MenuItem_Click_6(object sender, RoutedEventArgs e)
{
Structure.FillStructure(Connector.GetConnection(Connector.Name, Connector.Password, Connector.Db_name));
generalFrame.Navigate(tableUserControl);
tableUserControl.Update(Structure);
}
