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 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);
        }