public List <StudentModel> GetAllStudents() { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.Students.Select(_mapper.MapStudentEntityToStudentModel).ToList()); } }
public void CreateNewContext_CreateContext_NotNull() { using (var dbTest = new CourseEvaluationContext()) { Assert.IsNotNull(dbTest); } }
public CourseModel GetCourseModelFromCourseBasicModel(CourseBasicModel basicModel) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(GetCourseById(basicModel.Id)); } }
public List <TeacherModel> GetAllTeachers() { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.Teachers.Select(_mapper.MapTeacherEntityToTeacherModel).ToList()); } }
public void AssignPointToStudent_AssignedPoints_PointsAssigned() { using (var dbTest = new CourseEvaluationContext()) { var enrolledCourse = new EnrolledCourseEntity(); var student = _data.Xmensi03; var points = 15; var rating1 = new AssessmentRatingEntity() { Points = points, Type = AssessmentType.Examination }; enrolledCourse.Assessments.Add(rating1); student.EnrolledCourses.Add(enrolledCourse); dbTest.Students.Add(student); var assignedPoints = dbTest .Students .Single(n => n.Login == student.Login) .EnrolledCourses .First() .Assessments .First() .Points; Assert.AreEqual(points, assignedPoints); enrolledCourse.Assessments.Remove(rating1); student.EnrolledCourses.Remove(enrolledCourse); dbTest.Students.Remove(student); } }
public StudentModel GetStudentModelFromStudentBasicModel(StudentBasicModel basicModel) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(GetStudentById(basicModel.Id)); } }
public List <CourseModel> GetAllCourses() { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.Courses.Select(_mapper.MapCourseEntityToCourseModel).ToList()); } }
public TeacherModel FindTeacherByLogin(string login) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return (courseEvaluationContext.Teachers.Where(r => r.Login == login).Select(_mapper.MapTeacherEntityToTeacherModel).First()); } }
public void FindNonExistingStudent_FindStudent_False() { using (var dbTest = new CourseEvaluationContext()) { var student = dbTest.Students.Select(n => n.Login == "xnikdo06").SingleOrDefault(); Assert.IsFalse(student); } }
public StudentModel FindStudentByLogin(string login) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return (courseEvaluationContext.Students.Where(r => r.Login == login).Select(_mapper.MapStudentEntityToStudentModel).First()); } }
public TeacherModel GetTeacherById(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(_mapper.MapTeacherEntityToTeacherModel( courseEvaluationContext.Teachers .FirstOrDefault(s => s.Id == id))); } }
public bool IsStudentEnrolledInCourse(Guid StudentId, Guid CourseId) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.EnrolledCourses .FirstOrDefault(s => s.StudentId == StudentId && s.CourseId == CourseId) != null); } }
public StudentModel GetStudentById(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(_mapper.MapStudentEntityToStudentModel( courseEvaluationContext.Students .FirstOrDefault(s => s.Id == id))); } }
public List <StudentBasicModel> GetAllStudentsAssignedToCourse(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.Students .Where(s => s.EnrolledCourses.Any(e => e.CourseId == id)) .Select(_mapper.MapStudentEntityToStudentBasicModel).ToList()); } }
public CourseModel GetCourseById(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(_mapper.MapCourseEntityToCourseModel( courseEvaluationContext.Courses .FirstOrDefault(c => c.Id == id))); } }
public AssessmentRatingModel GetAssessmentById(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(_mapper.MapAssessmentRatingEntityToAssessmentRatingModel( courseEvaluationContext.AssessmentRatings .FirstOrDefault(a => a.Id == id))); } }
public List <AssessmentRatingModel> GetAllRatingsAssignedToStudent(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(courseEvaluationContext.AssessmentRatings .Where(s => s.EnrolledCourse.StudentId == id) .Select(_mapper.MapAssessmentRatingEntityToAssessmentRatingModel).ToList()); } }
public CourseModel GetCourseByAbbreviation(string abbreviation) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(_mapper.MapCourseEntityToCourseModel( courseEvaluationContext.Courses .FirstOrDefault(c => c.Abbreviation == abbreviation))); } }
public void AddCourseToDB_AddCourse_Added() { using (var dbTest = new CourseEvaluationContext()) { dbTest.Courses.Add(_data.Iw1); var course = dbTest.Courses.Where(n => n.Abbreviation == _data.Iw1.Abbreviation).Select(n => n.Abbreviation).ToList(); Assert.IsTrue(course.Any()); dbTest.Courses.Remove(_data.Iw1); } }
public void AddStudentToDB_AddStudent_Added() { using (var dbTest = new CourseEvaluationContext()) { dbTest.Students.Add(_data.Xmensi03); var students = dbTest.Students.Where(n => n.Login == _data.Xmensi03.Login).Select(n => n.Login).ToList(); Assert.IsTrue(students.Any()); dbTest.Students.Remove(_data.Xmensi03); } }
public EnrolledCourseModel GetEnrolledCourse(Guid StudentId, Guid CourseId) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(StudentId == Guid.Empty || StudentId == null || CourseId == Guid.Empty || CourseId == null ? new EnrolledCourseModel() : courseEvaluationContext.EnrolledCourses .Select(_mapper.MapEnrolledCourseEntityToEnrolledCourseModel) .FirstOrDefault(s => s.StudentId == StudentId && s.CourseId == CourseId)); } }
public List <AssessmentRatingModel> GetAllAssessmentsFromEnrolledCourse(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { return(id == null || id == Guid.Empty ? new List <AssessmentRatingModel>() : courseEvaluationContext.AssessmentRatings .Where(a => a.EnrolledCourseId == id) .Select(_mapper.MapAssessmentRatingEntityToAssessmentRatingModel) .ToList()); } }
public void RemoveAssessment(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = new AssessmentRatingEntity() { Id = id }; courseEvaluationContext.AssessmentRatings.Attach(entity); courseEvaluationContext.AssessmentRatings.Remove(entity); courseEvaluationContext.SaveChanges(); } }
public void UpdateAssessment(AssessmentRatingModel assessment) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = courseEvaluationContext.AssessmentRatings.First(a => a.Id == assessment.Id); entity.Type = assessment.Type; entity.Points = assessment.Points; entity.Note = assessment.Note; courseEvaluationContext.SaveChanges(); } }
public AssessmentRatingModel InsertAssessment(AssessmentRatingModel assessment) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = _mapper.MapAssessmentRatingModelToAssessmentRatingEntity(assessment); entity.Id = Guid.NewGuid(); courseEvaluationContext.AssessmentRatings.Add(entity); courseEvaluationContext.SaveChanges(); return(_mapper.MapAssessmentRatingEntityToAssessmentRatingModel(entity)); } }
public StudentModel InsertStudent(StudentModel student) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = _mapper.MapStudentModelToStudentEntity(student); entity.Id = Guid.NewGuid(); courseEvaluationContext.Students.Add(entity); courseEvaluationContext.SaveChanges(); return(_mapper.MapStudentEntityToStudentModel(entity)); } }
public void RemoveStudent(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = new StudentEntity() { Id = id }; courseEvaluationContext.Students.Attach(entity); courseEvaluationContext.Students.Remove(entity); courseEvaluationContext.SaveChanges(); } }
public CourseModel InsertCourse(CourseModel course) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = _mapper.MapCourseModelToCourseEntity(course); entity.Id = Guid.NewGuid(); courseEvaluationContext.Courses.Add(entity); courseEvaluationContext.SaveChanges(); return(_mapper.MapCourseEntityToCourseModel(entity)); } }
public TeacherModel InsertTeacher(TeacherModel teacher) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = _mapper.MapTeacherModelToTeacherEntity(teacher); entity.Id = Guid.NewGuid(); courseEvaluationContext.Teachers.Add(entity); courseEvaluationContext.SaveChanges(); return(_mapper.MapTeacherEntityToTeacherModel(entity)); } }
public void RemoveTeacher(Guid id) { using (var courseEvaluationContext = new CourseEvaluationContext()) { var entity = new TeacherEntity() { Id = id }; courseEvaluationContext.Teachers.Attach(entity); courseEvaluationContext.Teachers.Remove(entity); courseEvaluationContext.SaveChanges(); } }