public Prevision(int codeProjet, Qualification Qualif, short value, int idPrevision) { CodeProjet = codeProjet; this.LaQualif = Qualif; this.NbJours = value; this.idPrevision = idPrevision; }
public Collaborateur(int initCodeColl, string initNom, string initPrenom, DateTime initDembauche, decimal initPrJournalier, Qualification initLaQualif) { CodeColl = initCodeColl; Nom = initNom; Prenom = initPrenom; DEmbauche = initDembauche; PrJournalier = initPrJournalier; LaQualif = initLaQualif; }
public static List<Qualification> GetAllQualification() { using (SqlConnection sqlConnect = GetConnection()) { using (SqlCommand sqlCde = new SqlCommand()) { sqlCde.Connection = sqlConnect; string strsql = "GetAllQualification"; try { sqlCde.CommandType = CommandType.StoredProcedure; sqlCde.CommandText = strsql; SqlDataReader 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(ex.Message); } } } }