private void deleteEmployeeButton_Click(object sender, EventArgs e)
{
if (recordsDataGridView.CurrentCell is null)
{
return;
}
using (var cn = Database.CreateConnection())
{
cn.Open();
OracleCommand cmd = new OracleCommand("DELETE FROM departaments_employees WHERE id=:id", cn);
cmd.Parameters.Add(new OracleParameter("id", records[recordsDataGridView.CurrentCell.RowIndex].id));
try
{
cmd.ExecuteNonQuery();
employees = EmployeesDataSet.GetAvailableEmployees(departament_id);
employeesDataGridView.DataSource = employees;
DepartsEmplsDataSet.Update();
records = DepartsEmplsDataSet.GetRecordsForDepartament(departament_id);
recordsDataGridView.DataSource = records;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void addEmployeeButton_Click(object sender, EventArgs e)
{
if (employeesDataGridView.CurrentCell is null)
{
return;
}
using (var cn = Database.CreateConnection())
{
cn.Open();
OracleCommand cmd = new OracleCommand("INSERT INTO departaments_employees (departament_id, employee_id) " +
"VALUES (:dep, :empl)", cn);
cmd.Parameters.Add(new OracleParameter("dep", departament_id));
cmd.Parameters.Add(new OracleParameter("empl", employees[employeesDataGridView.CurrentCell.RowIndex].id));
try
{
cmd.ExecuteNonQuery();
employees = EmployeesDataSet.GetAvailableEmployees(departament_id);
employeesDataGridView.DataSource = employees;
DepartsEmplsDataSet.Update();
records = DepartsEmplsDataSet.GetRecordsForDepartament(departament_id);
recordsDataGridView.DataSource = records;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public ManageDepartamentEmployeesForm(Departament departament)
{
InitializeComponent();
departament_id = departament.id;
departamentNameTextBox.Text = departament.name;
employees = EmployeesDataSet.GetAvailableEmployees(departament_id);
employeesDataGridView.DataSource = employees;
employeesDataGridView.Columns[0].Visible = false;
DepartsEmplsDataSet.Update();
records = DepartsEmplsDataSet.GetRecordsForDepartament(departament_id);
recordsDataGridView.DataSource = records;
recordsDataGridView.Columns[0].Visible = false;
}
