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";
}
