public void DeleteVehicle_ExistsInSale() { DBConnection_Accessor connection = new DBConnection_Accessor(); Delete_Accessor d = new Delete_Accessor(connection.GetDB()); TestingFunctions tf = new TestingFunctions(connection.GetDB()); try { tf.DeleteSale("112", "121", "9"); } catch (Exception e) { } try { d.DeleteVehicle(112); } catch (Exception e) { } String[] D = new String[] { "112", "1", "1", "1", "1", "1" }; MakeVehicle_Accessor veh = new MakeVehicle_Accessor(D, connection.GetDB()); veh.CreateVehicle(); MakeCar_Accessor car = new MakeCar_Accessor("112", "smart car", connection.GetDB()); car.CreateCar(); String[] sale = new String[] { "112", "121", "9", "4/10/2008", "34000" }; MakeSale sa = new MakeSale(sale, connection.GetDB()); sa.CreateSale(); try { d.DeleteVehicle(112); } catch (Exception ex) { try { tf.DeleteSale("112", "121", "9"); } catch (Exception e) { } throw ex; } }
public void AddCar_NullID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeCar_Accessor mc = new MakeCar_Accessor("", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "", "", "", "", "", "" }; MakeVehicle_Accessor mp = new MakeVehicle_Accessor(D, db.GetDB()); mp.CreateVehicle(); mc.CreateCar(); }
public void AddCar_DeleteInstance() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeCar_Accessor mc = new MakeCar_Accessor("1", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "1", "", "", "", "", "" }; MakeVehicle_Accessor mp = new MakeVehicle_Accessor(D, db.GetDB()); try { d.DeleteVehicle(1); } catch (Exception) { } mp.CreateVehicle(); mc.CreateCar(); SearchFunction_Accessor SF = new SearchFunction_Accessor(db.GetDB()); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); try { dt2 = SF.SearchVehicle("1"); } catch (OleDbException ex) { throw ex; } mc.DeleteCar(); mp.DeleteVehicle(); try { dt1 = SF.SearchVehicle("1"); } catch (OleDbException ex) { throw ex; } Assert.IsTrue(dt1.Rows.Count == 0 && dt2.Rows.Count == 1); }
public void DeleteVehicle_ExistsInPart() { DBConnection_Accessor connection = new DBConnection_Accessor(); Delete_Accessor d = new Delete_Accessor(connection.GetDB()); try { d.DeletePart(1); } catch (Exception) { } try { d.DeleteVehicle(111); } catch (Exception e) { } String[] D = new String[] { "111", "1", "1", "1", "1", "1" }; MakeVehicle_Accessor veh = new MakeVehicle_Accessor(D, connection.GetDB()); veh.CreateVehicle(); MakeCar_Accessor car = new MakeCar_Accessor("111", "smart car", connection.GetDB()); car.CreateCar(); String[] D2 = new String[] { "1", "111", "", "", "", "" }; MakePart_Accessor mc = new MakePart_Accessor(D2, connection.GetDB()); mc.CreatePart(); try { d.DeleteVehicle(111); } catch (OleDbException ex) { throw ex; } }
public void AddCar_OnlyID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeCar_Accessor mc = new MakeCar_Accessor("1", "", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "1", "", "", "", "", "" }; MakeVehicle_Accessor mp = new MakeVehicle_Accessor(D, db.GetDB()); try { d.DeleteVehicle(1); } catch (Exception) { } mp.CreateVehicle(); mc.CreateCar(); }
public void AddCar_DuplicateID() { DBConnection_Accessor db = new DBConnection_Accessor(); MakeCar_Accessor mc = new MakeCar_Accessor("1", "sedan", db.GetDB()); Delete_Accessor d = new Delete_Accessor(db.GetDB()); String[] D = new String[] { "1", "123", "123", "123", "123", "123" }; MakeVehicle_Accessor mp = new MakeVehicle_Accessor(D, db.GetDB()); try { d.DeleteVehicle(1); } catch (Exception) { } mp.CreateVehicle(); mc.CreateCar(); mp.CreateVehicle(); mc.CreateCar(); }
public void DeleteVehicle_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.DeleteVehicle(1); } catch (Exception e) { } String[] D = new String[] { "1", "1", "1", "1", "1", "1" }; MakeVehicle_Accessor veh = new MakeVehicle_Accessor(D, connection.GetDB()); veh.CreateVehicle(); MakeCar_Accessor car = new MakeCar_Accessor("1", "smart car", connection.GetDB()); car.CreateCar(); d.DeleteVehicle(1); try { dt = SF.SearchVehicle("1"); } catch (OleDbException ex) { throw ex; } Assert.IsTrue(dt.Rows.Count == 0); }