public void DeletePerson_NormalPath() { DBConnection_Accessor connection = new DBConnection_Accessor(); SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB()); DataTable dt = new DataTable(); Delete_Accessor d = new Delete_Accessor(connection.GetDB()); try { d.DeletePerson(1005); } catch (Exception e) { } String[] p = new String[] {"1005", "1", "1123123123", "1", "M"}; MakePerson_Accessor pers = new MakePerson_Accessor(p, connection.GetDB()); pers.CreatePerson(); MakeEmployee_Accessor person = new MakeEmployee_Accessor("1005", "1234", "3/3/3", "", connection.GetDB()); person.CreateEmployee(); d.DeletePerson(1005); try { dt = SF.SearchPersonID("1005"); } catch (OleDbException ex) { throw ex; } Assert.IsTrue(dt.Rows.Count == 0); }
public void AddEmployee_DuplicateID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("1", "123", "1/1/1", "1", 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.CreateEmployee(); mp.CreatePerson(); mc.CreateEmployee(); }
public void AddEmployee_NullID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_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.CreateEmployee(); }
public void AddEmployee_DeleteInstance() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("21113", "", "", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "21113", "", "", "", "", "" }; MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB()); try { d.DeletePerson(21113); } catch (Exception) { } mp.CreatePerson(); mc.CreateEmployee(); SearchFunction_Accessor SF = new SearchFunction_Accessor(db.GetDB()); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); try { dt2 = SF.SearchPersonID("21113"); } catch (OleDbException ex) { throw ex; } mc.DeleteEmployee(); mp.DeletePerson(); try { dt1 = SF.SearchPersonID("21113"); } 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 AddEmployee_BadManIDFormat() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("1114", "", "", "abc", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "1114", "", "", "", "" }; MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB()); try { d.DeletePerson(1114); } catch (Exception) { } mp.CreatePerson(); mc.CreateEmployee(); }
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_BadPhoneLength() { 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", "", "12345678901", "", "" }; MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB()); try { d.DeletePerson(1113); } catch (Exception) { } mp.CreatePerson(); mc.CreateCustomer(); }
public void AddEmployee_OverFlowSalary() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("1113", "10000000", "", "", 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.CreateEmployee(); }
public void AddEmployee_NegativeID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("-5", "", "", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "-5", "", "", "", "" }; MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB()); try { d.DeletePerson(-5); } catch (Exception) { } mp.CreatePerson(); mc.CreateEmployee(); }
public void AddEmployee_BadPhoneChars() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("1113", "", "", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "1113", "", "123456789b", "", "" }; MakePerson_Accessor mp = new MakePerson_Accessor(D, db.GetDB()); try { d.DeletePerson(1113); } catch (Exception) { } mp.CreatePerson(); mc.CreateEmployee(); }
public void DeletePerson_NormalPath() { DBConnection_Accessor connection = new DBConnection_Accessor(); SearchFunction_Accessor SF = new SearchFunction_Accessor(connection.GetDB()); DataTable dt = new DataTable(); Delete_Accessor d = new Delete_Accessor(connection.GetDB()); try { d.DeletePerson(1005); } catch (Exception e) { } String[] p = new String[] { "1005", "1", "1123123123", "1", "M" }; MakePerson_Accessor pers = new MakePerson_Accessor(p, connection.GetDB()); pers.CreatePerson(); MakeEmployee_Accessor person = new MakeEmployee_Accessor("1005", "1234", "3/3/3", "", connection.GetDB()); person.CreateEmployee(); d.DeletePerson(1005); try { dt = SF.SearchPersonID("1005"); } catch (OleDbException ex) { throw ex; } Assert.IsTrue(dt.Rows.Count == 0); }
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 AddEmployee_NormalPath() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeEmployee_Accessor mc = new MakeEmployee_Accessor("1", "123", "1/1/1", "", 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.CreateEmployee(); }
public void AddCustomer_DuplicateID() { 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(); 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(); }