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