public List<AnsClass> GetAnswers(int questionID) { SqlCommand GetAnswersCommand = new SqlCommand("GetAnswers", DefaultConnection); GetAnswersCommand.CommandType = System.Data.CommandType.StoredProcedure; GetAnswersCommand.Parameters.Add("@QuestionID", System.Data.SqlDbType.Int); GetAnswersCommand.Parameters["@QuestionID"].Value = questionID; try { DefaultConnection.Open(); SqlDataReader AnswersReader = GetAnswersCommand.ExecuteReader(); List<AnsClass> AnswersList = new List<AnsClass>(); while (AnswersReader.Read()) { AnsClass answer = new AnsClass(); answer.AnswerID = (int)AnswersReader["AnswerID"]; answer.QuestionID = questionID; answer.Author = AnswersReader["Author"].ToString(); answer.PostedTime = (DateTime)AnswersReader["PostedTime"]; answer.Answer = AnswersReader["Answer"].ToString(); AnswersList.Add(answer); } AnswersReader.Close(); return AnswersList; } catch (Exception e) { throw; } finally { DefaultConnection.Close(); } }
public void InsertAnswer(AnsClass ans) { SqlCommand InsertCommand = new SqlCommand("AddAnswer", DefaultConnection); InsertCommand.CommandType = System.Data.CommandType.StoredProcedure; InsertCommand.Parameters.Add("@QuestionID", System.Data.SqlDbType.Int); InsertCommand.Parameters["@QuestionID"].Value = ans.QuestionID; InsertCommand.Parameters.Add("@Author", System.Data.SqlDbType.NVarChar, 50); InsertCommand.Parameters["@Author"].Value = ans.Author; InsertCommand.Parameters.Add("@PostedTime", System.Data.SqlDbType.DateTime); InsertCommand.Parameters["@PostedTime"].Value = ans.PostedTime; InsertCommand.Parameters.Add("@Answer", System.Data.SqlDbType.Text); InsertCommand.Parameters["@Answer"].Value = ans.Answer; try { DefaultConnection.Open(); InsertCommand.ExecuteNonQuery(); } catch (Exception e) { throw; } finally { DefaultConnection.Close(); } }