public static List<Qualification> GetAllQualifications() { List<Qualification> Qualifications = new List<Qualification>(); // création connection using (SqlConnection sqlConnect = GetConnection()) { using (SqlCommand sqlCde = new SqlCommand()) { //initialiser la connection de la commande sqlCde.Connection = sqlConnect; // chargement des qualifications String strSql = "Select idQualif, libelleQualif, pvjournalier from dbo.Qualification"; sqlCde.CommandText = strSql; // Exécution de la commande try { SqlDataReader sqlRdr = sqlCde.ExecuteReader(); while (sqlRdr.Read()) { Qualification oQualif = new Qualification(Convert.ToSByte(sqlRdr[0]), sqlRdr.GetString(1), sqlRdr.GetDecimal(2)); Qualifications.Add(oQualif); } sqlRdr.Close(); return Qualifications; } catch (SqlException se) { throw new DaoExceptionFinAppli("Lecture des qualifications impossible, l'application va se fermer: \n" + se.Message, se); } } } }
public Collaborateur(int code, string nom, string prenom, DateTime? dembauche, decimal prjour, Qualification qualif) { this.CodeColl = code; this.Nom = nom; this.PreNom = prenom; this.DEmbauche = dembauche; this.PrJournalier = prjour; //this.LeStatut = statut; this.LaQualif = qualif; }
public ProjetRegie(string nomprojet, DateTime debut, DateTime fin, Client cli, string contact, string mailcontact, decimal tj, Qualification q) : base( nomprojet, debut, fin, cli, contact, mailcontact) { this.TarifJournalier = tj; this.Qualification = q; }
public Prevision(Qualification oQ, short nbj) { this.LaQualif = oQ; this.NbJours = nbj; }