public void TestStartBeforeRes()
        {
            SiteSqlDAO dao = new SiteSqlDAO(connString);

            IList <Site> test = dao.ListAvailableSites(campId, Convert.ToDateTime("2019/11/01"), Convert.ToDateTime("2019/11/02"));

            Assert.AreEqual(2, test.Count);
        }
        public void TestTwoEndingAfterRes()
        {
            SiteSqlDAO dao = new SiteSqlDAO(connString);

            IList <Site> test = dao.ListAvailableSites(campId, Convert.ToDateTime("2019/11/03"), Convert.ToDateTime("2019/11/04"));

            Assert.AreEqual(2, test.Count);
        }
        public void TestAllSitesBooked()
        {
            SiteSqlDAO dao = new SiteSqlDAO(connString);

            IList <Site> test = dao.ListAvailableSites(campId, Convert.ToDateTime("2019/12/02"), Convert.ToDateTime("2019/12/03"));

            Assert.AreEqual(0, test.Count);
        }