public ActionResult FavoriteParks()
{
SurveySqlDAL sql = new SurveySqlDAL(connectionString);
List <SurveyModel> thisList = sql.BestParks();
return(View("FavoriteParks", thisList));
}
public ActionResult Survey(SurveyModel thisSurvey)
{
SurveySqlDAL sql = new SurveySqlDAL(connectionString);
sql.SurveyPost(thisSurvey);
return(RedirectToAction("FavoriteParks"));
}
public ActionResult SurveyResults()
{
SurveySqlDAL surveySD = new SurveySqlDAL(connectionString);
List <Survey> allsurveys = surveySD.GetAllSurveys();
return(View("SurveyResults", allsurveys));
}
// GET: Survey
public ActionResult Index()
{
SurveySqlDAL surveyDAL = new SurveySqlDAL(connectionString);
List <Survey> surveyList = surveyDAL.GetSurveys();
return(View("Index", surveyList));
}
//GET: SurveyResults
public ActionResult SurveyResults()
{
SurveySqlDAL dal = new SurveySqlDAL(connectionString);
List <SurveyResults> surveyResults = dal.GetHighestVoteTotal();
return(View("SurveyResults", surveyResults));
}
public void SaveNewSurveyTest() //void SaveNewSurvey(Survey survey)
{
//Arrange
ISurveyDAL surveySqlDAL = new SurveySqlDAL(connectionString);
Dictionary <string, int> surveys = surveySqlDAL.GetFavoriteParkBySurveyCount();
Survey survey = new Survey()
{
ParkCode = "YNP2",
Email = "*****@*****.**",
State = "Ohio",
ActivityLevel = "Inactive"
};
int before;
if (surveys.ContainsKey("YNP2"))
{
before = surveys["YNP2"];
}
else
{
before = 0;
}
//ACT
surveySqlDAL.SaveNewSurvey(survey);
//check that the added survey increased the # of votes for yosemite by 1.
Dictionary <string, int> surveysNew = surveySqlDAL.GetFavoriteParkBySurveyCount();
int after = surveysNew["YNP2"];
//Assert
Assert.IsNotNull(surveysNew, "Yosemite should have at least 1 vote(survey).");
Assert.AreEqual((before + 1), after, $"Yosemite should have had {before} surveys before the add and {after} surveys after the add.");
}
public void SQL_InsertSurvey_Tests()
{
SurveySqlDAL surveyDal = new SurveySqlDAL(connectionString);
Assert.IsNotNull(surveyDal);
Assert.AreEqual(1, rowsAffected);
}
public void GetAllSurveysTest()
{
SurveySqlDAL surveyDAL = new SurveySqlDAL(connectionString);
List <Survey> surveyList = surveyDAL.GetAllSurveys();
Assert.IsNotNull(surveyList);
Assert.AreEqual(surveys, surveyList.Count);
}
public void GetParkSurveyResult()
{
SurveySqlDAL surveySqlDAL = new SurveySqlDAL(connectionString);
List <ViewParksSurveyViewModel> surveys = surveySqlDAL.GetParkSurveyResult();
Assert.IsNotNull(surveys);
}
public void GetAllPostsTest()
{
SurveySqlDAL dal = new SurveySqlDAL(connectionString);
List <SurveyModel> result = dal.GetAllPosts();
Assert.AreEqual(1, result.Count);
}
public void SaveNewSurveyTest()
{
SurveySqlDAL surveyDAL = new SurveySqlDAL(connectionString);
Survey testSurvey = new Survey()
{
SurveyId = surveyId,
};
Assert.AreEqual(true, surveyDAL.SaveNewSurvey(testSurvey));
}
public ActionResult Survey(Survey survey)
{
if (ModelState.IsValid)
{
SurveySqlDAL dal = new SurveySqlDAL(connectionString);
dal.SaveSurvey(survey);
return(RedirectToAction("SurveyResults"));
}
return(View("Survey", survey));
}
public void GetResultsTest()
{
//Arrange
SurveySqlDAL surveyDal = new SurveySqlDAL(connectionString);
//Act
List <Survey> results = surveyDal.GetResults();
//Assert
Assert.IsTrue(results.Count <= 10);
}
public void GetFavoriteParksTest()
{
SurveySqlDAL sqlDAL = new SurveySqlDAL(connectionString);
List <Survey> listOfFavoriteParks = sqlDAL.GetFavoriteParks();
Assert.IsNotNull(listOfFavoriteParks);
Assert.AreEqual(surveyCount + 3, listOfFavoriteParks.Count);
Assert.AreEqual("GNC", listOfFavoriteParks[listOfFavoriteParks.FindIndex(list => list.ParkCode.Contains("GNC"))].ParkCode);
Assert.AreEqual("NTP", listOfFavoriteParks[listOfFavoriteParks.FindIndex(list => list.ParkCode.Contains("NTP"))].ParkCode);
Assert.AreEqual("NNN", listOfFavoriteParks[listOfFavoriteParks.FindIndex(list => list.ParkCode.Contains("NNN"))].ParkCode);
}
public void GetSurveysTest()
{
//Arrange
SurveySqlDAL surveySqlDal = new SurveySqlDAL(connectionString);
//Act
List <Survey> surveys = surveySqlDal.GetSurveys();
//Assert
Assert.IsNotNull(surveys);
Assert.AreEqual(numberOfParksWithSurvey, surveys.Count);
}
public void SubmitSurvey()
{
SurveySqlDAL surveySqlDAL = new SurveySqlDAL(connectionString);
Survey survey = new Survey {
ParkCode = "AAA",
EmailAddress = "*****@*****.**",
State = "Ohio",
ActivityLevel = "inactive"
};
Assert.IsTrue(surveySqlDAL.SubmitSurvey(survey));
}
public void SQL_ViewAllSurveys_Tests()
{
//Arrange
SurveySqlDAL surveyDal = new SurveySqlDAL(connectionString);
//Act
List <Survey> allSurveys = surveyDal.ViewAllSurveys();
//Assert
Assert.IsNotNull(surveyDal);
Assert.IsNotNull(allSurveys);
}
public void SurveySqlDAL_GetAllSurvey_Tests()
{
//Arrange
SurveySqlDAL surveyDAL = new SurveySqlDAL();
//Act
List <Survey> allSurveies = surveyDAL.getAllSurvey();
//Assert
Assert.IsNotNull(surveyDAL);
Assert.IsNotNull(allSurveies);
Assert.AreEqual(6, allSurveies.Count);
}
public void NewSurveyTest()
{
SurveySqlDAL sqlDAL = new SurveySqlDAL(connectionString);
Survey survey = new Survey
{
ParkCode = "GNC",
Email = "email",
State = "ohio",
ActivityLevel = "high",
};
Assert.AreEqual(true, sqlDAL.NewSurvey(survey));
}
public void DisplaySurveys()
{
// Arrange
ISurveyDAL sDAL = new SurveySqlDAL(connectionString);
//Act
IList <SurveyModel> survey = sDAL.DisplaySurveys();
//Assert
int surveyTotal = survey.Count;
Assert.IsNotNull(survey);
Assert.AreEqual(3, surveyTotal);
}
public void GetFavoriteParksTest()
{
SurveySqlDAL surveySqlDAL = new SurveySqlDAL(connectionString);
List <FavoriteParkViewModel> surveys = surveySqlDAL.GetFavoriteParks();
Assert.IsNotNull(surveys);
int totalVotes = 0;
foreach (var model in surveys)
{
totalVotes += model.Votes;
}
Assert.AreEqual(_surveyCount, totalVotes);
}
public ActionResult SurveySubmit(SurveyForm surveyForm)
{
if (!ModelState.IsValid)
{
return(View("SurveySubmit", surveyForm));
}
SurveySqlDAL surveyDAL = new SurveySqlDAL(connectionString);
surveyDAL.SubmitSurvey(surveyForm);
TempData["StatusMessage"] = "Your Survey Has Been Saved";
return(RedirectToAction("Index"));
}
public void SurveyController_FavoritesAction_ReturnFavoritesView()
{
//ParkSqlDAL parkDAL = new ParkSqlDAL(ConfigurationManager.ConnectionStrings["ParkWeather"].ConnectionString);
//WeatherSqlDAL weatherDAL = new WeatherSqlDAL(ConfigurationManager.ConnectionStrings["ParkWeather"].ConnectionString);
SurveySqlDAL surveyDAL = new SurveySqlDAL(ConfigurationManager.ConnectionStrings["ParkWeather"].ConnectionString);
//Arrange
SurveyController controller = new SurveyController(surveyDAL);
//Act
ViewResult result = controller.Favorites() as ViewResult;
//Assert
Assert.AreEqual("Favorites", result.ViewName);
}
public void SavePostTest()
{
SurveyModel model = new SurveyModel()
{
FavoritePark = "Everglades National Park",
Email = "*****@*****.**",
Residence = "OH",
ActivityLevel = "Low"
};
SurveySqlDAL dal = new SurveySqlDAL(connectionString);
bool result = dal.SaveNewPost(model);
Assert.AreEqual(true, result);
}
public void GetFavoriteParkBySurveyCountTest() //Dictionary<string, int> GetFavoriteParkBySurveyCount()
{
//Arrange
ISurveyDAL surveySqlDAL = new SurveySqlDAL(connectionString);
//ACT
int count = 0; //count number of surveys per park entry
Dictionary <string, int> surveys = surveySqlDAL.GetFavoriteParkBySurveyCount();
foreach (KeyValuePair <string, int> survey in surveys)
{
count += survey.Value;
}
//Assert
Assert.IsNotNull(surveys, "Favorite surveys list is empty!");
Assert.AreEqual(surveyCount, count, $"Expected a count of {surveyCount} for parks.");
}
public void SurveySqlDAL_AddNewSurvey_Tests()
{
//Arrange
SurveySqlDAL surveyDAL = new SurveySqlDAL();
//Survey newSurvey = new Survey();
//newSurvey.ActivityLevel = "test";
//newSurvey.EmailAddress = "test";
//newSurvey.State = "test";
//newSurvey.ParkCode = "ENP";
////Act
//bool successAdding = surveyDAL.addNewSurvey(newSurvey);
//Assert
//Assert.IsTrue(successAdding);
Assert.IsNotNull(surveyDAL);
Assert.AreEqual(1, rowAffected);
}
public void SubmitSurveyTest()
{
//Arrange
SurveySqlDAL surveyDal = new SurveySqlDAL(connectionString);
Survey survey = new Survey
{
Email = "*****@*****.**",
ParkCode = "TST2",
State = "Ohio",
ActivityLevel = "active"
};
//Act
bool didWork = surveyDal.SubmitSurvey(survey);
//Assert
Assert.AreEqual(true, didWork);
}
public void SubmitSurveyTest()
{
//Arrange
SurveySqlDAL surveySqlDAL = new SurveySqlDAL(connectionString);
SurveyForm model = new SurveyForm()
{
ParkCode = "gnp",
EmailAddress = "*****@*****.**",
State = "test",
ActivityLevel = "test"
};
//Act
bool didWork = surveySqlDAL.SubmitSurvey(model);
//Assert
Assert.AreEqual(true, didWork);
}
public ActionResult AddSurvey(Survey model, string id)
{
ViewBag.visable = "hidden";
if (!ModelState.IsValid)
{
ViewBag.visable = "";
return(View("AddSurvey"));
}
ISurveyDAL newSurvey = new SurveySqlDAL();
model.ParkCode = id;
if (newSurvey.addNewSurvey(model))
{
return(RedirectToAction("SurveyList", "Survey"));
}
else
{
return(View("AddSurvey"));
}
}
public void HomeController_SurveySubmitAction_RedirectToIndexView()
{
//Arrange
SurveySqlDAL mockDal = new SurveySqlDAL(connectionString);
SurveyController controller = new SurveyController();
SurveyForm model = new SurveyForm()
{
ParkCode = "gnp",
EmailAddress = "*****@*****.**",
State = "test",
ActivityLevel = "test"
};
//Act
mockDal.SubmitSurvey(model);
RedirectToRouteResult result = controller.SurveySubmit(model) as RedirectToRouteResult;
//Assert
Assert.IsNotNull(result);
Assert.AreEqual("Index", result.RouteValues["action"]);
}