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