public void GetSurveyResults_ShouldReturn_1_Survey()
{
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
IList <SurveyResult> results = dao.GetSurveyResults();
Assert.AreEqual(1, results.Count);
}
public void GetSurveyResultsReturnsOneResult()
{
SurveySqlDAO surveyDAO = new SurveySqlDAO(ConnectionString);
IList <SurveyResults> results = surveyDAO.Results();
Assert.AreEqual(1, results.Count);
}
public void GetSurveyTest_ShouldReturnAllSurveys()
{
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
IList <SurveyResult> surveys = dao.Results();
Assert.AreEqual(1, surveys.Count);
}
public ActionResult SurveyResult()
{
ISurveyDAO surveyDAO = new SurveySqlDAO(connectionString);
ViewBag.Parks = parkDAO.GetAllParks();
IList <Survey> posts = surveyDAO.GetAllPosts();
return(View(posts));
}
public void GetSurveys_By_ParkCode_Should_ReturnCorrectNumberOfSurveys(string parkCode, int expectedCount)
{
// Arrange
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
// Act
IList <Survey> surveys = dao.GetSurveys(parkCode);
// Assert
Assert.AreEqual(expectedCount, surveys.Count);
}
public void GetAllSurveysShouldReturnOneSurvey()
{
// Arrange
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
// Act - List of surveys should return 1 survey created in test data setup
IList <SurveyResults> listOfSurveys = dao.GetAllSurveys();
// Assert - should return one survey
Assert.AreEqual(listOfSurveys.Count, 1, "Querying for one survey should return one survey");
}
public ActionResult NewSurvey(Survey newSurvey)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("NewSurvey", newSurvey));
}
else
{
ISurveyDAO surveyDAO = new SurveySqlDAO(connectionString);
surveyDAO.SaveNewPost(newSurvey);
return(RedirectToAction("SurveyResult", new { newSurvey.ParkCode, newSurvey.EmailAddress, newSurvey.State, newSurvey.ActivityLevel }));
}
}
public void SaveSurveyAddsANewSurvey()
{
Survey survey2 = new Survey();
survey2.ActivityLevel = "Sedentary";
survey2.Email = "*****@*****.**";
survey2.ParkCode = "AAAA";
survey2.State = "Ohio";
SurveySqlDAO surveyDAO = new SurveySqlDAO(ConnectionString);
int startingRowCount = GetRowCount("survey_result");
surveyDAO.SaveSurvey(survey2);
int endingRowCount = GetRowCount("survey_result");
Assert.AreNotEqual(startingRowCount, endingRowCount);
}
public void SaveSurvey_Should_Return1Moresurvey()
{
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
int startingRows = GetRowCount("survey_result");
SurveyForm survey = new SurveyForm();
survey.ParkCode = ParkCode;
survey.Email = "*****@*****.**";
survey.State = "OH";
survey.ActivityLevel = "Active";
dao.SaveSurvey(survey);
int endingRows = GetRowCount("survey_result");
Assert.AreEqual(startingRows + 1, endingRows);
}
public void SubmitSurveyShouldReturnTrue()
{
// Arrange
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
// Act - create a new survey
Survey survey = new Survey();
survey.EmailAddress = "*****@*****.**";
survey.ActivityLevel = "active";
survey.ParkCode = "ABC";
survey.State = "VA";
bool actual = dao.SubmitSurvey(survey);
// Assert - sending new survey should return true
Assert.AreEqual(true, actual, "Creating new survey should return true");
}
public void AddSurvey_should_IncreaseCountBy1()
{
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
int initalRowCount = GetRowCount("survey_result");
Survey sur = new Survey()
{
ParkCode = "XYZ",
EmailAddress = "*****@*****.**",
State = "Ohio",
ActivityLevel = "Inactive",
};
dao.CreateSurvey(sur);
int finalRowCount = GetRowCount("survey_result");
Assert.AreEqual(initalRowCount + 1, finalRowCount);
}
public void AddSurvey_Should_IncreaseCountBy1()
{
Survey survey = new Survey();
survey.ParkCode = "FNP";
survey.State = "New Mexico";
survey.EmailAddress = "*****@*****.**";
survey.ActivityLevel = "active";
// Arrange
SurveySqlDAO dao = new SurveySqlDAO(ConnectionString);
int startingRowCount = GetRowCount("survey_result");
// Act
dao.SaveNewSurvey(survey);
int endingRowCount = GetRowCount("survey_result");
//Assert
Assert.AreNotEqual(startingRowCount, endingRowCount);
}
