public static int createSportsFestival(DateTime sportsFestivalDate, List <Competition> competitions)
{
executeSql(""
+ "INSERT INTO `" + tableName + "` "
+ "("
+ "`" + field_sportsFestivalDate + "`"
+ ") VALUES ("
+ "'" + sportsFestivalDate.ToString("yyyy-MM-dd") + "'"
+ ")"
);
Dictionary <string, object> result = querySingleSql("SELECT MAX(`" + field_sportsFestivalId + "`) AS `insertionId` FROM `" + tableName + "`");
int insertionId = Convert.ToInt32(result["insertionId"]);
foreach (Competition competition in competitions)
{
SportsFestivalCompetitionProvider.createSportsFestivalCompetitionRelation(
getSportsFestivalById(insertionId),
competition
);
}
return(insertionId);
}
public static void updateSportsFestival(SportsFestival sportsFestival)
{
executeSql(""
+ "UPDATE "
+ "`" + tableName + "` "
+ "SET "
+ "`" + field_sportsFestivalDate + "` = '" + sportsFestival.Date.ToString("yyyy-MM-dd") + "' "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId
);
foreach (Competition competition in sportsFestival.getCompetitions())
{
if (SportsFestivalCompetitionProvider.relationExists(sportsFestival, competition) == false)
{
SportsFestivalCompetitionProvider.createSportsFestivalCompetitionRelation(sportsFestival, competition);
}
}
}
public static List <Competition> getCompetitionsBySportsFestival(SportsFestival sportsFestival)
{
return(SportsFestivalCompetitionProvider.getCompetitionsBySportsFestival(sportsFestival));
}
