public List <Student> GetStudentsByCourseId(int courseId) { List <Student> result = new List <Student>(); using (var context = new StudyContext()) { IEnumerable <Student> k = from s in context.Students join c in context.CourseStudents on s.StudentId equals c.StudentId where c.CourseId == courseId select new Student { Name = s.Name, PhoneNumber = s.PhoneNumber, Email = s.Email, StudentId = s.StudentId, BirthDate = s.BirthDate, GitHubLink = s.GitHubLink, Notes = s.Notes, CourseStudents = s.CourseStudents, HomeTaskAssessments = s.HomeTaskAssessments }; result = k.ToList(); } return(result); }
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 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 DeleteCourse(int courseId) { using (var context = new StudyContext()) { var course = context.Courses.Find(courseId); context.Courses.Remove(course); 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 DeleteHomeTask(int homeTaskId) { using (var context = new StudyContext()) { var homeTask = context.HomeTasks.Find(homeTaskId); context.HomeTasks.Remove(homeTask); context.SaveChanges(); } }
public void DeleteStudent(int studentId) { using (var context = new StudyContext()) { var student = context.Students.Find(studentId); context.Students.Remove(student); context.SaveChanges(); } }
public Student CreateStudent(Student student) { using (var context = new StudyContext()) { context.Students.Add(student); context.SaveChanges(); } return(student); }
public Course CreateCourse(Course course) { using (var context = new StudyContext()) { context.Courses.Add(course); context.SaveChanges(); } return(course); }
public Lecturer CreateLecturer(Lecturer lecturer) { using (var context = new StudyContext()) { context.Lecturers.Add(lecturer); context.SaveChanges(); } return(lecturer); }
public Lecturer GetLecturerById(int id) { Lecturer result = new Lecturer(); using (var context = new StudyContext()) { result = context.Lecturers.Find(id); } return(result); }
public Course GetCourse(int id) { Course result = new Course(); using (var context = new StudyContext()) { result = context.Courses.Find(id); } return(result); }
public Student GetStudentById(int id) { Student result = new Student(); using (var context = new StudyContext()) { result = context.Students.Find(id); } return(result); }
public List <Student> GetAllStudents() { List <Student> result = new List <Student>(); using (var context = new StudyContext()) { result = context.Students.ToList(); } return(result); }
public HomeTask GetHomeTaskById(int id) { HomeTask result = new HomeTask(); using (var context = new StudyContext()) { result = context.HomeTasks.Find(id); } return(result); }
public List <Course> GetAllCourses() { List <Course> result = new List <Course>(); using (var context = new StudyContext()) { result = context.Courses.ToList(); } return(result); }
public List <Lecturer> GetAllLecturers() { List <Lecturer> result = new List <Lecturer>(); using (var context = new StudyContext()) { result = context.Lecturers.ToList(); } return(result); }
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 List <HomeTaskAssessment> GetHomeTaskAssessmentsByHomeTaskId(int homeTaskId) { List <HomeTaskAssessment> result = new List <HomeTaskAssessment>(); using (var context = new StudyContext()) { IEnumerable <HomeTaskAssessment> k = from h in context.HomeTaskAssessments where h.HomeTask.HomeTaskId == homeTaskId select new HomeTaskAssessment { Date = h.Date, HomeTask = h.HomeTask, HomeTaskAssessmentId = h.HomeTaskAssessmentId, IsComplete = h.IsComplete, Student = h.Student }; result = k.ToList(); } return(result); }
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(); } }
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(); } }
static void Main(string[] args) { using (var context = new StudyContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); } EFRepository eFRepository = new EFRepository(); Course course = eFRepository.CreateCourse(new Course { Name = "C#", StartDate = new DateTime(2019, 6, 13), EndDate = new DateTime(2019, 8, 13) }); Course course1 = eFRepository.CreateCourse(new Course { Name = "C++", StartDate = new DateTime(2019, 6, 13), EndDate = new DateTime(2019, 8, 13) }); HomeTask homeTask = eFRepository.CreateHomeTask(new HomeTask { Title = "Ho", Date = new DateTime(2019, 7, 13), Description = "Yop", Number = 2, CourseId = 2 }, 1); Student student = eFRepository.CreateStudent(new Student { Name = "Lukiian", PhoneNumber = "0971252805", Email = "*****@*****.**" }); Student student1 = eFRepository.CreateStudent(new Student { Name = "Vlad", PhoneNumber = "0971250430", Email = "*****@*****.**" }); Student student2 = eFRepository.CreateStudent(new Student { Name = "Klymko", PhoneNumber = "0971255040", Email = "*****@*****.**" }); Lecturer lecturer = eFRepository.CreateLecturer(new Lecturer { Name = "Oles", BirthDate = new DateTime(1978, 10, 21) }); Lecturer lecturer1 = eFRepository.CreateLecturer(new Lecturer { Name = "Taras", BirthDate = new DateTime(1992, 10, 12) }); List <HomeTaskAssessment> homeTaskAssessments = new List <HomeTaskAssessment>() { new HomeTaskAssessment { Date = new DateTime(2019, 06, 21), IsComplete = false, StudentId = 2, HomeTaskId = 1 }, new HomeTaskAssessment { Date = new DateTime(2019, 06, 21), IsComplete = true, StudentId = 1, HomeTaskId = 1 } }; eFRepository.CreateHomeTaskAssessments(homeTaskAssessments); List <Course> listCourses = eFRepository.GetAllCourses(); List <Student> listStudents = eFRepository.GetAllStudents(); List <Lecturer> listLecturers = eFRepository.GetAllLecturers(); Course getCourse = eFRepository.GetCourse(2); List <HomeTaskAssessment> homeTaskAssessment = eFRepository.GetHomeTaskAssessmentsByHomeTaskId(homeTask.HomeTaskId); HomeTask homeTask1 = eFRepository.GetHomeTaskById(1); Lecturer lecturer2 = eFRepository.GetLecturerById(2); Student student3 = eFRepository.GetStudentById(2); int[] studentsID = new int[] { 1, 3 }; int[] studentsID1 = new int[] { 1, 2, 3 }; eFRepository.SetStudentsToCourse(1, studentsID); eFRepository.SetStudentsToCourse(2, studentsID1); int[] lecturersID = new int[] { 1, 2 }; int[] lecturersID1 = new int[] { 1 }; eFRepository.SetLecturersToCourse(1, lecturersID); eFRepository.SetLecturersToCourse(2, lecturersID1); var l = eFRepository.GetStudentsByCourseId(1); var l1 = eFRepository.GetStudentsByCourseId(2); eFRepository.UpdateCourse(new Course { CourseId = 2, Name = "JAVA", StartDate = new DateTime(2019, 6, 13), EndDate = new DateTime(2019, 8, 13) }); eFRepository.UpdateHomeTask(new HomeTask { HomeTaskId = 1, Title = "HomeTaskUpdated", Date = new DateTime(2019, 7, 13), Description = "Yop", Number = 2, CourseId = 2 }); homeTaskAssessments[0].IsComplete = true; homeTaskAssessments[0].HomeTaskAssessmentId = 1; homeTaskAssessments[1].HomeTaskAssessmentId = 2; eFRepository.UpdateHomeTaskAssessments(homeTaskAssessments); eFRepository.UpdateLecturer(new Lecturer { LecturerId = 2, Name = "Lukiian", BirthDate = new DateTime(1992, 10, 12) }); eFRepository.UpdateStudent(new Student { StudentId = 2, Name = "Ostap", PhoneNumber = "0971250430", Email = "*****@*****.**" }); eFRepository.DeleteCourse(1); eFRepository.DeleteStudent(3); eFRepository.DeleteLecturer(2); eFRepository.DeleteHomeTask(1); }