/// <summary> /// Adds the courses to the database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Register_Button_Click(object sender, EventArgs e) { SQLController SQLhandler = new SQLController(); foreach (Dictionary <string, string> course in courses) { // Check if prerequisites are met if (course.TryGetValue("Course", out string courseID)) { // query for checking prerequisites String query = "EXEC dbo.checkPreRequsite @studentID = '" + studentID + "', @courseID = '" + courseID + "';"; DataSet queryResult = SQLhandler.executeFetchCommand(query); // pass that data set over if (queryResult.Tables.Count > 0) { // If prerequisites are all met if (queryResult.Tables[0].Rows.Count == 0) { // Get section if (course.TryGetValue("Section", out string sectionID)) { // query for inserting for section query = "EXEC dbo.insertSection @studentID = '" + studentID + "', @sectionID = '" + sectionID + "';"; SQLhandler.executeSetCommand(query); Error_Text.Visible = true; Error_Text.Text = "Yay you registered into your classes... b.b.baka it's not like I wanted you to register or anything o.o"; Error_Text.ForeColor = Color.Green; } else { Error_Text.Visible = true; Error_Text.Text = "Error adding the sections (ಠ_ಠ)"; return; } } // Prerequisites are not met else { Error_Text.Visible = true; Error_Text.Text = @"You do not have the cowwect prerequisites (ノಠ ∩ಠ)ノ彡( \o°o)\"; return; } } // Error getting prerequisites else { Error_Text.Visible = true; Error_Text.Text = "Ewwow checking prerequisites (・`ω´・) "; return; } } } //TODO: call subscribed method }