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); } }
private void Button4_Click(object sender, EventArgs e) { try { dataGridView1.DataSource = _dbM.StructureOfCompany(); state = StateOfDataGrid.StructureOfCompany; } 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); } }