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 GetAllUnpaidAsync_RETURNS_Valid_Unpaid_List() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Get_unpaids") .Options; // Insert seed data into the database using one instance of the context. using (var context = new UnpaidsContext(options)) { context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 1, PolicyNumber = "P1", IdNumber = "9009165023080", Name = "Tom", Message = "Test Message 1.", Title = "Test1" }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 2, PolicyNumber = "P2", Name = "Bob", IdNumber = "9009165023081", Message = "Test Message 2.", Title = "Test2" }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 3, PolicyNumber = "P1", IdNumber = "9009165023080", Name = "Tom", Message = "Test Message 3.", Title = "Test3" }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 4, PolicyNumber = "P4", IdNumber = "9009165023082", Name = "Brad", Message = "Test Message 4.", Title = "Test4" }); context.SaveChanges(); } // Act and Assert. // Use a clean instance of the context to run the test. using (var context = new UnpaidsContext(options)) { var service = new UnpaidDataManager(context); var actual = await service.GetAllUnpaidAsync(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 GetSingleUnpaidAsync_GIVEN_Invalid_Input_RETURNS_Null() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Find_unpaid2") .Options; // Insert seed data into the database using one instance of the context. using (var context = new UnpaidsContext(options)) { context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 1, PolicyNumber = "P1", Name = "Tom", Message = "Test Message 1." }); context.SaveChanges(); } // Act and Assert. // Use a clean instance of the context to run the test. using (var context = new UnpaidsContext(options)) { var service = new UnpaidDataManager(context); var actual = await service.GetSingleUnpaidAsync(0, CancellationToken.None); Assert.AreEqual(null, actual); } }
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 GetAllUnpaidAsync_GIVEN_Valid_Input_RETURNS_Valid_Unpaid_List() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Get_unpaids_against_idempotencyKey") .Options; // Insert seed data into the database using one instance of the context. using (var context = new UnpaidsContext(options)) { context.TbUnpaidBatch.Add(new TbUnpaidBatch { BatchKey = "7c9e6679-7425-40de-944b-e07fc1f90ae7", StatusId = (int)Status.Pending, UserName = "******", UnpaidBatchId = 1 }); context.TbUnpaidBatch.Add(new TbUnpaidBatch { BatchKey = "7c9e6679-7425-40de-944b-e07fc1f90ae9", StatusId = (int)Status.Pending, UserName = "******", UnpaidBatchId = 2 }); context.SaveChanges(); } // Insert seed data into the database using one instance of the context. using (var context = new UnpaidsContext(options)) { context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 1, PolicyNumber = "P1", IdNumber = "9009165023080", Name = "Tom", Message = "Test Message 1.", Title = "Test1", UnpaidBatchId = 1 }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 2, PolicyNumber = "P2", Name = "Bob", IdNumber = "9009165023081", Message = "Test Message 2.", Title = "Test2", UnpaidBatchId = 2 }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 3, PolicyNumber = "P1", IdNumber = "9009165023080", Name = "Tom", Message = "Test Message 3.", Title = "Test3", UnpaidBatchId = 1 }); context.TbUnpaid.Add(new TbUnpaid { UnpaidId = 4, PolicyNumber = "P4", IdNumber = "9009165023082", Name = "Brad", Message = "Test Message 4.", Title = "Test4", UnpaidBatchId = 2 }); context.SaveChanges(); } // Act and Assert. // Use a clean instance of the context to run the test. using (var context = new UnpaidsContext(options)) { var service = new UnpaidDataManager(context); var actual = await service.GetAllUnpaidAsync("7c9e6679-7425-40de-944b-e07fc1f90ae7", CancellationToken.None); var unpaidDbs = actual.ToList(); Assert.AreEqual(2, unpaidDbs.Count); Assert.AreEqual(1, unpaidDbs.ToList()[0].UnpaidId); Assert.AreEqual(3, unpaidDbs.ToList()[1].UnpaidId); } }
public async Task AddUnpaidAsync_2Entries_GIVEN_Valid_Unpaid_RETURNS_Valid_Result_With2Entries() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Add_writes_to_database2") .Options; // Act. // Run the test against one instance of the context using (var context = new UnpaidsContext(options)) { var service = new UnpaidDataManager(context); var actual = await service.AddUnpaidAsync(new List <TbUnpaid> { new TbUnpaid { PolicyNumber = "Test1234", IdNumber = "9009165023080", Name = "Nesan Pather", Message = "Payment bounced. Please accept a call back.", Title = "Test1" }, new TbUnpaid { PolicyNumber = "Test12345", IdNumber = "9009165023081", Name = "Tom Smith", Message = "Payment bounced. Please accept a call back.", Title = "Test2" } }, 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(2, context.TbUnpaid.Count()); Assert.AreEqual("Test1234", context.TbUnpaid.ToList()[0].PolicyNumber); Assert.AreEqual("9009165023080", context.TbUnpaid.ToList()[0].IdNumber); Assert.AreEqual("Nesan Pather", context.TbUnpaid.ToList()[0].Name); Assert.AreEqual("Payment bounced. Please accept a call back.", context.TbUnpaid.ToList()[0].Message); Assert.AreEqual("Test1", context.TbUnpaid.ToList()[0].Title); Assert.AreEqual("Test12345", context.TbUnpaid.ToList()[1].PolicyNumber); Assert.AreEqual("9009165023081", context.TbUnpaid.ToList()[1].IdNumber); Assert.AreEqual("Tom Smith", context.TbUnpaid.ToList()[1].Name); Assert.AreEqual("Payment bounced. Please accept a call back.", context.TbUnpaid.ToList()[1].Message); Assert.AreEqual("Test2", context.TbUnpaid.ToList()[1].Title); } }
public async Task AddUnpaidRequestAsync_2Entries_GIVEN_Valid_UnpaidRequest_RETURNS_Valid_Result_With2Entries() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Add_writes_to_database2") .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 }, new TbUnpaidRequest { UnpaidId = 12, StatusId = 2, NotificationId = 3 } }, 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(2, context.TbUnpaidRequest.Count()); Assert.AreEqual(10, context.TbUnpaidRequest.ToList()[0].UnpaidId); Assert.AreEqual(1, context.TbUnpaidRequest.ToList()[0].StatusId); Assert.AreEqual(1, context.TbUnpaidRequest.ToList()[0].NotificationId); Assert.AreEqual(12, context.TbUnpaidRequest.ToList()[1].UnpaidId); Assert.AreEqual(2, context.TbUnpaidRequest.ToList()[1].StatusId); Assert.AreEqual(3, context.TbUnpaidRequest.ToList()[1].NotificationId); } }
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 GetAllUnpaidRequestAsync_GIVEN_Valid_Input_RETURNS_Valid_UnpaidRequest_List() { // Arrange. var options = new DbContextOptionsBuilder <UnpaidsContext>() .UseInMemoryDatabase(databaseName: "Get_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 and Assert. using (var context = new UnpaidsContext(options)) { var service = new UnpaidRequestDataManager(context); var actual = await service.GetAllUnpaidRequestAsync(10, CancellationToken.None); var unpaidRequests = actual.ToList(); Assert.AreEqual(2, unpaidRequests.Count()); Assert.AreEqual(1, unpaidRequests.ToList()[0].UnpaidRequestId); Assert.AreEqual(3, unpaidRequests.ToList()[1].UnpaidRequestId); } }
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); } }
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); } }
public AccessTokenDataManager(UnpaidsContext unpaidsDbContext) { _unpaidsDbContext = unpaidsDbContext; }
public UnpaidBatchDataManager(UnpaidsContext unpaidsDbContext) { _unpaidsDbContext = unpaidsDbContext; }
public UnpaidRequestDataManager(UnpaidsContext unpaidsDbContext) { _unpaidsDbContext = unpaidsDbContext; }
public UnpaidResponseDataManager(UnpaidsContext unpaidsDbContext) { _unpaidsDbContext = unpaidsDbContext; }