private void TablesComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (TablesComboBox.SelectedValue != null)
{
string nameTable = TablesComboBox.SelectedValue.ToString();
TitlesListBox.ItemsSource = DataBaseSupport.GetTitles(nameTable);
TitlesListBox.SelectedIndex = 0;
}
}
private void DelTableButton_Click(object sender, RoutedEventArgs e)
{
string str = TablesComboBox.Text.ToString();
DataBaseSupport.DeleteTable(str);
TablesComboBox.ItemsSource = DataBaseSupport.GetTables();
if (TablesComboBox.SelectedValue != null)
{
TitlesListBox.ItemsSource = DataBaseSupport.GetTitles(TablesComboBox.SelectedValue.ToString());
}
}
private void Window_Activated(object sender, EventArgs e)
{
TablesComboBox.ItemsSource = DataBaseSupport.GetTables();
if (TablesComboBox.SelectedValue != null)
{
string nameTable = TablesComboBox.SelectedValue.ToString();
if (nameTable.Length > 0)
{
TitlesListBox.ItemsSource = DataBaseSupport.GetTitles(nameTable);
}
}
}
private void DelTitleButton_Click(object sender, RoutedEventArgs e)
{
string query = String.Format("DELETE FROM {0} WHERE NAME='{1}';",
TablesComboBox.SelectedValue.ToString(),
TitlesListBox.SelectedItem.ToString());
DataBaseSupport.SendQuery(query);
if (TablesComboBox.SelectedValue != null)
{
TitlesListBox.ItemsSource = DataBaseSupport.GetTitles(TablesComboBox.SelectedValue.ToString());
}
}
private void PrimenitButton_Click(object sender, RoutedEventArgs e)
{
string query = String.Format("UPDATE {0} SET TitleText='{1}' WHERE NAME='{2}';",
TablesComboBox.SelectedValue.ToString(),
TextTitle.Text,
TitlesListBox.SelectedItem.ToString());
DataBaseSupport.SendQuery(query);
if (TablesComboBox.SelectedValue != null)
{
TitlesListBox.ItemsSource = DataBaseSupport.GetTitles(TablesComboBox.SelectedValue.ToString());
}
}