public static DisciplineSet getDisciplineSetById(int disciplineSetId)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSetId
);
if (result == null)
{
return(null);
}
DisciplineSet disciplineSet = new DisciplineSet(
Convert.ToInt32(result[field_disciplineSetId])
);
foreach (Discipline discipline in DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet))
{
disciplineSet.addDiscipline(discipline);
}
foreach (Competition competition in CompetitionProvider.getCompetitionsByDisciplineSet(disciplineSet))
{
disciplineSet.addCompetition(competition);
}
foreach (DisciplineSetDisciplineMapping disciplineSetDisciplineMapping in DisciplineSetDisciplineMappingProvider.getDisciplineSetDisciplineMappingsByDisciplineSet(disciplineSet))
{
disciplineSet.addDisciplineSetDisciplineMapping(disciplineSetDisciplineMapping);
}
return(disciplineSet);
}