public void GetAllDetailsByParkCode()
        {
            //Arrange
            NPGeekDAL _dal = new NPGeekDAL(_connectionString);

            //Act
            ParkDetails parkDetailsItem = _dal.GetAllDetailsByParkCode("CVNP");

            //Assert
            Assert.AreEqual("Cuyahoga Valley National Park", parkDetailsItem.ParkName);
        }
        public void GetFiveDayForecast()
        {
            //Arrange
            NPGeekDAL _dal = new NPGeekDAL(_connectionString);

            //Act
            IList <ForecastDay> fiveDayForecast = _dal.GetFiveDayForecast("GSMNP");

            //Assert
            Assert.IsNotNull(fiveDayForecast);
            Assert.AreEqual("partly cloudy", fiveDayForecast[0].Forecast);
        }
        public void GetParksForHomePage()
        {
            //Arrange
            NPGeekDAL _dal = new NPGeekDAL(_connectionString);

            //Act
            IList <IndexViewModel> listForHomePage = _dal.GetParksForHomePage();

            //Assert
            Assert.IsNotNull(listForHomePage);
            Assert.AreEqual(10, listForHomePage.Count);
        }
        public void GetSurveyResults()
        {
            //Arrange
            NPGeekDAL _dal = new NPGeekDAL(_connectionString);

            //Act
            IList <SurveyResultsViewModel> surveyResults = _dal.GetSurveyResults();

            //Assert
            Assert.IsNotNull(surveyResults);
            Assert.AreEqual("Cuyahoga Valley National Park", surveyResults[0].ParkName);
        }
        public void AddSurveyToDatabase()
        {
            //Arrange
            NPGeekDAL       _dal  = new NPGeekDAL(_connectionString);
            SurveyViewModel model = new SurveyViewModel
            {
                ParkCode      = "GTNP",
                Email         = "*****@*****.**",
                State         = "Ohio",
                ActivityLevel = "Inactive"
            };

            //Act
            int numRowsAffected = _dal.AddSurveyToDatabase(model);


            //Assert
            Assert.AreEqual(1, numRowsAffected);
        }