public static SportsFestivalSubscription getSportsFestivalSubscriptionById(int sportsFestivalSubscriptionId)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalSubscriptionId + "` = " + sportsFestivalSubscriptionId
);
if (result == null)
{
return null;
}
SportsFestivalSubscription sportsFestivalSubscription = new SportsFestivalSubscription(
Convert.ToInt32(result[field_sportsFestivalSubscriptionId]),
SportsFestivalProvider.getSportsFestivalById(Convert.ToInt32(result[field_sportsFestivalId])),
StudentProvider.getStudentById(Convert.ToInt32(result[field_studentId])),
Convert.ToString(result[field_classShortcut])
);
return sportsFestivalSubscription;
}
public static void deleteSportsFestivalSubscription(SportsFestivalSubscription sportsFestivalSubscription)
{
executeSql(""
+ "DELETE FROM `" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalSubscriptionId + " = " + sportsFestivalSubscription.SportsFestivalSubscriptionId + " "
+ "LIMIT 1"
);
}