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(); } }