public void TestGetAllCourses()
{
_reservationContext.Rooms.Add(_testRooms[0]);
_reservationContext.Teachers.Add(_testTeachers[0]);
_reservationContext.SaveChanges();
BlockNrAndRoomAndWeekday d = new BlockNrAndRoomAndWeekday(0, _testRooms[0].RoomId, 1);
List <BlockNrAndRoomAndWeekday> liste = new List <BlockNrAndRoomAndWeekday>();
liste.Add(d);
Course c = new Course
{
BlockAndRoomAndWeekDay = liste,
TeacherId = _testTeachers[0].Id
};
Assert.Equal(0, _reservationContext.Courses.Count());
_reservationContext.Courses.Add(c);
_reservationContext.SaveChanges();
Assert.Equal(1, _reservationContext.Courses.Count());
Clear();
}
public bool AddCourse(DateTime startDate, DateTime endTime, int block,
string teacherId, int room, string nameOfCourse, int dayOfWeek)
{
DateTime dateTimeStart = GetCorrectDatetime(startDate);
DateTime dateTimeEnd = GetCorrectDatetime(endTime);
var blockNrAndRoom = new BlockNrAndRoomAndWeekday(block, room, dayOfWeek);
Course course = new Course
{
StartDate = dateTimeStart,
EndDate = dateTimeEnd,
BlockAndRoomAndWeekDay = new List <BlockNrAndRoomAndWeekday> {
blockNrAndRoom
},
Name = nameOfCourse,
TeacherId = teacherId
};
var c = _reservationContext.Courses.Add(course);
_reservationContext.SaveChanges();
_reservationContext.BlockNrAndRoomAndWeekdays.Find(blockNrAndRoom.Id).CourseId = c.Entity.CourseId;
_reservationContext.SaveChanges();
while (dateTimeStart <= dateTimeEnd)
{
_reservationContext.Add(new Reservation
{
Block = block,
TeacherId = course.TeacherId,
RoomId = room,
Date = dateTimeStart,
CourseId = c.Entity.CourseId
});
dateTimeStart = dateTimeStart.AddDays(7);
_reservationContext.SaveChanges();
}
_reservationContext.SaveChanges();
return(true);
}
public void TestGetCoursesFromTeacher()
{
_reservationContext.Rooms.Add(_testRooms[0]);
_reservationContext.Teachers.Add(_testTeachers[0]);
_reservationContext.SaveChanges();
BlockNrAndRoomAndWeekday d = new BlockNrAndRoomAndWeekday(0, _testRooms[0].RoomId, 1);
List <BlockNrAndRoomAndWeekday> liste = new List <BlockNrAndRoomAndWeekday>();
liste.Add(d);
Course c = new Course
{
BlockAndRoomAndWeekDay = liste,
TeacherId = _testTeachers[0].Id
};
_reservationContext.Courses.Add(c);
_reservationContext.SaveChanges();
Assert.NotNull(_databaseHandler.GetCoursesFromTeacher(_reservationContext.Teachers.First().Id));
Clear();
}
public void TestDeleteCourse()
{
_reservationContext.Rooms.Add(_testRooms[0]);
_reservationContext.Teachers.Add(_testTeachers[0]);
_reservationContext.SaveChanges();
BlockNrAndRoomAndWeekday d = new BlockNrAndRoomAndWeekday(0, _testRooms[0].RoomId, 1);
List <BlockNrAndRoomAndWeekday> liste = new List <BlockNrAndRoomAndWeekday>();
liste.Add(d);
Course c = new Course
{
BlockAndRoomAndWeekDay = liste,
TeacherId = _testTeachers[0].Id
};
_reservationContext.Courses.Add(c);
_reservationContext.SaveChanges();
Assert.Equal(true, _databaseHandler.DeleteCourse(_reservationContext.Courses.First().CourseId));
Assert.Equal(0, _reservationContext.Courses.Count());
Clear();
}
