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); }