private void AllData_Click(object sender, RoutedEventArgs e) //Все записи { dgClients.ItemsSource = null; db = new SchoolLanguageEntities(); var clients = db.Database.SqlQuery <Client>("SELECT * FROM Client"); dgClients.ItemsSource = clients.ToList(); tbNumber.Text = "100 из 100"; }
private void FirstTwoH_Click(object sender, RoutedEventArgs e) //Первые 200 записей { dgClients.ItemsSource = null; db = new SchoolLanguageEntities(); var clients = db.Database.SqlQuery <Client>("SELECT * FROM Client WHERE ID <=200"); dgClients.ItemsSource = clients.ToList(); tbNumber.Text = "200 из 100"; }
public MainWindow() { InitializeComponent(); db = new SchoolLanguageEntities(); db.Client.Load(); dgClients.ItemsSource = db.Client.Local.ToBindingList(); this.Closing += MainWindow_Closing; //Вызов метода для очистки кэша при закрытии приложения }
private void RadioButtonA_Checked(object sender, RoutedEventArgs e) //Сортировка все { dgClients.ItemsSource = null; db = new SchoolLanguageEntities(); var clients = db.Database.SqlQuery <Client>("SELECT * FROM Client"); dgClients.ItemsSource = clients.ToList(); tbNumber.Text = "100 из 100"; }
private void RadioButtonF_Checked(object sender, RoutedEventArgs e) //Сортировка женский пол { RadioButton pressed = (RadioButton)sender; dgClients.ItemsSource = null; db = new SchoolLanguageEntities(); var clients = db.Database.SqlQuery <Client>("SELECT * FROM Client WHERE GenderCode = 'ж'"); dgClients.ItemsSource = clients.ToList(); tbNumber.Text = "45 из 100"; }
private void TextBoxEmail_TextChanged(object sender, TextChangedEventArgs e) { TextBox textBox = (TextBox)sender; dgClients.ItemsSource = null; db = new SchoolLanguageEntities(); var clients = db.Database.SqlQuery <Client>("SELECT * FROM Client WHERE Email LIKE '%" + textBox.Text + "%'"); dgClients.ItemsSource = clients.ToList(); tbNumber.Text = "100 из 100"; }