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();
}
}
