public void SearchForAvailableReservationTest()
        {
            ReservationSqlDAL myDAL = new ReservationSqlDAL(connectionString);

            List <Site> testReservationList = myDAL.SearchForAvailableReservation(siteID, startDate, endDate);

            Assert.AreEqual(testReservationList.Count, 0);

            List <Site> testReservationList2 = myDAL.SearchForAvailableReservation(siteID, Convert.ToDateTime("02/01/2019"), Convert.ToDateTime("02/02/2019"));

            Assert.AreEqual(testReservationList.Count, 1);
        }
        // Called after user chooses a campsite, start date, and end date in order to search for available reservations.
        // Uses a DAO to search the database searching for available sites within the given dates and returns a list of
        // those that are available
        public void SearchForAvailableReservation(int campgroundSelection, DateTime arrivalDate, DateTime departureDate)
        {
            ReservationSqlDAL myDAL          = new ReservationSqlDAL(databaseConnectionString);
            List <Site>       availableSites = myDAL.SearchForAvailableReservation(campgroundSelection, arrivalDate, departureDate);

            Console.WriteLine("Site ID    Max Occupancy");
            foreach (Site site in availableSites)
            {
                Console.WriteLine(site);
            }
            Console.WriteLine();
            ConfirmReservation(campgroundSelection, arrivalDate, departureDate);
        }