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 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
| public void bdd(int idprofil, int idrole)
{
string connexion_string = @"Data Source=W260112\SQLExpress; Integrated Security=true; AttachDbFilename=D:\Profiles\super\Mes documents\Visual Studio*2005\WebSites\Admin\App_Data\intranet2.mdf; User Instance=true;";
SqlTransaction trans=null;
SqlConnection cx;
cx=new SqlConnection();
cx.ConnectionString=connexion_string;
try
{
cx.Open();
trans = cx.BeginTransaction();
string rq = "insert into salarie (nom,prenom,adresse1,adresse2,codepost,ville,telfixe,telport,telpro,mail,login,password,idprofil,idrole) values(@zeNom,@zePrenom,@zeAdresse,@zeAdresse2,@zeCodePost,@zeVille,@zeTelFixe,@zeTelPort,@zeTelProf,@zeMail,@zeLogin,@zePassword,'" + idprofil + "','"+idrole+"')";
SqlCommand sql;
sql = new SqlCommand(rq, cx);
//Paramétrage
sql.Parameters.Add("@zeNom", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zePrenom", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeAdresse", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeAdresse2", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeCodePost", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeVille", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeTelFixe", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeTelPort", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeTelProf", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeMail", SqlDbType.VarChar, 30);
sql.Parameters.Add("@zeLogin", SqlDbType.VarChar, 50);
sql.Parameters.Add("@zePassword", SqlDbType.VarChar, 50);
sql.Parameters.Add("" + idprofil + "", SqlDbType.Int);
sql.Parameters.Add("" + idrole + "", SqlDbType.Int);
//Valeur des paramètres
sql.Parameters["@zeNom"].Value = zeNom.Text;
sql.Parameters["@zePrenom"].Value = zePrenom.Text;
sql.Parameters["@zeAdresse"].Value = zeAdresse.Text;
sql.Parameters["@zeAdresse2"].Value = zeAdresse2.Text;
sql.Parameters["@zeCodePost"].Value = zeCodePost.Text;
sql.Parameters["@zeVille"].Value = zeVille.Text;
sql.Parameters["@zeTelFixe"].Value = zeTelFixe.Text;
sql.Parameters["@zeTelPort"].Value = zeTelPort.Text;
sql.Parameters["@zeTelProf"].Value = zeTelProf.Text;
sql.Parameters["@zeMail"].Value = zeMail.Text;
sql.Parameters["@zeLogin"].Value = zeLogin.Text;
sql.Parameters["@zePassword"].Value = zePassword.Text;
sql.Parameters["" + idprofil + ""].Value = idprofil;
sql.Parameters["" + idrole + ""].Value = idrole;
sql.Transaction = trans;
sql.ExecuteNonQuery();
SqlCommand verif = new SqlCommand("select count(idsalarie) from salarie where nom=@zeNom", cx);
verif.Parameters.Add("@zeNom", SqlDbType.VarChar, 30);
verif.Parameters["@zeNom"].Value = zeNom.Text;
verif.Transaction = trans;
int n = (int)verif.ExecuteScalar();
if (n == 1)
{
// info.Text = string.Format("nombre d'utilisateur : {0} ", n);
trans.Commit();//validation transaction
}
else
{
throw new Exception("Le salarié existe déjà !!!");
}
}
catch (Exception err)
{
if (trans != null)
{
trans.Rollback();
info.Text = err.Message;
}
}
finally
{
cx.Close();
//HttpContext.Current.Session.Add("nom", zeNom.Text);
//Session.Add("nom", zeNom.Text);
// Response.Redirect("ajousalarie2.aspx");
}
} |
Partager