public void GetAllSurveysTest()
        {
            Survey_ResultSqlDAL  dal     = new Survey_ResultSqlDAL(connectionString);
            List <Survey_Result> results = dal.GetAllSurveys();

            CollectionAssert.AllItemsAreNotNull(results);
            Assert.IsNotNull(results);
            Assert.AreEqual(6, results.Count);
        }
        public void AddResultTests()
        {
            Survey_ResultSqlDAL  dal          = new Survey_ResultSqlDAL(connectionString);
            List <Survey_Result> priorResults = dal.GetAllSurveys();

            bool addSuccessful = dal.AddResult(new Survey_Result()
            {
                ParkCode = "JSNP", Email = "*****@*****.**", State = "Ohio", ActivityLevel = "Very Active"
            });

            List <Survey_Result> newResults = dal.GetAllSurveys();

            Assert.AreEqual(true, addSuccessful);
            Assert.AreEqual(priorResults.Count + 1, newResults.Count);
        }
        public void GetTopRankedParksTest()
        {
            Survey_ResultSqlDAL dal = new Survey_ResultSqlDAL(connectionString);

            List <SurveyResultViewModel> surveys = dal.GetTopRankedParks();

            bool result = false;

            if (surveys[0].ParkCode == "JSNP")
            {
                result = true;
            }


            Assert.IsTrue(result);
        }