public void AddCustomer_NullID()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_DeleteInstance()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("3", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "3", "", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(3);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
SearchFunction_Accessor SF = new SearchFunction_Accessor(db.GetDB());
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
try
{
dt2 = SF.SearchPersonID("3");
}
catch (OleDbException ex)
{
throw ex;
}
mc.DeleteCustomer();
mp.DeletePerson();
try
{
dt1 = SF.SearchPersonID("3");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt1.Rows.Count == 0 && dt2.Rows.Count == 1);
}
public void AddCustomer_BadIDFormat()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("abc", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "abc", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_OnlyID()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("1", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "1", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_NormalPath()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("1", "test", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "1", "Sean", "5555555555", "calgary", "M" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_BadPhoneChars()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("1113", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "1113", "", ".234567890", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1113);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_NullID()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_NormalPath()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("1", "test", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] {"1", "Sean", "5555555555", "calgary", "M"};
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_DeleteInstance()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("3", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "3", "", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(3);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
SearchFunction_Accessor SF = new SearchFunction_Accessor(db.GetDB());
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
try
{
dt2 = SF.SearchPersonID("3");
}
catch (OleDbException ex)
{
throw ex;
}
mc.DeleteCustomer();
mp.DeletePerson();
try
{
dt1 = SF.SearchPersonID("3");
}
catch (OleDbException ex)
{
throw ex;
}
Assert.IsTrue(dt1.Rows.Count == 0 && dt2.Rows.Count == 1);
}
public void AddCustomer_BadPhoneLength()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("1", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "1", "", "12345678901", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
public void AddCustomer_NullCIDValue()
{
DBConnection_Accessor db = new DBConnection_Accessor();
MakeCustomer_Accessor mc = new MakeCustomer_Accessor("", "", db.GetDB());
Delete_Accessor d = new Delete_Accessor(db.GetDB());
String[] D = new String[] { "1113", "", "", "", "" };
MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB());
try
{
d.DeletePerson(1113);
}
catch (Exception)
{
}
mp.CreatePerson();
mc.CreateCustomer();
}
