public Task <IEnumerable <EmployeeManagerModel> > Handle(EmployeesWithManagersQuery request, CancellationToken cancellationToken)
{
var sql = @"
SELECT e.EmployeeId as EmployeeId, e.FirstName as EmployeeFirstName, e.LastName as EmployeeLastName, e.Title as EmployeeTitle,
m.EmployeeId as ManagerId, m.FirstName as ManagerFirstName, m.LastName as ManagerLastName, m.Title as ManagerTitle
FROM employees AS e
JOIN employees AS m ON e.ReportsTo = m.EmployeeID
WHERE e.ReportsTo is not null";
return(_context.Database.GetDbConnection().QueryAsync <EmployeeManagerModel>(sql));
}
public async Task ShouldReturnReport()
{
var context = GetDbContext(useSqlLite: true);
NorthwindInitializer.Initialize(context);
var query = new EmployeesWithManagersQuery();
var queryHandler = new EmployeesWithManagersQueryHandler(context);
var result = await queryHandler.Handle(query, CancellationToken.None);
Assert.NotEmpty(result);
Assert.Equal(8, result.Count());
Assert.Contains(result, r => r.ManagerTitle == "Vice President, Sales");
Assert.DoesNotContain(result, r => r.EmployeeTitle == "Vice President, Sales");
}
public async Task ShouldReturnReport()
{
UseSqlite();
var context = GetDbContext();
NorthwindInitializer.Initialize(context);
var command = new EmployeesWithManagersQuery(context);
var result = await command.Execute();
Assert.IsNotNull(result);
Assert.AreEqual(result.Count(), 8);
Assert.IsTrue(result.Any(c => c.ManagerTitle == "Vice President, Sales"));
Assert.IsFalse(result.Any(c => c.EmployeeTitle == "Vice President, Sales"));
}
public async Task ShouldReturnReport()
{
UseSqlite();
using (var context = GetDbContext())
{
// Arrange
// Use same seed data as production.
NorthwindInitializer.Initialize(context);
var query = new EmployeesWithManagersQuery(context);
// Act
var result = await query.Execute();
// Assert
Assert.NotEmpty(result);
Assert.Equal(8, result.Count());
Assert.Contains(result, r => r.ManagerTitle == "Vice President, Sales");
Assert.DoesNotContain(result, r => r.EmployeeTitle == "Vice President, Sales");
}
}
