public static SportsFestival getSportsFestivalById(int sportsFestivalId)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestivalId
);
if (result == null)
{
return(null);
}
SportsFestival sportsFestival = new SportsFestival(
Convert.ToInt32(result[field_sportsFestivalId]),
Convert.ToDateTime(result[field_sportsFestivalDate])
);
foreach (Competition competition in CompetitionProvider.getCompetitionsBySportsFestival(sportsFestival))
{
sportsFestival.addCompetition(competition);
}
return(sportsFestival);
}
public void OpenResultsGUI(SportsFestival pSportsFestival)
{
ResultsGUIForm = new ResultsGUI(this, pSportsFestival);
ResultsGUIForm.updateSubscriptions();
ResultsGUIForm.ShowDialog();
}
public static void deleteSportsFestival(SportsFestival sportsFestival)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + " = " + sportsFestival.SportsFestivalId + " "
+ "LIMIT 1"
);
}
public static void deleteSportsFestival(SportsFestival sportsFestival, Competition competition)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + " = " + sportsFestival.SportsFestivalId + " "
+ "AND `" + field_competitionId + " = " + competition.CompetitionId + " "
+ "LIMIT 1"
);
}
public static void createSportsFestivalCompetitionRelation(SportsFestival sportsFestival, Competition competition)
{
executeSql(""
+ "INSERT INTO `" + tableName + "` "
+ "("
+ "`" + field_sportsFestivalId + "`,"
+ "`" + field_competitionId + "`"
+ ") VALUES ("
+ sportsFestival.SportsFestivalId + ","
+ competition.CompetitionId
+ ")"
);
}
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);
}
}
}
public static bool relationExists(SportsFestival sportsFestival, Competition competition)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId + " "
+ "AND `" + field_competitionId + "` = " + competition.CompetitionId
);
if (result.Count == 1)
{
return(true);
}
return(false);
}
public static List <Class> getClassesBySportsFestival(SportsFestival sportsFestival)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`sportsfestivalSubscription` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId
);
List <Class> classes = new List <Class>();
foreach (var row in results)
{
classes.Add(ClassProvider.getClassByShortcutSimplified(row["classShortcut"].ToString()));
}
return(classes);
}
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);
}
public static List <Competition> getCompetitionsBySportsFestival(SportsFestival sportsFestival)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_sportsFestivalId + "` = " + sportsFestival.SportsFestivalId
);
List <Competition> competitions = new List <Competition>();
foreach (var row in results)
{
competitions.Add(CompetitionProvider.getCompetitionById(Convert.ToInt32(row[field_competitionId])));
}
return(competitions);
}
public void createNewSportsFestival(DateTime sportsFestivalDate, List <Int32> competitionIds)
{
List <Competition> competitions = new List <Competition>();
foreach (int competitionId in competitionIds)
{
Competition competition = CompetitionProvider.getCompetitionById(competitionId);
competitions.Add(competition);
}
int sportsFestivalId = SportsFestivalProvider.createSportsFestival(sportsFestivalDate, competitions);
SportsFestival sportsFestival = SportsFestivalProvider.getSportsFestivalById(sportsFestivalId);
List <Student> students = StudentProvider.getAllActiveStudents();
foreach (Student student in students)
{
SportsFestivalSubscriptionProvider.createSportsFestivalSubscription(
sportsFestival,
student
);
}
}
public static int createSportsFestivalSubscription(
SportsFestival sportsFestival,
Student student
)
{
executeSql(""
+ "INSERT INTO `" + tableName + "` "
+ "("
+ "`" + field_sportsFestivalId + "`, "
+ "`" + field_studentId + "`, "
+ "`" + field_classShortcut + "`"
+ ") VALUES ("
+ sportsFestival.SportsFestivalId + ", "
+ student.StudentId + ", "
+ "'" + student.ClassObject.Shortcut + "'"
+ ")"
);
Dictionary <string, object> result = querySingleSql("SELECT MAX(`" + field_sportsFestivalSubscriptionId + "`) AS `insertionId` FROM `" + tableName + "`");
int insertionId = Convert.ToInt32(result["insertionId"]);
return(insertionId);
}
public static List <Competition> getCompetitionsBySportsFestival(SportsFestival sportsFestival)
{
return(SportsFestivalCompetitionProvider.getCompetitionsBySportsFestival(sportsFestival));
}
internal ResultsGUI(ResultsController controller, SportsFestival curSportsFestival)
{
m_SportsFestivalRef = curSportsFestival;
InitializeComponent();
}
