public Prevision(int idPrev,int idProj,Qualification qualification, short nbJ) { CodePrevision = idPrev; CodeProjet = idProj; LaQualif = qualification; NbJours = nbJ; }
public static List<Qualification> GetAllQualifications() { using (SqlConnection sqlConnect = ConnectSQLServ()) { using (SqlCommand sqlCde = new SqlCommand()) { try { // Ouvre la connection. sqlConnect.Open(); // Création de la commande SqlDataReader sqlRdr; sqlCde.Connection = sqlConnect; // Constitution Requête SQL //sqlCde.CommandText = strSql; sqlCde.CommandType = System.Data.CommandType.StoredProcedure; sqlCde.CommandText = "GetAllQualifications"; // Exécution de la commande sqlRdr = sqlCde.ExecuteReader(); Qualifications = new List<Qualification>(); while (sqlRdr.Read()) { Qualification qualif = new Qualification() { CodeQualif = (sbyte)sqlRdr.GetByte(0), Libelle = sqlRdr.GetString(1), PvJournee=sqlRdr.GetDecimal(2) }; Qualifications.Add(qualif); } sqlRdr.Close(); return Qualifications; } catch (Exception ex) { throw new DaoException("Récupération des qualifications impossible : " + ex.Message, ex); } finally { sqlConnect.Close(); } } } }