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;
}
public static List<MotifFin> GetAllMotif()
{
List<MotifFin> oMotif = new List<MotifFin>();
using (SqlConnection sqlConnect = GetConnection())
{
using (SqlCommand sqlCde = new SqlCommand())
{
sqlCde.Connection = sqlConnect;
string strsql = "GetAllMotif";
try
{
sqlCde.CommandType = CommandType.StoredProcedure;
sqlCde.CommandText = strsql;
SqlDataReader sqlRdr = sqlCde.ExecuteReader();
while (sqlRdr.Read())
{
MotifFin mot = new MotifFin()
{
IdMotif = (sbyte)sqlRdr.GetByte(0),
LibelleMotif = sqlRdr.GetString(1)
};
oMotif.Add(mot);
}
sqlRdr.Close();
return oMotif;
}
catch (SqlException ex)
{
throw new DaoExceptionFinApplication("Chargement des qualifications impossible, l'application va se fermer: \n" + ex.Message, ex);
}
}
}
}