public static Competition getCompetitionById(int competitionId)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_competitionId + "` = " + competitionId
);
if (result == null)
{
return(null);
}
Competition competition = new Competition(
Convert.ToInt32(result[field_competitionId]),
Convert.ToString(result[field_competitionName])
);
foreach (DisciplineSet disciplineSet in DisciplineSetProvider.getDisciplineSetsByCompetition(competition))
{
competition.addDisciplineSet(disciplineSet);
}
return(competition);
}
public static List <DisciplineSet> getDisciplineSetsByDiscipline(Discipline discipline)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineId + "` = " + discipline.DisciplineId
);
List <DisciplineSet> disciplineSets = new List <DisciplineSet>();
foreach (var row in results)
{
disciplineSets.Add(DisciplineSetProvider.getDisciplineSetById(Convert.ToInt32(row[field_disciplineSetId])));
}
return(disciplineSets);
}
