1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
| protected void Button_validerinfo_Click(object sender, EventArgs e)
{
try
{
c.cmd = c.cn.CreateCommand();
c.cmd.CommandText = "AjouterAgent";
c.cmd.CommandType = CommandType.StoredProcedure;
if (c.cn.State == ConnectionState.Closed)
{
c.cn.Open();
}
c.cmd.Parameters.Add("@ppr", SqlDbType.Int);
c.cmd.Parameters.Add("@lieu", SqlDbType.VarChar);
c.cmd.Parameters.Add("@adresspro", SqlDbType.VarChar);
c.cmd.Parameters.Add("@adressperso", SqlDbType.VarChar);
c.cmd.Parameters.Add("@telbureau", SqlDbType.VarChar);
c.cmd.Parameters.Add("@telgsm", SqlDbType.VarChar);
c.cmd.Parameters.Add("@email", SqlDbType.VarChar);
c.cmd.Parameters.Add("@np", SqlDbType.VarChar);
c.cmd.Parameters.Add("@proff", SqlDbType.VarChar);
c.cmd.Parameters.Add("@empl", SqlDbType.VarChar);
c.cmd.Parameters.Add("@retraite", SqlDbType.VarChar);
c.cmd.Parameters.Add("@lbl", SqlDbType.VarChar);
c.cmd.Parameters.Add("@lblrecru", SqlDbType.VarChar);
c.cmd.Parameters.Add("@daterecru", SqlDbType.Date);
c.cmd.Parameters.Add("@lblgrade", SqlDbType.VarChar);
c.cmd.Parameters.Add("@TypeOperation", SqlDbType.Int);
c.cmd.Parameters["@ppr"].Value = Session["Code"];
c.cmd.Parameters["@lieu"].Value = TextBox_ln.Text;
c.cmd.Parameters["@adresspro"].Value = TextBox_adrspro.Text;
c.cmd.Parameters["@adressperso"].Value = TextBox_adrssperso.Text;
c.cmd.Parameters["@telbureau"].Value = TextBox_bureau.Text;
c.cmd.Parameters["@telgsm"].Value = TextBox_gsm.Text;
c.cmd.Parameters["@email"].Value = TextBox_email.Text;
c.cmd.Parameters["@np"].Value = TextBox_npconj.Text;
c.cmd.Parameters["@proff"].Value = TextBox_prof.Text;
c.cmd.Parameters["@empl"].Value = TextBox_empl.Text;
c.cmd.Parameters["@retraite"].Value = DropDownList_retraite.SelectedValue;
c.cmd.Parameters["@lbl"].Value = DropDownList_etatcivil.SelectedValue;
c.cmd.Parameters["@lblrecru"].Value = DropDownList_moderecru.SelectedValue;
c.cmd.Parameters["@daterecru"].Value = TextBox_daterecru.Text;
c.cmd.Parameters["@lblgrade"].Value = TextBox_gradeactu.Text;
c.cmd.Parameters["@TypeOperation"].Value = 0;
c.cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
TextBox_ln.Text = lblln.Text;
TextBox_adrspro.Text = lbladrspro.Text;
TextBox_adrssperso.Text = lbladrsperso.Text;
TextBox_bureau.Text = lblbureau.Text;
TextBox_gsm.Text = lblgsm.Text;
TextBox_email.Text = lblemail.Text;
DropDownList_etatcivil.SelectedValue = lbletat.Text;
TextBox_npconj.Text = lblnpconj.Text;
DropDownList_retraite.SelectedValue = lblretraite.Text;
TextBox_prof.Text = lblprof.Text;
TextBox_empl.Text = lblempl.Text;
if (c.cn.State == ConnectionState.Open)
{
c.cn.Close();
}
}
} |
Partager