public async Task AddSalary_Duplicate()
{
await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 1 });
await dbContext.Salaries.AddAsync(new Salary { SalaryId = 1, Value = 100, TimePeriod = "some", EmployeeId = 1 });
await dbContext.Salaries.AddAsync(new Salary { SalaryId = 2, Value = 200, TimePeriod = "some2", EmployeeId = 1 });
await dbContext.SaveChangesAsync();
var objToBeAdded = new Salary {
SalaryId = 3, Value = 300, TimePeriod = "some2", EmployeeId = 1
};
var dao = new PostgresDataAccessObjectService(dbContext);
bool exThrown = false;
try {
exThrown = true;
dao.AddSalary(objToBeAdded);
} catch (Exception ex) {
Assert.Equal(typeof(ArgumentException), ex.GetType());
Assert.Equal("Salary with TimePeriod: some2 for Employee: 1 already exists", ex.Message);
}
Assert.True(exThrown);
}
public async Task AddSalary_WhenNotEmptyTable()
{
await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 2 });
await dbContext.Salaries.AddAsync(new Salary { SalaryId = 1, Value = 100, TimePeriod = "some", EmployeeId = 1 });
await dbContext.Salaries.AddAsync(new Salary { SalaryId = 2, Value = 200, TimePeriod = "some2", EmployeeId = 1 });
await dbContext.SaveChangesAsync();
var objToBeAdded = new Salary {
SalaryId = 3, Value = 300, TimePeriod = "some2", EmployeeId = 2
};
var dao = new PostgresDataAccessObjectService(dbContext);
dao.AddSalary(objToBeAdded);
var coll = dao.GetAllSalaries();
Assert.Equal(3, coll.Count);
Assert.Equal(100f, coll[0].Value);
Assert.Equal(200f, coll[1].Value);
Assert.Equal(1, coll[0].EmployeeId);
Assert.Equal(1, coll[1].EmployeeId);
Assert.Equal(2, coll[2].EmployeeId);
}
public async Task AddSalary_WhenEmptyTable()
{
await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 4 });
await dbContext.SaveChangesAsync();
var objToBeAdded = new Salary {
SalaryId = 3, Value = 300, TimePeriod = "some2", EmployeeId = 4
};
var dao = new PostgresDataAccessObjectService(dbContext);
dao.AddSalary(objToBeAdded);
var coll = dao.GetAllSalaries();
Assert.Single(coll);
Assert.Equal(4, coll[0].EmployeeId);
}
public async Task AddSalary_WhenEmployeeIdNotSet()
{
await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 9 });
await dbContext.SaveChangesAsync();
var objToBeAdded = new Salary {
SalaryId = 3, Value = 300, TimePeriod = "some2"
};
var dao = new PostgresDataAccessObjectService(dbContext);
bool exThrown = false;
try {
exThrown = true;
dao.AddSalary(objToBeAdded);
} catch (Exception e) {
Assert.Equal(typeof(ArgumentException), e.GetType());
Assert.Equal("EmployeeId was not set", e.Message);
}
Assert.True(exThrown);
}
public async Task Synchronize_Works_StartWithNotEmplyDb_HQNotEmpty_SalaryIsNotAddedTwice()
{
var cs = CommonHelpers.MockConfServ(false);
var hqApiClient = new Moq.Mock <IHQAPIClient>();
// setup HQ state
var hqEmp1 = new HQEmployee {
Name = "Jan K", Email = "*****@*****.**", IsManager = false, ID = 1
};
var hqEmp2 = new HQEmployee {
Name = "Ela K", Email = "*****@*****.**", IsManager = true, ID = 2
};
var hqEmps = new List <HQEmployee>();
hqEmps.Add(hqEmp1);
hqEmps.Add(hqEmp2);
hqApiClient.Setup(m => m.ListEmployees(cs.GetBranchOfficeId())).Returns(
Task.FromResult(hqEmps)
);
var hqSalary1 = new HQSalary {
ID = 1, EmployeeID = 2, Value = 1000, TimePeriod = "hqsalary1"
};
var hqSalary2 = new HQSalary {
ID = 2, EmployeeID = 2, Value = 1000, TimePeriod = "hqsalary2"
};
var hqSalaries = new List <HQSalary>();
hqSalaries.Add(hqSalary1);
hqSalaries.Add(hqSalary2);
hqApiClient.Setup(m => m.ListSalariesForEmployee(2)).Returns(
Task.FromResult(hqSalaries)
);
var dao = new PostgresDataAccessObjectService(dbContext);
// setup BO state
var boEmp2 = new Employee {
Name = "Ela K", Email = "*****@*****.**", EmployeeId = 5, IsManager = true
};
dao.AddEmployee(boEmp2, true);
var salary3 = new Salary {
SalaryId = 3, EmployeeId = 5, TimePeriod = "hqsalary1", Value = 333
};
dao.AddSalary(salary3, true);
var ss = new SynchronizatorService(hqApiClient.Object, cs, dao);
await ss.Synchronize();
hqApiClient.Verify(m => m.ListEmployees(0), Moq.Times.Once);
// 1 for each hq employee
hqApiClient.Verify(m => m.ListSalariesForEmployee(Moq.It.IsAny <int>()), Moq.Times.Exactly(2));
ss.Dispose();
var emps = dao.GetAllEmployees();
var eh = dao.GetAllEmployeeHours();
var salaries = dao.GetAllSalaries();
Assert.Equal(2, emps.Count);
Assert.Equal("*****@*****.**", emps[1].Email);
Assert.Equal("*****@*****.**", emps[0].Email);
Assert.Empty(eh);
Assert.Equal(2, salaries.Count);
}
