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