public Form3(Employee empin = null)
{
_dbm = new DatabaseManipulations();
emp = empin;
InitializeComponent();
if (empin != null)
{
surnameBox.Text = empin.Surname;
firstnameBox.Text = empin.FirstName;
patronymicBox.Text = empin.Patronymic;
DataTable departs = _dbm.StructureOfCompany();
CurDep(departs, empin.DepartmentID);
dateOfBirthBox.Text = empin.DateOfBirth.ToString().Split(' ')[0];
positionBox.Text = empin.Position;
seriesPasBox.Text = empin.DocSeries;
numberOfPasport.Text = empin.DocNumber;
ageBox.Text = empin.Age.ToString();
addEmployeeButton.Enabled = false;
}
else
{
changeEmployeeButton.Enabled = false;
DataTable departs = _dbm.StructureOfCompany();
CurDep(departs);
}
}
public Company()
{
try
{
_bd = new DatabaseManipulations();
_departmentsTable = _bd.departmentsSelectAll();
_employeesTable = _bd.employeesSelectAll();
LoadEmployees();
LoadDepartments();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Form2_FormClosed(object sender, FormClosedEventArgs e)
{
this.Enabled = true;
if (DatabaseManipulations._connect != null && DatabaseManipulations._connect.Connection)
{
_company = new Company();
dataGridView1.DataSource = _company._departmentsTable;
List <string> deps = new List <string>();
_dbM = new DatabaseManipulations();
DataTable departs = _dbM.StructureOfCompany();
deps.Add("Все департаменты");
foreach (DataRow row in departs.Rows)
{
string dep = (row[0].ToString() + "," + row[1].ToString()).Trim('_', ' ');
deps.Add(dep);
}
comboBox1.DataSource = deps;
state = StateOfDataGrid.Departments;
SetActiveButton(true);
}
}
