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