/// <summary>
/// This function convert the data give by ImportCsvBrut to Participation and transfer it to db
/// </summary>
/// <param name="dico"></param>
/// <param name="course"></param>
public static void Import(Dictionary <string, List <string> > dico, Course course)
{
ParticipationCSVToDB.CSVContainsRightColumnLabel(dico);
ParticipationCSVToDB.CSVContainsColumnWithSameNumberOfElement(dico);
Participation part;
Coureur coureur;
// Save data in db
IParticipationRepository repo = new ParticipationRepository();
for (int i = 0; i < dico[dico.Keys.First()].Count; i++)
{
coureur = new Coureur(dico["nom"][i]
, dico["prenom"][i]
, dico["licence"][i]
, dico["courriel"][i]
, dico["sexe"][i]
, Convert.ToDateTime(dico["annee_naissance"][i]));
part = new Participation();
part.Course = course;
part.Participant = coureur;
part.NumDossard = Convert.ToInt32(dico["dossard"][i]);
if (dico.Keys.Contains("temps"))
{
part.Temps = Convert.ToDouble(dico["temps"][i].Replace('.', ','));
}
repo.Save(part);
}
}
public void RemoveCoureur(Coureur coureur)
{
IParticipationRepository participationRepository = new ParticipationRepository();
IList <Participation> participations = participationRepository.SearchParticipationByCoureurId(coureur.IdCoureur);
foreach (Participation p in participations)
{
Session.Delete(p);
Session.Flush();
}
Session.Delete(coureur);
Session.Flush();
}