public void GetEmployees_ListOfIds_ListOfEmployees() { IList<Employee> employee; using (var dbContext = new DatabaseContext(testUser, testPass)) { var repository = new EmployeesRepository(dbContext); var ids = new int[5] { 1, 2, 3, 4, 5 }; employee = repository.GetByIdList(ids); } Assert.IsTrue(employee.Count > 1); }
public void FindByFilter_FilterString_ListOfEmployees() { IList<Employee> employee; string lastNameFilter = "Aleksandr"; using (var dbContext = new DatabaseContext(testUser, testPass)) { var repository = new EmployeesRepository(dbContext); employee = repository.FindByLastName(lastNameFilter); } Assert.IsTrue(employee.All(x => x.LastName.Contains(lastNameFilter))); }
public void ChangeCredentialsToDBonRuntime_twousers_bonusesFound() { int numberOfBonusesFirstUser; int numberOfBonusesSecondUser; using (var dbContext = new DatabaseContext("ryakh", "1")) { var repository = new BonusesRepository(dbContext); numberOfBonusesFirstUser = repository.FindAll().Count(); } using (var dbContext = new DatabaseContext("kmikula", "1")) { var repository = new BonusesRepository(dbContext); numberOfBonusesSecondUser = repository.FindAll().Count(); } Assert.IsTrue(numberOfBonusesFirstUser > 0); Assert.IsTrue(numberOfBonusesSecondUser > 0); }
public JsonResult Create(BonusDto bonusDto) { BonusAggregate bonus; if (bonusDto.Amount <= 0) throw new ArgumentOutOfRangeException("Amount should be more than 0"); if (bonusDto.EmployeeId <= 0) throw new ArgumentNullException("You should specify an existing employee"); using (var dbContext = new DatabaseContext()) { BonusesRepository = new BonusesRepository(dbContext); var employeeRepository = new EmployeesRepository(dbContext); bonus = new BonusFactory(employeeRepository).Create(bonusDto); BonusesRepository.Save(bonus); } return Json(bonus); }
public void Save_noParams_exception() { using (var dbContext = new DatabaseContext(testUser, testPass)) { employeeRepository = new EmployeesRepository(dbContext); employeeRepository.Save(new Employee("", "", "")); } }
public JsonResult Edit(BonusDto bonusDto) { if (bonusDto == null) throw new ArgumentNullException("bonusDto can not be null in controller Edit"); Employee employee = null; BonusAggregate bonus = null; using (var dbContext = new DatabaseContext()) { if (bonusDto.EmployeeId != 0) { var employeeRepository = new EmployeesRepository(dbContext); employee = employeeRepository.GetById(bonusDto.EmployeeId); } BonusesRepository = new BonusesRepository(dbContext); bonus = BonusesRepository.GetById(bonusDto.BonusId); bonus.Comment = bonusDto.Comment; bonus.Amount = bonusDto.Amount; bonus.Date = bonusDto.Date; bonus.IsActive = bonusDto.IsActive; if (employee != null && employee.EmployeeId != bonus.EmployeeId) { bonus.Employee = employee; } BonusesRepository.Save(bonus); } return Json(bonus); }
public JsonResult GetPagedJsonBonuses(int take, int skip) { PagedResponse<BonusAggregate> bonuses; var filteredRequest = new FilteredRequest(Request.Params); using (var dbContext = new DatabaseContext()) { BonusesRepository = new BonusesRepository(dbContext); bonuses = BonusesRepository.FindAll(skip, take, filteredRequest.SortingField, filteredRequest.Direction, filteredRequest.FilterField, filteredRequest.FilterPattern); } return Json(bonuses, JsonRequestBehavior.AllowGet); }
public JsonResult GetJsonEmployeesByLastName() { IList<Employee> employees = new List<Employee>(); string lastName = FilterStringFactory.FormFilterValue(Request.Params); if (String.IsNullOrEmpty(lastName) == false) { using (var dbContext = new DatabaseContext()) { var employeesRepository = new EmployeesRepository(dbContext); employees = employeesRepository.FindByLastName(lastName); } } if (employees.Count == 0) // this's because some magic happens with autocomplete combobox employees.Add(new Employee("", "", "")); // and it start to cycle ajax requests if the list is empty or null return Json(employees, JsonRequestBehavior.AllowGet); }
public void FindAll_NoParams_EmployeeExists() { BonusAggregate bonusAggregate; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); bonusAggregate = bonusRepository.FindAll().First(); } Assert.IsNotNull(bonusAggregate.Employee); }
/// <summary> /// Gets the employee by id. /// </summary> /// <param name="id">The id.</param> /// <returns>Employee.</returns> private Employee GetEmployeeById(int id = 1) { Employee employee; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { employeeRepository = new EmployeesRepository(dbContext); employee = employeeRepository.GetById(id); } return employee; }
public void Save_BonusesList_2BonusesUpdated() { IList<BonusAggregate> bonusesToUpdate; IList<BonusAggregate> updatedBonuses = new List<BonusAggregate>(); var bonusesIds = new int[2]; string newComment = "comment on " + DateTime.Now; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); bonusesToUpdate = bonusRepository.FindAll().Take(2).ToList(); bonusesToUpdate[0].Comment = newComment; bonusesToUpdate[1].Comment = newComment; bonusesIds[0] = bonusesToUpdate[0].BonusId; bonusesIds[1] = bonusesToUpdate[1].BonusId; bonusRepository.Save(bonusesToUpdate); } using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); updatedBonuses.Add(bonusRepository.GetById(bonusesIds[0])); updatedBonuses.Add(bonusRepository.GetById(bonusesIds[1])); } Assert.AreEqual(updatedBonuses[0].Comment, newComment); Assert.AreEqual(updatedBonuses[1].Comment, newComment); }
public void Save_BonusesList_2BonusesAdded() { int numberOfItemsBeforSave; int numberOfCurrentBonuses; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusFactory = new BonusFactory(new EmployeesRepository(dbContext)); var bonusesList = new List<BonusAggregate> { bonusFactory.Create(GetEmployeeById(4), DateTime.Now, 100), bonusFactory.Create(GetEmployeeById(5), DateTime.Now, 90) }; bonusRepository = new BonusesRepository(dbContext); numberOfItemsBeforSave = bonusRepository.FindAll().Count(); bonusRepository.Save(bonusesList); numberOfCurrentBonuses = bonusRepository.FindAll().Count(); } Assert.AreEqual(numberOfCurrentBonuses - 2, numberOfItemsBeforSave); }
public void GetById_NoParams_Bonus() { BonusAggregate bonusAggregate; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); bonusAggregate = bonusRepository.GetById(1); } Assert.AreEqual(1, bonusAggregate.BonusId); }
public void FindAll_noParams_SomeBonuses() { IList<BonusAggregate> bonuses; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); bonuses = bonusRepository.FindAll(); } Assert.IsNotNull(bonuses); Assert.AreNotEqual(0, bonuses.Count); }
public void FindAllWithPaging_NegativeSkip2Take3_3bonuses() { using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); bonusRepository.FindAllWithPaging(-2, 3); } }
public void GetFirstEmployee_noParams_employee() { Employee employee; using (var dbContext = new DatabaseContext(testUser, testPass)) { employeeRepository = new EmployeesRepository(dbContext); employee = employeeRepository.FindAll().FirstOrDefault(); } Assert.IsNotNull(employee); }
public void FindAllWithPaging_Skip2Take3_CorrectTotalCount() { IList<BonusAggregate> notSkipedBonuses; PagedResponse<BonusAggregate> skipedBonuses; using (var dbContext = new DatabaseContext(TestUser, TestPass)) { bonusRepository = new BonusesRepository(dbContext); notSkipedBonuses = bonusRepository.FindAll(); skipedBonuses = bonusRepository.FindAllWithPaging(2, 3); } Assert.AreEqual(skipedBonuses.TotalCount, notSkipedBonuses.Count); }