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