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 List <Student> getStudentsBySportsFestival(SportsFestival sportsFestival) { List <Dictionary <string, object> > results = querySql("" + "SELECT " + "* " + "FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId ); List <Student> students = new List <Student>(); foreach (var row in results) { students.Add(StudentProvider.getStudentById((int)row[field_studentId])); } return(students); }