public void Update()
{
_departmentsTable = _bd.departmentsSelectAll();
_employeesTable = _bd.employeesSelectAll();
LoadEmployees();
LoadDepartments();
}
private void Button3_Click(object sender, EventArgs e)
{
try
{
DataTable emps;
if (comboBox1.SelectedItem.ToString() == "Все департаменты")
{
emps = _dbM.employeesSelectAll();
}
else
{
string search = comboBox1.SelectedItem.ToString().Trim('_', ' ').Split(',')[1];
emps = _dbM.employeesSelect(search);
}
state = StateOfDataGrid.Employees;
dataGridView1.DataSource = emps;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Company()
{
try
{
_bd = new DatabaseManipulations();
_departmentsTable = _bd.departmentsSelectAll();
_employeesTable = _bd.employeesSelectAll();
LoadEmployees();
LoadDepartments();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}