public void DepartmentTests() { // Open a SqlConnection object using the active transaction using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); DepartmentSqlDAL testDAL = new DepartmentSqlDAL(connectionString); IList <Department> testList = new List <Department>(); testList = testDAL.GetDepartments(); int savecount = testList.Count; Assert.AreNotEqual(0, testList.Count, "There should be Initial Data"); Department testDepartment = new Department(); testDepartment.Name = "alkjfagjhasivs"; departmentId = testDAL.CreateDepartment(testDepartment); Assert.AreNotEqual(0, departmentId, "Deparment ID should be greater than 0"); testDepartment = testDAL.GetADepartment(departmentId); Assert.AreEqual(departmentId, testDepartment.Id, "Department IDs should match"); Assert.AreEqual("alkjfagjhasivs", testDepartment.Name, "Departname should be \"alkjfagjhasivs\""); testList = testDAL.GetDepartments(); Assert.AreEqual(savecount + 1, testList.Count, "List should have 1 more element"); testDepartment.Name = "zzhzhzhzhzhzhz"; testDepartment.Id = departmentId; bool status = testDAL.UpdateDepartment(testDepartment); Assert.AreEqual(true, status); testDepartment = testDAL.GetADepartment(departmentId); Assert.AreEqual("zzhzhzhzhzhzhz", testDepartment.Name); } }
public void DepartmentTest() { DepartmentSqlDAL deptTest01 = new DepartmentSqlDAL(connectionString); List <Department> happyList = deptTest01.GetDepartments(); Department goodDept02 = new Department(); goodDept02.Id = 1; goodDept02.Name = "yeah"; deptTest01.UpdateDepartment(goodDept02); Assert.AreEqual(departmentCount + 3, happyList.Count); Assert.AreEqual("yeah", deptTest01.GetDepartments(1).Name); }
public void GetDepartmentsTest() { List <Department> departments = test.GetDepartments(); Assert.AreEqual(8, departments.Count); Assert.AreEqual(departmentID, departments[departments.Count - 1].Id); }
public void GetAllDepartmentsTest() { DepartmentSqlDAL testDept = new DepartmentSqlDAL(connectionString); List <Department> testList = testDept.GetDepartments(); Assert.AreEqual(7, testList.Count); }
public void GetDepartmentsTest() { DepartmentSqlDAL getDepartmentTest = new DepartmentSqlDAL(connectionString); List <Department> deptList = getDepartmentTest.GetDepartments(); Assert.IsNotNull(deptList); Assert.AreEqual(deptCount + 1, deptList.Count); }
public void GetDepartmentTests() { DepartmentSqlDAL deptDal = new DepartmentSqlDAL(connectionString); List <Department> dept = deptDal.GetDepartments(); Assert.AreEqual(5, dept.Count); Assert.AreEqual(deptId, dept[4].Id); }
public void GetDepartmentTest() { DepartmentSqlDAL departmentSqldal = new DepartmentSqlDAL(connectionString); List <Department> departments = departmentSqldal.GetDepartments(); Assert.AreEqual(numberOfDepartments + 1, departments.Count); }
public void GetDepartmentsTest() { DepartmentSqlDAL department = new DepartmentSqlDAL(connectionString); IList <Department> names = department.GetDepartments(); Assert.IsNotNull(names); Assert.AreEqual(departmentCount + 1, names.Count); }
public void GetDept() { DepartmentSqlDAL deptSqlDal = new DepartmentSqlDAL(connectionString); List <Department> deptNames = deptSqlDal.GetDepartments(); Assert.IsNotNull(deptNames); Assert.AreEqual(numOfDept, deptNames.Count - 1); }
public void GetDepartmentsTest() { DepartmentSqlDAL departmentSqlDAL = new DepartmentSqlDAL(connectionString); IList <Department> departments = departmentSqlDAL.GetDepartments(); Assert.IsNotNull(departments, "GetDepartments failed, the list was null."); Assert.AreEqual(numberOfDepartments + 1, departments.Count, "GetDepartments failed, an incorrect number of departments has been returned."); }
public void GetDepartmentsTest() { DepartmentSqlDAL departmentSqlDal = new DepartmentSqlDAL(connectionString); List <Department> d = departmentSqlDal.GetDepartments(); Assert.IsNotNull(d); Assert.AreEqual(5, d.Count); }
public void GetDepartmentsTest() { DepartmentSqlDAL departments = new DepartmentSqlDAL(connectionString); List <Department> department = departments.GetDepartments(); Assert.IsNotNull(department); Assert.AreEqual(4, department.Count()); }
public void DepartmentListTest() { DepartmentSqlDAL departmentDal = new DepartmentSqlDAL(connectionString); List <Department> getDepartment = departmentDal.GetDepartments(); Assert.IsNotNull(getDepartment); Assert.IsTrue(getDepartment.Count > 0); Assert.AreEqual(4, getDepartment.Count); }
public void TestGetAllDepartments() { //Arrange DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString); //Act List <Department> departments = departmentDAL.GetDepartments(); //Assert Assert.AreEqual(departmentCount, departments.Count); }
public void GetDepartmentsTest() { DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString); List <Department> departments = departmentDAL.GetDepartments(); entries++; Assert.IsNotNull(departments); Assert.AreEqual(entries, departments.Count); }
public void GetDepartmentsTest() { //Arrange DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString); //Act List <Department> departments = departmentDAL.GetDepartments(); //Assert Assert.AreEqual(7, departments.Count, "Insert: 5 initial departments. 1 Insert in the Initialize"); }
public void CreateDeptartmentTest() { DepartmentSqlDAL createDeptTest = new DepartmentSqlDAL(connectionString); Department testCreateDept = new Department(); testCreateDept.Name = "TestDeptCreate"; bool didWork = createDeptTest.CreateDepartment(testCreateDept); List <Department> deptList = createDeptTest.GetDepartments(); Assert.IsTrue(didWork); Assert.AreEqual(deptCount + 2, deptList.Count); }
public void GetDepartmentsTest() { //Arrange DepartmentSqlDAL dal = new DepartmentSqlDAL(ConnectionString); //Act List <Department> result = dal.GetDepartments(); //Assert Assert.IsNotNull(result); Assert.IsTrue(result.Count > 0); Assert.AreEqual(1, result.Where(d => d.Id == departmentId).Count()); }
public void TestCreateDepartment() { //Arrange DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString); Department updatedDepartment = new Department(); updatedDepartment.Name = "UpdatedDepartmentName"; //Act bool successChange = departmentDAL.CreateDepartment(updatedDepartment); List <Department> departments = departmentDAL.GetDepartments(); //Assert Assert.AreEqual(departmentCount + 1, departments.Count); }
public void UpdateDepartment() { DepartmentSqlDAL departments = new DepartmentSqlDAL(connectionString); Department ABCD = new Department() { Name = "ABCD", Id = 2 }; bool isTrue = departments.UpdateDepartment(ABCD); List <Department> updatedDepartments = departments.GetDepartments(); Assert.AreEqual("ABCD", updatedDepartments[0].Name); Assert.AreEqual(true, isTrue); }
private void GetAllDepartments() { DepartmentSqlDAL dal = new DepartmentSqlDAL(DatabaseConnection); List <Department> departments = dal.GetDepartments(); if (departments.Count > 0) { departments.ForEach(dept => { Console.WriteLine(dept); }); } else { Console.WriteLine("**** NO RESULTS ****"); } }
private void GetAllDepartments() { DepartmentSqlDAL dal = new DepartmentSqlDAL(DatabaseConnection); IList <Department> departments = dal.GetDepartments(); if (departments.Count > 0) { foreach (Department dept in departments) { Console.WriteLine(dept.Id.ToString().PadRight(10) + dept.Name.PadRight(40)); } } else { Console.WriteLine("**** NO RESULTS ****"); } }
public void GetDepartmentsTest() { DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString); IList <Department> departments = departmentDAL.GetDepartments(); Assert.IsNotNull(departments); bool areEqual = false; foreach (Department id in departments) { if (id.Name == "TestDepartment") { areEqual = true; } } Assert.AreEqual(true, areEqual); }
public void UpdateDepartmentTest() { DepartmentSqlDAL departmentSqldal = new DepartmentSqlDAL(connectionString); List <Department> departments = departmentSqldal.GetDepartments(); //int testDepartmentID = 0; Department testDepartment = new Department(); foreach (Department thisDepartment in departments) { if (thisDepartment.Name == "Test Department") { testDepartment = thisDepartment; } } testDepartment.Name = "Altered Name"; bool didUpdate = departmentSqldal.UpdateDepartment(testDepartment); Assert.AreEqual(true, didUpdate); }