public QuesClass GetQuestion(int questionID)
{
SqlCommand GetQuestionCommand = new SqlCommand("GetQuestion", DefaultConnection);
GetQuestionCommand.CommandType = CommandType.StoredProcedure;
GetQuestionCommand.Parameters.Add("@QuestionID", SqlDbType.Int);
GetQuestionCommand.Parameters["@QuestionID"].Value = questionID;
try
{
DefaultConnection.Open();
SqlDataReader questionReader = GetQuestionCommand.ExecuteReader(CommandBehavior.SingleRow);
questionReader.Read();
QuesClass ques = new QuesClass();
ques.QuestionID = questionID;
ques.Question = questionReader["Question"].ToString();
ques.Author = questionReader["Author"].ToString();
ques.PostedTime = (DateTime)questionReader["PostedTime"];
ques.Views = (int)questionReader["Views"];
questionReader.Close();
return ques;
}
catch (Exception e)
{
throw;
}
finally
{
DefaultConnection.Close();
}
}
public void InsertQuestion(QuesClass ques)
{
SqlCommand InsertCommand = new SqlCommand("AddQuestion", DefaultConnection);
InsertCommand.CommandType = System.Data.CommandType.StoredProcedure;
InsertCommand.Parameters.Add("@Question", System.Data.SqlDbType.Text);
InsertCommand.Parameters["@Question"].Value = ques.Question;
InsertCommand.Parameters.Add("@Author", System.Data.SqlDbType.NVarChar, 50);
InsertCommand.Parameters["@Author"].Value = ques.Author;
InsertCommand.Parameters.Add("@PostedTime", System.Data.SqlDbType.DateTime);
InsertCommand.Parameters["@PostedTime"].Value = ques.PostedTime;
try
{
DefaultConnection.Open();
InsertCommand.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
DefaultConnection.Close();
}
}
