public async System.Threading.Tasks.Task StudentsGetSuccesfull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetStudents");
var data = new List <Student>
{
new Student()
{
Id = 1
},
new Student()
{
Id = 2
},
new Student()
{
Id = 3
}
};
context.Students.AddRange(data);
context.SaveChanges();
var cont = new StudentsController(context);
//Act
var result = await cont.GetStudents();
var resValue = result.Value;
var resResult = result.Result;
//Assert
Assert.Equal(data, resValue);
Assert.Null(resResult);
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task QuestionnairesByStudentGetSuccesfull()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetQByStudents");
var q1 = new Questionnaire()
{
Id = 3, StudentId = 0, ClassId = 0
};
var q2 = new Questionnaire()
{
Id = 1, StudentId = 1, ClassId = 0
};
var q3 = new Questionnaire()
{
Id = 2, StudentId = 1, ClassId = 1
};
var correctData = new List <Questionnaire>
{
q2, q3
};
context.Questionnaires.Add(q1);
context.Questionnaires.Add(q2);
context.Questionnaires.Add(q3);
context.SaveChanges();
var qController = new QuestionnaireController(context);
//Act
var result = await qController.GetQuestionnairesByStudent(new QuestionnaireController.QuestionnaireIdentityArgs {
ClassId = 0, StudentId = 1
});
var resValue = result.Value;
//Assert
Assert.Equal(correctData, resValue);
}
public async System.Threading.Tasks.Task GetClassNotFound()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetClassFailed");
var data = new List <Class>
{
new Class()
{
Id = 1
},
new Class()
{
Id = 2
}
};
context.Classes.AddRange(data);
context.SaveChanges();
var controller = new ClassesController(context);
//Act
var result = await controller.GetClass(id : 3);
//Assert
Assert.IsType <NotFoundResult>(result.Result);
Assert.Null(result.Value);
}
public async System.Threading.Tasks.Task GetAllSubjectsSuccesfull()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetSubjects");
var data = new List <Subject>
{
new Subject()
{
Id = 1
},
new Subject()
{
Id = 2
}
};
context.Subjects.AddRange(data);
context.SaveChanges();
var controller = new SubjectsController(context);
//Act
var result = await controller.GetSubjects();
var resValue = result.Value;
var resResult = result.Result;
//Assert
Assert.Equal(data, resValue);
}
public async System.Threading.Tasks.Task GetClassSuccesfull()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetClass");
var data = new List <Class>
{
new Class()
{
Id = 1
},
new Class()
{
Id = 2
}
};
context.Classes.AddRange(data);
context.SaveChanges();
var controller = new ClassesController(context);
//Act
var result = await controller.GetClass(id : 1);
var resValue = result.Value;
//Assert
Assert.Equal(data[0], resValue);
}
public async System.Threading.Tasks.Task GetTeacherClasses()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetTeacherClasses");
var data = new List <Class>
{
new Class()
{
Id = 1, TeacherId = 1
},
new Class()
{
Id = 2, TeacherId = 1
},
new Class()
{
Id = 3, TeacherId = 2
}
};
context.Classes.AddRange(data);
context.SaveChanges();
var controller = new ClassesController(context);
//Act
var result = await controller.TeacherClasses(Id : 1);
var resValue = result.Value;
//Assert
Assert.Equal(data.Where(x => x.TeacherId == 1), result.Value);
}
public async System.Threading.Tasks.Task QuestionnaireGetSuccesfull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetQ");
var data = new List <Questionnaire>
{
new Questionnaire()
{
Id = 0, StudentId = 0, ClassId = 0
},
new Questionnaire()
{
Id = 1, StudentId = 1, ClassId = 0
}
};
context.Questionnaires.Add(data[0]);
context.SaveChanges();
var qController = new QuestionnaireController(context);
//Act
var result = await qController.GetQuestionnaire(new QuestionnaireController.QuestionnaireIdentityArgs {
ClassId = 0, StudentId = 0
});
var resValue = result.Value;
var resResult = result.Result;
//Assert
Assert.Equal(data.First(), resValue);
}
public async System.Threading.Tasks.Task GetTeacherByIdSuccesfull()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetTeacherById");
var data = new List <Teacher>
{
new Teacher()
{
Id = 1
},
new Teacher()
{
Id = 2
},
new Teacher()
{
Id = 3
}
};
context.Teachers.AddRange(data);
context.SaveChanges();
var contr = new TeachersController(context);
//Act
var result = await contr.Get(1);
var resValue = result.Value;
var resResult = result.Result;
//Assert
Assert.Equal(data[0], resValue);
Assert.Null(resResult);
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task TestDeleteClass_NotFound_OnEmptySet()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("DeleteClassSuccefull");
var controller = new ClassesController(context);
//Act
var result = await controller.DeleteClass(44);
//Assert
Assert.IsType <NotFoundResult>(result);
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task TestPutStudent_BadRequest()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabasePutStudentBadRequest");
var contr = new StudentsController(context);
//Act
var result = await contr.PutStudent(2, new Student { Id = 1 });
//Assert
Assert.IsType <BadRequestResult>(result);
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task TeachersSuccefull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetTeachersFaculties");
var faculties = new List <Faculty>
{
new Faculty()
{
Id = 1
},
new Faculty()
{
Id = 2
}
};
var teachers = new List <Teacher>
{
new Teacher()
{
Id = 1, FacultyId = 1
},
new Teacher()
{
Id = 2, FacultyId = 1
},
new Teacher()
{
Id = 3, FacultyId = 2
},
new Teacher()
{
Id = 4, FacultyId = 3
},
};
context.Faculties.AddRange(faculties);
context.Teachers.AddRange(teachers);
context.SaveChanges();
var controller = new FacultiesController(context);
//Act
var result = await controller.Teachers();
var resAsOk = result as OkObjectResult;
var expectedResult = teachers
.GroupBy(entry => entry.FacultyId)
.Select(g => new FacultyTeachersTestClass(g.Key, g.Select(t => new TeacherTestClass(t.Id, t.Name))))
.OrderBy(obj => obj.facultyId);
//Assert
Assert.IsType <OkObjectResult>(result);
}
public async System.Threading.Tasks.Task StudentsGetByClassSuccesfull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetStudentsByClass");
var qs = new List <Questionnaire>
{
new Questionnaire()
{
StudentId = 1, ClassId = 1
},
new Questionnaire()
{
StudentId = 2, ClassId = 1
},
new Questionnaire()
{
StudentId = 3, ClassId = 0
},
};
var data = new List <Student>
{
new Student()
{
Id = 1
},
new Student()
{
Id = 2
},
new Student()
{
Id = 3
}
};
context.Questionnaires.AddRange(qs);
context.Students.AddRange(data);
context.SaveChanges();
var cont = new StudentsController(context);
//Act
var result = await cont.GetStudentsByClass(new Questionnaire { ClassId = 1, StudentId = 1 });
var resValue = result.Value;
var resResult = result.Result;
//Assert
Assert.Equal(data.Where(st => st.Id != 3), resValue);
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task TestPostClass_Succesfull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("PostClassSuccefull");
var testEntity = new Class()
{
Id = 42
};
var controller = new ClassesController(context);
//Act
var result = await controller.PostClass(testEntity);
//Assert
Assert.IsType <CreatedAtActionResult>(result.Result);
Assert.Equal(testEntity, context.Classes.Last());
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task QuestionnairePostAlreadyPresent()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("PostContext1");
var testEntity = new Questionnaire()
{
Id = 0, StudentId = 0, ClassId = 0
};
context.Questionnaires.Add(testEntity);
context.SaveChanges();
//mockDbContext.Setup(x => x.Questionnaires).Returns(DbContextMock.GetQueryableMockDbSet(questionnaireList));
var qController = new QuestionnaireController(context);
//Act
var result = await qController.PostQuestionnaire(testEntity);
//Assert
Assert.IsType <ConflictResult>(result.Result);
}
public async System.Threading.Tasks.Task TestDeleteClass_NotFound_OnWrongId()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("DeleteClassSuccefull");
var testEntity = new Class()
{
Id = 42
};
context.Classes.Add(testEntity);
context.SaveChanges();
var controller = new ClassesController(context);
//Act
var result = await controller.DeleteClass(44);
//Assert
Assert.IsType <NotFoundResult>(result);
Assert.True(context.Classes.Contains(testEntity));
Assert.Equal(1, context.Classes.Where(x => x.Id == 42).Count());
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task TestDeleteSubject_Succesfull()
{
//Arrange
var context = TestingUtilities.CreateInMemoryDatabaseContext("DeleteSubjectSuccefull");
var testEntity = new Subject()
{
Id = 42
};
context.Subjects.Add(testEntity);
context.SaveChanges();
var controller = new SubjectsController(context);
//Act
var result = await controller.DeleteSubject(42);
//Assert
Assert.IsType <NoContentResult>(result);
Assert.False(context.Subjects.Contains(testEntity));
Assert.Equal(0, context.Subjects.Where(x => x.Id == 42).Count());
context.Database.EnsureDeleted();
}
public async System.Threading.Tasks.Task GetFacultiesSuccessfull()
{
var context = TestingUtilities.CreateInMemoryDatabaseContext("TestDatabaseGetFaculties");
var faculties = new List <Faculty>
{
new Faculty()
{
Id = 1
},
new Faculty()
{
Id = 2
}
};
var teachers = new List <Teacher>
{
new Teacher()
{
Id = 1, FacultyId = 1
},
new Teacher()
{
Id = 2, FacultyId = 1
},
new Teacher()
{
Id = 3, FacultyId = 2
},
new Teacher()
{
Id = 4, FacultyId = 3
},
};
context.Faculties.AddRange(faculties);
context.Teachers.AddRange(teachers);
context.SaveChanges();
var controller = new FacultiesController(context);
var groupedList = teachers
.GroupBy(entry => entry.FacultyId)
.Select(g => new
{
FacultyId = g.Key,
Teachers = g.Select(t => new { Id = t.Id, Name = t.Name, Surname = t.Surname })
})
.OrderBy(obj => obj.FacultyId)
.ToList();
var expectedResult = faculties
.ToList()
.OrderBy(f => f.Id)
.Select((faculty, index) => {
return(new
{
Name = faculty.Name,
Id = faculty.Id,
facultyTeachers = groupedList[index].Teachers.ToList()
});
})
.ToList();
//Act
var result = await controller.GetFaculties();
var resAsOk = result as OkObjectResult;
//Assert
Assert.IsType <OkObjectResult>(result);
//Assert.Equal(expectedResult, resAsOk.Value);
}
