예제 #1
0
        //function to update an existing record on the dbase
        public void Update(clsBookings ExistingBooking)
        {
            clsDataConnection ExistingDBBooking = new clsDataConnection();

            //add parameters
            ExistingDBBooking.AddParameter("@BookingNo", ExistingBooking.BookingNo);
            ExistingDBBooking.AddParameter("@CustomerNo", ExistingBooking.CustomerNo);
            ExistingDBBooking.AddParameter("@TourNo", ExistingBooking.TourNo);
            ExistingDBBooking.AddParameter("@DateTime", ExistingBooking.DateandTime);
            ExistingDBBooking.AddParameter("@PassengerCount", ExistingBooking.PassengerCount);
            //execute the sproc
            ExistingDBBooking.Execute("sproc_tblBooking_Update");
        }
예제 #2
0
        //function for adding new booking record to the database
        public Int32 Add(clsBookings NewBooking)
        {
            clsDataConnection NewDBBooking = new clsDataConnection();

            //add the parameters
            NewDBBooking.AddParameter("@BookingNo", NewBooking.BookingNo);
            NewDBBooking.AddParameter("@CustomerNo", NewBooking.CustomerNo);
            NewDBBooking.AddParameter("@TourNo", NewBooking.TourNo);
            NewDBBooking.AddParameter("@DateTime", NewBooking.DateandTime);
            NewDBBooking.AddParameter("@PassengerCount", NewBooking.PassengerCount);
            //execute the insert stored procedure
            return(NewDBBooking.Execute("sproc_tblBookings_Insert"));
        }