public async Task GetAllUnpaidRequestAsync_RETURNS_Valid_UnpaidRequest_List()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Get_unpaidRequests")
.Options;
using (var context = new UnpaidsContext(options))
{
context.TbUnpaidRequest.Add(new TbUnpaidRequest {
UnpaidRequestId = 1, UnpaidId = 10, StatusId = 1, NotificationId = 1
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest {
UnpaidRequestId = 2, UnpaidId = 12, StatusId = 2, NotificationId = 3
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest {
UnpaidRequestId = 3, UnpaidId = 10, StatusId = 1, NotificationId = 1
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest {
UnpaidRequestId = 4, UnpaidId = 55, StatusId = 3, NotificationId = 2
});
context.SaveChanges();
}
// Act and Assert.
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidRequestDataManager(context);
var actual = await service.GetAllUnpaidRequestAsync(CancellationToken.None);
Assert.AreEqual(4, actual.Count());
}
}
public async Task AddUnpaidRequestAsync_GIVEN_Valid_UnpaidRequest_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 UnpaidRequestDataManager(context);
var actual = await service.AddUnpaidRequestAsync(new List <TbUnpaidRequest>
{
new TbUnpaidRequest
{
UnpaidId = 10,
StatusId = 1,
NotificationId = 1
}
}, 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.TbUnpaidRequest.Count());
Assert.AreEqual(10, context.TbUnpaidRequest.Single().UnpaidId);
Assert.AreEqual(1, context.TbUnpaidRequest.Single().StatusId);
Assert.AreEqual(1, context.TbUnpaidRequest.Single().NotificationId);
}
}
public async Task UpdateUnpaidRequestAsync_GIVEN_Valid_Input_RETURNS_Valid_Result()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Update_unpaidRequests_against_unpaidId")
.Options;
using (var context = new UnpaidsContext(options))
{
context.TbUnpaidRequest.Add(new TbUnpaidRequest
{
UnpaidRequestId = 1, UnpaidId = 10, StatusId = 1, NotificationId = 1
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest
{
UnpaidRequestId = 2, UnpaidId = 12, StatusId = 2, NotificationId = 3
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest
{
UnpaidRequestId = 3, UnpaidId = 10, StatusId = 1, NotificationId = 1
});
context.TbUnpaidRequest.Add(new TbUnpaidRequest
{
UnpaidRequestId = 4, UnpaidId = 55, StatusId = 3, NotificationId = 2
});
context.SaveChanges();
}
// Act.
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidRequestDataManager(context);
await service.UpdateUnpaidRequestAsync(3, Notification.Call, Status.Failed, "Testing.", DateTime.Now, "GUID_1", CancellationToken.None);
}
// Assert.
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new UnpaidsContext(options))
{
var actual = context.TbUnpaidRequest.FirstOrDefault(item => item.UnpaidRequestId == 3);
if (actual != null)
{
Assert.AreEqual(3, actual.UnpaidRequestId);
Assert.AreEqual(3, actual.StatusId);
Assert.AreEqual(4, actual.NotificationId);
Assert.AreEqual("Testing.", actual.StatusAdditionalInfo);
Assert.AreEqual("GUID_1", actual.CorrelationId);
}
}
}
public async Task GetSingleUnpaidRequestAsync_GIVEN_Invalid_Input_RETURNS_Null()
{
// Arrange.
var options = new DbContextOptionsBuilder <UnpaidsContext>()
.UseInMemoryDatabase(databaseName: "Find_unpaidRequest2")
.Options;
using (var context = new UnpaidsContext(options))
{
context.TbUnpaidRequest.Add(new TbUnpaidRequest {
UnpaidRequestId = 1, UnpaidId = 10, StatusId = 1, NotificationId = 1
});
context.SaveChanges();
}
// Act and Assert.
using (var context = new UnpaidsContext(options))
{
var service = new UnpaidRequestDataManager(context);
var actual = await service.GetSingleUnpaidRequestAsync(0, CancellationToken.None);
Assert.AreEqual(null, actual);
}
}
