public CourseModel UpdateCourse(CourseModel courseModel) { var resultSP = DB.UpdateCourse(courseModel.courseCode, courseModel.courseName).Select(c => new CourseModel { courseCode = c.courseCode, courseName = c.courseName }); if (GlobalVariable.queryType == 0) { COURS course = DB.COURSES.Where(c => c.courseCode.Equals(courseModel.courseCode)).SingleOrDefault(); if (course == null) { return(null); } course.courseCode = courseModel.courseCode; course.courseName = courseModel.courseName; DB.SaveChanges(); return(GetOneCourseByCode(course.courseCode)); } else { return(resultSP.SingleOrDefault()); } }
public int DeleteCourse(string courseCode) { var resultSP = DB.DeleteCourse(courseCode); if (GlobalVariable.queryType == 0) { COURS course = DB.COURSES.Where(c => c.courseCode.Equals(courseCode)).SingleOrDefault(); DB.COURSES.Attach(course); if (course == null) { return(0); } DB.COURSES.Remove(course); DB.SaveChanges(); return(1); } else { return(resultSP); } }
public CourseModel AddCourse(CourseModel courseModel) { var resultSP = DB.AddCourse(courseModel.courseCode, courseModel.courseName).Select(c => new CourseModel { courseCode = c.courseCode, courseName = c.courseName }); if (GlobalVariable.queryType == 0) { COURS course = new COURS { courseCode = courseModel.courseCode, courseName = courseModel.courseName }; DB.COURSES.Add(course); DB.SaveChanges(); return(GetOneCourseByCode(course.courseCode)); } else { return(resultSP.SingleOrDefault()); } }