public void GetAllEmployeesTest() { EmployeeSqlDAL testEmployee = new EmployeeSqlDAL(connectionString); List <Employee> testList = testEmployee.GetAllEmployees(); Assert.AreEqual(numOfEmployee, testList.Count); }
public void Initialize() { _departmentItem = new DepartmentSqlDAL(_connectionString); _department = new Department(); _department.Name = "Test Department"; _department.Id = _departmentItem.CreateDepartment(_department); // Initialize a new transaction scope. This automatically begins the transaction. tran = new TransactionScope(); _employeeItem = new EmployeeSqlDAL(_connectionString); _employee = new Employee(); _employee.DepartmentId = _department.Id; _employee.FirstName = "John"; _employee.LastName = "Smith"; _employee.Gender = "M"; _employee.JobTitle = "Developer"; _employee.BirthDate = new DateTime(1990, 01, 01); _employee.HireDate = new DateTime(2000, 02, 03); _employee.EmployeeId = _employeeItem.CreateEmployee(_employee); }
public void GetEmployeesWithoutProjects_Test() { EmployeeSqlDAL getEmployeeTest = new EmployeeSqlDAL(connectionString); List <Employee> noProjectList = getEmployeeTest.GetEmployeesWithoutProjects(); Assert.AreEqual(noProjectsCount, noProjectList.Count); }
public void GetAllEmployeesTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); List <Employee> employees = employee.GetAllEmployees(); Assert.AreEqual(12, employees.Count); }
public void EmployeeSearchTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); IList <Employee> restul = employee.Search("John", "Fulton"); Assert.IsNotNull(restul); }
public void SearchTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); List <Employee> employees = employee.Search("Flo", "Henderson"); Assert.AreEqual(1, employees.Count); }
public void GetEmployeesWithoutProjectsTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); List <Employee> employees = employee.GetEmployeesWithoutProjects(); Assert.AreEqual(1, employees.Count); }
public void EmployeeTests() { // Open a SqlConnection object using the active transaction using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); EmployeeSqlDAL testDAL = new EmployeeSqlDAL(connectionString); IList <Employee> testList = new List <Employee>(); testList = testDAL.GetAllEmployees(); int savecount = testList.Count; Assert.AreNotEqual(0, testList.Count, "There should be Initial Data"); Employee testEmployee = new Employee(); testEmployee.DepartmentId = 1; testEmployee.FirstName = "Roger"; testEmployee.LastName = "Rabbit"; testEmployee.JobTitle = "Cartoon Actor"; testEmployee.BirthDate = Convert.ToDateTime("01/01/1981"); testEmployee.Gender = "M"; testEmployee.HireDate = Convert.ToDateTime("06/22/1988"); SqlCommand command = new SqlCommand("Insert into employee (department_id,first_name,last_name,job_title,birth_date,gender,hire_date)" + $" Values ('{testEmployee.DepartmentId}','{testEmployee.FirstName}','{testEmployee.LastName}','{testEmployee.JobTitle}','{testEmployee.BirthDate}','{testEmployee.Gender}','{testEmployee.HireDate}')", conn); command.ExecuteNonQuery(); testList = testDAL.GetAllEmployees(); Assert.AreEqual(savecount + 1, testList.Count, "List should have 1 more element"); testList = testDAL.Search("Roger", "Rabbit"); Assert.AreEqual(1, testList.Count, "Search should return 1"); } }
public void EmployeeWithoutProjectTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); IList <Employee> list = employee.GetEmployeesWithoutProjects(); Assert.IsTrue(list.Count > 0); }
public void GetEmployeesWithoutProjectsTest() { EmployeeSqlDAL newEmployee = new EmployeeSqlDAL(connectionString); List <Employee> employeesList = newEmployee.GetEmployeesWithoutProjects(); Assert.IsNotNull(employeesList); }
public void ShowEmployees() { EmployeeSqlDAL employeeSqlDal = new EmployeeSqlDAL(connectionString); List <Employee> employees = employeeSqlDal.GetAllEmployees(); Assert.IsNotNull(employees); Assert.AreEqual(numOfEmployee, employees.Count - 1); }
public void GetAllEmployeeWithoutProjectsTests() { EmployeeSqlDAL empDal = new EmployeeSqlDAL(connectionString); List <Employee> emp = empDal.GetAllEmployees(); Assert.AreEqual("firstname", emp[emp.Count - 1].FirstName); Assert.AreEqual("lastname", emp[emp.Count - 1].LastName); }
public void SearchTest() { EmployeeSqlDAL empDal = new EmployeeSqlDAL(connectionString); List <Employee> emp = empDal.Search("Chris", "Christie"); Assert.AreEqual(1, emp.Count); Assert.AreEqual("Chris", emp[0].FirstName); }
public void GetAllEmployeeTests() { EmployeeSqlDAL empDal = new EmployeeSqlDAL(connectionString); List <Employee> emp = empDal.GetAllEmployees(); Assert.AreEqual(13, emp.Count); Assert.AreEqual("firstname", emp[12].FirstName); }
public void GetEmployeesWithoutProjects() { EmployeeSqlDAL eSQL = new EmployeeSqlDAL(connectionString); List <Employee> e = eSQL.GetEmployeesWithoutProjects(); Assert.IsNotNull(e); }
public void SearchTest() { EmployeeSqlDAL eSQL = new EmployeeSqlDAL(connectionString); List <Employee> e = eSQL.Search("Matthew", "Duford"); Assert.IsNotNull(e); }
public void GetAllEmployeesTest() { EmployeeSqlDAL eSQL = new EmployeeSqlDAL(connectionString); List <Employee> e = eSQL.GetAllEmployees(); Assert.IsNotNull(e); }
public void SearchTest() { EmployeeSqlDAL newEmployee = new EmployeeSqlDAL(connectionString); List <Employee> employeesList = newEmployee.Search("Mike", "Beers"); Assert.AreEqual(employeesList[0].FirstName, "Mike"); Assert.AreEqual(employeesList[0].LastName, "Beers"); }
public void GetWithoutProjectsTest() { EmployeeSqlDAL testEmployee = new EmployeeSqlDAL(connectionString); List <Employee> withoutList = testEmployee.GetEmployeesWithoutProjects(); Assert.AreEqual(2, withoutList.Count); Assert.AreEqual("Coty", withoutList[0].LastName); }
public void GetAllEmployeesTest() { EmployeeSqlDAL employee = new EmployeeSqlDAL(connectionString); IList <Employee> names = employee.GetAllEmployees(); Assert.IsNotNull(names); Assert.AreEqual(employeeCount + 1, names.Count); }
public void GetAllEmployees_Test() { EmployeeSqlDAL getEmployeeTest = new EmployeeSqlDAL(connectionString); List <Employee> employeeList = getEmployeeTest.GetAllEmployees(); Assert.IsNotNull(employeeList); Assert.AreEqual(employeeCount + 1, employeeList.Count); }
public void GetAllEmployeesTest() { EmployeeSqlDAL employeeSqldal = new EmployeeSqlDAL(connectionString); List <Employee> employees = employeeSqldal.GetAllEmployees(); Assert.AreEqual(numberOfEmployees, employees.Count); }
public void SearchEmployeesTest() { EmployeeSqlDAL testEmployee = new EmployeeSqlDAL(connectionString); List <Employee> testList = testEmployee.Search("Sid", "Goodman"); Assert.AreEqual("Sid", testList[0].FirstName); Assert.AreEqual("Goodman", testList[0].LastName); Assert.AreEqual(1, testList.Count); }
public void Search_Test() { EmployeeSqlDAL getEmployeeTest = new EmployeeSqlDAL(connectionString); List <Employee> empSearchTest = getEmployeeTest.Search("Test", "Employee"); CollectionAssert.AllItemsAreNotNull(empSearchTest); Assert.AreEqual(1, empSearchTest.Count); Equals("Test", empSearchTest[0].FirstName); }
public void SearchEmployeesTest() { //Arrange EmployeeSqlDAL employeeDAL = new EmployeeSqlDAL(connectionString); //Assert Assert.AreEqual(2, newEmployeeID); }
public void GetAllEmployeesTest() { EmployeeSqlDAL newEmployee = new EmployeeSqlDAL(connectionString); List <Employee> employeesList = newEmployee.GetAllEmployees(); employees++; Assert.IsNotNull(employeesList); Assert.AreEqual(employees, employeesList.Count); }
public void SearchEmployee() { EmployeeSqlDAL employeeSqlDal = new EmployeeSqlDAL(connectionString); List <Employee> employees = employeeSqlDal.GetAllEmployees(); employees = employeeSqlDal.Search("Joe", "Testman"); Assert.AreEqual(employeeId, employees[0].EmployeeId); Assert.AreEqual("Joe", employees[0].FirstName); }
public void EmployeeListTests() { EmployeeSqlDAL employeeDal = new EmployeeSqlDAL(connectionString); List <Employee> getEmployee = employeeDal.GetAllEmployees(); Assert.AreEqual(12, getEmployee.Count); Assert.IsNotNull(getEmployee); Assert.IsTrue(getEmployee.Count > 0); }
public void EmployeesWithoutProjectsTest() { //Arrange EmployeeSqlDAL employeeDAL = new EmployeeSqlDAL(connectionString); List <Employee> employees = employeeDAL.GetEmployeesWithoutProjects(); //Assert Assert.AreEqual(1, numOfEmployeesWithoutProjects); }
public void TestSearch() { //Arrange EmployeeSqlDAL employeeDAL = new EmployeeSqlDAL(connectionString); //Act List <Employee> foundEmployee = employeeDAL.Search("Delora", "Coty"); //Assert Assert.AreEqual(searchEmployee[0].EmployeeId, foundEmployee[0].EmployeeId); }