public void DeleteMethodOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//create the item of test data
clsFlights TestItem = new clsFlights();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.FlightNo = "AA11";
TestItem.Airline = "Air India";
TestItem.ArrivalAirport = "DXB";
TestItem.Arrival = DateTime.Now.Date;
TestItem.Departure = DateTime.Now.Date;
TestItem.DepartureAirport = "MCR";
TestItem.Destination = "Dubai";
//set ThisFlights to the test data
AllFlights.ThisFlight = TestItem;
//add the record
PrimaryKey = AllFlights.Add();
//set the primary key of the test data
TestItem.FlightID = PrimaryKey;
//find the record
AllFlights.ThisFlight.Find(PrimaryKey);
//delete the record
AllFlights.Delete();
//now find the record
Boolean Found = AllFlights.ThisFlight.Find(PrimaryKey);
//test to see that the record was not found
Assert.IsFalse(Found);
}
Int32 DisplayFlight(string DateOfBirthFilter)
{
//var to store the Dateofbirth
string DateOfBirth;
//create an instance of the Orderline collection class
clsFlightCollection Flight = new clsFlightCollection();
Flight.ReportByDateOfBirth(DateOfBirthFilter);
//var to store the count of records
Int32 RecordCount;
//var to store the index for the loop
Int32 Index = 0;
//get the count of records
RecordCount = Flight.Count;
//clear the list box
lstFlight.Items.Clear();
//while there are records
while (Index < RecordCount)
{
//get the Dateofbirth
DateOfBirth = Flight.FlightList[Index].DateOfBirth;
//create a new entry for the list box
ListItem NewEntry = new ListItem(DateOfBirth + " ".ToString());
//add the staff to the list
lstFlight.Items.Add(NewEntry);
//move the index to the next record
Index++;
}
//return to the count of records found
return(RecordCount);
}
public void AddMethod()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//create the item of test data
clsFlight TestItem = new clsFlight();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.FlightID = 1;
TestItem.TicketID = 2;
TestItem.DateOfBirth = "1st May 2000";
TestItem.Gate = "12B";
TestItem.DepartureDate = DateTime.Now.Date;
//set thisflight to the test data
AllFlight.ThisFlight = TestItem;
//add the record
PrimaryKey = AllFlight.Add();
//set the primary key of the test data
TestItem.FlightID = PrimaryKey;
//find the record
AllFlight.ThisFlight.Find(PrimaryKey);
//test to see that the two values are the same
Assert.AreEqual(AllFlight.ThisFlight, TestItem);
}
public void DeleteMethod()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//create the item of test data
clsFlight TestItem = new clsFlight();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.FlightID = 1;
TestItem.TicketID = 2;
TestItem.DateOfBirth = "1st May 2000";
TestItem.Gate = "12B";
TestItem.DepartureDate = DateTime.Now.Date;
//set thisflight to the test data
AllFlight.ThisFlight = TestItem;
//add the record
PrimaryKey = AllFlight.Add();
//set the primary key of the test data
TestItem.FlightID = PrimaryKey;
//find the record
AllFlight.ThisFlight.Find(PrimaryKey);
//delete the record
AllFlight.Delete();
//now find the record
Boolean Found = AllFlight.ThisFlight.Find(PrimaryKey);
//test to see that record was not found
Assert.IsFalse(Found);
}
public void AddMethodOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//create the item of test data
clsFlights TestFlights = new clsFlights();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
//set its properties
//TestFlights.FlightID = 1;
TestFlights.FlightNo = "AA11";
TestFlights.Airline = "Air India";
TestFlights.ArrivalAirport = "DXB";
TestFlights.Arrival = DateTime.Now.Date;
TestFlights.Departure = DateTime.Now.Date;
TestFlights.DepartureAirport = "MCR";
TestFlights.Destination = "Dubai";
//set ThisFlights to the test data
AllFlights.ThisFlight = TestFlights;
//add the record
PrimaryKey = AllFlights.Add();
//set the primary key of the test data
TestFlights.FlightID = PrimaryKey;
//find the record
AllFlights.ThisFlight.Find(PrimaryKey);
//test to see that the two values are the same
Assert.AreEqual(AllFlights.ThisFlight, TestFlights);
}
public void FilterByDestinationTestDataFound()
{
//create an instance of the filtered data
clsFlightCollection FilteredFlights = new clsFlightCollection();
//var to store outcome
Boolean OK = true;
//apply a destination that doesn't exist
FilteredFlights.FilterByDestination("XXXXX");
//check that the correct number of records are found
if (FilteredFlights.Count == 2)
{
//check that the first record is ID 36
if (FilteredFlights.FlightList[0].FlightID != 24)
{
OK = false;
}
//check that the first record is ID 37
if (FilteredFlights.FlightList[1].FlightID != 31)
{
OK = false;
}
}
else
{
OK = false;
}
//test to see that there are no records
Assert.IsTrue(OK);
}
void Update40()
{
//create an instance of the flight book
MyClassLibrary.clsFlightCollection Flights = new clsFlightCollection();
//validate the data on the web form
//Valid(string flightNo, string airline, string destination, string arrival, string arrivalAirport, string departure, string departureAirport)
string Error = Flights.ThisFlight.Valid(txtFlightNo.Text, txtAirline.Text, txtDestination.Text, txtArrivalTime.Text, txtArrival.Text, txtDepartureTime.Text, txtDeparture.Text);
//if the data is OK then add it to the object
if (Error == "")
{
//get the data entered by the user
Flights.ThisFlight.Find(FlightID);
Flights.ThisFlight.FlightNo = txtFlightNo.Text;
Flights.ThisFlight.Airline = txtAirline.Text;
Flights.ThisFlight.Destination = txtDestination.Text;
Flights.ThisFlight.ArrivalAirport = txtArrivalTime.Text;
Flights.ThisFlight.Arrival = Convert.ToDateTime(txtArrivalTime.Text);
Flights.ThisFlight.Departure = Convert.ToDateTime(txtDepartureTime.Text);
Flights.ThisFlight.DepartureAirport = txtDepartureTime.Text;
//add the record
Flights.Update();
//all done so redirect back to the main page
//Response.Redirect("frmFlightsMain.cs");
}
else
{
//report an error
lblError.Text = "There were problems with the data entered" + Error;
}
}
public void UpdateMethod()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//create the item of test data
clsFlight TestItem = new clsFlight();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.TicketID = 2;
TestItem.DateOfBirth = "1st May 2000";
TestItem.Gate = "12B";
TestItem.DepartureDate = DateTime.Now.Date;
//set thisflight to the test data
AllFlight.ThisFlight = TestItem;
//add the record
PrimaryKey = AllFlight.Add();
//set the primary key of the test data
TestItem.FlightID = PrimaryKey;
//modify the test data
TestItem.TicketID = 3;
TestItem.DateOfBirth = "11th April 2001";
TestItem.Gate = "1D";
TestItem.DepartureDate = DateTime.Now.Date;
//set the record based on the new test data
AllFlight.ThisFlight = TestItem;
//update the record
AllFlight.Update();
//find the record
AllFlight.ThisFlight.Find(PrimaryKey);
//test to see thisflight matches the test data
Assert.AreEqual(AllFlight.ThisFlight, TestItem);
}
//function for updating new records
void Update()
{
//create an instance of the Ticket Book
clsFlightCollection FlightBook = new clsFlightCollection();
//validate the data on the web form
string Error = FlightBook.ThisFlight.Valid(txtDateOfBirth.Text, txtGate.Text, txtDepartureDate.Text);
//if the data is ok then add it to the object
if (Error == "")
{
//get the data entered by the user
FlightBook.ThisFlight.DateOfBirth = txtDateOfBirth.Text;
FlightBook.ThisFlight.Gate = txtGate.Text;
FlightBook.ThisFlight.DepartureDate = Convert.ToDateTime(txtDepartureDate.Text);
//update the record
FlightBook.Update();
//all done so redirect back to the main page
Response.Redirect("FlightList.aspx");
}
else
{
//report the error
lblError.Text = "There were problems with the data entered " + Error;
}
}
public void ListAndCountOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//create some test data to assign to the property
//in this case the data needs to be a list of objects
List <clsFlights> TestList = new List <clsFlights>();
//add an item to the list
//create the item of test data
clsFlights TestItem = new clsFlights();
//set its properties
TestItem.FlightID = 1;
TestItem.FlightNo = "A114";
TestItem.Airline = "Air India";
TestItem.ArrivalAirport = "BHX";
TestItem.Arrival = DateTime.Now.Date;
TestItem.Departure = DateTime.Now.Date;
TestItem.DepartureAirport = "BHX";
TestItem.Destination = "India";
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
AllFlights.FlightList = TestList;
//test to see that the two values are the same
Assert.AreEqual(AllFlights.Count, TestList.Count);
}
public void ReportByDateOFBirthTestDataFound()
{
//create an instance of the filtered data
clsFlightCollection FilteredFlight = new clsFlightCollection();
//var to store outcome
Boolean OK = true;
//apply a name that doesnt exist
FilteredFlight.ReportByDateOfBirth("June 2020");
//check that the correct number of records are found
if (FilteredFlight.Count == 2)
{
//check of the record is ID 8
if (FilteredFlight.FlightList[0].FlightID != 20)
{
OK = false;
}
//check that the first record is ID 10
if (FilteredFlight.FlightList[1].FlightID != 22)
{
OK = false;
}
}
else
{
OK = false;
}
//test to see that there are no records
Assert.IsTrue(OK);
}
//function for adding new records
void Add()
{
//create an instance of the flight book
MyClassLibrary.clsFlightCollection Flights = new clsFlightCollection();
//validate the data on the web form
string Error = Flights.ThisFlight.Valid(txtFlightNo.Text, txtAirline.Text, txtDestination.Text, txtArrivalTime.Text, txtArrival.Text, txtDepartureTime.Text, txtDeparture.Text);
//if the data is OK then add it to the object
if (Error == "")
{
//get the data entered by the user
Flights.ThisFlight.FlightNo = txtFlightNo.Text;
Flights.ThisFlight.Airline = txtAirline.Text;
Flights.ThisFlight.Destination = txtDestination.Text;
Flights.ThisFlight.ArrivalAirport = txtArrival.Text;
Flights.ThisFlight.Arrival = Convert.ToDateTime(txtArrivalTime.Text);
Flights.ThisFlight.Departure = Convert.ToDateTime(txtDepartureTime.Text);
Flights.ThisFlight.DepartureAirport = txtDeparture.Text;
//add the record
Flights.Add();
//all done so redirect back to the main page
}
else
{
//report an error
lblError.Text = "There were problems with the data entered" + Error;
}
}
//This function handles the load event for the page
protected void Page_Load(object sender, EventArgs e)
{
//if this is the first time the page is displayed
if (IsPostBack == false)
{
//update the list box
DisplayFlight();
}
void DisplayFlight()
{
//create an instance of the collection class
clsFlightCollection Flight = new clsFlightCollection();
//set the data source to the list of flights in the collection
lstFlight.DataSource = Flight.FlightList;
//set the name of the primary key
lstFlight.DataValueField = "FlightID";
//set the data field to display
lstFlight.DataTextField = "DateOfBirth";
//bind the data to the list
lstFlight.DataBind();
}
}
public void InstanceOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//test to see that it exists
Assert.IsNotNull(AllFlights);
}
public void InstanceOK()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//test to see that it exists
Assert.IsNotNull(AllFlight);
}
public void ReportByDateOfBirthNoneFound()
{
//create an instance of the filtered data
clsFlightCollection FilteredFlight = new clsFlightCollection();
//apply a date of birth that doesnt exist
FilteredFlight.ReportByDateOfBirth("xxx xxxx xxxx");
//test to see that there are no records
Assert.AreEqual(0, FilteredFlight.Count);
}
public void FilterByDestinationNoneFound()
{
//create an instance of the filtered data
clsFlightCollection FilteredFlights = new clsFlightCollection();
//apply a airline that doesn't exist
FilteredFlights.FilterByDestination("@@@");
//test to see that there are no records
Assert.AreEqual(0, FilteredFlights.Count);
}
void DeleteFlight()
{
//function to delete the selected record
//create a new instance of the Booking book
clsFlightCollection FlightBook = new clsFlightCollection();
//find the record to delete
FlightBook.ThisFlight.Find(FlightID);
//delete the record
FlightBook.Delete();
}
void DisplayFlight()
{
MyClassLibrary.clsFlightCollection Flights = new clsFlightCollection();
Flights.ThisFlight.Find(FlightID);
txtFlightNo.Text = Flights.ThisFlight.FlightNo;
txtAirline.Text = Flights.ThisFlight.Airline;
txtDestination.Text = Flights.ThisFlight.Destination;
txtArrival.Text = Flights.ThisFlight.ArrivalAirport;
txtArrivalTime.Text = Flights.ThisFlight.Arrival.ToString();
txtDepartureTime.Text = Flights.ThisFlight.Departure.ToString();
txtDeparture.Text = Flights.ThisFlight.DepartureAirport;
}
void DisplayFlight()
{
//create an instance of the flight book
clsFlightCollection FlightBook = new clsFlightCollection();
//find the record to update
FlightBook.ThisFlight.Find(FlightID);
//display the data for this record
txtDateOfBirth.Text = FlightBook.ThisFlight.DateOfBirth;
txtGate.Text = FlightBook.ThisFlight.Gate;
txtDepartureDate.Text = FlightBook.ThisFlight.DepartureDate.ToString();
}
public void FilterByDestinationMethodOK()
{
//create an instance of the class containing unfiltred results
clsFlightCollection AllFlights = new clsFlightCollection();
//create an instance of the filtered data
clsFlightCollection FilteredFlights = new clsFlightCollection();
//apply a blank string (should return all records);
FilteredFlights.FilterByDestination("");
//test to see that the two values are the same
Assert.AreEqual(AllFlights.Count, FilteredFlights.Count);
}
public void ReportByDateOfBirthMethod()
{
//create an instance of the class containing unfiltered results
clsFlightCollection AllFlight = new clsFlightCollection();
//create an instance of the filtered data
clsFlightCollection FilteredFlight = new clsFlightCollection();
//apply a blank string (should return all records)
FilteredFlight.ReportByDateOfBirth("");
//test to see that the two values are the same
Assert.AreEqual(AllFlight.Count, FilteredFlight.Count);
}
void DisplayBookings()
{
//create an instance of the booking collection
clsFlightCollection Bookings = new clsFlightCollection();
//set the data source to the list of bookings in the collection
lstFlights.DataSource = Bookings.FlightList;
//set the name of the primary key
lstFlights.DataValueField = "FlightID";
//set the data field to display
lstFlights.DataTextField = "FlightNo";
//bind the data to the list
lstFlights.DataBind();
}
Int32 DisplayBookings()
{
//create an instance of the booking collection
clsFlightCollection Bookings = new clsFlightCollection();
//set the data source to the list of bookings in the collection
lstFlights.DataSource = Bookings.FlightList;
//set the name of the primary key
lstFlights.ValueMember = "FlightID";
//set the data field to display
lstFlights.DisplayMember = "FlightNo";
//bind the data to the list
return(Bookings.Count);
}
void FilterByDestination(string Destination)
{
//create an instance of the booking collection
clsFlightCollection C = new clsFlightCollection();
C.FilterByDestination(Destination);
//set the data source to the list of bookings in the collection
lstFlights.DataSource = C.FlightList;
//set the name of the primary key
lstFlights.DataValueField = "FlightID";
//set the data field to display
lstFlights.DataTextField = "Destination";
//bind the data to the list
lstFlights.DataBind();
}
Int32 FilterByDestination(string Destination)
{
//create an instance of the booking collection
clsFlightCollection C = new clsFlightCollection();
C.FilterByDestination(Destination);
//set the data source to the list of bookings in the collection
lstFlights.DataSource = C.FlightList;
//set the name of the primary key
lstFlights.ValueMember = "FlightID";
//set the data field to display
lstFlights.DisplayMember = "Destination";
//bind the data to the list
return(C.Count);
}
public void ThisFlightProperty()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//create some test data to assign to the property
clsFlight TestFlight = new clsFlight();
TestFlight.FlightID = 1;
TestFlight.TicketID = 2;
TestFlight.DateOfBirth = "1st May 2000";
TestFlight.Gate = "12B";
TestFlight.DepartureDate = DateTime.Now.Date;
//assign the data to the property
AllFlight.ThisFlight = TestFlight;
//test to see that the two value are the same
Assert.AreEqual(AllFlight.ThisFlight, TestFlight);
}
public void ThisFlightsPropertyOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//create some test data to assign to the property
clsFlights TestFlights = new clsFlights();
//set the properties of the test object
TestFlights.FlightID = 1;
TestFlights.FlightNo = "A114";
TestFlights.Airline = "Air India";
TestFlights.ArrivalAirport = "BHX";
TestFlights.Arrival = DateTime.Now.Date;
TestFlights.Departure = DateTime.Now.Date;
TestFlights.DepartureAirport = "BHX";
TestFlights.Destination = "India";
//assign the data to the property
AllFlights.ThisFlight = TestFlights;
//test to see that the two values are the same
Assert.AreEqual(AllFlights.ThisFlight, TestFlights);
}
public void UpdateMethodOK()
{
//create an instance of the class we want to create
clsFlightCollection AllFlights = new clsFlightCollection();
//create the item of test data
clsFlights TestItem = new clsFlights();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.FlightNo = "AA11";
TestItem.Airline = "Air India";
TestItem.ArrivalAirport = "DXB";
TestItem.Arrival = DateTime.Now.Date;
TestItem.Departure = DateTime.Now.Date;
TestItem.DepartureAirport = "MCR";
TestItem.Destination = "Dubai";
//set ThisFlights to the test data
AllFlights.ThisFlight = TestItem;
//add the record
PrimaryKey = AllFlights.Add();
//set the primary key of the test data
TestItem.FlightID = PrimaryKey;
//modify the test data
TestItem.FlightNo = "AA30";
TestItem.Airline = "Air France";
TestItem.ArrivalAirport = "LHR";
TestItem.Arrival = DateTime.Now.Date;
TestItem.Departure = DateTime.Now.Date;
TestItem.DepartureAirport = "DHL";
TestItem.Destination = "Germany";
//set the record based on the new test data
AllFlights.ThisFlight = TestItem;
//update the record
AllFlights.Update();
//find the record
AllFlights.ThisFlight.Find(PrimaryKey);
//test to see ThisFlights matches the test data
Assert.AreEqual(AllFlights.ThisFlight, TestItem);
}
public void ListAndCount()
{
//create an instance of a class
clsFlightCollection AllFlight = new clsFlightCollection();
//create some test data to assign to the property
//in this case the data needs to be a list of objects
List <clsFlight> TestList = new List <clsFlight>();
//add an item to the list
//create the item of test data
clsFlight TestItem = new clsFlight();
//set its properties
TestItem.FlightID = 1;
TestItem.TicketID = 2;
TestItem.DateOfBirth = "1st May 2000";
TestItem.Gate = "12B";
TestItem.DepartureDate = DateTime.Now.Date;
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
AllFlight.FlightList = TestList;
//test to see that the two values are the same
Assert.AreEqual(AllFlight.Count, TestList.Count);
}
