public void GetSurveyResultsTest() { SurveySqlDal dal = new SurveySqlDal(connectionString); List <DailySurvey> surveys = dal.GetSurveyResults(); Assert.IsTrue(surveys.Any(i => i.ParkCode == "TESTII")); Assert.IsTrue(surveys.Any(i => i.ParkCode == "TEST")); Assert.IsFalse(surveys.Any(i => i.ParkCode == "TESTI")); Assert.IsTrue(surveys.Count >= 2); }
public void SubmitSurveyTest() { Survey p = new Survey { ParkCode = "CVNP", EmailAddress = "*****@*****.**", State = "Ohio", ActivityLevel = "active" }; SurveySqlDal surveyDal = new SurveySqlDal(connectionString); surveyDal.InsertSurvey(p); Assert.AreEqual(surveyDal.InsertSurvey(p), true); }
public void SaveSurvey() { SurveySqlDal dal = new SurveySqlDal(connectionString); List <DailySurvey> surveys = dal.GetSurveyResults(); surveyCount = surveys.Count(); DailySurvey survey = new DailySurvey(); survey.ParkCode = "TESTI"; survey.ActivityLevel = "sedentary"; survey.EmailAddress = "*****@*****.**"; survey.State = "HI"; dal.SaveSurvey(survey); surveys = dal.GetSurveyResults(); Assert.IsTrue(surveyCount + 1 == surveys.Count()); Assert.IsTrue(surveys.Any(i => i.ParkCode == "TESTI")); }
public HomeController() { dal = new NationalParkSqlDal(ConfigurationManager.ConnectionStrings["NPGeek"].ConnectionString); surveyDal = new SurveySqlDal(ConfigurationManager.ConnectionStrings["NPGeek"].ConnectionString); weatherDal = new WeatherSqlDal(ConfigurationManager.ConnectionStrings["NPGeek"].ConnectionString); }