private void Button_Add_Click(object sender, RoutedEventArgs e)
{
var results = from table1 in db1.employee.AsEnumerable()
// join table2 in db1.employee_type.AsEnumerable() on (int)table1.employee_type_id equals (int)table2.Id_Employee_Type
// join table3 in db1.Postal_Code_Worker.AsEnumerable() on (int)table1.postal_code_id equals (int)table3.Id_Postal_Code_Worker
select new
{
Employee_Id = (int)table1.Id_Employee,
Id_Number = (string)table1.id_number,
Name = (string)table1.name,
Phone = (string)table1.phone,
// Gender = (string)table1.gender,
Deleted = (string)table1.deleted,
/* employee_type_id = (int)table2.Id_Employee_Type,
* type = (string)table2.type,
* salary = (string)table2.salary,
* postal_code_id = (int)table3.Id_Postal_Code_Worker,
* city = (string)table3.city,
* street = (string)table3.street,
* house_number = (string)table3.house_number*/
};
employeeDataGrid.ItemsSource = results.ToList();
AddWorker aw = new WpfApplication8.AddWorker(employeeDataGrid, db1);
aw.ShowDialog();
employeeDataGrid.ItemsSource = results.ToList();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
AddWorker aw = new WpfApplication8.AddWorker(employeeDataGrid, db1);
aw.ShowDialog();
}
private void Button_Add_Worker(object sender, RoutedEventArgs e)
{
AddWorker aw = new WpfApplication8.AddWorker();
aw.ShowDialog();
}
