public void FilterByDestinationTestPKDataFound() { // create an instance of the filtered data clsDestinationCollection FilteredDestinations = new clsDestinationCollection(); // var to store outcome Boolean OK = true; // apply a destination that does exist FilteredDestinations.FilterByDestination("California"); // check that the correct number of records are found if (FilteredDestinations.Count == 2) { // check the first record is ID 8 if (FilteredDestinations.DestinationList[0].DestinationID != 9) { OK = false; } // check the first record if ID 11 if (FilteredDestinations.DestinationList[1].DestinationID != 10) { OK = false; } } else { OK = false; } // test to see that there are no records Assert.IsTrue(OK); }
public void FilterByDestinationTestPriceDataFound() { // create an instance of the filtered data clsDestinationCollection FilteredDestinations = new clsDestinationCollection(); // var to store outcome Boolean OK = true; // apply a destination that exists FilteredDestinations.FilterByDestination("California"); // check that the correct number of records are found if (FilteredDestinations.Count == 2) { // check the data is 300 if (FilteredDestinations.DestinationList[0].PricePerPerson != 300) { OK = false; } // check the data is 250 if (FilteredDestinations.DestinationList[1].PricePerPerson != 250) { OK = false; } } else { OK = false; } // test to see that there are no records Assert.IsTrue(OK); }
public void AddMethodOk() { // create an instance of the class we want to create clsDestinationCollection AllDestinations = new clsDestinationCollection(); // create the item of test data clsDestination TestItem = new clsDestination(); // primary key variable Int32 PrimaryKey = 0; // set its properties TestItem.DestinationID = 1; TestItem.Destination = "Rome"; TestItem.PricePerPerson = 99; TestItem.DayOfFlight = DateTime.Now.Date; TestItem.ReturnDate = DateTime.Now.Date.AddDays(1); // set ThisDestination to the test data AllDestinations.ThisDestination = TestItem; // add the record PrimaryKey = AllDestinations.Add(); // set the primary key of the test data TestItem.DestinationID = PrimaryKey; // find the record AllDestinations.ThisDestination.Find(PrimaryKey); // test to see that the two values are the same Assert.AreEqual(AllDestinations.ThisDestination, TestItem); }
void Update() { clsDestinationCollection DestinationBook = new clsDestinationCollection(); //validate the data on the web form String Error = DestinationBook.ThisDestination.Valid(txtHouseNo.Text, txtPostCode.Text, txtStreet.Text, txtTown.Text, txtPickUp.Text); //if the datas is OK the add it to the object if (Error == "") { //find the record to update DestinationBook.ThisDestination.Find(DestinationID); //get the data entered by the user DestinationBook.ThisDestination.EndPointHouseNo = txtHouseNo.Text; DestinationBook.ThisDestination.EndPointPostCode = txtPostCode.Text; DestinationBook.ThisDestination.EndPointStreet = txtStreet.Text; DestinationBook.ThisDestination.EndPointTown = txtTown.Text; DestinationBook.ThisDestination.PickupTime = Convert.ToDateTime(txtPickUp.Text); DestinationBook.ThisDestination.DropoffTime = Convert.ToDateTime(txtPickUp.Text); //add the record DestinationBook.Update(); Response.Redirect("DestinationPage.aspx"); } else { //report an error lblError.Text = "There were problem with the data enetered " + Error; } }
// function for updating destinations void Update() { // create an instance of the destination collection class clsDestinationCollection Destinations = new clsDestinationCollection(); // validate the data Boolean OK = Destinations.ThisDestination.Valid(txtDestinationName.Text, Convert.ToDecimal(txtPrice.Text), txtDayofFlight.Text, txtReturnDate.Text); // if the data is OK then add it to the object if (OK == true) { // find the record to update Destinations.ThisDestination.Find(DestinationID); // get the data entered by the user Destinations.ThisDestination.Destination = txtDestinationName.Text; Destinations.ThisDestination.PricePerPerson = Convert.ToDecimal(txtPrice.Text); Destinations.ThisDestination.DayOfFlight = Convert.ToDateTime(txtDayofFlight.Text); Destinations.ThisDestination.ReturnDate = Convert.ToDateTime(txtReturnDate.Text); // update the record Destinations.Update(); } else { // error lblError.Text = "There is a problem with the data entered"; } }
public void AddMethodOK() { //create an instance of the class we want to creat clsDestinationCollection AllDestinations = new clsDestinationCollection(); //create the item of test data clsDestination TestItem = new clsDestination(); //var to store the primary key Int32 Primarykey = 0; //set its properties TestItem.DestinationID = 1; TestItem.EndPointHouseNo = "1"; TestItem.EndPointPostCode = "LE2 2WX"; TestItem.EndPointStreet = "God Street"; TestItem.EndPointTown = "Leicester"; TestItem.PickupTime = DateTime.Now.Date; TestItem.DropoffTime = DateTime.Now.Date; //set ThisDestination to the test data AllDestinations.ThisDestination = TestItem; //add the record Primarykey = AllDestinations.Add(); //find the record AllDestinations.ThisDestination.Find(Primarykey); //test to see that the two valyes are the same Assert.AreEqual(AllDestinations.ThisDestination, TestItem); }
public void ListAndCountOk() { //create an instance of the class we want to creat clsDestinationCollection AllDestinations = new clsDestinationCollection(); //create some test data to assign to the property //in this case the data needs to be a list of objects List <clsDestination> TestList = new List <clsDestination>(); //add an item to the list //create the item of test data clsDestination TestItem = new clsDestination(); //set its properties TestItem.DestinationID = 1; TestItem.EndPointHouseNo = "1"; TestItem.EndPointPostCode = "LE2 2WX"; TestItem.EndPointStreet = "God Street"; TestItem.EndPointTown = "Leicester"; TestItem.PickupTime = DateTime.Now.Date; TestItem.DropoffTime = DateTime.Now.Date; //add the item to the test list TestList.Add(TestItem); //assign the date to the property AllDestinations.DestinationList = TestList; //test to see that the two values are the same Assert.AreEqual(AllDestinations.Count, TestList.Count); }
public void InstanceOK() { // create an instance of the class we want to create clsDestinationCollection Destinations = new clsDestinationCollection(); // test to see that it exists Assert.IsNotNull(Destinations); }
public void FilterByDestinationNoneFound() { // create an instance of the filtered data clsDestinationCollection FilteredDestinations = new clsDestinationCollection(); // apply a destination that does not exist FilteredDestinations.FilterByDestination("XXX XXX"); // test to see that there are no records Assert.AreEqual(0, FilteredDestinations.Count); }
void DeleteDestination() { //function to delete the select record //create a new instance of the Destination book clsDestinationCollection DestinationBook = new clsDestinationCollection(); //find the record to delete DestinationBook.ThisDestination.Find(DestinationID); //Delete the record DestinationBook.Delete(); }
public void FilterByDestinationMethodOK() { // create an instance of the class we want to create clsDestinationCollection AllDestinations = new clsDestinationCollection(); // create an instance of the filtered data clsDestinationCollection FilteredDestinations = new clsDestinationCollection(); // apply a blank string to return all records FilteredDestinations.FilterByDestination(""); // test to see that the two values are the same Assert.AreEqual(AllDestinations.Count, FilteredDestinations.Count); }
void DisplayDestination() { // create an instance of the destination collection class clsDestinationCollection Destinations = new clsDestinationCollection(); // find the record to update Destinations.ThisDestination.Find(DestinationID); // display the data of the record chosen txtDestinationName.Text = Destinations.ThisDestination.Destination; txtPrice.Text = Destinations.ThisDestination.PricePerPerson.ToString(); txtDayofFlight.Text = Destinations.ThisDestination.DayOfFlight.ToString(); txtReturnDate.Text = Destinations.ThisDestination.ReturnDate.ToString(); }
void DisplayDestination() { clsDestinationCollection DestinationBook = new clsDestinationCollection(); //find the record to update DestinationBook.ThisDestination.Find(DestinationID); //find the record to update txtHouseNo.Text = DestinationBook.ThisDestination.EndPointHouseNo; txtPostCode.Text = DestinationBook.ThisDestination.EndPointPostCode; txtStreet.Text = DestinationBook.ThisDestination.EndPointStreet; txtTown.Text = DestinationBook.ThisDestination.EndPointTown; txtPickUp.Text = DestinationBook.ThisDestination.PickupTime.ToString(); }
// function to populate the list box - for display purposes only Int32 DisplayDestinations() { // create an instance of the destination collection clsDestinationCollection Destinations = new clsDestinationCollection(); // var for record count Int32 RecordCount; // var for destination name string DestinationName; // var for destination price per person decimal DestinationPrice; // var for single flight string DayFlight; // var for return flight string ReturnFlight; // var for destination ID string DestinationID; // var for Index Int32 Index = 0; // clear the list of any existing item lstFlights.Items.Clear(); // get the count of records RecordCount = Destinations.Count; // loop through each record found using the index while (Index < RecordCount) { // get the name of the destination DestinationName = Convert.ToString(Destinations.DestinationList[Index].Destination); // get the price per person for each destination DestinationPrice = Convert.ToDecimal(Destinations.DestinationList[Index].PricePerPerson); // get the day of flight DayFlight = Convert.ToString(Destinations.DestinationList[Index].DayOfFlight); // get the return flight ReturnFlight = Convert.ToString(Destinations.DestinationList[Index].ReturnDate); // get the ID of each destination DestinationID = Convert.ToString(Destinations.DestinationList[Index].DestinationID); // set up a new object of class list item ListItem NewItem = new ListItem(DestinationName + " " + "£PP" + " " + " " + DestinationPrice + " " + DayFlight + " " + ReturnFlight, DestinationID); // add the item to the list lstFlights.Items.Add(NewItem); // increment the index Index++; } // return the number of records found return(RecordCount); }
public void ThisDestinationPropertyOK() { // create an instance of the class we want to create clsDestinationCollection AllDestinations = new clsDestinationCollection(); // create some test data to assign to the property clsDestination TestDestination = new clsDestination(); // set the properties to the test object TestDestination.DestinationID = 1; TestDestination.Destination = "Rome"; TestDestination.PricePerPerson = 99; TestDestination.DayOfFlight = DateTime.Now.Date; TestDestination.ReturnDate = DateTime.Now.Date.AddDays(1); // assign the data to the property AllDestinations.ThisDestination = TestDestination; // test to see that the two values are the same Assert.AreEqual(AllDestinations.ThisDestination, TestDestination); }
Int32 DisplaysDestination() { //create an instance of the Destination collection clsDestinationCollection Destinations = new clsDestinationCollection(); //find all destination Destinations.FindAllDestinations(); //set the data source to the list of the destinations in the collection lstDestinations.DataSource = Destinations.DestinationList; //set the test to be displayed lstDestinations.DataTextField = "EndPointTown"; //set the primary key lstDestinations.DataValueField = "DestinationID"; //return the count of records in the list lstDestinations.DataBind(); //bind the data to the list return(Destinations.DestinationList.Count); }
public void ThisDestinationPropertyOK() { //create an instance of the class we want to create clsDestinationCollection AllDestinations = new clsDestinationCollection(); //create some test data to assign to the property clsDestination TestDestination = new clsDestination(); //set its properties TestDestination.DestinationID = 1; TestDestination.EndPointHouseNo = "1"; TestDestination.EndPointPostCode = "LE2 2WX"; TestDestination.EndPointStreet = "God Street"; TestDestination.EndPointTown = "Leicester"; TestDestination.PickupTime = DateTime.Now.Date; TestDestination.DropoffTime = DateTime.Now.Date; //assign the data to the property AllDestinations.ThisDestination = TestDestination; //test to see that the two values are the same Assert.AreEqual(AllDestinations.ThisDestination, TestDestination); }
public void ListAndCountOK() { // create an instance of the class we want to create clsDestinationCollection AllDestinations = new clsDestinationCollection(); // create a list of test data List <clsDestination> TestList = new List <clsDestination>(); // create the item of test data clsDestination TestItem = new clsDestination(); // set its properties TestItem.DestinationID = 1; TestItem.Destination = "Rome"; TestItem.PricePerPerson = 99; TestItem.DayOfFlight = DateTime.Now.Date; TestItem.ReturnDate = DateTime.Now.Date.AddDays(1); // add the item to the test list TestList.Add(TestItem); // assign the data to the property AllDestinations.DestinationList = TestList; // test to see that the two values are the same Assert.AreEqual(AllDestinations.Count, TestList.Count); }
public void UpdateMethodOK() { //create an instance of the class we want to creat clsDestinationCollection AllDestinations = new clsDestinationCollection(); //create the item of test data clsDestination TestItem = new clsDestination(); //var to store the primary key Int32 Primarykey = 0; //set its properties TestItem.EndPointHouseNo = "1"; TestItem.EndPointPostCode = "LE2 2WX"; TestItem.EndPointStreet = "God Street"; TestItem.EndPointTown = "Leicester"; TestItem.PickupTime = DateTime.Now.Date; TestItem.DropoffTime = DateTime.Now.Date; //set ThisDestination to the test data AllDestinations.ThisDestination = TestItem; //add the record Primarykey = AllDestinations.Add(); //set the primary key of the test data TestItem.DestinationID = Primarykey; //modify the test data TestItem.EndPointHouseNo = "132"; TestItem.EndPointPostCode = "GH2 2WX"; TestItem.EndPointStreet = "God's Son Street"; TestItem.EndPointTown = "Ash Town"; TestItem.PickupTime = DateTime.Now.Date; TestItem.DropoffTime = DateTime.Now.Date; //set the record based on the new test data AllDestinations.ThisDestination = TestItem; //update the record AllDestinations.Update(); //find the record AllDestinations.ThisDestination.Find(Primarykey); //test to see ThisDestionation match the test date Assert.AreEqual(AllDestinations.ThisDestination, TestItem); }