/// <summary> /// Public method that adds a record to the course table. /// </summary> public void CreateCourse(Persistence.Cours course) { try { using (var connection = new Persistence.LHEntities()) { var crs = new Persistence.Cours { Course_Name = course.Course_Name, Syllabus_Course = course.Syllabus_Course, Active_Course = course.Active_Course, Category_Course = course.Category_Course, Passing_Score = course.Passing_Score }; connection.Courses.Add(crs); connection.SaveChanges(); } } catch (DbEntityValidationException e) { var exception = Util.HandleDbEntityValidationException(e); throw exception; } catch (DbUpdateException e) { var exception = Util.HandleDbUpdateException(e); throw exception; } catch (Exception e) { throw new Exception(e.Message); } }/// <summary>
/// <summary> /// Public method that queries the course table from the data base to get the record /// that matches the course id. /// </summary> /// <param name="idCourse"> Course ID, Type INT </param> public void UpdateDBData(int idCourse, Persistence.Cours courseData) { try { using (var connection = new Persistence.LHEntities()) { var course = connection.Courses .Where(crse => crse.Course_ID == idCourse) .FirstOrDefault(); course.Course_Name = courseData.Course_Name; course.Syllabus_Course = courseData.Course_Name; course.Active_Course = courseData.Active_Course; course.Category_Course = courseData.Category_Course; course.Passing_Score = courseData.Passing_Score; connection.SaveChanges(); } } catch (DbEntityValidationException e) { var exception = Util.HandleDbEntityValidationException(e); throw exception; } catch (Exception e) { throw new Exception(e.Message); } }