public void EditItem()
{
Employee tmpEmp = (Employee)EmployeeComboBox.SelectedValue;
Department tmpDep = (Department)DepartamentComboBox.SelectedValue;
if (tmpEmp != null && tmpDep != null)
{
var result = from f
in parent.workersList
where f.Employee.UUID == tmpEmp.UUID
select f;
foreach (Worker a in result)
{
a.Department = tmpDep;
}
SQLer.UpdateWorkers(itemId, tmpEmp.UUID, tmpDep.UUID);
parent.ResetWorkersList();
parent.ListViewTotal.Items.Refresh();
}
else
{
MessageBox.Show("Employee or departament can't be null!", "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
this.Close();
}
private void RemoveEmployee_Click(object sender, RoutedEventArgs e)
{
Worker item = (Worker)ListViewTotal.SelectedItem;
if (item != null)
{
SQLer.RemoveWorkers(item.Id);
}
else
{
MessageBox.Show("Please, select item.", "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
ResetWorkersList();
}
public void AddItem()
{
Employee tmpEmp = (Employee)EmployeeComboBox.SelectedValue;
Department tmpDep = (Department)DepartamentComboBox.SelectedValue;
if (tmpEmp != null && tmpDep != null)
{
SQLer.InserntWorkers(tmpEmp.UUID, tmpDep.UUID);
parent.ResetWorkersList();
parent.ListViewTotal.Items.Refresh();
}
else
{
MessageBox.Show("Employee or departament can't be null!", "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
this.Close();
}
private void GetFromBase_Click(object sender, RoutedEventArgs e)
{
if (employeeList.Count > 0)
{
employeeList.Clear();
}
if (departmentList.Count > 0)
{
departmentList.Clear();
}
if (workersList.Count > 0)
{
workersList.Clear();
}
SQLer.ExecuteEmployee(employeeList);
SQLer.ExecuteDepartament(departmentList);
SQLer.ExecuteWorkers(workersList, departmentList, employeeList);
}
public void ResetWorkersList()
{
workersList.Clear();
SQLer.ExecuteWorkers(workersList, departmentList, employeeList);
}
