private void RefreshList()
{
MySqlConnection connection = new MySqlConnection(connectionString);
//Думаю, что не очень хорошо, когда в списке пользователей виден пароль!!! /* employees.Password, */
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);
productsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
productsGrid.SelectedIndex = 0;
//Код алёши еблоши
List <int> ids = new List <int>();
foreach (DataRowView row in productsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonOpenList.Style = (Style)ButtonOpenList.FindResource("NoActive");
}
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
List <int> ids = new List <int>();
foreach (DataRowView row in productsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonOpenList.Style = (Style)ButtonOpenList.FindResource("NoActive");
}
}
private void DataGridCell_GotFocus(object sender, RoutedEventArgs e)
{
ButtonDelete.Style = (Style)ButtonDelete.FindResource("Active");
ButtonEdit.Style = (Style)ButtonEdit.FindResource("Active");
ButtonOpenList.Style = (Style)ButtonOpenList.FindResource("Active");
}