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