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