public void SearchTest() { EmployeeSqlDAO employeeSqlDAO = new EmployeeSqlDAO(connectionString); List <Employee> employeesList = (List <Employee>)employeeSqlDAO.Search("Sid", "Goodman"); Assert.AreEqual(1, employeesList.Count); }
public void EmployeeSearch_Should_Return_Correct_Results(string firstName, string lastName, int expectedCount) { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> employees = dao.Search(firstName, lastName); Assert.AreEqual(expectedCount, employees.Count); }
public void GetEmployeesWithoutProjectsTest() { EmployeeSqlDAO employeeSqlDAO = new EmployeeSqlDAO(connectionString); List <Employee> employeesList = (List <Employee>)employeeSqlDAO.GetEmployeesWithoutProjects(); Assert.AreEqual(2, employeesList.Count); }
public void Get_employees_not_assigned_to_tests() { EmployeeSqlDAO employeesNotAssigned = new EmployeeSqlDAO(ConnectionString); List <Employee> noProjectList = (List <Employee>)employeesNotAssigned.GetEmployeesWithoutProjects(); Assert.AreEqual(projectID, noProjectList.Count); }
public void GetAllEmployeesTest() { EmployeeSqlDAO employeeSqlDAO = new EmployeeSqlDAO(connectionString); List <Employee> employeesList = (List <Employee>)employeeSqlDAO.GetAllEmployees(); Assert.AreEqual(12, employeesList.Count); }
public void GetAllEmployees_Should_Return_Correct_Count() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> employees = dao.GetAllEmployees(); Assert.AreEqual(2, employees.Count); }
public void GetEmployeesWithoutProjects_Test() { EmployeeSqlDAO accessObj = new EmployeeSqlDAO(connectionString); IList <Employee> listOfEmployeesToFire = accessObj.GetEmployeesWithoutProjects(); Assert.AreEqual(3, listOfEmployeesToFire.Count); }
public void Search_Test() { EmployeeSqlDAO accessObj = new EmployeeSqlDAO(connectionString); IList <Employee> listofMatchedEmployess = accessObj.Search("JoEli", "Collinsall"); Assert.AreEqual(1, listofMatchedEmployess.Count); }
public void GetEmployeesWithoutProjects_Should_Return_Correct_Count() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> employees = dao.GetEmployeesWithoutProjects(); Assert.AreEqual(1, employees.Count); Assert.AreEqual(UnassignedEmployeeId, employees[0].EmployeeId); }
public void TestSearch() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> result = dao.Search("pe", "pe"); Assert.AreEqual(NewEmployeeId, result[0].EmployeeId); }
public void TestGetEmployeesWithoutProjects() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> result = dao.GetEmployeesWithoutProjects(); Assert.AreEqual(NewEmployeeId2, result[0].EmployeeId); }
public void Search_Test() { EmployeeSqlDAO getEmployee = new EmployeeSqlDAO(ConnectionString); List <Employee> searchTest = (List <Employee>)getEmployee.Search("TheFun", "Employee"); CollectionAssert.AllItemsAreNotNull(searchTest); Assert.AreEqual(1, searchTest.Count); Equals("TheFun", searchTest[0].FirstName); }
static void Main(string[] args) { IProjectDAO projectDAO = new ProjectSqlDAO(@"Data Source =.\SQLEXPRESS; Initial Catalog = EmployeeDB; Integrated Security = True"); IEmployeeDAO employeeDAO = new EmployeeSqlDAO(@"Data Source =.\SQLEXPRESS; Initial Catalog = EmployeeDB; Integrated Security = True"); IDepartmentDAO departmentDAO = new DepartmentSqlDAO(@"Data Source =.\SQLEXPRESS; Initial Catalog = EmployeeDB; Integrated Security = True"); ProjectCLI projectCLI = new ProjectCLI(employeeDAO, projectDAO, departmentDAO); projectCLI.RunCLI(); }
public void SearchForEmployeeTest() { // Arrange EmployeeSqlDAO employee = new EmployeeSqlDAO(ConnectionString); // Act IList <Employee> employees = employee.Search("Sarah", "Watkins"); // Assert Assert.AreEqual(1, employees.Count); }
public void GetEmployeesWithoutProjectsTest() { // Arrange EmployeeSqlDAO employee = new EmployeeSqlDAO(ConnectionString); // Act IList <Employee> employees = employee.GetEmployeesWithoutProjects(); // Assert Assert.AreEqual(1, employees.Count); }
public void TestGetAllEmployees() { // Arrange EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); //ACT IList <Employee> result = dao.GetAllEmployees(); //ASERT Assert.AreEqual(GetRowCount("employee"), result.Count); }
public void GetEmployeesWithoutProjectsTest() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> iemployees = dao.GetEmployeesWithoutProjects(); List <Employee> employees = iemployees.ToList(); Assert.IsNotNull(employees); Assert.IsTrue(employees.Count > 0); Assert.IsNotNull(employees.Find(e => e.EmployeeId == testEmployeeId)); Assert.IsNull(employees.Find(e => e.EmployeeId == testEmployeeIdAssignedToProject)); }
public void Get_Employee_Test() { //Arrange EmployeeSqlDAO getEmployee = new EmployeeSqlDAO(ConnectionString); List <Employee> employeeList = (List <Employee>)getEmployee.GetAllEmployees(); //Assert Assert.IsNotNull(employeeList); Assert.AreEqual(numberOfEmployees + 1, employeeList.Count); }
public void GetAllEmployees_ShouldReturnEmployees() { //Arrange EmployeeSqlDAO employee = new EmployeeSqlDAO(ConnectionString); //Act int result = employee.GetAllEmployees().Count; //Assert Assert.AreEqual(1, result); }
public void GetAllEmployees_ShouldReturnRightNumberOfEmployees() { //Arrange const int numberOfEmployeesAddedForTests = 2;//set in sql test setup file EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); //Act IList <Employee> employees = dao.GetAllEmployees(); //Assert Assert.AreEqual(numberOfEmployeesAddedForTests, employees.Count, "GetAllEmployees doesn't return correct number for one employee"); }
public void GetAllEmployeesTest() { // Arrange EmployeeSqlDAO employee = new EmployeeSqlDAO(ConnectionString); // Act IList <Employee> employees = employee.GetAllEmployees(); // Assert Assert.AreEqual(2, employees.Count); }
public void SearchTest() { EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); IList <Employee> employees = dao.Search("First Name", "Last Name"); Assert.IsNotNull(employees); Assert.IsTrue(employees.Count > 0); Employee testEmployee = employees.Where(e => e.EmployeeId == testEmployeeId).FirstOrDefault(); Assert.IsNotNull(testEmployee); Assert.AreEqual("First Name", testEmployee.FirstName); Assert.AreEqual("Last Name", testEmployee.LastName); }
public void GetEmployeesWithoutProjects_ShouldGetCorrectNumEmployees() { //Arrange EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); const int numberOfEmployeesAddedWithoutPojects = 1;//set in sql test setup file //Act IList <Employee> employees = dao.GetEmployeesWithoutProjects(); //Assert Assert.AreEqual(numberOfEmployeesAddedWithoutPojects, employees.Count); }
public void GetAllEmployees_Test() { EmployeeSqlDAO accessObj = new EmployeeSqlDAO(connectionString); IList <Employee> items = accessObj.GetAllEmployees(); bool found = false; foreach (Employee loopItem in items) { if (loopItem.LastName == "Collinsall") { found = true; break; } } Assert.IsTrue(found); }
public void TestSearch() { EmployeeSqlDAO employee = new EmployeeSqlDAO(connectionString); IList <Employee> employeeSearchList = employee.Search("JB", "Martin"); bool result = false; foreach (Employee person in employeeSearchList) { if (person.FirstName == "JB") { result = true; break; } } Assert.IsTrue(result); }
public void TestGetAllEmployees() { EmployeeSqlDAO employee = new EmployeeSqlDAO(connectionString); IList <Employee> employeeList = employee.GetAllEmployees(); bool found = false; foreach (Employee person in employeeList) { if (person.JobTitle == "TRAITOR") { found = true; break; } } Assert.IsTrue(found); }
static void Main(string[] args) { // Get the connection string from the appsettings.json file IConfigurationBuilder builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("Project"); IProjectDAO projectDAO = new ProjectSqlDAO(connectionString); IEmployeeDAO employeeDAO = new EmployeeSqlDAO(connectionString); IDepartmentDAO departmentDAO = new DepartmentSqlDAO(connectionString); ProjectCLI projectCLI = new ProjectCLI(employeeDAO, projectDAO, departmentDAO); projectCLI.RunCLI(); }
public void SearchEmployee_ShouldFindEmployeeName(string firstName, string lastName, bool isMatchExpected) { //Arrange EmployeeSqlDAO dao = new EmployeeSqlDAO(ConnectionString); const string testValFirstName = "John";//Set in sql test setup file const string testValLastName = "Smith"; //Act IList <Employee> employees = dao.Search(firstName, lastName); //list will be empty when search terms aren't in table and when table not empty then check name matches expected bool isMatch = employees.Count != 0 && (testValFirstName == employees[0].FirstName) && (testValLastName == employees[0].LastName);//employee[0] set in sql test file //Assert Assert.AreEqual(isMatchExpected, isMatch); }
public void AssignEmployeeToProject_ShouldReturnRightNumberOfEmployees() { //Arrange const int numberOfEmployeesWithoutProjects = 0;//set in sql test setup file minus the one employee assigned here ProjectSqlDAO projectDao = new ProjectSqlDAO(ConnectionString); EmployeeSqlDAO empDao = new EmployeeSqlDAO(ConnectionString); IList <Project> projects = projectDao.GetAllProjects(); IList <Employee> testEmployee = empDao.GetEmployeesWithoutProjects();//Get the employee added in sql test file that does not have a project assigned //Act projectDao.AssignEmployeeToProject(projects[0].ProjectId, testEmployee[0].EmployeeId);//assign employee withou project to the only project //Assert Assert.AreEqual(numberOfEmployeesWithoutProjects, empDao.GetEmployeesWithoutProjects().Count, "GetAllProjects doesn't return correct number for one project"); }
public void RemoveEmployeeFromProject_ShouldReturnTrueWhenEmployeeRemoved() { //Arrange const bool expectedResult = true;//when employee successfully removed, function should return true ProjectSqlDAO projectDao = new ProjectSqlDAO(ConnectionString); EmployeeSqlDAO empDao = new EmployeeSqlDAO(ConnectionString); IList <Project> projects = projectDao.GetAllProjects(); IList <Employee> testEmployee = empDao.Search("John", "Smith");//Get the employee added in sql test file that does have a project assigned. name from sql test file //Act bool resultOfRemove = projectDao.RemoveEmployeeFromProject(projects[0].ProjectId, testEmployee[0].EmployeeId);//remove employee with project from the only project //Assert Assert.AreEqual(expectedResult, resultOfRemove, "RemoveEmployeeFromProject doesn't return true when employee removed"); }