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 UpdateDepartmentTest()
{
Department testdept = new Department();
testdept.Id = 3;
testdept.Name = "steve";
Assert.IsTrue(test.UpdateDepartment(testdept));
}
public void UpdateDepartmentTest()
{
DepartmentSqlDAL updateDeptTest = new DepartmentSqlDAL(connectionString);
Department testUpdateDept = new Department();
testUpdateDept.Name = "TestDepartment3";
testUpdateDept.Id = departmentCode;
bool didWork = updateDeptTest.UpdateDepartment(testUpdateDept);
Assert.IsTrue(didWork);
}
public void UpdateDepartmentTest()
{
DepartmentSqlDAL departmentSqlDAL = new DepartmentSqlDAL(connectionString);
Department department = new Department();
department.Name = "TestDepartment";
department.Id = id;
bool result = departmentSqlDAL.UpdateDepartment(department);
Assert.AreEqual(true, result);
}
public void UpdateDepartmentTests()
{
DepartmentSqlDAL deptDal = new DepartmentSqlDAL(connectionString);
Department dept = new Department();
dept.Id = 4;
dept.Name = "Logistics";
bool updateWorked = deptDal.UpdateDepartment(dept);
Assert.AreEqual(true, updateWorked);
}
public void UpdateDept()
{
DepartmentSqlDAL deptSqlDal = new DepartmentSqlDAL(connectionString);
Department dept = new Department
{
Name = "Test Dept",
Id = deptId
};
bool didWork = deptSqlDal.UpdateDepartment(dept);
Assert.AreEqual(true, didWork);
}
public void UpdateDepartmentsTests()
{
_department.Name = "New Name";
_departmentItem.UpdateDepartment(_department);
Department getDepartment = _departmentItem.GetSinlgeDepartment(_department.Id);
Assert.AreEqual(_department.Name, getDepartment.Name);
Assert.AreEqual(_department.Id, getDepartment.Id);
}
public void UpdateDepartmentTest()
{
DepartmentSqlDAL departmentSqlDAL = new DepartmentSqlDAL(connectionString);
Department department = new Department
{
Name = "The Next Department",
Id = 2
};
bool didItWork = departmentSqlDAL.UpdateDepartment(department);
Assert.IsTrue(didItWork);
}
public void UpdateDepartmentsTest()
{
DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString);
Department department = new Department
{
Name = "Kyle's Place",
Id = 1
};
bool departmentID = departmentDAL.UpdateDepartment(department);
Assert.IsTrue(departmentID);
}
public void UpdateDepartmentTest()
{
DepartmentSqlDAL testDept = new DepartmentSqlDAL(connectionString);
Department myDept = new Department
{
Id = 5,
Name = "NewTestDept"
};
bool isUpdated = testDept.UpdateDepartment(myDept);
Assert.IsTrue(isUpdated);
}
public void UpdateDepartmentTest()
{
DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString);
Department departmentTestObj = new Department
{
Id = id,
Name = "Shoe",
};
bool didWork = departmentDAL.UpdateDepartment(departmentTestObj);
Assert.AreEqual(true, didWork);
}
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 UpdateDepartmentTest()
{
//Arrange
DepartmentSqlDAL departmentDAL = new DepartmentSqlDAL(connectionString);
Department updatedDepartment = new Department()
{
Id = newDaprtmentID,
Name = "Playsation"
};
bool wasSuccessful = departmentDAL.UpdateDepartment(updatedDepartment);
//Assert
Assert.AreEqual(true, wasSuccessful);
}
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);
}
public void UpdateDepartmentTest()
{
//Arrange
Department updatedDept = new Department
{
Id = departmentId,
Name = "Updated Department"
};
DepartmentSqlDAL dal = new DepartmentSqlDAL(ConnectionString);
//Act
bool result = dal.UpdateDepartment(updatedDept);
//Assert
Assert.IsTrue(result);
}
private void UpdateDepartment()
{
int departmentId = CLIHelper.GetInteger("Which department are you updating?");
string updatedName = CLIHelper.GetString("Provide the new name:");
Department updatedDepartment = new Department
{
Id = departmentId,
Name = updatedName
};
DepartmentSqlDAL dal = new DepartmentSqlDAL(DatabaseConnection);
bool result = dal.UpdateDepartment(updatedDepartment);
if (result)
{
Console.WriteLine("*** SUCCESS ***");
}
else
{
Console.WriteLine("*** DID NOT UPDATE ***");
}
}
public void TestUpdateDepartment()
{
DepartmentSqlDAL testUpdate = new DepartmentSqlDAL(connectionString);
Department updatedDepartment = new Department();
updatedDepartment.Id = 1;
updatedDepartment.Name = "UpdatedDepartmentName";
testUpdate.UpdateDepartment(updatedDepartment);
string altereddepartment = "";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd;
connection.Open();
cmd = new SqlCommand("SELECT name FROM department WHERE department_id = 1;", connection);
altereddepartment = (string)cmd.ExecuteScalar();
}
Assert.AreEqual(updatedDepartment.Name, altereddepartment);
}
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);
}