public void FindOpenSites()
        {
            //arrange
            ReservationSqlDAO reservationDAO   = new ReservationSqlDAO(connectionString);
            DateTime          selectedFromDate = Convert.ToDateTime("2019 - 01 - 01");
            DateTime          selectedToDate   = Convert.ToDateTime("2019 - 12 - 31");
            int selectedCampgroundID           = 1;

            //act
            IList <Site> sites        = reservationDAO.FindOpenSites(selectedCampgroundID, selectedFromDate, selectedToDate);
            int          actualResult = sites.Count;

            //assert
            Assert.AreEqual(actualResult, 5);
        }