private void RefreshList()
{
MySqlConnection connection = new MySqlConnection(connectionString);
string query_text = getQueryText();
connection.Open();
DataTable dataTable = new DataTable();
MySqlCommand command = new MySqlCommand(query_text, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataTable);
costsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
costsGrid.SelectedIndex = 0;
List <int> ids = new List <int>();
foreach (DataRowView row in costsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
ButtonOpenDocument.Style = (Style)ButtonOpenDocument.FindResource("NoActive");
}
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
List <int> ids = new List <int>();
foreach (DataRowView row in costsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
ButtonOpenDocument.Style = (Style)ButtonOpenDocument.FindResource("NoActive");
}
}
private void DataGridCell_GotFocus(object sender, RoutedEventArgs e)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("Active");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("Active");
ButtonOpenDocument.Style = (Style)ButtonOpenDocument.FindResource("Active");
}
