public void AddBookingMethodOK() { // create an instance of the booking collection class clsBookingCollection Bookings = new clsBookingCollection(); // create item of test data clsBooking TestItem = new clsBooking(); // var to store primary key Int32 PrimaryKey = 0; // set the properties TestItem.BookingID = 3; TestItem.TotalPrice = 200; TestItem.BookingApproved = false; TestItem.DestinationID = 2; TestItem.BookingDate = DateTime.Now.Date; TestItem.CarParkID = 151; TestItem.CustomerNo = 1; // set ThisBooking to the test data Bookings.ThisBooking = TestItem; // add the record PrimaryKey = Bookings.Add(); // set the primary key TestItem.BookingID = PrimaryKey; // find the record Bookings.ThisBooking.Find(PrimaryKey); // test to see that the two values are the same Assert.AreEqual(Bookings.ThisBooking, TestItem); }
//function for Adding records void Add() { //create an instance of the booking list clsBookingCollection Bookings = new clsBookingCollection(); //validate the data on the web form //string foreName, string surname, string dateOfBirth, string gender, string contactNumber, string eMail, string flatNo, string houseNo, string postCode String Error = Bookings.ThisBookings.Valid(txtuseremail.Text, txtDateBooked.Text, txtTimeBooked.Text, txtGuestsBooked.Text, txtDiningBooked.Text); //if the data is OK then add it to the object if (Error == "") { //find the record to update //Customer.ThisCustomer.Find(Id); //get the data entered by the user Bookings.ThisBookings.useremail = Convert.ToString(txtuseremail.Text); Bookings.ThisBookings.DateBooked = Convert.ToDateTime(txtDateBooked.Text); Bookings.ThisBookings.TimeBooked = Convert.ToString(txtTimeBooked.Text); Bookings.ThisBookings.GuestsBooked = Convert.ToString(txtGuestsBooked.Text); Bookings.ThisBookings.DiningBooked = Convert.ToString(txtDiningBooked.Text); //CList.ThisCustomer.UserName = User.Identity.Name; //update the record Bookings.Add(); //all done so redirect back to the main page // Response.Redirect("AdminHomepage.aspx"); page does not exist lblError.Text = "add"; } else { //report an error lblError.Text = "There were problems with the data entered " + Error; } }
public void DeleteMethodOK() { //create an instance of the class we want to create clsBookingCollection AllBookings = new clsBookingCollection("Fbloggs"); //create an instance of test data clsBooking TestItem = new clsBooking(); //var to store primary key Int32 PK = 0; //set the properties //TestItem.CustomerID = 3; TestItem.useremail = "*****@*****.**"; TestItem.DateBooked = DateTime.Now.Date; TestItem.TimeBooked = DateTime.Now.Date.ToString(); TestItem.GuestsBooked = "10"; TestItem.DiningBooked = "Dinner"; //set ThisCustomer to validate test data AllBookings.ThisBookings = TestItem; //add the record PK = AllBookings.Add(); //set primary key of test data TestItem.BookRef = PK; //find the record AllBookings.ThisBookings.Find(PK); //delete the record AllBookings.Delete(); //now find the record Boolean Found = AllBookings.ThisBookings.Find(PK); //test to see that it exists Assert.IsFalse(Found); }
//function for adding new records void Add() { //create an instance of the booking Book clsBookingCollection BookingBook = new clsBookingCollection(); //validate the data on the web form string Error = BookingBook.ThisBooking.Valid(txtBookingName.Text, txtBookingDate.Text, txtBookingValidity.Text); //if the data is ok then add it to the object if (Error == "") { //get the data entered by the user BookingBook.ThisBooking.BookingName = txtBookingName.Text; BookingBook.ThisBooking.BookingDate = Convert.ToDateTime(txtBookingDate.Text); BookingBook.ThisBooking.BookingValidity = Convert.ToInt32(txtBookingValidity.Text); //add the record BookingBook.Add(); //all done so redirect back to the main page Response.Redirect("BookingList.aspx"); } else { //report an error lblError.Text = "There are problems with the data entered " + Error; } }
public void AddMethod() { //create an instance of a class clsBookingCollection AllBooking = new clsBookingCollection(); //create the item of test data clsBooking TestItem = new clsBooking(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.BookingID = 1; TestItem.CustomerID = 2; TestItem.StaffID = 2; TestItem.FlightID = 2; TestItem.BookingName = "Tom"; TestItem.BookingDate = DateTime.Now.Date; TestItem.BookingValidity = 30; //set thisBooking to the test data AllBooking.ThisBooking = TestItem; //add the record PrimaryKey = AllBooking.Add(); //set the primary key of the test data TestItem.BookingID = PrimaryKey; //find the record AllBooking.ThisBooking.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllBooking.ThisBooking, TestItem); }
public void DeleteMethod() { //create an instance of a class clsBookingCollection AllBooking = new clsBookingCollection(); //create the item of test data clsBooking TestItem = new clsBooking(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.BookingID = 1; TestItem.CustomerID = 2; TestItem.StaffID = 2; TestItem.FlightID = 2; TestItem.BookingName = "Tom"; TestItem.BookingDate = DateTime.Now.Date; TestItem.BookingValidity = 30; //set thisBooking to the test data AllBooking.ThisBooking = TestItem; //add the record PrimaryKey = AllBooking.Add(); //set the primary key of the test data TestItem.BookingID = PrimaryKey; //find the record AllBooking.ThisBooking.Find(PrimaryKey); //delete this record AllBooking.Delete(); //now find the record Boolean Found = AllBooking.ThisBooking.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
void Add() { // create an instance of the class file clsBookingCollection Booking = new clsBookingCollection(); // get the data Booking.ThisBooking.DestinationID = Convert.ToInt32(txtID.Text); Booking.ThisBooking.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text); Booking.ThisBooking.BookingApproved = Convert.ToBoolean(txtBookingApproved.Text); Booking.ThisBooking.BookingDate = Convert.ToDateTime(txtBookingDate.Text); Booking.ThisBooking.CustomerNo = Convert.ToInt32(txtCustomerID.Text); Booking.ThisBooking.CarParkID = Convert.ToInt32(txtCarParkID.Text); // add the record Booking.Add(); }
protected void btnOK_Click(object sender, EventArgs e) { //instance of cls booking clsBookings ThisBooking = new clsBookings(); //variable to store error msg string ErrorMessage; //test data entered ErrorMessage = ThisBooking.BookingValid(txtCustomerNo.Text, txtTourNo.Text, txtPassengerCount.Text, txtDateandTime.Text); //if no errors if (ErrorMessage == "") { //instance of booking collection class clsBookingCollection BookingList = new clsBookingCollection(); //insert new data if (BookingNo == -1) { //copy data from the interface to the object BookingList.ThisBooking.CustomerNo = Convert.ToInt32(txtCustomerNo.Text); BookingList.ThisBooking.TourNo = Convert.ToInt32(txtTourNo.Text); BookingList.ThisBooking.PassengerCount = Convert.ToInt32(txtPassengerCount.Text); BookingList.ThisBooking.DateandTime = Convert.ToDateTime(txtDateandTime); //add the new record BookingList.Add(); } else//update existing data { BookingList.ThisBooking.CustomerNo = Convert.ToInt32(txtCustomerNo.Text); BookingList.ThisBooking.TourNo = Convert.ToInt32(txtTourNo.Text); BookingList.ThisBooking.PassengerCount = Convert.ToInt32(txtPassengerCount.Text); BookingList.ThisBooking.DateandTime = Convert.ToDateTime(txtDateandTime); //add the new record BookingList.Update(); } //Redirect back to the bookings list Response.Redirect("StaffBooking.aspx"); } else { //display error message lblError.Text = ErrorMessage; } }
public void UpdateBookingMethodOK() { // create an instance of the booking collection class clsBookingCollection Bookings = new clsBookingCollection(); // create item of test data clsBooking TestItem = new clsBooking(); // var to store primary key Int32 PrimaryKey = 0; // set the properties TestItem.TotalPrice = 198; TestItem.BookingApproved = false; TestItem.DestinationID = 1; TestItem.BookingDate = DateTime.Now.Date; TestItem.CarParkID = 151; TestItem.CustomerNo = 1; // set ThisBooking to the test data Bookings.ThisBooking = TestItem; // add the record PrimaryKey = Bookings.Add(); // set the primary key of the test data TestItem.BookingID = PrimaryKey; // modify the test data TestItem.TotalPrice = 1500; TestItem.BookingApproved = true; TestItem.DestinationID = 12; TestItem.BookingDate = DateTime.Now.Date; TestItem.CarParkID = 154; TestItem.CustomerNo = 5; // set the record based on the new test data Bookings.ThisBooking = TestItem; // update the record Bookings.Update(); // find the record Bookings.ThisBooking.Find(PrimaryKey); // test to see ThisBooking matches the test data Assert.AreEqual(Bookings.ThisBooking, TestItem); }
protected void btnAdd_Click(object sender, EventArgs e) { string Username = Session["user"].ToString(); clsBookingCollection Booking = new clsBookingCollection(Username); //validation here Boolean OK = Booking.ThisBooking.Valid(Station_origin.Text, Station_destination.Text, ddlType.Text, ddlDate.Text, ddlMonth.Text, ddlDeparture.Text); //set some vars for the txt elements string Station_Origin = Station_origin.Text; string Station_Destination = Station_destination.Text; string Type = ddlType.Text; string Date = ddlDate.Text; string Month = ddlMonth.Text; string Departure = ddlDeparture.Text; // string Arrival = ddlArrival.Text; string UserName = Username; //if the data is OK add it to the object if (OK == true) { Booking.ThisBooking.Station_Origin = Station_Origin; Booking.ThisBooking.Station_Destination = Station_Destination; Booking.ThisBooking.Type = Type; Booking.ThisBooking.Date = Date; Booking.ThisBooking.Month = Month; Booking.ThisBooking.Departure = Departure; // Booking.ThisBooking.Arrival = Arrival; Booking.ThisBooking.Username = UserName; Booking.Add(); //Response.Redirect("Cart.aspx"); lblError.Text = "Success"; } else { //report an error lblError.Text = "Please try again"; } }
public void UpdateMethodOK() { //create an instance of the class we want to create clsBookingCollection AllBookings = new clsBookingCollection("Fbloggs"); //create an instance of test data clsBooking TestItem = new clsBooking(); //var to store primary key Int32 PK = 0; //set the properties TestItem.useremail = "*****@*****.**"; TestItem.DateBooked = DateTime.Now.Date; TestItem.TimeBooked = DateTime.Now.Date.ToString(); TestItem.GuestsBooked = "10"; TestItem.DiningBooked = "Dinner"; //set ThisCustomer to validate test data AllBookings.ThisBookings = TestItem; //add the record PK = AllBookings.Add(); //set primary key of test data TestItem.BookRef = PK; //modify the record TestItem.useremail = "*****@*****.**"; TestItem.DateBooked = DateTime.Now.Date; TestItem.TimeBooked = DateTime.Now.Date.ToString(); TestItem.GuestsBooked = "10"; TestItem.DiningBooked = "Dinner"; //set the record based on the new record AllBookings.ThisBookings = TestItem; //update the record AllBookings.Update(); //find the record AllBookings.ThisBookings.Find(PK); //test to see that it exists Assert.AreEqual(AllBookings.ThisBookings, TestItem); }