public void InsertSurveyTest() { //Arrange SurveyResultDAL surveyDAL = new SurveyResultDAL(connectionString); bool isAdded; //Act isAdded = surveyDAL.InsertSurvey(survey); //Assert Assert.IsTrue(isAdded); //TEST: Expected to return False when null values are passed in //Arrange SurveyResult surveyNull = new SurveyResult(); surveyNull.parkCode = "ABC"; surveyNull.emailAddress = "*****@*****.**"; surveyNull.state = "VA"; surveyNull.activityLevel = null; bool isAdded2; //Act isAdded2 = surveyDAL.InsertSurvey(surveyNull); //Assert Assert.IsFalse(isAdded2); }
public ActionResult SaveSurvey(SurveyResult survey) { if (!ModelState.IsValid) { return(View("Index", survey)); } dao.InsertSurvey(survey); return(RedirectToAction("FavoriteParks")); }
public void GetSurveyResultsTest() { //Arrange SurveyResultDAL surveyDAL = new SurveyResultDAL(connectionString); List <SurveyResult> surveys = new List <SurveyResult>(); //Act surveyDAL.InsertSurvey(survey); //Obtain surveyId and store it //try //{ // using (SqlConnection connect = new SqlConnection(connectionString)) // { // connect.Open(); // SqlCommand cmd; // cmd = new SqlCommand("Select @@identity;", connect); // surveyIdCode = Convert.ToInt32(cmd.ExecuteScalar()); // } //} //catch (Exception) //{ // throw; //} //survey.surveyId = surveyIdCode; surveys = surveyDAL.GetSurveyResults(); //Assert //Ensures correct email is returned. /* * bool containsCorrectEmail = false; * foreach (SurveyResult survey in surveys) * { * if (survey.emailAddress == "*****@*****.**") * { * containsCorrectEmail = true; * } * } * Assert.IsTrue(containsCorrectEmail); * * //Assert * //Ensures correct parkCode is returned. * bool containsCorrectParkCode = false; * foreach (SurveyResult survey in surveys) * { * if (survey.parkCode == "ABC") * { * containsCorrectParkCode = true; * } * } * Assert.IsTrue(containsCorrectParkCode); * * //Assert * //Ensures correct state is returned. * bool containsCorrectState = false; * foreach (SurveyResult survey in surveys) * { * if (survey.state == "PA") * { * containsCorrectState = true; * * } * } * Assert.IsTrue(containsCorrectState); */ //Assert //Ensures correct activity level is returned. bool containsCorrectActivityLevel = false; foreach (SurveyResult survey in surveys) { if (survey.activityLevel == "High") { containsCorrectActivityLevel = true; } } Assert.IsTrue(containsCorrectActivityLevel); }