public Mission(int idMission, int initCodeEntreprise, MotifFin motif, Qualification qualif, Niveau niv, Consultant consult, DateTime dateOuv, DateTime? dateFin, decimal? remu, string precis, sbyte? duree) { IdMission = idMission; CodeEntreprise = initCodeEntreprise; Motif = motif; QualificationDemandee = qualif; NiveauDemande = niv; Consult = consult; DateOuverture = dateOuv; DateFin = dateFin; RemunerationProposee = remu; Precisions = precis; Duree = duree; }
// récupération des motifs et des niveaux public static List<Niveau> GetAllNiveau() { List<Niveau> oNiveau = new List<Niveau>(); using (SqlConnection sqlConnect = GetConnection()) { using (SqlCommand sqlCde = new SqlCommand()) { sqlCde.Connection = sqlConnect; string strsql = "GetAllNiveau"; try { sqlCde.CommandType = CommandType.StoredProcedure; sqlCde.CommandText = strsql; SqlDataReader sqlRdr = sqlCde.ExecuteReader(); while (sqlRdr.Read()) { Niveau niv = new Niveau() { IdNiveau = (sbyte)sqlRdr.GetByte(0), Libelle = sqlRdr.GetString(1) }; oNiveau.Add(niv); } sqlRdr.Close(); return oNiveau; } catch (SqlException ex) { throw new DaoExceptionFinApplication("Chargement des qualifications impossible, l'application va se fermer: \n" + ex.Message, ex); } } } }