public CtrlSyntheseECF()
{
_evaluationSelectionnee = null;
_lesSessionsECFsStag = null;
_sessionSelectionnee = null;
_stagiaireEncours = null;
}
public CtrlSaisieResultats()
{
_evaluationEnCours = null;
_listeSessionECFs = null;
_planif = null;
_sessionECFcourant = null;
}
public static Evaluation donneNote(SessionECF pSession, Stagiaire pStag, Competence pComp)
{
Evaluation eval = new Evaluation(pSession.Ecf, pComp, pStag, pSession.Version, -1, pSession.Date);
SqlConnection connexion = ConnexionSQL.CreationConnexion();
SqlCommand cmd = new SqlCommand(SELECT_NOTE_STAG, connexion);
cmd.Parameters.AddWithValue("@idECF", pSession.Ecf.Id);
cmd.Parameters.AddWithValue("@version", pSession.Version);
cmd.Parameters.AddWithValue("@date", pSession.Date);
cmd.Parameters.AddWithValue("@idStagiaire", pStag._id);
cmd.Parameters.AddWithValue("@idCompetence", pComp.Id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
eval = new Evaluation();
eval.Id = reader.GetInt32(reader.GetOrdinal("idEvaluation"));
eval.Ecf = pSession.Ecf;
eval.Stagiaire = pStag;
eval.Competence = pComp;
eval.Note = (float)reader.GetDouble(reader.GetOrdinal("note"));
eval.Version = reader.GetInt32(reader.GetOrdinal("version"));
eval.Date = reader.GetDateTime(reader.GetOrdinal("date"));
}
connexion.Close();
return eval;
}
public static void ajouterEvaluation(Evaluation eval)
{
//Récup de l'id max dans la table EVALUATIONS
SqlConnection connexion = ConnexionSQL.CreationConnexion();
SqlCommand cmd = new SqlCommand(SELECT_MAX, connexion);
SqlDataReader reader = cmd.ExecuteReader();
int idMaxEvaluation = 0;
if (reader.Read())
{
if (reader[0] != DBNull.Value)
{
idMaxEvaluation = reader.GetInt32(0);
}
}
eval.Id = idMaxEvaluation + 1;
connexion.Close();
//Création de la competence
connexion = ConnexionSQL.CreationConnexion();
cmd = new SqlCommand(INSERT_EVALUATION, connexion);
cmd.Parameters.AddWithValue("@idEvaluation", eval.Id);
cmd.Parameters.AddWithValue("@idECF", eval.Ecf.Id);
cmd.Parameters.AddWithValue("@idStagiaire", eval.Stagiaire._id);
cmd.Parameters.AddWithValue("@idCompetence", eval.Competence.Id);
cmd.Parameters.AddWithValue("@note", eval.Note);
cmd.Parameters.AddWithValue("@version", eval.Version);
cmd.Parameters.AddWithValue("@date", eval.Date);
cmd.ExecuteReader();
connexion.Close();
}
public void ajouterEvaluation(Evaluation pEval)
{
EvaluationsDAL.ajouterEvaluation(pEval);
}
public void modifierNoteEvaluation(Evaluation pEvaluation, float pNote)
{
EvaluationsDAL.modifierNoteEvaluation(pEvaluation, pNote);
}
public static void modifierNoteEvaluation(Evaluation pEvaluation, float pNote)
{
if (pEvaluation.Id != 0)
{
//Modification de la note
SqlConnection connexion = ConnexionSQL.CreationConnexion();
SqlCommand cmd = new SqlCommand(UPDATE_EVALUATION, connexion);
cmd.Parameters.AddWithValue("@idEvaluation", pEvaluation.Id);
cmd.Parameters.AddWithValue("@note", pNote);
cmd.ExecuteReader();
connexion.Close();
}
else
{
pEvaluation.Note = pNote;
ajouterEvaluation(pEvaluation);
}
}
public CtrlModifNoteECF()
{
_evaluation = null;
_stagaire = null;
}