public void GetById_ShouldReturnNull_WhenWrongId()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
// Act
var employee = repo.GetById(999);
// Assert
Assert.Null(employee);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByMarkId_ShouldReturnEmptyArray_WhenWrongDepartmentId()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
// Act
var employees = repo.GetAllByDepartmentId(999);
// Assert
Assert.Empty(employees);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByDepartmentIdAndPosition_ShouldReturnEmptyArray_WhenWrongDepartmentId()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
var positionId = _rnd.Next(1, TestData.positions.Count());
// Act
var employees = repo.GetAllByDepartmentIdAndPosition(999, positionId);
// Assert
Assert.Empty(employees);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByDepartmentIdAndPositions_ShouldReturnEmptyArray_WhenWrongDepartmentId()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
// Act
var employees = repo.GetAllByDepartmentIdAndPositions(999, 1, 2);
var employees2 = repo.GetAllByDepartmentIdAndPositions(999, new int[] { 1, 2 });
// Assert
Assert.Empty(employees);
Assert.Empty(employees2);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByDepartmentId_ShouldReturnEmployees()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
var departmentId = _rnd.Next(1, TestData.departments.Count());
// Act
var employees = repo.GetAllByDepartmentId(departmentId);
// Assert
Assert.Equal(TestData.employees.Where(
v => v.Department.Id == departmentId), employees);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetById_ShouldReturnEmployee()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
int id = _rnd.Next(1, TestData.employees.Count());
// Act
var employee = repo.GetById(id);
// Assert
Assert.Equal(TestData.employees.SingleOrDefault(v => v.Id == id),
employee);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByDepartmentIdAndPositions_ShouldReturnEmployees()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
var departmentId = _rnd.Next(1, TestData.departments.Count());
var positionIds = new int[] { 1, 2 };
// Act
var employees = repo.GetAllByDepartmentIdAndPositions(departmentId, positionIds);
// Assert
Assert.Equal(TestData.employees.Where(
v => v.Department.Id == departmentId && positionIds.Contains(v.Position.Id)), employees);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByDepartmentIdAndPositions_ShouldReturnEmployees()
{
// Arrange
var context = GetContext(TestData.employees);
var repo = new SqlEmployeeRepo(context);
var departmentId = _rnd.Next(1, TestData.departments.Count());
// Act
var employees = repo.GetAllByDepartmentIdAndPositions(departmentId, 1, 2);
var employees2 = repo.GetAllByDepartmentIdAndPositions(departmentId, new int[] { 1, 2 });
// Assert
Assert.Equal(TestData.employees.Where(
v => v.Department.Id == departmentId && v.Position.Id >= 1 && v.Position.Id <= 2 && v.IsActive), employees);
Assert.Equal(TestData.employees.Where(
v => v.Department.Id == departmentId && (v.Position.Id == 1 || v.Position.Id == 2) && v.IsActive), employees2);
context.Database.EnsureDeleted();
context.Dispose();
}
