public static CommissionStatementEntity InsertCommissionStatement(DbContextOptions <DataContext> options, OrganisationEntity organisation, Guid?companyId = null, DateTime?date = null)
{
companyId = companyId.HasValue ? companyId : InsertCompany(options).Id;
var statement = new CommissionStatementEntity {
Id = Guid.NewGuid(), OrganisationId = organisation.Id, CompanyId = companyId.Value, Date = date ?? DateTime.Now
};
using (var context = new DataContext(options))
{
context.CommissionStatement.Add(statement);
context.SaveChanges();
}
return(statement);
}
private CommissionStatementEntity MapModelToEntity(CommissionStatementEdit model, CommissionStatementEntity entity = null)
{
if (entity == null)
{
entity = new CommissionStatementEntity();
}
entity.CompanyId = model.CompanyId.Value;
entity.AmountIncludingVAT = model.AmountIncludingVAT.Value;
entity.VAT = model.VAT.Value;
entity.Date = model.Date.Value.Date;
entity.Processed = model.Processed.Value;
entity.Notes = model.Notes;
return(entity);
}
public async Task GetClientRevenueData_PolicyTypeFilter()
{
var options = await CreateDatabaseSqlServer();
var company = TestHelper.InsertCompany(options);
var commissionType1 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_MONTHLY_ANNUITY);
var commissionType2 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_LIFE_INSURANCE, CommissionEarningsType.EARNINGS_TYPE_MONTHLY_ANNUITY);
var user1 = TestHelper.InsertUserDetailed(options);
var user2 = TestHelper.InsertUserDetailed(options, user1.Organisation); //Same org different branch
var client1 = TestHelper.InsertClient(options, user1.Organisation);
var thisMonth = DateTime.Now.Date;
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 0,
VAT = 0,
Date = thisMonth,
Processed = true,
OrganisationId = user1.Organisation.Id
};
//------------------------------------------------------------------------
var policy1 = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client1.Client.Id,
UserId = user1.User.Id
};
var commission1 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 100,
VAT = 0,
CommissionStatementId = cs1.Id
};
//------------------------------------------------------------------------
var policy2 = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client1.Client.Id,
UserId = user2.User.Id
};
var commission2 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy2.Id,
UserId = policy2.UserId,
CommissionTypeId = commissionType2.Id,
AmountIncludingVAT = 200,
VAT = 0,
CommissionStatementId = cs1.Id
};
//------------------------------------------------------------------------
using (var context = new DataContext(options))
{
context.Policy.Add(policy2);
context.Policy.Add(policy1);
context.CommissionStatement.Add(cs1);
context.Commission.Add(commission1);
context.Commission.Add(commission2);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var service = new CommissionReportService(context);
//When - Branch Filter
var scope = TestHelper.GetScopeOptions(user1);
var queryOptions = new ClientRevenueQueryOptions(scope, "", "", 0, 0, $"YearEnding={thisMonth.Year};MonthEnding={thisMonth.Month}");
queryOptions.PolicyTypeId.Add(commissionType2.PolicyTypeId);
var data = await service.GetClientRevenueData(queryOptions);
//Then
var results = data.Items.ToList();
Assert.Equal(1, data.TotalItems);
var resultsCount = results.Count();
Assert.Equal(1, resultsCount);
var actual = results[0];
Assert.Equal(client1.Client.Id, actual.ClientId);
Assert.Equal(200, actual.MonthlyAnnuityMonth);
}
}
public async Task GetClientRevenueData()
{
var options = await CreateDatabaseSqlServer();
var company = TestHelper.InsertCompany(options);
var commissionType1 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_ANNUAL_ANNUITY);
var commissionType2 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_MONTHLY_ANNUITY);
var commissionType3 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_ONCE_OFF);
var commissionType4 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_LIFE_FIRST_YEARS);
var user1 = TestHelper.InsertUserDetailed(options);
var client1 = TestHelper.InsertClient(options, user1.Organisation);
var thisMonth = DateTime.Now.Date;
var lastMonth = thisMonth.AddMonths(-1);
var policy1 = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client1.Client.Id,
UserId = user1.User.Id
};
//Statement 1 - this month
// ANNUAL_ANNUITY | MONTHLY_ANNUITY | ONCE_OFF | LIFE_FIRST_YEARS
//com1 100 0 0 0
//com2 0 200 0 0
//com3 0 0 300 0
//com4 0 0 0 400
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 0,
VAT = 0,
Date = thisMonth,
Processed = true,
OrganisationId = user1.Organisation.Id
};
var commission1 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 110,
VAT = 10,
CommissionStatementId = cs1.Id
};
var commission2 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType2.Id,
AmountIncludingVAT = 220,
VAT = 20,
CommissionStatementId = cs1.Id
};
var commission3 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType3.Id,
AmountIncludingVAT = 330,
VAT = 30,
CommissionStatementId = cs1.Id
};
var commission4 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType4.Id,
AmountIncludingVAT = 440,
VAT = 40,
CommissionStatementId = cs1.Id
};
//Statement 2 - last month
// ANNUAL_ANNUITY | MONTHLY_ANNUITY | ONCE_OFF | LIFE_FIRST_YEARS
//com5 500 0 0 0
//com6 0 600 0 0
//com7 0 0 700 0
//com8 0 0 0 800
var cs2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 0,
VAT = 0,
Date = lastMonth,
Processed = true,
OrganisationId = user1.Organisation.Id
};
var commission5 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 500,
VAT = 0,
CommissionStatementId = cs2.Id
};
var commission6 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType2.Id,
AmountIncludingVAT = 600,
VAT = 0,
CommissionStatementId = cs2.Id
};
var commission7 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType3.Id,
AmountIncludingVAT = 700,
VAT = 0,
CommissionStatementId = cs2.Id
};
var commission8 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType4.Id,
AmountIncludingVAT = 800,
VAT = 0,
CommissionStatementId = cs2.Id
};
//Statement 3 - 2 months age
// ANNUAL_ANNUITY | MONTHLY_ANNUITY | ONCE_OFF | LIFE_FIRST_YEARS
//com9 900 0 0 0
//com10 0 1000 0 0
//com11 0 0 1100 0
//com12 0 0 0 1200
var cs3 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 0,
VAT = 0,
Date = lastMonth.AddMonths(-1),
Processed = true,
OrganisationId = user1.Organisation.Id
};
var commission9 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 900,
VAT = 0,
CommissionStatementId = cs3.Id
};
var commission10 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType2.Id,
AmountIncludingVAT = 1000,
VAT = 0,
CommissionStatementId = cs3.Id
};
var commission11 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType3.Id,
AmountIncludingVAT = 1100,
VAT = 0,
CommissionStatementId = cs3.Id
};
var commission12 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType4.Id,
AmountIncludingVAT = 1200,
VAT = 0,
CommissionStatementId = cs3.Id
};
using (var context = new DataContext(options))
{
context.Policy.Add(policy1);
context.CommissionStatement.Add(cs1);
context.Commission.Add(commission1);
context.Commission.Add(commission2);
context.Commission.Add(commission3);
context.Commission.Add(commission4);
context.CommissionStatement.Add(cs2);
context.Commission.Add(commission5);
context.Commission.Add(commission6);
context.Commission.Add(commission7);
context.Commission.Add(commission8);
context.CommissionStatement.Add(cs3);
context.Commission.Add(commission9);
context.Commission.Add(commission10);
context.Commission.Add(commission11);
context.Commission.Add(commission12);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var service = new CommissionReportService(context);
//When
var scope = TestHelper.GetScopeOptions(user1);
var queryOptions = new ClientRevenueQueryOptions(scope, "", "", 0, 0, $"YearEnding={thisMonth.Year};MonthEnding={thisMonth.Month}");
var data = await service.GetClientRevenueData(queryOptions);
//Then
var results = data.Items.ToList();
Assert.Equal(1, data.TotalItems);
Assert.Single(results);
var actual = results[0];
Assert.Equal(client1.Client.Id, actual.ClientId);
Assert.Equal(client1.Client.LastName, actual.ClientLastName);
Assert.Equal(client1.Client.Initials, actual.ClientInitials);
Assert.Equal(client1.Client.DateOfBirth, actual.ClientDateOfBirth);
Assert.Equal(200, actual.MonthlyAnnuityMonth); // com2
Assert.Equal(125, actual.AnnualAnnuityAverage); // (100 + 500 + 900) / 12
Assert.Equal(325, actual.TotalMonthlyEarnings); // 125 + 200
Assert.Equal(2100, actual.OnceOff); //300 + 700 + 1100
Assert.Equal(2400, actual.LifeFirstYears); //400 + 800 + 1200
Assert.Equal(7800, actual.GrandTotal); // add up all commission entries
Assert.Equal(0, actual.AllocationsCount);
}
}
public async Task GetClientRevenueData_Allocations()
{
var options = await CreateDatabaseSqlServer();
var company = TestHelper.InsertCompany(options);
var commissionType1 = TestHelper.InsertCommissionType(options, PolicyType.POLICY_TYPE_INVESTMENT, CommissionEarningsType.EARNINGS_TYPE_MONTHLY_ANNUITY);
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 thisMonth = DateTime.Now.Date;
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 0,
VAT = 0,
Date = thisMonth,
Processed = true,
OrganisationId = user1.Organisation.Id
};
//------------------------------------------------------------------------
var policy1 = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client1.Client.Id,
UserId = user1.User.Id
};
var commission1 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy1.Id,
UserId = policy1.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 100,
VAT = 0,
CommissionStatementId = cs1.Id
};
//------------------------------------------------------------------------
var policy2 = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client2.Client.Id,
UserId = user1.User.Id
};
var commission2 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy2.Id,
UserId = policy2.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 200,
VAT = 0,
CommissionStatementId = cs1.Id
};
//------------------------------------------------------------------------
var policy3a = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client3.Client.Id,
UserId = user1.User.Id
};
var commission3a = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy3a.Id,
UserId = policy3a.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 300,
VAT = 0,
CommissionStatementId = cs1.Id
};
var policy3b = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client3.Client.Id,
UserId = user1.User.Id
};
var commission3b = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy3b.Id,
UserId = policy3b.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 400,
VAT = 0,
CommissionStatementId = cs1.Id
};
var policy3c = new PolicyEntity
{
Id = Guid.NewGuid(),
Number = Guid.NewGuid().ToString(),
CompanyId = company.Id,
ClientId = client3.Client.Id,
UserId = user1.User.Id
};
var commission3c = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = policy3c.Id,
UserId = policy3c.UserId,
CommissionTypeId = commissionType1.Id,
AmountIncludingVAT = 500,
VAT = 0,
CommissionStatementId = cs1.Id
};
//------------------------------------------------------------------------
//Allocate Client1, Policy1 to Client2.
var allocation1 = new CommissionAllocationEntity
{
Id = Guid.NewGuid(),
FromClientId = client1.Client.Id,
ToClientId = client2.Client.Id
};
var cap1 = new CommissionAllocationPolicyEntity
{
Id = Guid.NewGuid(),
CommissionAllocationId = allocation1.Id,
PolicyId = policy1.Id
};
//Allocate Client3, Policy3b to Client2.
var allocation2 = new CommissionAllocationEntity
{
Id = Guid.NewGuid(),
FromClientId = client3.Client.Id,
ToClientId = client2.Client.Id
};
var cap2 = new CommissionAllocationPolicyEntity
{
Id = Guid.NewGuid(),
CommissionAllocationId = allocation2.Id,
PolicyId = policy3b.Id
};
using (var context = new DataContext(options))
{
context.Policy.Add(policy2);
context.Policy.Add(policy1);
context.Policy.Add(policy3a);
context.Policy.Add(policy3b);
context.Policy.Add(policy3c);
context.CommissionStatement.Add(cs1);
context.Commission.Add(commission3a);
context.Commission.Add(commission1);
context.Commission.Add(commission2);
context.Commission.Add(commission3b);
context.Commission.Add(commission3c);
context.CommissionAllocation.Add(allocation1);
context.CommissionAllocation.Add(allocation2);
context.CommissionAllocationPolicy.Add(cap1);
context.CommissionAllocationPolicy.Add(cap2);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var service = new CommissionReportService(context);
//When
var scope = TestHelper.GetScopeOptions(user1);
var queryOptions = new ClientRevenueQueryOptions(scope, "MonthlyAnnuityMonth", "asc", 0, 0, $"YearEnding={thisMonth.Year};MonthEnding={thisMonth.Month}");
var data = await service.GetClientRevenueData(queryOptions);
//Then
var results = data.Items.ToList();
Assert.Equal(3, data.TotalItems);
var resultsCount = results.Count();
Assert.Equal(3, resultsCount);
var actual = results[0];
Assert.Equal(client1.Client.Id, actual.ClientId);
Assert.Equal(100, actual.MonthlyAnnuityMonth);
Assert.Equal(0, actual.AllocationsCount);
actual = results[1];
Assert.Equal(client2.Client.Id, actual.ClientId);
Assert.Equal(700, actual.MonthlyAnnuityMonth); //200 + 100 (pol1) + 400 (pol3b)
Assert.Equal(2, actual.AllocationsCount);
actual = results[2];
Assert.Equal(client3.Client.Id, actual.ClientId);
Assert.Equal(1200, actual.MonthlyAnnuityMonth); //300 + 400 + 500
Assert.Equal(0, actual.AllocationsCount);
}
}
public async Task UpdateCommissionStatement()
{
var options = TestHelper.GetDbContext("UpdateCommissionStatement");
var user1 = TestHelper.InsertUserDetailed(options);
var user2 = TestHelper.InsertUserDetailed(options);
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = Guid.NewGuid(),
AmountIncludingVAT = 100,
VAT = 10,
Date = DateTime.Now,
Processed = true,
OrganisationId = user1.Organisation.Id,
Notes = "note 1"
};
var cs2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = Guid.NewGuid(),
AmountIncludingVAT = 200,
VAT = 20,
Date = DateTime.Now.AddDays(-1),
Processed = false,
OrganisationId = user1.Organisation.Id,
Notes = "note 2"
};
using (var context = new DataContext(options))
{
context.CommissionStatement.Add(cs1);
context.CommissionStatement.Add(cs2);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var auditService = new AuditServiceMock();
var service = new CommissionStatementService(context, null, auditService);
var model = new CommissionStatementEdit
{
Id = cs2.Id,
CompanyId = Guid.NewGuid(),
AmountIncludingVAT = 300,
VAT = 30,
Date = DateTime.Now.AddDays(-10),
Processed = true,
Notes = "note 2 updated"
};
//When
var scopeOptions = TestHelper.GetScopeOptions(user1);
var result = await service.UpdateCommissionStatement(scopeOptions, model);
//Then
Assert.True(result.Success);
var actual = await context.CommissionStatement.FindAsync(model.Id);
Assert.Equal(model.CompanyId, actual.CompanyId);
Assert.Equal(model.Date.Value.Date, actual.Date);
Assert.Equal(model.AmountIncludingVAT, actual.AmountIncludingVAT);
Assert.Equal(model.VAT, actual.VAT);
Assert.Equal(user1.Organisation.Id, user1.Organisation.Id);
Assert.Equal(model.Processed, actual.Processed);
Assert.Equal(model.Notes, actual.Notes);
//Out of scope
scopeOptions = TestHelper.GetScopeOptions(user2, Scope.User);
result = await service.UpdateCommissionStatement(scopeOptions, model);
Assert.False(result.Success);
}
}
public async Task GetCommissionStatement()
{
var options = TestHelper.GetDbContext("GetCommissionStatement");
var user1 = TestHelper.InsertUserDetailed(options);
var user2 = TestHelper.InsertUserDetailed(options);
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = Guid.NewGuid(),
AmountIncludingVAT = 100,
VAT = 10,
Date = DateTime.Now,
Processed = true,
OrganisationId = user1.Organisation.Id,
Notes = "note 1"
};
var cs2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = Guid.NewGuid(),
AmountIncludingVAT = 200,
VAT = 20,
Date = DateTime.Now.AddDays(-1),
Processed = false,
OrganisationId = user1.Organisation.Id,
Notes = "note 2"
};
using (var context = new DataContext(options))
{
context.CommissionStatement.Add(cs1);
context.CommissionStatement.Add(cs2);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var auditService = new AuditServiceMock();
var service = new CommissionStatementService(context, null, auditService);
//When
var scope = TestHelper.GetScopeOptions(user1);
var actual = await service.GetCommissionStatement(scope, cs2.Id);
//Then
Assert.Equal(cs2.Id, actual.Id);
Assert.Equal(cs2.CompanyId, actual.CompanyId);
Assert.Equal(cs2.Date, actual.Date);
Assert.Equal(cs2.AmountIncludingVAT, actual.AmountIncludingVAT);
Assert.Equal(cs2.VAT, actual.VAT);
Assert.Equal(cs2.OrganisationId, user1.Organisation.Id);
Assert.Equal(cs2.Processed, actual.Processed);
Assert.Equal(cs2.Notes, actual.Notes);
//Check scope
scope = TestHelper.GetScopeOptions(user2);
actual = await service.GetCommissionStatement(scope, cs2.Id);
Assert.Null(actual);
}
}
public async Task GetCommissionStatements_DateFilter()
{
var options = TestHelper.GetDbContext("GetCommissionStatements_DateFilter");
var user1 = TestHelper.InsertUserDetailed(options);
var company = TestHelper.InsertCompany(options);
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
Date = new DateTime(2000, 1, 1),
OrganisationId = user1.Organisation.Id
};
var cs2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
Date = new DateTime(2000, 1, 20),
OrganisationId = user1.Organisation.Id
};
var cs3 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
Date = new DateTime(2000, 1, 31),
OrganisationId = user1.Organisation.Id
};
var cs4 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
Date = new DateTime(2000, 2, 1),
OrganisationId = user1.Organisation.Id
};
using (var context = new DataContext(options))
{
context.CommissionStatement.Add(cs1);
context.CommissionStatement.Add(cs2);
context.CommissionStatement.Add(cs3);
context.CommissionStatement.Add(cs4);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var auditService = new AuditServiceMock();
var service = new CommissionStatementService(context, null, auditService);
//When
var scope = TestHelper.GetScopeOptions(user1);
var filters = "startDate=1999-12-01;endDate=1999-12-31";
var queryOptions = new CommissionStatementQueryOptions(scope, "", "", 0, 0, filters);
var statements = await service.GetCommissionStatements(queryOptions);
Assert.Equal(0, statements.TotalItems);
Assert.Empty(statements.Items);
filters = "startDate=2000-01-01;endDate=2000-01-21";
queryOptions = new CommissionStatementQueryOptions(scope, "Date", "desc", 0, 0, filters);
statements = await service.GetCommissionStatements(queryOptions);
//Then
Assert.Equal(2, statements.TotalItems);
var items = statements.Items.ToList();
Assert.Equal(cs2.Id, items[0].Id);
Assert.Equal(cs1.Id, items[1].Id);
filters = "startDate=2000-01-01;endDate=2000-01-31";
queryOptions = new CommissionStatementQueryOptions(scope, "Date", "desc", 0, 0, filters);
statements = await service.GetCommissionStatements(queryOptions);
//Then
Assert.Equal(3, statements.TotalItems);
Assert.Equal(3, statements.Items.Count());
items = statements.Items.ToList();
Assert.Equal(cs3.Id, items[0].Id);
Assert.Equal(cs2.Id, items[1].Id);
Assert.Equal(cs1.Id, items[2].Id);
}
}
public async Task GetCommissionStatements()
{
var options = TestHelper.GetDbContext("GetCommissionStatements");
var user1 = TestHelper.InsertUserDetailed(options);
var user2 = TestHelper.InsertUserDetailed(options);
var company = TestHelper.InsertCompany(options);
var cs1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 111,
VAT = 11,
Date = DateTime.Now,
Processed = true,
OrganisationId = user1.Organisation.Id,
Notes = "note 1"
};
var cs2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 222,
VAT = 22,
Date = DateTime.Now.AddDays(-1),
Processed = false,
OrganisationId = user1.Organisation.Id,
Notes = "note 2"
};
var cs3 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 333,
VAT = 33,
Date = DateTime.Now.AddDays(-2),
Processed = false,
OrganisationId = user1.Organisation.Id,
Notes = "note 3"
};
var cs4 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
AmountIncludingVAT = 444,
VAT = 44,
Date = DateTime.Now.AddDays(-2),
Processed = false,
OrganisationId = user2.Organisation.Id,
Notes = "note 4"
};
var commission1a = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
AmountIncludingVAT = 50,
VAT = 5,
CommissionStatementId = cs1.Id,
UserId = user1.User.Id
};
var commission1b = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
AmountIncludingVAT = 50,
VAT = 5,
CommissionStatementId = cs1.Id,
UserId = user1.User.Id,
};
var commission2 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
AmountIncludingVAT = 200,
VAT = 20,
CommissionStatementId = cs2.Id,
UserId = user1.User.Id,
};
var commission3 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
AmountIncludingVAT = 300,
VAT = 30,
CommissionStatementId = cs3.Id,
UserId = user1.User.Id,
};
var commission4 = new CommissionEntity
{
Id = Guid.NewGuid(),
PolicyId = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
AmountIncludingVAT = 40,
VAT = 400,
CommissionStatementId = cs4.Id,
UserId = user2.User.Id,
};
using (var context = new DataContext(options))
{
context.CommissionStatement.Add(cs1);
context.CommissionStatement.Add(cs2);
context.CommissionStatement.Add(cs3);
context.CommissionStatement.Add(cs4);
context.Commission.Add(commission1a);
context.Commission.Add(commission1b);
context.Commission.Add(commission2);
context.Commission.Add(commission3);
context.Commission.Add(commission4);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
var auditService = new AuditServiceMock();
var service = new CommissionStatementService(context, null, auditService);
//When
var scope = TestHelper.GetScopeOptions(user1);
var queryOptions = new CommissionStatementQueryOptions(scope, "", "", 0, 0);
var statements = await service.GetCommissionStatements(queryOptions);
//Then
Assert.Equal(3, statements.TotalItems);
Assert.Equal(3, statements.Items.Count());
Assert.Equal(600, statements.SumAmountIncludingVAT);
Assert.Equal(60, statements.SumVAT);
var items = statements.Items.ToList();
var actual = items[0];
Assert.Equal(cs1.Id, actual.Id);
Assert.Equal(cs1.CompanyId, actual.CompanyId);
Assert.Equal(cs1.Date, actual.Date);
Assert.Equal(cs1.AmountIncludingVAT, actual.AmountIncludingVAT);
Assert.Equal(cs1.VAT, actual.VAT);
Assert.Equal(cs1.Processed, actual.Processed);
Assert.Equal(cs1.Notes, actual.Notes);
Assert.Equal(cs1.OrganisationId, user1.Organisation.Id);
Assert.Equal(100, actual.ActualAmountIncludingVAT);
Assert.Equal(10, actual.ActualVAT);
Assert.Equal(2, actual.CommissionCount);
actual = items[1];
Assert.Equal(cs2.Id, actual.Id);
actual = items[2];
Assert.Equal(cs3.Id, actual.Id);
//Check scope
scope = TestHelper.GetScopeOptions(user2);
queryOptions = new CommissionStatementQueryOptions(scope, "", "", 0, 0);
statements = await service.GetCommissionStatements(queryOptions);
Assert.Single(statements.Items);
actual = statements.Items.First();
Assert.Equal(cs4.Id, actual.Id);
}
}
public async Task UpdateUnknownCommissionTypes_CommissionErrors()
{
var options = TestHelper.GetDbContext("UpdateUnknownCommissionTypes_CommissionErrors");
var user1 = TestHelper.InsertUserDetailed(options);
var company = TestHelper.InsertCompany(options);
var commissionType1 = TestHelper.InsertCommissionType(options);
var commissionType2 = TestHelper.InsertCommissionType(options);
var template1 = new CommissionStatementTemplateEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
Config = new Config()
{
Sheets = new List <Sheet>()
{
new Sheet()
{
Config = new SheetConfig()
{
CommissionTypes = new CommissionTypes()
{
Types = new List <CommissionType>()
{
new CommissionType()
{
CommissionTypeCode = commissionType1.Code, Value = "abc"
},
new CommissionType()
{
CommissionTypeCode = commissionType2.Code, Value = "xyz"
}
}
}
}
}
}
}
};
var statement1 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = company.Id,
};
var statement2 = new CommissionStatementEntity
{
Id = Guid.NewGuid(),
CompanyId = Guid.NewGuid(),
};
var commission1 = new CommissionErrorEntity
{
Id = Guid.NewGuid(),
CommissionTypeId = OneAdvisor.Model.Commission.Model.Lookup.CommissionType.COMMISSION_TYPE_UNKNOWN_ID,
CommissionStatementId = statement1.Id,
Data = new ImportCommission()
{
CommissionTypeValue = "abc"
}
};
var commission2 = new CommissionErrorEntity
{
Id = Guid.NewGuid(),
CommissionTypeId = Guid.NewGuid(),
CommissionStatementId = statement1.Id,
Data = new ImportCommission()
{
CommissionTypeValue = "abc"
}
};
var commission3 = new CommissionErrorEntity
{
Id = Guid.NewGuid(),
CommissionTypeId = OneAdvisor.Model.Commission.Model.Lookup.CommissionType.COMMISSION_TYPE_UNKNOWN_ID,
CommissionStatementId = statement1.Id,
Data = new ImportCommission()
{
CommissionTypeValue = "xyz"
}
};
//Different company
var commission4 = new CommissionErrorEntity
{
Id = Guid.NewGuid(),
CommissionTypeId = OneAdvisor.Model.Commission.Model.Lookup.CommissionType.COMMISSION_TYPE_UNKNOWN_ID,
CommissionStatementId = statement2.Id,
Data = new ImportCommission()
{
CommissionTypeValue = "abc"
}
};
using (var context = new DataContext(options))
{
context.CommissionStatementTemplate.Add(template1);
context.CommissionStatement.Add(statement1);
context.CommissionError.Add(commission1);
context.CommissionError.Add(commission2);
context.CommissionError.Add(commission3);
context.CommissionError.Add(commission4);
context.SaveChanges();
}
using (var context = new DataContext(options))
{
List <CommissionErrorEntity> updatedCommissionErrors = null;
var bulkActions = new Mock <IBulkActions>(MockBehavior.Strict);
bulkActions.Setup(c => c.BulkUpdateCommissionErrorsAsync(It.IsAny <DataContext>(), It.IsAny <IList <CommissionErrorEntity> >()))
.Callback((DataContext dc, IList <CommissionErrorEntity> errors) =>
{
updatedCommissionErrors = errors.ToList();
})
.Returns(Task.CompletedTask);
var service = new CommissionStatementTemplateService(context, null, bulkActions.Object);
//When
await service.UpdateUnknownCommissionTypes(template1.Id);
//Then
Assert.Equal(2, updatedCommissionErrors.Count);
Assert.Equal(commission1.Id, updatedCommissionErrors[0].Id);
Assert.Equal(commissionType1.Id, updatedCommissionErrors[0].CommissionTypeId);
Assert.Equal(commissionType1.Code, updatedCommissionErrors[0].Data.CommissionTypeCode);
Assert.Equal(commission3.Id, updatedCommissionErrors[1].Id);
Assert.Equal(commissionType2.Id, updatedCommissionErrors[1].CommissionTypeId);
Assert.Equal(commissionType2.Code, updatedCommissionErrors[1].Data.CommissionTypeCode);
}
}