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