}//fin constructeur //getStudent public Etudiant getEtudiant(int IdEtudiant) { var select = "SELECT etudiant.IdEtudiant, etudiant.Erasmus, etudiant.DernierDiplomeObtenu, etudiant.OrigineDiplome, etudiant.Natinoalite" + "\n"; var from = "FROM student.ETUDIANT etudiant" + "\n"; var where = "etudiant.IdEtudiant = {0}"; var etudiant = new Etudiant(); using (var dbConnection = new SqlConnection(StudentDbConnectionString)) { dbConnection.Open(); using (SqlCommand sqlCommand = dbConnection.CreateCommand()) { sqlCommand.CommandText = String.Format(select + from + where, IdEtudiant); SqlDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); int id = (int)reader["IdEtudiant"]; bool erasmus = (bool)reader["Erasmus"]; String dernierDiplomeObtenu = (String)reader["DernierDiplomeObtenu"]; String origineDiplome = (String)reader["OrigineDiplome"]; String nationalite = (String)reader["Nationalite"]; reader.Close(); etudiant.IdEtudiant = id; etudiant.Erasmus = erasmus; etudiant.DernierDiplomeObtenu = dernierDiplomeObtenu; etudiant.OrigineDiplome = origineDiplome; etudiant.Nationalite = nationalite; } dbConnection.Close(); } return etudiant; }//fin getEtudiant
}//fin getEtudiant //getAllStudent public List<Etudiant> getAllEtudiants() { List<Etudiant> etudiants = null; using (var dbConnection = new SqlConnection(StudentDbConnectionString)) { dbConnection.Open(); using (SqlCommand sqlCommand = dbConnection.CreateCommand()) { sqlCommand.CommandText = "SELECT * FROM student.ETUDIANT"; SqlDataReader reader = sqlCommand.ExecuteReader(); etudiants = new List<Etudiant>(); while (reader.Read()) { var etudiant = new Etudiant { IdEtudiant = (int)reader["IdEtudiant"], Erasmus = (bool)reader["Erasmus"], DernierDiplomeObtenu = (String)reader["DernierDiplomeObtenu"], OrigineDiplome = (String)reader["OrigineDiplome"], Nationalite = (String)reader["Nationalite"] }; } } dbConnection.Close(); } return etudiants; }//fin getAllEtudiants