public void AddCourse(POCO.Course c, ref List<string> errors) { var db_course = new course(); try { db_course.course_level = c.Level; db_course.course_description = c.Description; db_course.course_title = c.Title; this.context.courses.Add(db_course); this.context.SaveChanges(); } catch (Exception e) { errors.Add("Error occured in CourseRepository.AddCourse: " + e); } }
public void AssignPreReqToCourse(int courseId, int preReqCourseId, ref List<string> errors) { course db_coursePreReq = new course(); course_preReq db_preReq = new course_preReq(); try { db_coursePreReq = this.context.courses.Find(preReqCourseId); db_preReq.course_id = courseId; db_preReq.preReq_id = preReqCourseId; db_preReq.preReq_title = db_coursePreReq.course_title; this.context.course_preReq.Add(db_preReq); this.context.SaveChanges(); } catch (Exception e) { errors.Add("Error occured in CourseRepository.AssignPreReqToCourse: " + e); } }
public void RemoveCourse(int course_id, ref List<string> errors) { var db_course = new course(); try { db_course = this.context.courses.Find(course_id); this.context.courses.Remove(db_course); this.context.SaveChanges(); } catch (Exception e) { errors.Add("Error occured in CourseRepository.RemoveCourse: " + e); } }
public List<Course> GetAllPreReqs(int courseId, ref List<string> errors) { List<POCO.Course> pocoCourseList = new List<POCO.Course>(); course db_course = new course(); IEnumerable<course_preReq> db_preReqCourseList; try { db_preReqCourseList = this.context.course_preReq.Where(x => x.course_id == courseId); foreach (course_preReq preReq in db_preReqCourseList) { var tempPoco = new POCO.Course(); var db_Poco = new course(); db_Poco = this.context.courses.Find(preReq.preReq_id); tempPoco.CourseId = db_Poco.course_id; tempPoco.Title = db_Poco.course_title; tempPoco.Description = db_Poco.course_description; tempPoco.Level = db_Poco.course_level; pocoCourseList.Add(tempPoco); } } catch (Exception e) { errors.Add("Error occured in CourseRepository.GetAllPreReqs: " + e); } return pocoCourseList; }