public QuickForecasterDbContext Build()
{
var options = new DbContextOptionsBuilder <QuickForecasterDbContext>()
.UseInMemoryDatabase(databaseName: _dbName)
.EnableSensitiveDataLogging(true)
.Options;
var context = new QuickForecasterDbContext(options);
context.Database.EnsureCreated();
if (_clients != null && _clients.Count > 0)
{
context.Clients.AddRange(_clients.ToArray());
context.SaveChanges();
}
if (_estimats != null && _estimats.Count > 0)
{
context.Estimates.AddRange(_estimats.ToArray());
context.SaveChanges();
}
if (_backlogItems != null && _backlogItems.Count > 0)
{
context.BacklogItems.AddRange(_backlogItems.ToArray());
context.SaveChanges();
}
return(context);
}
public void SpGetStatsByComplexity_WithExistingBacklogItems_ReturnsAggregatedData()
{
var optionsBuilder = new DbContextOptionsBuilder <QuickForecasterDbContext>();
optionsBuilder.EnableSensitiveDataLogging(true);
optionsBuilder.UseSqlServer(connectionString);
using (var context = new QuickForecasterDbContext(optionsBuilder.Options))
{
context.Database.EnsureCreated();
List <Stat> stats = null;
context.LoadStoredProc("[dbo].[spGetStatsByComplexity]")
.AddParam("EstimateId", 1)
.Exec(r => stats = r.ToList <Stat>());
stats.Should().NotBeNull();
stats.Count.Should().Be(3);
}
}
public GetAllClientsQueryHandler(QuickForecasterDbContext context)
{
_context = context;
}
public UpdateBacklogItemCommandHandler(QuickForecasterDbContext context)
{
_context = context;
}
public GetBacklogItemsQueryHandler(QuickForecasterDbContext context)
{
_context = context;
}
public GetProjectsQueryHandler(QuickForecasterDbContext context)
{
_context = context;
}
public GetSummaryQueryHandler(QuickForecasterDbContext context, IDateTimeProvider dateTimeProvider)
{
_context = context;
_dateTimeProvider = dateTimeProvider;
}
public CreateClientCommandHandler(QuickForecasterDbContext context)
{
_context = context;
}
public ScopedInmemoryDatabase(QuickForecasterDbContext context, string dbName)
{
Context = context;
DatabaseName = dbName;
}
