public bool AddSurvey(AdacitySurvey surveyData) { var result = false; if (surveyData != null) { result = AddSurveyToDB(surveyData); } return result; }
private bool AddSurveyToDB(AdacitySurvey surveyData) { var result = true; using (SqlConnection conn = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "[adacitySurvey].[SaveSurvey]"; cmd.Parameters.AddWithValue("@AgeGroup", surveyData.AgeGroup); cmd.Parameters.AddWithValue("@Employment", surveyData.Employment); cmd.Parameters.AddWithValue("@Option", surveyData.Option); cmd.Parameters.AddWithValue("@EntertainmentCategory", surveyData.EntertainmentCategory); try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { result = false; throw; } finally { conn.Close(); conn.Dispose(); } return result; } }