public void UpdateLecturer(Lecturer lecturer) { using (var context = new StudyContext()) { context.Lecturers.Update(lecturer); context.SaveChanges(); } }
public void UpdateStudent(Student student) { using (var context = new StudyContext()) { context.Students.Update(student); context.SaveChanges(); } }
public void UpdateCourse(Course course) { using (var context = new StudyContext()) { context.Courses.Update(course); context.SaveChanges(); } }
public void UpdateHomeTask(HomeTask homeTask) { using (var context = new StudyContext()) { context.HomeTasks.Update(homeTask); context.SaveChanges(); } }
public void DeleteHomeTask(int homeTaskId) { using (var context = new StudyContext()) { var homeTask = context.HomeTasks.Find(homeTaskId); context.HomeTasks.Remove(homeTask); context.SaveChanges(); } }
public void DeleteCourse(int courseId) { using (var context = new StudyContext()) { var course = context.Courses.Find(courseId); context.Courses.Remove(course); context.SaveChanges(); } }
public Student CreateStudent(Student student) { using (var context = new StudyContext()) { context.Students.Add(student); context.SaveChanges(); } return(student); }
public Lecturer CreateLecturer(Lecturer lecturer) { using (var context = new StudyContext()) { context.Lecturers.Add(lecturer); context.SaveChanges(); } return(lecturer); }
public Course CreateCourse(Course course) { using (var context = new StudyContext()) { context.Courses.Add(course); context.SaveChanges(); } return(course); }
public void DeleteStudent(int studentId) { using (var context = new StudyContext()) { var student = context.Students.Find(studentId); context.Students.Remove(student); context.SaveChanges(); } }
public void DeleteLecturer(int lecturerId) { using (var context = new StudyContext()) { var lecturer = context.Lecturers.Find(lecturerId); context.Lecturers.Remove(lecturer); context.SaveChanges(); } }
public void UpdateHomeTaskAssessments(List <HomeTaskAssessment> homeTaskHomeTaskAssessments) { using (var context = new StudyContext()) { foreach (var homeTaskAssessment in homeTaskHomeTaskAssessments) { context.HomeTaskAssessments.Update(homeTaskAssessment); } context.SaveChanges(); } }
public HomeTask CreateHomeTask(HomeTask homeTask, int courseId) { using (var context = new StudyContext()) { context.HomeTasks.Add(new HomeTask { Title = homeTask.Title, Date = homeTask.Date, Description = homeTask.Description, Number = homeTask.Number, CourseId = courseId }); context.SaveChanges(); } return(homeTask); }
public void CreateHomeTaskAssessments(List <HomeTaskAssessment> homeTaskAssessments) { using (var context = new StudyContext()) { foreach (var assessment in homeTaskAssessments) { context.HomeTaskAssessments.Add(new HomeTaskAssessment { Date = assessment.Date, HomeTaskId = assessment.HomeTaskId, StudentId = assessment.StudentId, IsComplete = assessment.IsComplete }); } context.SaveChanges(); } }
public void SetStudentsToCourse(int courseId, IEnumerable <int> studentsId) { List <CourseStudent> courseStudents = new List <CourseStudent>(); using (var context = new StudyContext()) { courseStudents = context.CourseStudents.Where(p => p.CourseId == courseId).ToList(); foreach (var courseStudent in courseStudents) { context.CourseStudents.Remove(courseStudent); } foreach (var studentId in studentsId) { context.CourseStudents.Add(new CourseStudent { CourseId = courseId, StudentId = studentId }); } context.SaveChanges(); } }
public void SetLecturersToCourse(int courseId, IEnumerable <int> lecturerIds) { List <CourseLecturer> courseLecturers = new List <CourseLecturer>(); using (var context = new StudyContext()) { courseLecturers = context.CourseLecturers.Where(p => p.CourseId == courseId).ToList(); foreach (var courseLecturer in courseLecturers) { context.CourseLecturers.Remove(courseLecturer); } foreach (var lecturerId in lecturerIds) { context.CourseLecturers.Add(new CourseLecturer { CourseId = courseId, LecturerId = lecturerId }); } context.SaveChanges(); } }