//get a db context from in memory db
private async Task <WeTestContext> GetWeTestDbContext()
{
var options = new DbContextOptionsBuilder <WeTestContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString()) //from efcore.InMemory package
.Options;
var databaseContext = new WeTestContext(options);
databaseContext.Database.EnsureCreated();
if (await databaseContext.Tester.CountAsync() <= 0)
{
for (int i = 1; i <= 10; i++)
{
//add tester
databaseContext.Tester.Add(new Tester()
{
TesterId = i.ToString(),
TesterName = $"testerMocked{i}",
});
await databaseContext.SaveChangesAsync();
//add test
databaseContext.Test.Add(new Test()
{
TestId = i.ToString(),
TestTitle = $"TestMocked{i}",
});
await databaseContext.SaveChangesAsync();
}
}
return(databaseContext);
}
public async Task <IActionResult> Create([Bind("TesterId,TesterName")] Tester tester)
{
if (ModelState.IsValid)
{
if (TesterExists(tester.TesterId))
{
return(Content("Tester Id already exists.Please use company id number."));
}
_context.Add(tester);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tester));
}
public async Task <IActionResult> Create([Bind("TestId,TestTitle,Functionality,TesterId")] Test test)
{
if (ModelState.IsValid)
{
if (TestExists(test.TestId))
{
return(Content("This test Id already exists. Check Id from Requirements of Your Company database."));
}
if (!TesterExists(test.TesterId.ToString()))
{
return(Content("The tester Id for this test does not exist .Return and retry."));
}
_context.Add(test);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(test));
}
