private void BTN_Vider_Click(object sender, EventArgs e)
{
TB_NumStage.Clear();
RTB_Description.Clear();
CB_TypeStage.SelectedIndex = -1;
CB_NumEntreprise.SelectedIndex = -1;
}
private void FB_Supprimer_Click(object sender, EventArgs e)
{
if (NumstageValide(TB_NumStage.Text))
{
string sqlcommande2 = "delete from postuler where numstage = " + TB_NumStage.Text;
string sqlcommande = "delete from stage where numstage = " + TB_NumStage.Text;
OracleCommand orcd2 = new OracleCommand(sqlcommande2, oraconnPrincipale);
OracleCommand orcd = new OracleCommand(sqlcommande, oraconnPrincipale);
try
{
orcd2.CommandType = CommandType.Text;
orcd2.ExecuteNonQuery();
orcd.CommandType = CommandType.Text;
orcd.ExecuteNonQuery();
MessageBox.Show("Suppression reussite");
FB_Supprimer.Enabled = false;
}
catch (OracleException ex)
{
MessageBox.Show("Suppression non reussite");
FB_Supprimer.Enabled = false;
Erreur(ex);
}
TB_NumStage.Clear();
}
else
{
TB_NumStage.Text = "";
UpdateControl();
}
UpdateControl();
}
/// <summary>
/// Unbind et clear de touts les controles de la form
/// </summary>
private void UnbindTB()
{
TB_NumStage.DataBindings.Clear();
TB_NumStage.Clear();
RTB_Description.DataBindings.Clear();
RTB_Description.Clear();
CB_TypeStage.DataBindings.Clear();
CB_NumEntreprise.DataBindings.Clear();
}
