/// <summary>
/// Méthode de récupération des qualifications.
/// </summary>
/// <returns>Est retourné la liste des qualifications.</returns>
public static List <Metier.Qualification> GetAllQualifications()
{
List <Metier.Qualification> Qualifications = new List <Metier.Qualification>();
using (SqlConnection sqlCo = DaoConnection.GetConnection())
{
using (SqlCommand sqlCde = new SqlCommand())
{
sqlCde.Connection = sqlCo;
String strCo = "GetAllQualifications";
sqlCde.CommandType = CommandType.StoredProcedure;
sqlCde.CommandText = strCo;
try
{
SqlDataReader sqlRdr = sqlCde.ExecuteReader();
while (sqlRdr.Read())
{
Metier.Qualification Qual = new Metier.Qualification(sqlRdr.GetInt32(0));
Qual.LibelleQualification = sqlRdr.GetString(1);
Qualifications.Add(Qual);
}
sqlRdr.Close();
}
catch (SqlException se)
{
throw new Exceptions.DaoException.DAOExceptionFinApplication("Lecture des candidats impossible: \n" + se.Message, se);
}
}
}
return(Qualifications);
}
/// <summary>
/// Méthode de récupération des qualifications.
/// </summary>
/// <returns>Est retourné la liste des qualifications.</returns>
public static List<Metier.Qualification> GetAllQualifications()
{
List<Metier.Qualification> Qualifications = new List<Metier.Qualification>();
using (SqlConnection sqlCo = DaoConnection.GetConnection())
{
using (SqlCommand sqlCde = new SqlCommand())
{
sqlCde.Connection = sqlCo;
String strCo = "GetAllQualifications";
sqlCde.CommandType = CommandType.StoredProcedure;
sqlCde.CommandText = strCo;
try
{
SqlDataReader sqlRdr = sqlCde.ExecuteReader();
while (sqlRdr.Read())
{
Metier.Qualification Qual = new Metier.Qualification(sqlRdr.GetInt32(0));
Qual.LibelleQualification = sqlRdr.GetString(1);
Qualifications.Add(Qual);
}
sqlRdr.Close();
}
catch (SqlException se)
{
throw new Exceptions.DaoException.DAOExceptionFinApplication("Lecture des candidats impossible: \n" + se.Message, se);
}
}
}
return Qualifications;
}
