public void ReturnNoSitesTest()
        {
            SiteSqlDAL  testSite = new SiteSqlDAL(connectionString);
            List <Site> siteList = testSite.GetTopFiveSites(37, new System.DateTime(2018, 10, 15), new System.DateTime(2018, 10, 20));

            Assert.AreEqual(0, siteList.Count);
        }
        //Checks with current reservations to see if site is available

        public bool AvailableSitesToReserve(int campgroundID, string arrivalDate, string departureDate)
        {
            int reservationId = 0;

            DateTime arrivalResult   = DateTime.MinValue;
            DateTime departureResult = DateTime.MinValue;

            DateTime.TryParse(arrivalDate, out arrivalResult);
            DateTime.TryParse(departureDate, out departureResult);

            SiteSqlDAL  dal  = new SiteSqlDAL(connectionString);
            List <Site> site = dal.GetTopFiveSites(campgroundID, arrivalResult, departureResult);

            if (site.Count == 0)
            {
                Console.WriteLine();
                Console.WriteLine("No availiable sites to reserve");
                return(true);
            }

            Console.WriteLine();
            Console.WriteLine("Results Matching Your Search Criteria");
            Console.WriteLine("Site No.   Max Occup.   Accessible?   Max RV Length   Utility   Cost");

            foreach (Site sites in site)
            {
                string result;
                result  = sites.Id.ToString().PadRight(11);
                result += sites.MaxOcc.ToString().PadRight(13);

                if (sites.Accessible == false)
                {
                    result += "No".PadRight(14);
                }
                else
                {
                    result += "Yes".PadRight(14);
                }

                if (sites.RVLength > 0)
                {
                    result += sites.RVLength.ToString().PadRight(16);
                }
                else
                {
                    result += "N/A".PadRight(16);
                }

                if (sites.Utilities == false)
                {
                    result += "No".PadRight(10);
                }
                else
                {
                    result += "Yes".PadRight(10);
                }
                result += "$" + sites.totalCost;
                Console.WriteLine(result);
            }

            int siteNumber = CLIHelper.GetInteger("Which site should be reserved? (enter 0 to cancel)");

            if (siteNumber == 0)
            {
                Console.WriteLine("Hope to have you stay next time!");
                return(false);
            }
            else if (siteNumber < 0)
            {
                Console.WriteLine("Please select valid site number");
                Console.WriteLine();
                return(true);
            }

            string nameToBook = CLIHelper.GetString("What name should the reservation be made under?  ");

            ReservationSQLDal newDAL = new ReservationSQLDal(connectionString);

            reservationId = newDAL.MakeReservation(siteNumber, nameToBook, arrivalDate, departureDate);

            Console.WriteLine($"{nameToBook} The reservation has been made and the confirmation id is {reservationId}");
            Console.WriteLine();
            Console.WriteLine("Would you like to make another reservation? If so press enter to return to park menu");
            Console.ReadLine();

            return(true);
        }