private void addRecordToolStripMenuItem_Click(object sender, EventArgs e)
{
Form_adauga_departament form_adauga = new Form_adauga_departament();
form_adauga.ShowDialog();
if (form_adauga.DialogResult == DialogResult.OK)
{
OleDbConnection conexiune = new OleDbConnection(Provider);
OleDbCommand comanda = new OleDbCommand();
comanda.Connection = conexiune;
try
{
conexiune.Open();
comanda.Transaction = conexiune.BeginTransaction();
comanda.CommandText = "SELECT max(id_departament) FROM departamente";
int cod = Convert.ToInt32(comanda.ExecuteScalar());
comanda.CommandText = "INSERT INTO departamente(id_departament,denumire,id_supervizor) " +
" VALUES(@id_departament,@denumire,@id_supervizor)";
comanda.Parameters.Add("id_departament", OleDbType.Integer).Value = cod + 1;
comanda.Parameters.Add("denumire", OleDbType.Char).Value = form_adauga.dep.Denumire;
comanda.Parameters.Add("id_supervizor", OleDbType.Integer).Value = form_adauga.dep.Id_supervizor;
comanda.ExecuteNonQuery();
comanda.Transaction.Commit();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
comanda.Transaction.Rollback();
}
finally
{
conexiune.Close();
}
// form_adauga.Validating += new CancelEventHandler(form_adauga.idSuper_txt_Validating);
UpdateList();
}
}
private void modificaInregistrareToolStripMenuItem_Click(object sender, EventArgs e)
{
Form_adauga_departament update_form = new Form_adauga_departament((Departamente)listView1.SelectedItems[0].Tag);
update_form.ShowDialog();
if (update_form.DialogResult == DialogResult.OK)
{
OleDbConnection conexiune = new OleDbConnection(Provider);
OleDbCommand comanda = new OleDbCommand();
comanda.Connection = conexiune;
try
{
conexiune.Open();
comanda.Transaction = conexiune.BeginTransaction();
comanda.CommandText = "UPDATE departamente SET denumire = @denumire, id_supervizor = @id_supervizor WHERE id_departament = @id_departament";
comanda.Parameters.Add("denumire", OleDbType.Char).Value = update_form.dep.Denumire;
comanda.Parameters.Add("id_supervizor", OleDbType.Integer).Value = update_form.dep.Id_supervizor;
comanda.Parameters.Add("id_departament", OleDbType.Integer).Value = update_form.dep.Id_departament;
comanda.ExecuteScalar();
comanda.Transaction.Commit();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
comanda.Transaction.Rollback();
}
finally
{
conexiune.Close();
}
UpdateList();
}
}
