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