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