public void GetAllEmployees_ShouldReturnEmptyListWhenDBIsEmpty() { var dao = new PostgresDataAccessObjectService(dbContext); var employees = dao.GetAllEmployees(); Assert.Empty(employees); }
public async Task Synchronize_Works_StartWithEmplyDb_HQEmpty() { var cs = CommonHelpers.MockConfServ(false); var hqApiClient = new Moq.Mock <IHQAPIClient>(); // no employees in HQ hqApiClient.Setup(m => m.ListEmployees(cs.GetBranchOfficeId())).Returns( Task.FromResult(new List <HQEmployee>()) ); // no salaries in HQ hqApiClient.Setup(m => m.ListSalariesForEmployee(Moq.It.IsAny <int>())).Returns( Task.FromResult(new List <HQSalary>()) ); var dao = new PostgresDataAccessObjectService(dbContext); var ss = new SynchronizatorService(hqApiClient.Object, cs, dao); await ss.Synchronize(); hqApiClient.Verify(m => m.ListEmployees(0), Moq.Times.Once); // ListEmployees did not succeed, so no new http requests are handled hqApiClient.Verify(m => m.ListSalariesForEmployee(Moq.It.IsAny <int>()), Moq.Times.Never); ss.Dispose(); var emps = dao.GetAllEmployees(); var eh = dao.GetAllEmployeeHours(); Assert.Empty(emps); Assert.Empty(eh); }
public async Task DeleteEmployee_WhenNotExists() { await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 4 }); await dbContext.Employees.AddAsync(new Employee { Name = "Ola 2", Email = "*****@*****.**", EmployeeId = 5 }); await dbContext.SaveChangesAsync(); var dao = new PostgresDataAccessObjectService(dbContext); var coll = dao.GetAllEmployees(); Assert.Equal(2, coll.Count); dao.DeleteEmployee(477); coll = dao.GetAllEmployees(); Assert.Equal(2, coll.Count); }
public async Task GetAllEmployees_ShouldReturnAllEmployeesWhenSomeInDB() { await dbContext.Employees.AddAsync(new Employee { Name = "Ola Dwa", Email = "*****@*****.**" }); await dbContext.SaveChangesAsync(); var dao = new PostgresDataAccessObjectService(dbContext); var employees = dao.GetAllEmployees(); Assert.Single(employees); }
public async Task Synchronize_Works_StartWithEmplyDb_HQNotEmpty() { var cs = CommonHelpers.MockConfServ(false); var hqApiClient = new Moq.Mock <IHQAPIClient>(); 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); var hqSalary1 = new HQSalary { ID = 1, EmployeeID = 1, Value = 1000, TimePeriod = "01.02.2019-06.02.2019" }; var hqSalary2 = new HQSalary { ID = 2, EmployeeID = 1, Value = 1000, TimePeriod = "07.02.2019-09.02.2019" }; var hqSalaries = new List <HQSalary>(); hqSalaries.Add(hqSalary1); hqSalaries.Add(hqSalary2); hqApiClient.Setup(m => m.ListEmployees(cs.GetBranchOfficeId())).Returns( Task.FromResult(hqEmps) ); hqApiClient.Setup(m => m.ListSalariesForEmployee(1)).Returns( Task.FromResult(hqSalaries) ); var dao = new PostgresDataAccessObjectService(dbContext); 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[0].Email); Assert.Equal("*****@*****.**", emps[1].Email); Assert.Empty(eh); Assert.Equal(2, salaries.Count); }
public void AddEmployee_WhenEmptyTable() { var emp = new Employee { Name = "Ola 2", Email = "*****@*****.**", EmployeeId = 44 }; var dao = new PostgresDataAccessObjectService(dbContext); dao.AddEmployee(emp); var coll = dao.GetAllEmployees(); Assert.Single(coll); Assert.Equal("Ola 2", coll[0].Name); Assert.Equal("*****@*****.**", coll[0].Email); Assert.Equal(1, coll[0].EmployeeId);// apparently we must start from 1 }
public async Task AddEmployee_WhenNotEmptyTable() { await dbContext.Employees.AddAsync(new Employee { Name = "Ola AAA", Email = "*****@*****.**", EmployeeId = 4 }); await dbContext.SaveChangesAsync(); var emp = new Employee { Name = "Ola 2", Email = "*****@*****.**", EmployeeId = 44 }; var dao = new PostgresDataAccessObjectService(dbContext); dao.AddEmployee(emp); var coll = dao.GetAllEmployees(); Assert.Equal(2, coll.Count); Assert.Equal("Ola AAA", coll[0].Name); Assert.Equal("Ola 2", coll[1].Name); Assert.Equal("*****@*****.**", coll[0].Email); Assert.Equal("*****@*****.**", coll[1].Email); Assert.Equal(4, coll[0].EmployeeId); Assert.Equal(5, coll[1].EmployeeId); }
public async Task Synchronize_Works_StartWithNotEmplyDb_HQNotEmpty() { 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 = 1, Value = 1000, TimePeriod = "hqsalary1" }; var hqSalary2 = new HQSalary { ID = 2, EmployeeID = 1, Value = 1000, TimePeriod = "hqsalary2" }; var hqSalaries = new List <HQSalary>(); hqSalaries.Add(hqSalary1); hqSalaries.Add(hqSalary2); hqApiClient.Setup(m => m.ListSalariesForEmployee(1)).Returns( Task.FromResult(hqSalaries) ); var dao = new PostgresDataAccessObjectService(dbContext); // setup BO state var boEmp1 = new Employee { Name = "BO Employee1", Email = "*****@*****.**", EmployeeId = 4 }; // will be deleted var boEmp2 = new Employee { Name = "Ela K", Email = "*****@*****.**", EmployeeId = 5, IsManager = true }; dao.AddEmployee(boEmp1, true); dao.AddEmployee(boEmp2, true); var eh1 = new EmployeeHours { EmployeeHoursId = 102, Value = 100f, TimePeriod = "01.01.2019_01.01.2019", EmployeeId = 4 }; // will be deleted var eh2 = new EmployeeHours { EmployeeHoursId = 103, Value = 100f, TimePeriod = "02.01.2019_02.01.2019", EmployeeId = 4 }; // will be deleted var eh3 = new EmployeeHours { EmployeeHoursId = 104, Value = 100f, TimePeriod = "03.01.2019_03.01.2019", EmployeeId = 4 }; // will be deleted var eh4 = new EmployeeHours { EmployeeHoursId = 105, Value = 100f, TimePeriod = "02.01.2019_08.01.2019", EmployeeId = 5 }; dao.AddEmployeeHours(eh1, true); dao.AddEmployeeHours(eh2, true); dao.AddEmployeeHours(eh3, true); dao.AddEmployeeHours(eh4, true); var salary1 = new Salary { SalaryId = 1, EmployeeId = 4, TimePeriod = "bosalary1", Value = 111 }; // will be deleted var salary2 = new Salary { SalaryId = 2, EmployeeId = 4, TimePeriod = "bosalary2", Value = 222 }; // will be deleted var salary3 = new Salary { SalaryId = 3, EmployeeId = 5, TimePeriod = "bosalary3", Value = 333 }; dao.AddSalary(salary1, true); dao.AddSalary(salary2, true); 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.Single(eh); Assert.Equal(105, eh[0].EmployeeHoursId); Assert.Equal(3, salaries.Count); }