public async Task ExportPolicies()
{
//https://github.com/dotnet/aspnetcore/issues/7644
var syncIOFeature = HttpContext.Features.Get <IHttpBodyControlFeature>();
if (syncIOFeature != null)
{
syncIOFeature.AllowSynchronousIO = true;
}
var scope = AuthenticationService.GetScope(User);
var csvRenderer = new CsvRenderer <ClientPolicy>();
var fileName = $"ClientPolicies_{DateTime.Now.ToString("yyyy-MM-dd")}";
SetResponseHeaders(Response, fileName);
await ClientExportService.Policies(csvRenderer, Response.Body, scope);
}
public async Task Policies()
{
var options = TestHelper.GetDbContext("Policies");
var user1 = TestHelper.InsertUserDetailed(options);
var client1 = TestHelper.InsertClient(options, user1.Organisation);
var client2 = TestHelper.InsertClient(options, user1.Organisation);
var client3 = TestHelper.InsertClient(options, user1.Organisation);
var policyType1 = TestHelper.InsertPolicyType(options);
var policyType2 = TestHelper.InsertPolicyType(options);
TestHelper.InsertClient(options); //Different org
var policy1 = new PolicyEntity {
Number = "123456", ClientId = client1.Client.Id, Premium = 200, StartDate = DateTime.Now.AddYears(-1), UserId = user1.User.Id, PolicyTypeId = policyType1.Id
};
var policy2 = new PolicyEntity {
Number = "654321", ClientId = client2.Client.Id, Premium = 300, UserId = user1.User.Id, PolicyTypeId = policyType2.Id
};
var policy3 = new PolicyEntity {
Number = "987654", ClientId = client1.Client.Id, StartDate = DateTime.Now.AddYears(-2), UserId = user1.User.Id
};
using (var context = new DataContext(options))
{
context.Policy.Add(policy1);
context.Policy.Add(policy2);
context.Policy.Add(policy3);
context.Contact.Add(new ContactEntity {
ClientId = client2.Client.Id, ContactTypeId = ContactType.CONTACT_TYPE_EMAIL, Value = "*****@*****.**"
});
context.Contact.Add(new ContactEntity {
ClientId = client1.Client.Id, ContactTypeId = ContactType.CONTACT_TYPE_EMAIL, Value = "*****@*****.**"
});
context.Contact.Add(new ContactEntity {
ClientId = client1.Client.Id, ContactTypeId = ContactType.CONTACT_TYPE_CELLPHONE, Value = "0825728997"
});
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var service = new ClientExportService(context);
//When
var renderer = new MockClientExportRenderer <ClientPolicy>();
var scopeOptions = TestHelper.GetScopeOptions(user1);
await service.Policies(renderer, new MemoryStream(), scopeOptions);
//Then
Assert.Equal(4, renderer.Items.Count());
var actual = renderer.Items.ToArray()[0];
Assert.Equal(client1.Client.IdNumber, actual.IdNumber);
Assert.Equal(client1.Client.FirstName, actual.FirstName);
Assert.Equal(client1.Client.LastName, actual.LastName);
Assert.Equal(client1.Client.DateOfBirth, actual.DateOfBirth);
Assert.Equal(client1.Client.TaxNumber, actual.TaxNumber);
Assert.Equal("*****@*****.**", actual.Email);
Assert.Equal("0825728997", actual.CellPhone);
Assert.Equal(policy1.Number, actual.PolicyNumber);
Assert.Equal($"{user1.User.FirstName} {user1.User.LastName}", actual.PolicyBroker);
Assert.Equal(policy1.Premium, actual.PolicyPremium);
Assert.Equal(policyType1.Code, actual.PolicyTypeCode);
Assert.Equal(policy1.StartDate, actual.PolicyStartDate);
actual = renderer.Items.ToArray()[1];
Assert.Equal(client1.Client.IdNumber, actual.IdNumber);
Assert.Equal(client1.Client.FirstName, actual.FirstName);
Assert.Equal(client1.Client.LastName, actual.LastName);
Assert.Equal(client1.Client.DateOfBirth, actual.DateOfBirth);
Assert.Equal(client1.Client.TaxNumber, actual.TaxNumber);
Assert.Equal("*****@*****.**", actual.Email);
Assert.Equal("0825728997", actual.CellPhone);
Assert.Equal(policy3.Number, actual.PolicyNumber);
Assert.Equal($"{user1.User.FirstName} {user1.User.LastName}", actual.PolicyBroker);
Assert.Equal(policy3.Premium, actual.PolicyPremium);
Assert.Null(actual.PolicyTypeCode);
Assert.Equal(policy3.StartDate, actual.PolicyStartDate);
actual = renderer.Items.ToArray()[2];
Assert.Equal(client2.Client.IdNumber, actual.IdNumber);
Assert.Equal(client2.Client.FirstName, actual.FirstName);
Assert.Equal(client2.Client.LastName, actual.LastName);
Assert.Equal(client2.Client.DateOfBirth, actual.DateOfBirth);
Assert.Equal(client2.Client.TaxNumber, actual.TaxNumber);
Assert.Equal("*****@*****.**", actual.Email);
Assert.Null(actual.CellPhone);
Assert.Equal(policy2.Number, actual.PolicyNumber);
Assert.Equal($"{user1.User.FirstName} {user1.User.LastName}", actual.PolicyBroker);
Assert.Equal(policy2.Premium, actual.PolicyPremium);
Assert.Equal(policyType2.Code, actual.PolicyTypeCode);
Assert.Equal(policy2.StartDate, actual.PolicyStartDate);
actual = renderer.Items.ToArray()[3];
Assert.Equal(client3.Client.IdNumber, actual.IdNumber);
Assert.Equal(client3.Client.FirstName, actual.FirstName);
Assert.Equal(client3.Client.LastName, actual.LastName);
Assert.Equal(client3.Client.DateOfBirth, actual.DateOfBirth);
Assert.Equal(client3.Client.TaxNumber, actual.TaxNumber);
Assert.Null(actual.Email);
Assert.Null(actual.CellPhone);
Assert.Null(actual.PolicyNumber);
Assert.Equal(" ", actual.PolicyBroker);
Assert.Null(actual.PolicyPremium);
Assert.Null(actual.PolicyTypeCode);
Assert.Null(actual.PolicyStartDate);
}
}
public async Task PolicyAggregates()
{
var options = TestHelper.GetDbContext("PolicyAggregates");
var user1 = TestHelper.InsertUserDetailed(options);
var client1 = TestHelper.InsertClient(options, user1.Organisation);
var client2 = TestHelper.InsertClient(options, user1.Organisation);
TestHelper.InsertClient(options); //Different org
using (var context = new DataContext(options))
{
context.Policy.Add(new PolicyEntity {
ClientId = client1.Client.Id, PolicyTypeId = PolicyType.POLICY_TYPE_INVESTMENT
});
context.Policy.Add(new PolicyEntity {
ClientId = client1.Client.Id, PolicyTypeId = PolicyType.POLICY_TYPE_MEDICAL_COVER
});
context.Policy.Add(new PolicyEntity {
ClientId = client1.Client.Id, PolicyTypeId = PolicyType.POLICY_TYPE_SHORT_TERM
});
context.Policy.Add(new PolicyEntity {
ClientId = client2.Client.Id, PolicyTypeId = PolicyType.POLICY_TYPE_SHORT_TERM
});
context.Policy.Add(new PolicyEntity {
ClientId = client1.Client.Id, PolicyTypeId = PolicyType.POLICY_TYPE_INVESTMENT
});
context.Contact.Add(new ContactEntity {
ClientId = client2.Client.Id, ContactTypeId = ContactType.CONTACT_TYPE_EMAIL, Value = "*****@*****.**"
});
context.Contact.Add(new ContactEntity {
ClientId = client1.Client.Id, ContactTypeId = ContactType.CONTACT_TYPE_EMAIL, Value = "*****@*****.**"
});
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var service = new ClientExportService(context);
//When
var renderer = new MockClientExportRenderer <ClientPolicyAggregate>();
var scopeOptions = TestHelper.GetScopeOptions(user1);
await service.PolicyAggregates(renderer, new MemoryStream(), scopeOptions);
//Then
Assert.Equal(2, renderer.Items.Count());
var actual = renderer.Items.ToArray()[0];
Assert.Equal(client1.Client.IdNumber, actual.IdNumber);
Assert.Equal(client1.Client.FirstName, actual.FirstName);
Assert.Equal(client1.Client.LastName, actual.LastName);
Assert.Equal("*****@*****.**", actual.Email);
Assert.Equal(2, actual.PolicyInvestmentCount);
Assert.Equal(1, actual.PolicyShortTermCount);
Assert.Equal(1, actual.PolicyMedicalCoverCount);
Assert.Equal(0, actual.PolicyLifeInsuranceCount);
actual = renderer.Items.ToArray()[1];
Assert.Equal(client2.Client.IdNumber, actual.IdNumber);
Assert.Equal(client2.Client.FirstName, actual.FirstName);
Assert.Equal(client2.Client.LastName, actual.LastName);
Assert.Equal("*****@*****.**", actual.Email);
Assert.Equal(0, actual.PolicyInvestmentCount);
Assert.Equal(1, actual.PolicyShortTermCount);
Assert.Equal(0, actual.PolicyMedicalCoverCount);
Assert.Equal(0, actual.PolicyLifeInsuranceCount);
}
}
