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);
}
public static List <Subscription> getAllSubscriptions()
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "`"
);
List <Subscription> subscriptions = new List <Subscription>();
foreach (var row in results)
{
Competition competition = CompetitionProvider.getCompetitionById(Convert.ToInt32(row[field_competitionId]));
Discipline discipline = DisciplineProvider.getDisciplineById(Convert.ToInt32(row[field_disciplineId]));
subscriptions.Add(getSubscriptionByPrimaryKey(
Convert.ToInt32(row[field_sportsFestivalSubscriptionId]),
competition,
discipline
));
}
return(subscriptions);
}
public static List <Competition> getCompetitionsBySportsFestival(SportsFestival sportsFestival)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId
);
List <Competition> competitions = new List <Competition>();
foreach (var row in results)
{
competitions.Add(CompetitionProvider.getCompetitionById(Convert.ToInt32(row[field_competitionId])));
}
return(competitions);
}
public static List <Competition> getCompetitionsByDisciplineSet(DisciplineSet disciplineSet)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List <Competition> competitions = new List <Competition>();
foreach (var row in results)
{
competitions.Add(CompetitionProvider.getCompetitionById(Convert.ToInt32(row[field_competitionId])));
}
return(competitions);
}
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);
}
