public static void deleteSubscription(Subscription subscription)
{
executeSql(""
+ "DELETE FROM `" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalSubscriptionId + " = " + subscription.SportsFestivalSubscriptionId + " "
+ "AND `" + field_competitionId + "` = " + subscription.Competition.CompetitionId + " "
+ "AND `" + field_disciplineId + "` = " + subscription.Discipline.DisciplineId + " "
+ "LIMIT 1"
);
}
public static Subscription getSubscriptionByPrimaryKey(
int sportsFestivalSubscriptionId,
Competition competition,
Discipline discipline
)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalSubscriptionId + "` = " + sportsFestivalSubscriptionId + " "
+ "AND `" + field_competitionId + "` = " + competition.CompetitionId + " "
+ "AND `" + field_disciplineId + "` = " + discipline.DisciplineId
);
if (result == null)
{
return null;
}
Subscription subscription = new Subscription(
Convert.ToInt32(result[field_sportsFestivalSubscriptionId]),
competition,
discipline,
Convert.ToDouble(result[field_result])
);
return subscription;
}
public static void updateSubscription(Subscription subscription)
{
executeSql(""
+ "UPDATE "
+ "`" + tableName + "` "
+ "SET "
+ "`" + field_result + "` = " + subscription.Result + " "
+ "WHERE "
+ "`" + field_sportsFestivalSubscriptionId + " = " + subscription.SportsFestivalSubscriptionId + " "
+ "AND `" + field_competitionId + "` = " + subscription.Competition.CompetitionId + " "
+ "AND `" + field_disciplineId + "` = " + subscription.Discipline.DisciplineId
);
}
