private void btnDeleteAllDepartmentsManagers_Click(object sender, RoutedEventArgs e) { ManageDatabaseService manager = new ManageDatabaseService(); manager.DeleteAllDepartmentManagers(); InitTablesInfo(); }
private void btnDeleteAllEmployeeTitles_Click(object sender, RoutedEventArgs e) { ManageDatabaseService manager = new ManageDatabaseService(); manager.DeleteAllEmployeeTitles(); InitTablesInfo(); }
private void InitTablesInfo() { ManageDatabaseService manager = new ManageDatabaseService(); var stats = manager.GetTablesStatistics(); if (stats == null) { return; } Dispatcher.BeginInvoke(new Action(() => { lbNumberDepartmentEmployees.Content = stats.DepartmentEmployees.ToString(); lbNumberDepartments.Content = stats.Departments.ToString(); lbNumberDepartmentsManagers.Content = stats.DepartmentManagers.ToString(); lbNumberEmployees.Content = stats.Employees.ToString(); lbNumberEmployeeTitles.Content = stats.EmployeeTitles; }), DispatcherPriority.Background); /* * lbNumberDepartmentEmployees.Content = stats.DepartmentEmployees.ToString(); * lbNumberDepartments.Content = stats.Departments.ToString(); * lbNumberDepartmentsManagers.Content = stats.DepartmentManagers.ToString(); * lbNumberEmployees.Content = stats.Employees.ToString(); * lbNumberEmployeeTitles.Content = stats.EmployeeTitles; */ }
private void DeleteRecords() { ManageDatabaseService manager = new ManageDatabaseService(); int employees = 0; int titles = 0; int departments = 0; int managers = 0; int depemployees = 0; int.TryParse(txtInsertEmployees.Text, out employees); int.TryParse(txtInsertEmployeeTitles.Text, out titles); int.TryParse(txtInsertDepartments.Text, out departments); int.TryParse(txtInsertDepartmentManagers.Text, out managers); int.TryParse(txtInsertDepartmentEmployees.Text, out depemployees); if (employees > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { manager.DeleteRangeEmployees(employees); InitTablesInfo(); }, null); } if (titles > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { manager.DeleteRangeEmployeeTitles(titles); InitTablesInfo(); }, null); } if (departments > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { manager.DeleteRangeDepartments(departments); InitTablesInfo(); }, null); } if (managers > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { manager.DeleteRangeDepartmentManagers(managers); InitTablesInfo(); }, null); } if (depemployees > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { manager.DeleteRangeDepartmentEmployee(depemployees); InitTablesInfo(); }, null); } }