public MainWindow()
{
InitializeComponent();
var connectionString =
ConfigurationManager.ConnectionStrings["DBEmployeesConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(
"SELECT Last name, First name, Patronymic, Department FROM DBEmplouees", connection);
adapter.SelectCommand = command;
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
EmployeesDataGrid.DataContext = dataTable.DefaultView;
EmpCommands data = EmpCommands.getInstance();
DataContext = data;
AdjEmp.Click += (s, e) => OpenWindow <WAdjustment>();
AdjDep.Click += (s, e) => OpenWindow <WAdjustmentDep>();
Delete.Click += delegate { data.Clear(); };
Exit.Click += (s, e) => Application.Current.Shutdown();
}
public WAdjustment()
{
InitializeComponent();
DataContext = EmpCommands.getInstance();
listDepartments.ItemsSource = DepCommands.getInstance().Departments;
}
