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