void Add() { //create an instance clsCarRepairsCollection CarRepair = new clsCarRepairsCollection(); //validate the data on webform Boolean OK = CarRepair.ThisCarRepair.Valid(txtMechanicDaysInForRepair.Text, txtMechanicDeadlineDate.Text, txtMechanicPartPrice.Text, txtMechanicPartRequired.Text, txtMechanicCarID.Text, txtMechanicStaffID.Text); //if data is okay then add to object if (OK == true) { //Fetch data entered by user CarRepair.ThisCarRepair.DaysInForRepair = Convert.ToInt32(txtMechanicDaysInForRepair.Text); CarRepair.ThisCarRepair.DeadlineDate = Convert.ToDateTime(txtMechanicDeadlineDate.Text); CarRepair.ThisCarRepair.PartPrice = Convert.ToDecimal(txtMechanicPartPrice.Text); CarRepair.ThisCarRepair.PartRequired = txtMechanicPartRequired.Text; CarRepair.ThisCarRepair.CarID = Convert.ToInt32(txtMechanicCarID.Text); CarRepair.ThisCarRepair.StaffID = Convert.ToInt32(txtMechanicStaffID.Text); //add record CarRepair.Add(); Response.Redirect("MechanicHomepage.aspx"); lblMechanicError.Text = "Repair successfully added"; } else { //report error lblMechanicError.Text = "There were problems with the data you have entered, please try again"; } }
public void AddMethodOK() { //Create an instance of the class clsCarRepairsCollection AllCarRepairs = new clsCarRepairsCollection(); //create the item of test data clsCarRepairs TestItem = new clsCarRepairs(); //Var to store the primary key Int32 PrimaryKey = 0; //Set its properties TestItem.CarRepairID = 2000; TestItem.DaysInForRepair = 27; TestItem.DeadlineDate = DateTime.Now.Date.AddDays(60); TestItem.PartPrice = 52.99m; TestItem.PartRequired = "Add test"; TestItem.CarID = 2000; TestItem.StaffID = 2000; //set this repair to the test data AllCarRepairs.ThisCarRepair = TestItem; //add the record PrimaryKey = AllCarRepairs.Add(); //set the primary key of the test data TestItem.CarRepairID = PrimaryKey; //find the record AllCarRepairs.ThisCarRepair.Find(PrimaryKey); //Test to see if the two values are the same Assert.AreEqual(AllCarRepairs.ThisCarRepair, TestItem); }
public void DeleteMethodOK() { //Create an instance of the class clsCarRepairsCollection AllCarRepairs = new clsCarRepairsCollection(); //create the item of test data clsCarRepairs TestItem = new clsCarRepairs(); //Var to store the primary key Int32 PrimaryKey = 0; //Set its properties TestItem.CarRepairID = 8; TestItem.DaysInForRepair = 1; TestItem.DeadlineDate = DateTime.Now.Date.AddDays(9); TestItem.PartPrice = 200.00m; TestItem.PartRequired = "4 new tyres"; //set this repair to the test data AllCarRepairs.ThisCarRepair = TestItem; //add the record PrimaryKey = AllCarRepairs.Add(); //set the primary key of the test data TestItem.CarRepairID = PrimaryKey; //find the record AllCarRepairs.ThisCarRepair.Find(PrimaryKey); //Delete the record AllCarRepairs.Archive(); //Now find the record Boolean Found = AllCarRepairs.ThisCarRepair.Find(PrimaryKey); //Test to see if the two values are the same Assert.IsFalse(Found); }
public void UpdateMethodOK() { //Create an instance of the class clsCarRepairsCollection AllCarRepairs = new clsCarRepairsCollection(); //create the item of test data clsCarRepairs TestItem = new clsCarRepairs(); //Var to store the primary key Int32 PrimaryKey = 0; //Set its properties TestItem.DaysInForRepair = 1; TestItem.DeadlineDate = DateTime.Now.Date.AddDays(9); TestItem.PartPrice = 200.00m; TestItem.PartRequired = "4 new tyres"; //set this repair to the test data AllCarRepairs.ThisCarRepair = TestItem; //add the record PrimaryKey = AllCarRepairs.Add(); //set the primary key of the test data TestItem.CarRepairID = PrimaryKey; //Modify the data TestItem.DaysInForRepair = 2; TestItem.DeadlineDate = DateTime.Now.Date.AddDays(12); TestItem.PartPrice = 210.00m; TestItem.PartRequired = "7 new tyres"; //set this repair to the new test data AllCarRepairs.ThisCarRepair = TestItem; //Update the record AllCarRepairs.Update(); //find the record AllCarRepairs.ThisCarRepair.Find(PrimaryKey); //Test to see if the two values are the same Assert.AreEqual(AllCarRepairs.ThisCarRepair, TestItem); }