public async Task GetAllUnpaidResponseAsync_RETURNS_Valid_UnpaidResponse_List()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Get_unpaidResponses")
.Options;
using (var context = new UnpaidsContext(options))
{
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 1, UnpaidRequestId = 12, StatusId = 1, ResponseId = 1, Accepted = true
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 2, UnpaidRequestId = 50, StatusId = 1, ResponseId = 1, Accepted = true
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 3, UnpaidRequestId = 12, StatusId = 1, ResponseId = 1, Accepted = false
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 4, UnpaidRequestId = 25, StatusId = 1, ResponseId = 2, Accepted = true
});
context.SaveChanges();
}
// Act and Assert.
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidResponseDataManager(context);
var actual = await service.GetAllUnpaidResponseAsync(CancellationToken.None);
Assert.AreEqual(4, actual.Count());
}
}
public async Task AddUnpaidResponseAsync_GIVEN_Valid_Unpaid_RETURNS_Valid_Result()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Add_writes_to_database")
.Options;
// Act.
// Run the test against one instance of the context
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidResponseDataManager(context);
var actual = await service.AddUnpaidResponseAsync(new List <TbUnpaidResponse>
{
new TbUnpaidResponse
{
UnpaidRequestId = 41,
StatusId = 1,
ResponseId = 1,
Accepted = true
}
}, CancellationToken.None);
}
// Assert.
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new UnpaidsContext(options))
{
Assert.AreEqual(1, context.TbUnpaidResponse.Count());
Assert.AreEqual(41, context.TbUnpaidResponse.Single().UnpaidRequestId);
Assert.AreEqual(1, context.TbUnpaidResponse.Single().StatusId);
Assert.AreEqual(1, context.TbUnpaidResponse.Single().ResponseId);
Assert.IsTrue(context.TbUnpaidResponse.Single().Accepted);
}
}
public async Task AddUnpaidResponseAsync_GIVEN_Null_UnpaidResponse_RETURNS_Valid_Result()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Add_writes_to_database3")
.Options;
// Act.
// Run the test against one instance of the context
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidResponseDataManager(context);
var actual = await service.AddUnpaidResponseAsync(null, CancellationToken.None);
}
// Assert.
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new UnpaidsContext(options))
{
Assert.AreEqual(0, context.TbUnpaidResponse.Count());
}
}
public async Task GetSingleUnpaidResponseAsync_GIVEN_Valid_Input_RETURNS_Valid_UnpaidResponse()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Find_unpaidResponse")
.Options;
using (var context = new UnpaidsContext(options))
{
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 1, UnpaidRequestId = 12, StatusId = 1, ResponseId = 1, Accepted = true
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 2, UnpaidRequestId = 50, StatusId = 1, ResponseId = 1, Accepted = true
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 3, UnpaidRequestId = 12, StatusId = 1, ResponseId = 1, Accepted = false
});
context.TbUnpaidResponse.Add(new TbUnpaidResponse {
UnpaidResponseId = 4, UnpaidRequestId = 25, StatusId = 1, ResponseId = 2, Accepted = true
});
context.SaveChanges();
}
// Act and Assert.
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidResponseDataManager(context);
var actual = await service.GetSingleUnpaidResponseAsync(3, CancellationToken.None);
Assert.AreEqual(3, actual.UnpaidResponseId);
Assert.AreEqual(12, actual.UnpaidRequestId);
Assert.AreEqual(1, actual.StatusId);
Assert.AreEqual(1, actual.ResponseId);
Assert.AreEqual(false, actual.Accepted);
}
}
