public void AddSurvey(ParkSurveyVM parkSurveyVM)
{
try
{
// Create a new connection object
using (SqlConnection conn = new SqlConnection(connectionString))
{
// Open the connection
conn.Open();
string sql = @"INSERT survey_result (parkCode, emailAddress, State, activityLevel)
VALUES (@parkCode, @emailAddress, @state, @activityLevel)";
SqlCommand cmd = new SqlCommand(sql, conn);
// Execute the command
cmd.Parameters.AddWithValue("@parkCode", parkSurveyVM.ParkCode);
cmd.Parameters.AddWithValue("@emailAddress", parkSurveyVM.EmailAddress);
cmd.Parameters.AddWithValue("@state", parkSurveyVM.State);
cmd.Parameters.AddWithValue("@activityLevel", parkSurveyVM.ActivityLevel);
cmd.ExecuteNonQuery();
}
}
catch (SqlException)
{
throw;
}
return;
}
public IActionResult Index()
{
ParkSurveyVM vm = new ParkSurveyVM();
vm.survey = new Survey();
vm.parks = parksDAO.GetAllParks();
return(View(vm));
}
public IActionResult Index(ParkSurveyVM vm)
{
//parksDAO.GetPark(vm.ParkCode);
if (!ModelState.IsValid)
{
vm.parks = parksDAO.GetAllParks();
return(View(vm));
}
surveyResultDAO.AddSurvey(vm);
return(RedirectToAction("GetSurveyResults"));
}
