public static Variant getVariantById(int variantId)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_variantId + "` = " + variantId
);
if (result == null)
{
return(null);
}
Discipline discipline = DisciplineProvider.getDisciplineById(Convert.ToInt32(result[field_disciplineId]));
Variant variant = new Variant(
Convert.ToInt32(result[field_variantId]),
Convert.ToString(result[field_variantName]),
Convert.ToInt32(result[field_ageFrom]),
Convert.ToInt32(result[field_ageUntil]),
discipline
);
return(variant);
}
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 <Benchmark> getAllBenchmarks()
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "`" + field_disciplineId + "`, "
+ "`" + field_ageFrom + "`, "
+ "`" + field_ageUntil + "`, "
+ "`" + field_gender + "`, "
+ "`" + field_rank + "` "
+ "FROM "
+ "`" + tableName + "`"
);
List <Benchmark> benchmarks = new List <Benchmark>();
foreach (var row in results)
{
Discipline discipline = DisciplineProvider.getDisciplineById(Convert.ToInt32(row[field_disciplineId]));
benchmarks.Add(getBenchmarkByPrimaryKey(
discipline,
Convert.ToInt32(row[field_ageFrom]),
Convert.ToInt32(row[field_ageUntil]),
Convert.ToChar(row[field_gender]),
Convert.ToString(row[field_rank])
));
}
return(benchmarks);
}
public static List <Discipline> getDisciplinesByDisciplineSet(DisciplineSet disciplineSet)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List <Discipline> disciplines = new List <Discipline>();
foreach (var row in results)
{
disciplines.Add(DisciplineProvider.getDisciplineById(Convert.ToInt32(row[field_disciplineId])));
}
return(disciplines);
}