public List <QuestionABC> GetAllQuestionsBySubThemeName(string subThemeName) { List <QuestionABC> questions = new List <QuestionABC>(); QuestionABC quest = new QuestionABC(); AnswerDAL aDAL = new AnswerDAL(); base.OpenConnection(); SqlCommand command = new SqlCommand(string.Format("Select * from Questions inner join Sub_Themes on Questions.ID_SubTheme = Sub_Themes.ID where Sub_Themes.Sub_Theme like '" + "{0}" + "'", subThemeName), base._sqlConnection); SqlDataReader reader = command.ExecuteReader(); using (reader) { while (reader.Read()) { quest.Id = (int)reader["ID"]; quest.QuestionCurrent = (string)reader["Question"]; quest.SubThemeId = (int)reader["ID_SubTheme"]; quest.ListAnswers = aDAL.GetAllAnswersByQuestion(quest.QuestionCurrent); questions.Add(quest); quest = new QuestionABC(); } } base.CloseConnection(); return(questions); }
public void InsertQuestionViaStoredProc(QuestionABC quest) { base.OpenConnection(); SqlCommand cmd = new SqlCommand("InsertIntoQuestions", base._sqlConnection); using (cmd) { cmd.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter(); param.ParameterName = "@Question"; param.SqlDbType = SqlDbType.VarChar; param.Size = 200; param.Value = quest.QuestionCurrent; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Id_Sub_Theme"; param.SqlDbType = SqlDbType.Int; param.Value = quest.SubThemeId; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); } base.CloseConnection(); }
public string GetSubThemeByQuestion(QuestionABC quest) { string subTheme = ""; base.OpenConnection(); SqlCommand command = new SqlCommand(string.Format("Select Sub_Themes.Sub_Theme from Sub_Themes inner join Questions on Sub_Themes.ID = Questions.ID_SubTheme where Questions.Question like '" + "{0}" + "'", quest.QuestionCurrent), base._sqlConnection); SqlDataReader reader = command.ExecuteReader(); using (reader) { while (reader.Read()) { subTheme = (string)reader["Sub_Theme"]; } } base.CloseConnection(); return(subTheme); }