public List <Survey_Result> GetAllSurveys() { List <Survey_Result> output = new List <Survey_Result>(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetAllSurveys, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Survey_Result sr = new Survey_Result(); sr.Id = Convert.ToInt32(reader["surveyId"]); sr.ParkCode = Convert.ToString(reader["parkCode"]); sr.Email = Convert.ToString(reader["emailAddress"]); sr.State = Convert.ToString(reader["state"]); sr.ActivityLevel = Convert.ToString(reader["activityLevel"]); output.Add(sr); } } return(output); }
public bool AddResult(Survey_Result result) { bool output; try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_AddResult, conn); cmd.Parameters.AddWithValue("@parkCode", result.ParkCode); cmd.Parameters.AddWithValue("@email", result.Email); cmd.Parameters.AddWithValue("@state", result.State); cmd.Parameters.AddWithValue("@activityLevel", result.ActivityLevel); cmd.ExecuteNonQuery(); } output = true; } catch { output = false; } return(output); }
public IActionResult Survey(Survey_Result surveyResult) { surveyResult.State = surveyResult.State.ToUpper(); survey_ResultDAL.AddResult(surveyResult); return(RedirectToAction("SurveyResults")); }