public ActionResult SurveyCount()
{
var model = new SurveyPost();
//model.Count = _dal.GetSurveyCount();
return(View("SurveyCount", model));
}
public bool AddSurvey(SurveyPost surveypost)
{
surveypost.SurveyId = MaxId + 1;
surveyPosts.Add(surveypost);
if (surveyPosts.Count == surveypost.SurveyId)
{
return(true);
}
return(false);
}
public IActionResult AddSurveyPost(SurveyPost newSurvey)
{
if (ModelState.IsValid)
{
surveyDAL.SaveSurveyPost(newSurvey);
return(RedirectToAction("Index", "Survey", new { ParkCode = newSurvey.ParkCode, EmailAddress = newSurvey.EmailAddress, State = newSurvey.State, ActivityLevel = newSurvey.ActivityLevel }));
}
else
{
return(View(newSurvey));
}
}
public void TestAddSurvey()
{
// Arrange
SurveyMockDAO surveyDAO = new SurveyMockDAO();
ParkMockDAO parkDAO = new ParkMockDAO();
SurveyController controller = new SurveyController(surveyDAO, parkDAO);
// Act
SurveyPost survey = new SurveyPost();
bool result = surveyDAO.AddSurvey(survey);
// Assert
Assert.IsTrue(result);
}
private SurveyPost AssignSurvey(SqlDataReader reader)
{
var survey = new SurveyPost();
try
{
survey.ParkCode = reader["parkCode"].ToString();
survey.EMail = reader["emailAddress"].ToString();
survey.StateOfResidence = reader["state"].ToString();
survey.PhysicalActivity = (reader["activityLevel"].ToString());
}
catch (Exception) { }
return(survey);
}
public bool PostSurvey(SurveyPost survey)
{
bool IsSuccessful = false;
const string getSurveySql = @"Insert into survey_result(parkCode, emailAddress, state, activityLevel) Values(@parkCode, @email, @state, @activity)";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(getSurveySql, conn);
cmd.Parameters.AddWithValue("@parkCode", survey.ParkCode);
cmd.Parameters.AddWithValue("@email", survey.EMail);
cmd.Parameters.AddWithValue("@state", survey.StateOfResidence);
cmd.Parameters.AddWithValue("@activity", survey.PhysicalActivity);
IsSuccessful = (cmd.ExecuteNonQuery() > 0);
}
return(IsSuccessful);
}
public IActionResult AddSurveyPost()
{
var getParks = parkDAL.GetParks();
IList <Park> parkList = new List <Park>();
foreach (Park park in getParks)
{
parkList.Add(park);
}
SurveyPost surveyPost = new SurveyPost(); // Get all Parks using park Dal ... Turn the List of Parks into a list of select list items ... Take the list of select list items and set a list of parks in the model
List <SelectListItem> natParks = new List <SelectListItem>();
foreach (Park park in parkList)
{
surveyPost.SurveyParks.Add(new SelectListItem()
{
Text = park.ParkName, Value = park.ParkCode
});
}
return(View(surveyPost));
}
public void SaveSurveyPost(SurveyPost surveyPost)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Insert Into survey_result Values (@parkCode, @emailAddress, @state, @activityLevel)", conn);
cmd.Parameters.AddWithValue("@parkCode", surveyPost.ParkCode);
cmd.Parameters.AddWithValue("@emailAddress", surveyPost.EmailAddress);
cmd.Parameters.AddWithValue("@state", surveyPost.State);
cmd.Parameters.AddWithValue("@activityLevel", surveyPost.ActivityLevel);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw ex;
}
}
public bool AddSurvey(SurveyPost surveypost)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO survey_result (parkCode, emailAddress, state, activityLevel) VALUES (@parkCode, @emailAddress, @state, @activityLevel)", connection);
command.Parameters.AddWithValue("@parkCode", surveypost.ParkCode);
command.Parameters.AddWithValue("@emailAddress", surveypost.EmailAddress);
command.Parameters.AddWithValue("@state", surveypost.State);
command.Parameters.AddWithValue("@activityLevel", surveypost.ActivityLevel);
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult PostSurvey(SurveyPost sur)
{
_dal.PostSurvey(sur);
return(RedirectToAction("Surveys"));
}
