/// <summary> /// saves a course /// </summary> /// <param name="course">course to save</param> public static void SaveCourse(CourseData course) { if (course.Id == 0) courseEntity.CreateCourse(course); else courseEntity.UpdateCourse(course); }
public static List<QuizData> GetQuizzes(CourseData course) { // TODO replace with entity retrieving List<QuizData> quizzes = new List<QuizData>(); QuizData quiz = new QuizData(); quiz.Name = "My New Quiz"; quizzes.Add(quiz); return quizzes; }
public QuizzesView(CourseData course) { InitializeComponent(); //erase all items in list lvwQuizzes.Items.Clear(); //add items in the course to the list quizzes = QuizController.GetQuizzes(course); foreach (QuizData quiz in quizzes) { lvwQuizzes.Items.Add(quiz.Name,0); } }
public void AddUser(CourseData theCourse, UserData theUser) { if (DataReader != null) DataReader.Close(); SQL = "INSERT INTO `rel_courses_users` (`course_id`, `user_id`) VALUES (\"" + theCourse.Id + "\", \"" + theUser.Id + "\");"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("The user could not be added to the course"); }
/// <summary> /// Create c Course on the Database /// </summary> /// <param name="theCourse">a Course object to create on Database</param> public void CreateCourse(CourseData theCourse) { theCourse.Id = NextId; if (DataReader != null) DataReader.Close(); SQL = "INSERT INTO `courses` (`course_id`, `name`) VALUES (\"" + theCourse.Id + "\", \"" + theCourse.Name + "\");"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("Unable to add Course to Database"); }
public void AddQuiz(CourseData theCourse, QuizData theQuiz) { if (DataReader != null) DataReader.Close(); SQL = "INSERT INTO `rel_courses_quizzes` (`course_id`, `quiz_id`) VALUES (\"" + theCourse.Id + "\", \"" + theQuiz.Id + "\");"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("The Quiz could not be added to the Course"); }
/// <summary> /// handles add course button click. allows user to add a new course. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void addToolStripMenuItem_Click(object sender, EventArgs e) { //prompt user for name of new course string courseName = ""; var result = HelperUI.InputBox("New Course", "Enter name of course", ref courseName); //if user selected okay if (result == DialogResult.OK) { //add to database CourseData courseToAdd = new CourseData(); courseToAdd.Name = courseName; CourseController.SaveCourse(courseToAdd); CourseController.AddUser(courseToAdd, GlobalData.currentUser); //add to list ListViewItem item = lvwCourses.Items.Add(courseToAdd.Name,0); item.Tag = courseToAdd; } }
/// <summary> /// removes a specified user from a specified course /// </summary> /// <param name="course">course to remove user from</param> /// <param name="user">user to be removed</param> public static void RemoveUser(CourseData course, UserData user) { courseEntity.RemoveUser(course, user); }
/// <summary> /// Deletes a specified course from the database /// </summary> /// <param name="course">course to delete</param> public static void DeleteCourse(CourseData course) { courseEntity.DeleteCourse(course); }
/// <summary> /// adds a user to a specified course /// </summary> /// <param name="course">the course to add the user to</param> /// <param name="user">the user to add to the course</param> public static void AddUser(CourseData course, UserData user) { courseEntity.AddUser(course, user); }
/// <summary> /// adds a quiz to a course /// </summary> /// <param name="course">course to add quiz to</param> /// <param name="quiz">quiz to add</param> public static void AddQuiz(CourseData course, QuizData quiz) { courseEntity.AddQuiz(course, quiz); }
public List<QuizData> ReadQuizzes(CourseData theCourse) { List<QuizData> return_data = new List<QuizData>(); if (DataReader != null) DataReader.Close(); SQL = "SELECT r.`quiz_id` FROM `rel_courses_quizzes` r WHERE r.`course_id` = \"" + theCourse.Id + "\";"; InitializeCommand(); OpenConnection(); DataReader = Command.ExecuteReader(); List<int> temp = new List<int>(); if (DataReader.HasRows) while (DataReader.Read()) temp.Add(DataReader.GetInt16("quiz_id")); for (int i = 0; i < temp.Count; i++) return_data.Add(ReadQuiz(temp[i])); CloseConnection(); return return_data; }
public void RemoveUser(CourseData theCourse, UserData theUser) { if (DataReader != null) DataReader.Close(); SQL = "DELETE FROM `rel_courses_users` WHERE `rel_courses_users`.`course_id` = \"" + theCourse.Id + "\" and `rel_courses_users`.`user_id` = \"" + theUser.Id + "\";"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("Unable to remove the user from the course"); }
/// <summary> /// gets the list of all students in a specified course /// </summary> /// <param name="course">the course to search in</param> /// <returns>list of student in the course</returns> public static List<UserData> GetStudents(CourseData course) { return userEntity.GetStudentsByCourse(course.Id); }
/// <summary> /// Gets a List of courses a given user is enrolled in /// </summary> /// <param name="theUser">a User object that is being queried</param> /// <returns>A List of Course objects</returns> public List<CourseData> ReadCourses(UserData theUser) { List<CourseData> return_data = new List<CourseData>(); if (DataReader != null) DataReader.Close(); SQL = "SELECT * FROM `courses` c INNER JOIN `rel_courses_users` r ON r.`course_id` = c.`course_id` WHERE r.`user_id` = \"" + theUser.ID + "\";"; InitializeCommand(); OpenConnection(); DataReader = Command.ExecuteReader(); if (DataReader.HasRows) { while (DataReader.Read()) { CourseData temp = new CourseData(DataReader.GetUInt16("`course_id`")); temp.Name = DataReader.GetString("`name`"); return_data.Add(temp); } } CloseConnection(); return return_data; }
/// <summary> /// Reads a Course from the database given the CourseName /// </summary> /// <param name="courseName">name of the Course to search</param> /// <returns>A Course object</returns> /// public CourseData ReadCourse(String courseName) { CourseData return_data = null; if (DataReader != null) DataReader.Close(); SQL = "SELECT * FROM `courses` c WHERE c.`name` = \"" + courseName + "\";"; InitializeCommand(); OpenConnection(); DataReader = Command.ExecuteReader(); if (DataReader.HasRows) { DataReader.Read(); return_data = new CourseData(DataReader.GetUInt16("`course_id`")); return_data.Name = DataReader.GetString("`name`"); } CloseConnection(); return return_data; }
/// <summary> /// gets a list of all the quizzes associated with a course from the database /// through the quiz entity /// </summary> /// <param name="course">course to get quizzes in</param> /// <returns></returns> public static List<QuizData> GetQuizzes(CourseData course) { return entity.ReadQuizzes(course); }
private void lvwCourses_ItemActivate(object sender, EventArgs e) { mySelectedCourse = CourseController.getCourse(lvwCourses.SelectedItems[0].Text); this.Dispose(); }
/// <summary> /// Delete a Course from the database /// </summary> /// <param name="theCourse">a Course object to delete from the Database</param> public void DeleteCourse(CourseData theCourse) { }
/// <summary> /// Update a Course on the Database given the Course data /// </summary> /// <param name="theCourse">a Course object of the Course to be updated</param> public void UpdateCourse(CourseData theCourse) { if (DataReader != null) DataReader.Close(); SQL = "UPDATE `courses` c SET c.'name' = \"" + theCourse.Name + "\" WHERE c.`course_id` = \"" + theCourse.Id + "\";"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("Unable to update course information"); }
/// <summary> /// Delete a Course from the database /// </summary> /// <param name="theCourse">a Course object to delete from the Database</param> public void DeleteCourse(CourseData theCourse) { QuizEntity temp = new QuizEntity(); List<QuizData> quizzes = temp.ReadQuizzes(theCourse); for (int i = 0; i < quizzes.Count; i++) temp.DeleteQuiz(quizzes[i]); if (DataReader != null) DataReader.Close(); SQL = "DELETE FROM `courses` WHERE `courses`.`course_id` = \"" + theCourse.Id + "\";"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("Could not delete Course from the database"); }