/// <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);
}
}
