public void CarDeleteMethodOK() { //create an instance of the class we want to create. clsCarsCollection AllCars = new clsCarsCollection(); //create the item of test data clsCar TestItem = new clsCar(); //variable to store the primary key. Int32 PrimaryKey = 0; //set it's properties. TestItem.CarID = 4; TestItem.CarManufacturer = "BMW"; TestItem.CarModel = "i8"; TestItem.CarRegistrationPlate = "FE17 GTE"; TestItem.CarColour = "yellow"; TestItem.CarNumberOfDoors = 5; TestItem.CarNumberOfSeats = 5; TestItem.CarNeedsRepair = false; TestItem.CarSold = true; //set thiscar to the test date AllCars.ThisCar = TestItem; //add the record PrimaryKey = AllCars.Add(); //set the primary key of the test data. TestItem.CarID = PrimaryKey; //find the record. AllCars.ThisCar.Find(PrimaryKey); //delete the record. AllCars.Delete(); //now find the record. Boolean Found = AllCars.ThisCar.Find(PrimaryKey); //Test to see that the record was not found. Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsCarsCollection AllCars = new clsCarsCollection(); clsCars TestCar = new clsCars(); Int32 PrimaryKey = 0; TestCar.CarMake = "Mercedes"; TestCar.CarModel = "S Class"; TestCar.CarModelNumber = "VRi122"; TestCar.CarColour = "Blue"; TestCar.CarPrice = 1; TestCar.CarTypeNumber = 1; TestCar.CarReleaseDate = "11/10/2001"; AllCars.ThisCar = TestCar; PrimaryKey = AllCars.Add(); TestCar.CarNo = PrimaryKey; TestCar.CarMake = "Mer"; TestCar.CarModel = "SAClass"; TestCar.CarModelNumber = "Vi122"; TestCar.CarColour = "Black"; TestCar.CarPrice = 2; TestCar.CarTypeNumber = 3; TestCar.CarReleaseDate = "30/11/2015"; AllCars.ThisCar = TestCar; AllCars.Update(); AllCars.ThisCar.Find(PrimaryKey); Assert.AreEqual(AllCars.ThisCar, TestCar); }
public void CarUpdateMethodOk() { //create an instance of the class we want to create. clsCarsCollection AllCars = new clsCarsCollection(); //create the item of test data clsCar TestItem = new clsCar(); //variable to store the primary key. Int32 PrimaryKey = 0; //set it's properties. TestItem.CarManufacturer = "BMW"; TestItem.CarModel = "i8"; TestItem.CarRegistrationPlate = "FE17 GTE"; TestItem.CarColour = "yellow"; TestItem.CarNumberOfDoors = 5; TestItem.CarNumberOfSeats = 5; TestItem.CarNeedsRepair = false; TestItem.CarSold = true; //set thiscar to the test date AllCars.ThisCar = TestItem; //add the record PrimaryKey = AllCars.Add(); //set the primary key of the test data. TestItem.CarID = PrimaryKey; //Modify the test data TestItem.CarManufacturer = "Audi"; TestItem.CarModel = "s5"; TestItem.CarRegistrationPlate = "FE15 EDS"; TestItem.CarColour = "White"; TestItem.CarNumberOfDoors = 3; TestItem.CarNumberOfSeats = 5; TestItem.CarNeedsRepair = true; TestItem.CarSold = false; //set the record based on the new test data AllCars.ThisCar = TestItem; //update the record AllCars.Update(); //find the record AllCars.ThisCar.Find(PrimaryKey); //test to see ThisCar matches the test data. Assert.AreEqual(AllCars.ThisCar, TestItem); }
void Add() { //function to add a car. //create an instance clsCarsCollection Cars = new clsCarsCollection(); //validate the data on the web form Boolean OK = Cars.ThisCar.Valid(txtReceptionistCarManufacturer.Text, txtReceptionistCarModel.Text, txtReceptionistCarRegistrationPlate.Text, txtReceptionistCarColour.Text, txtReceptionistCarNumberOfDoors.Text, txtReceptionistCarNumberOfSeats.Text, txtReceptionistSupplierID.Text); //if the data is OK then add it to the object. if (OK == true) { //get the data entered by the user. Cars.ThisCar.CarManufacturer = txtReceptionistCarManufacturer.Text; Cars.ThisCar.CarModel = txtReceptionistCarModel.Text; Cars.ThisCar.CarRegistrationPlate = txtReceptionistCarRegistrationPlate.Text; Cars.ThisCar.CarColour = txtReceptionistCarColour.Text; Cars.ThisCar.CarNumberOfDoors = Convert.ToInt32(txtReceptionistCarNumberOfDoors.Text); Cars.ThisCar.CarNumberOfSeats = Convert.ToInt32(txtReceptionistCarNumberOfSeats.Text); Cars.ThisCar.CarNeedsRepair = Convert.ToBoolean(ChkBoxReceptionistNeedsRepair.Checked); Cars.ThisCar.CarSold = Convert.ToBoolean(ChkBoxReceptionistSold.Checked); Cars.ThisCar.SupplierID = Convert.ToInt32(txtReceptionistSupplierID.Text); //test to see if the registration exists. if (Convert.ToInt32(Cars.CarRegistrationExists()) == 0) { lblError.Text = "Car Reg already exists"; } else { //add the record. Cars.Add(); //set lbl to empty lblError.Text = ""; //reload/refresh the page. Response.Redirect("ReceptionistHomepage.aspx"); } } else { //report the error lblError.Text = "There were problems with the data entered"; } }
void Add() { clsCarsCollection CarShop = new clsCarsCollection(); String Error = CarShop.ThisCar.Valid(txtCarMake.Text, txtCarModel.Text, txtCarModelNumber.Text, txtCarColour.Text, txtCarRDate.Text, Convert.ToInt32(txtCarPrice.Text)); if (Error == "") { CarShop.ThisCar.CarMake = txtCarMake.Text; CarShop.ThisCar.CarModel = txtCarModel.Text; CarShop.ThisCar.CarModelNumber = txtCarModelNumber.Text; CarShop.ThisCar.CarColour = txtCarColour.Text; CarShop.ThisCar.CarReleaseDate = txtCarRDate.Text; CarShop.ThisCar.CarPrice = Convert.ToInt32(txtCarPrice.Text); CarShop.ThisCar.CarTypeNumber = Convert.ToInt32(drpCarType.SelectedValue); CarShop.Add(); } else { lblError.Text = "There were problem with the data entered " + Error; } }
public void DeleteMethodOK() { clsCarsCollection AllCars = new clsCarsCollection(); clsCars TestCar = new clsCars(); Int32 PrimaryKey = 0; TestCar.CarNo = 1; TestCar.CarMake = "Mercedes"; TestCar.CarModel = "S Class"; TestCar.CarModelNumber = "VRi122"; TestCar.CarColour = "Blue"; TestCar.CarPrice = 1; TestCar.CarTypeNumber = 1; TestCar.CarReleaseDate = "11/10/2001"; AllCars.ThisCar = TestCar; PrimaryKey = AllCars.Add(); TestCar.CarNo = PrimaryKey; AllCars.ThisCar.Find(PrimaryKey); AllCars.Delete(); Boolean Found = AllCars.ThisCar.Find(PrimaryKey); Assert.IsFalse(Found); }