public static SportsFestival getSportsFestivalById(int sportsFestivalId)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestivalId
);
if (result == null)
{
return null;
}
SportsFestival sportsFestival = new SportsFestival(
Convert.ToInt32(result[field_sportsFestivalId]),
Convert.ToDateTime(result[field_sportsFestivalDate])
);
foreach (Competition competition in CompetitionProvider.getCompetitionsBySportsFestival(sportsFestival))
{
sportsFestival.addCompetition(competition);
}
return sportsFestival;
}
