private void Ajouter()
{
Form_Ajouter_Division aDiv = new Form_Ajouter_Division(oracon, connection);
aDiv.Text = "Ajouter une division";
if (aDiv.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string sqlAjout = "insert into Division (NomDivision,DateCreation)" +
" VALUES(:NomDivision,:DateCreation)";
try
{
OracleParameter OraParaNomDiv = new OracleParameter(":NomDivision", OracleDbType.Varchar2, 40);
OracleParameter OraParamDateCreation = new OracleParameter(":DateCreation", OracleDbType.Date);
OraParaNomDiv.Value = aDiv.nomDivision;
OraParamDateCreation.Value = DateTime.Parse(aDiv.dateCreation);
OracleCommand oraAjout = new OracleCommand(sqlAjout, oracon);
oraAjout.Parameters.Add(OraParaNomDiv);
oraAjout.Parameters.Add(OraParamDateCreation);
oraAjout.ExecuteNonQuery();
LoadDGV();
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
private void Modifier()
{
Form_Ajouter_Division Modifier = new Form_Ajouter_Division(oracon, connection);
Modifier.Text = "Modification de la division";
Modifier.nomDivision = DGV_Divisions.SelectedRows[0].Cells[0].Value.ToString();
Modifier.dateCreation = DGV_Divisions.SelectedRows[0].Cells[1].Value.ToString();
if (Modifier.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
string sqlModif = "Update Division set NomDivision =:NomDivision, DateCreation =:DateCreation " +
"where NomDivision =:NomDivision2";
OracleCommand oraUpdate = new OracleCommand(sqlModif, oracon);
OracleParameter paramNomDivision = new OracleParameter(":NomDivision", OracleDbType.Varchar2, 40);
OracleParameter paramDateCreation = new OracleParameter(":DateCreation", OracleDbType.Date);
OracleParameter paramNomDivision2 = new OracleParameter(":NomDivision2", OracleDbType.Varchar2, 40);
paramNomDivision.Value = Modifier.nomDivision;
paramDateCreation.Value = DateTime.Parse(Modifier.dateCreation);
paramNomDivision2.Value = DGV_Divisions.SelectedRows[0].Cells[0].Value.ToString();
oraUpdate.Parameters.Add(paramNomDivision);
oraUpdate.Parameters.Add(paramDateCreation);
oraUpdate.Parameters.Add(paramNomDivision2);
oraUpdate.ExecuteNonQuery();
LoadDGV();
}
catch (OracleException ex)
{
if (ex.Number == 2292)
{
MessageBox.Show("Le nom de la division ne peut etre modifié si elle contient des équipes.", "Erreur 2292", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}