public void InsertEnseignantChercheur(Entities.EnseignantChercheur Ensch) { String StrSQL = "INSERT INTO EnseignantChercheur(Nom,Prenom,Grade,Email,Telephone) VALUES (@Nom,@Prenom,@Grade,@Email,@Telephone)"; SqlCommand cmd = new SqlCommand(StrSQL, Program.Connection); cmd.Parameters.Add("@Nom", SqlDbType.NVarChar).Value = Ensch.Nom; cmd.Parameters.Add("@Prenom", SqlDbType.NVarChar).Value = Ensch.Prenom; cmd.Parameters.Add("@Grade", SqlDbType.NVarChar).Value = Ensch.Grade; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Ensch.Email; cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = Ensch.Telephone; }
public void UpdateEnseignantChercheur(int id, Entities.EnseignantChercheur Ensch) { string StrSQL = "UPDATE EnseignantChercheur set Nom=@Nom, Prenom=@Prenom, Grade=@Grade Email=@Email Telephone=@Telephone where IdEnseignantChercheur=@IdEnseignantChercheur"; SqlCommand cmd = new SqlCommand(StrSQL, Program.Connection); cmd.Parameters.Add("@Nom", SqlDbType.NVarChar).Value = Ensch.Nom; cmd.Parameters.Add("@Prenom", SqlDbType.NVarChar).Value = Ensch.Prenom; cmd.Parameters.Add("@Grade", SqlDbType.NVarChar).Value = Ensch.Grade; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Ensch.Email; cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = Ensch.Telephone; cmd.Parameters.Add("@IdEnseignantChercheur", SqlDbType.Int).Value = id; try { Program.Connection.Open(); cmd.ExecuteNonQuery(); Program.Connection.Close(); } catch (Exception e) { Program.Connection.Close(); MessageBox.Show(e.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }