public void AddStaffTest()
{
AccountManager_Accessor target = new AccountManager_Accessor(); // TODO: Initialize to an appropriate value
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
string staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
DataTable expectedResult = setupExpectedResultTable();
storeInfoIntoExpectedTables(expectedResult, staffID);
storeInfoIntoTargetTables(target, staffID);
DataTable targetResult = DBController.FetchStaff();
DataRow expectedRow = expectedResult.Rows[expectedResult.Rows.Count - 1];
DataRow targetRow = targetResult.Rows[targetResult.Rows.Count - 1];
Assert.AreEqual(expectedRow["StaffID"].ToString(), targetRow["StaffID"].ToString());
Assert.AreEqual(expectedRow["Name"].ToString(), targetRow["Name"].ToString());
Assert.AreEqual(expectedRow["Password"].ToString(), targetRow["Password"].ToString());
Assert.AreEqual(expectedRow["RenewPasswordDate"].ToString(), targetRow["RenewPasswordDate"].ToString());
Assert.AreEqual(expectedRow["JoinDate"].ToString(), targetRow["JoinDate"].ToString());
Assert.AreEqual(expectedRow["Gender"].ToString(), targetRow["Gender"].ToString());
Assert.AreEqual(expectedRow["Religion"].ToString(), targetRow["Religion"].ToString());
Assert.AreEqual(expectedRow["Position"].ToString(), targetRow["Position"].ToString());
Assert.AreEqual(expectedRow["Contact"].ToString(), targetRow["Contact"].ToString());
Assert.AreEqual(expectedRow["DefaultPassword"].ToString(), targetRow["DefaultPassword"].ToString());
Assert.AreEqual(expectedRow["IsValidLogin"].ToString(), targetRow["IsValidLogin"].ToString());
DBController.DeleteStaff(staffID);
}
public void ChangePasswordTest()
{
AccountManager_Accessor target = new AccountManager_Accessor();
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
Hypermarket_Admin_Management_Tool._2_Controller.SecurityManager_Accessor SecurityController =
Hypermarket_Admin_Management_Tool._2_Controller.SecurityManager_Accessor.getInstance();
string staffID = "*****@*****.**";
string password = "******";
DBController.DeleteStaff(staffID);
DataTable expectedResult = setupExpectedResultTable();
storeInfoIntoExpectedTables(expectedResult, staffID);
storeInfoIntoTargetTables(target, staffID);
target.ChangePassword(staffID, password);
DataRow expectedRow = expectedResult.Rows[expectedResult.Rows.Count - 1];
expectedRow["password"] = SecurityController.ComplexEncrypt(password);
DataTable targetResult = DBController.FetchStaff();
DataRow targetRow = targetResult.Rows[targetResult.Rows.Count - 1];
Assert.AreEqual(expectedRow["StaffID"].ToString(), targetRow["StaffID"].ToString());
Assert.AreEqual(expectedRow["password"].ToString(), targetRow["password"].ToString());
DBController.DeleteStaff(staffID);
}
public void VerifyUserIdAndPasswordTest()
{
AccountManager_Accessor target = new AccountManager_Accessor();
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
Hypermarket_Admin_Management_Tool._2_Controller.SecurityManager_Accessor SecurityController =
Hypermarket_Admin_Management_Tool._2_Controller.SecurityManager_Accessor.getInstance();
string staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
string password = "******";
storeInfoIntoTargetTables(target, staffID);
bool expected = true;
bool actual;
actual = target.VerifyUserIdAndPassword(staffID, password);
Assert.AreEqual(expected, actual);
DBController.DeleteStaff(staffID);
}
private static void storeInfoIntoTargetTables(AccountManager_Accessor target, string staffID)
{
//string name = "CG3002"; // TODO: Initialize to an appropriate value
// string password = Hypermarket_Admin_Management_Tool.Constant_Accessor.DEFAULT_PASSWORD;
DateTime renewPasswordDate = DateTime.Today.AddDays(180).Date;
DateTime dateOfBirth = new DateTime(2000, 12, 12); // TODO: Initialize to an appropriate value
DateTime joinDate = new DateTime(2012, 8, 1); // TODO: Initialize to an appropriate value
//string gender = "male"; // TODO: Initialize to an appropriate value
//string religion = "N.A"; // TODO: Initialize to an appropriate value
//string position = "Manager"; // TODO: Initialize to an appropriate value
//string contact = "+6589896464"; // TODO: Initialize to an appropriate value
//target.AddStaff(staffID, name, dateOfBirth, joinDate, gender, religion, position, contact);
}
public void UpdateStaffTest()
{
AccountManager_Accessor target = new AccountManager_Accessor();
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
string staffID = staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
DataTable expectedResult = setupExpectedResultTable();;
// string name = "CG3002"; // TODO: Initialize to an appropriate value
//string password = Hypermarket_Admin_Management_Tool.Constant_Accessor.DEFAULT_PASSWORD;
DateTime renewPasswordDate = DateTime.Today.AddDays(180).Date;
DateTime dateOfBirth = new DateTime(2000, 12, 12); // TODO: Initialize to an appropriate value
DateTime joinDate = new DateTime(2012, 8, 1); // TODO: Initialize to an appropriate value
// string gender = "male"; // TODO: Initialize to an appropriate value
// string religion = "N.A"; // TODO: Initialize to an appropriate value
string position = "Manager"; // TODO: Initialize to an appropriate value
string contact = "+6589896464"; // TODO: Initialize to an appropriate value
// bool IsDefaultPassword = true;
// bool IsValidLogin = true;
//expectedResult.Rows.Add(staffID, name, password, renewPasswordDate, dateOfBirth.Date,
// joinDate.Date, gender, religion, position, contact, IsDefaultPassword, IsValidLogin);
storeInfoIntoTargetTables(target, staffID);
DataTable targetResult = DBController.FetchStaff();
contact = "6511110000";
position = "CEO";
//target.UpdateStaff(staffID, contact, position);
DataRow expectedRow = expectedResult.Rows[expectedResult.Rows.Count - 1];
DataRow targetRow = targetResult.Rows[targetResult.Rows.Count - 1];
Assert.AreEqual(expectedRow["StaffID"].ToString(), targetRow["StaffID"].ToString());
Assert.AreEqual(expectedRow["Name"].ToString(), targetRow["Name"].ToString());
Assert.AreEqual(expectedRow["Password"].ToString(), targetRow["Password"].ToString());
Assert.AreEqual(expectedRow["RenewPasswordDate"].ToString(), targetRow["RenewPasswordDate"].ToString());
Assert.AreEqual(expectedRow["JoinDate"].ToString(), targetRow["JoinDate"].ToString());
Assert.AreEqual(expectedRow["Gender"].ToString(), targetRow["Gender"].ToString());
Assert.AreEqual(expectedRow["Religion"].ToString(), targetRow["Religion"].ToString());
Assert.AreEqual(position, targetRow["Position"].ToString());
Assert.AreEqual(contact, targetRow["Contact"].ToString());
Assert.AreEqual(expectedRow["DefaultPassword"].ToString(), targetRow["DefaultPassword"].ToString());
Assert.AreEqual(expectedRow["IsValidLogin"].ToString(), targetRow["IsValidLogin"].ToString());
DBController.DeleteStaff(staffID);
}
public void IsValidUserTest()
{
AccountManager_Accessor target = new AccountManager_Accessor(); // TODO: Initialize to an appropriate value
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
string staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
storeInfoIntoTargetTables(target, staffID);
bool expected = true;
bool actual;
actual = target.IsValidUser(staffID);
Assert.AreEqual(expected, actual);
DBController.DeleteStaff(staffID);
expected = false;
actual = target.IsValidUser(staffID);
Assert.AreEqual(expected, actual);
}
public void IsValidLoginTest()
{
AccountManager_Accessor target = new AccountManager_Accessor();
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
string staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
storeInfoIntoTargetTables(target, staffID);
bool expected = true;
bool actual;
actual = target.IsBlocked(staffID);
Assert.AreEqual(expected, actual);
}
public void FetchStaffTest()
{
AccountManager_Accessor target = new AccountManager_Accessor(); // TODO: Initialize to an appropriate value
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
DataTable expected = DBController.FetchStaff();
DataTable actual = target.FetchStaff();
Assert.AreEqual(expected, actual);
}
public void DeleteStaffTest()
{
AccountManager_Accessor target = new AccountManager_Accessor(); // TODO: Initialize to an appropriate value
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor DBController =
Hypermarket_Admin_Management_Tool._1_Model.DBManager_Accessor.getInstance();
string staffID = "*****@*****.**";
DBController.DeleteStaff(staffID);
DataTable expected = setupExpectedResultTable();
expected = DBController.FetchStaff();
storeInfoIntoTargetTables(target, staffID);
target.DeleteStaff(staffID);
DataTable actual = DBController.FetchStaff();
Assert.AreEqual(expected, actual);
}
