private void bt_next_Click(object sender, RoutedEventArgs e) { try { next_topic_id = connect.returnconnection_string("SELECT min(topic_id) FROM Topics WHERE topic_fk_course =" + current_course_id + " AND topic_id > " + topic_id); if (next_topic_id.Equals("")) { int check = Convert.ToInt32(connect.returnconnection_string("SELECT COUNT(1) FROM Student_Course WHERE student_course_fk_student_uid= " + StudentLogin.student_uid + " AND student_course_fk_course_id=" + current_course_id)); if (check == 0) { StudentCourseProvider studentCourseProvider = new StudentCourseProvider(); studentCourseProvider.student_course_fk_student_uid = StudentLogin.student_uid; studentCourseProvider.student_course_fk_course_id = current_course_id; MessageBox.Show("provider"); StudentCourseHandler studentCourseHandler = new StudentCourseHandler(); string user_message = studentCourseHandler.enroll_student(studentCourseProvider); MessageBox.Show(user_message); } TopicSelector topicSelector = new TopicSelector(); topicSelector.Show(); } else { load_page(current_course_id); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public string enroll_student(StudentCourseProvider studentCourseProvider) { string user_message; SqlConnection sqlConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connection"].ConnectionString); try { SqlCommand sqlCmd = new SqlCommand("[enroll_student]", sqlConnection); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@student_course_fk_student_uid", SqlDbType.Int).Value = studentCourseProvider.student_course_fk_student_uid; sqlCmd.Parameters.Add("@student_course_fk_course_id", SqlDbType.Int).Value = studentCourseProvider.student_course_fk_course_id; sqlConnection.Open(); sqlCmd.ExecuteNonQuery(); return(user_message = "You can now take the test for this Course!"); } catch (Exception ex) { MessageBox.Show(ex.Message); return(user_message = "Failure!"); } finally { sqlConnection.Close(); } }