public void SearchName_EmptyName()
{
//Person array = id, name, phone no, address, sex
DBConnection_Accessor connection = new DBConnection_Accessor();
SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB());
DataTable dt = new DataTable();
//String[] p = new String[] { "1", "1", "1", "1", "1" };
//MakePerson_Accessor Person = new MakePerson_Accessor(p, connection.GetDB());
//Person.DeletePerson();
//Person.CreatePerson();
try
{
dt = SF.SearchPersonName("");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt.Rows.Count == 0);
//Person.DeletePerson();
}
public void SearchName_NonExistent()
{
//Person array = id, name, phone no, address, sex
DBConnection_Accessor connection = new DBConnection_Accessor();
SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB());
DataTable dt = new DataTable();
//String[] p = new String[] { "1", "1", "1", "1", "1" };
//MakePerson_Accessor Person = new MakePerson_Accessor(p, connection.GetDB());
//Person.DeletePerson();
//Person.CreatePerson();
try
{
dt = SF.SearchPersonName("dyrone tonkson");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt.Rows.Count == 0);
//Person.DeletePerson();
}
public void SearchName_NormalPath()
{
DBConnection_Accessor connection = new DBConnection_Accessor();
SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB());
DataTable dt = new DataTable();
try
{
dt = SF.SearchPersonName("hi there");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt.Rows.Count == 1);
}
public void SearchName_NormalPath()
{
DBConnection_Accessor connection = new DBConnection_Accessor();
SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB());
DataTable dt = new DataTable();
try
{
dt = SF.SearchPersonName("hi there");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt.Rows.Count == 1);
}