private void ButtonFindSurname_Click(object sender, RoutedEventArgs e)
{
string surname = TextBoxSurname.Text;
dataEntities = new DavidovEntities();
ListEmployee.Clear();
List <Workers> employee = new List <Workers>();
var queryEmployee = from emp in dataEntities.Workers
where emp.Surname == surname
select emp;
foreach (var emp in queryEmployee)
{
ListEmployee.Add(emp);
}
if (ListEmployee.Count > 0)
{
DataGridCliesnt.ItemsSource = ListEmployee;
ButtonFindSurname.IsEnabled = true;
ButtonFindTitle.IsEnabled = false;
}
else
{
MessageBox.Show("Сотрудник с фамилией \n" + surname + "\n не найдан",
"Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public UserControlClients()
{
DavidovEntities dataEntities = new DavidovEntities();
InitializeComponent();
save.IsEnabled = false;
edit.IsEnabled = true;
Undo.IsEnabled = false;
serch.IsEnabled = true;
add.IsEnabled = true;
remove.IsEnabled = true;
}
private void ButtonFindTitle_Click(object sender, RoutedEventArgs e)
{
dataEntities = new DavidovEntities();
ListEmployee.Clear();
List <Title> titles = new List <Title>();
Title title = ComboBoxTitle.SelectedItem as Title;
var queryEmployee = from emp in dataEntities.Workers
where emp.TitleID == title.ID
select emp;
foreach (var emp in queryEmployee)
{
ListEmployee.Add(emp);
}
DataGridCliesnt.ItemsSource = ListEmployee;
}
