public void GetSurveyTest() { SurveySQLDAL dal = new SurveySQLDAL(connectionString); List <Result> surveyResults = dal.GetSurveyResults(); Assert.AreNotEqual(0, surveyResults.Count); }
public ActionResult FavoriteParks() { SurveySQLDAL DAL = new SurveySQLDAL(); List <Survey> favoriteParks = DAL.GetTopFiveResults(); return(View("FavoriteParks", favoriteParks)); }
public ActionResult FavoriteParks(Survey model) { if (!ModelState.IsValid) { return(View("Survey", model)); } SurveySQLDAL DAL = new SurveySQLDAL(); DAL.AddSurvey(model); return(RedirectToAction("FavoriteParks", "Survey")); }
//GET: public ActionResult SurveyResults() { ISurveyDAL dal = new SurveySQLDAL(connectionString); List <Survey> results = new List <Survey>(); Survey s = new Survey(); s.ActivityLevel = (String.IsNullOrEmpty(Request["activityLevel"])) ? "Inactive" : Request["activityLevel"]; s.ParkCode = (String.IsNullOrEmpty(Request["FavoritePark"])) ? "" : Request["FavoritePark"]; s.EmailAddress = (String.IsNullOrEmpty(Request["email"])) ? "Did not provide" : Request["email"]; s.State = (String.IsNullOrEmpty(Request["state"])) ? "Did not provide" : Request["state"]; dal.SaveSurvey(s); ViewBag.WinningPark = dal.GetWinningParkName(); results = dal.GetAllSurveys(); return(View(results)); }