public void PrintCost()
        {
            SiteSqlDAL  siteSqlDAL   = new SiteSqlDAL(dbconnectionString);
            List <Site> testSiteList = siteSqlDAL.ListCampGroundSites(3);


            string siteCost = siteSqlDAL.PrintCost(testSiteList[0], "3/3/2018", "3/5/2018");

            Assert.AreEqual("$60.00", siteCost);
        }
        public void ListCampGroundSites()
        {
            SiteSqlDAL siteSqlDAL = new SiteSqlDAL(dbconnectionString);

            List <Site> testSite = new List <Site>();

            testSite = siteSqlDAL.ListCampGroundSites(3);

            Assert.IsNotNull(testSite);
            Assert.AreEqual(12, testSite.Count, "For CampGround 3");

            List <Site> testSite2 = new List <Site>();

            testSite2 = siteSqlDAL.ListCampGroundSites(5);
            Assert.AreEqual(1, testSite2.Count, "For CampGround 5");

            List <Site> testSite3 = new List <Site>();

            testSite3 = siteSqlDAL.ListCampGroundSites(7);
            Assert.AreEqual(5, testSite3.Count, "For CampGround 7");
        }