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);
}
}
