public static bool inserNewQuestion(eQuestionDetail _question) { string spName = "SP_T_QUESTION_DETAIL_INSERT"; SqlParameter[] param = new SqlParameter[10]; param[0] = new SqlParameter("@pPart", _question.PART); param[1] = new SqlParameter("@pExamCode", _question.EXAM_CODE); param[2] = new SqlParameter("@pClassify", _question.CLASSIFY); param[3] = new SqlParameter("@pIdxInExam", _question.IDX_IN_EXAM); param[4] = new SqlParameter("@pQuestionContent", _question.QUESTION_CONTENT); param[5] = new SqlParameter("@pAnswerA", _question.ANSWER_A); param[6] = new SqlParameter("@pAnswerB", _question.ANSWER_B); param[7] = new SqlParameter("@pAnswerC", _question.ANSWER_C); param[8] = new SqlParameter("@pAnswerD", _question.ANSWER_D); param[9] = new SqlParameter("@pCorrectAnswer", _question.CORRECT_ANSWER); DataTable dtResult = DBHelper.getDataTable_SP(spName, param); bool result = false; if (dtResult.Rows[0][0].ToString() == "OK") { result = true; } return(result); }
public HttpResponseMessage getQuestionDetail(HttpRequestMessage req, string questionCode) { return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; eQuestionDetail eResult = aQuestionAccess.getQuestionDetail(questionCode); res = req.CreateResponse(HttpStatusCode.OK, eResult); return res; })); }
public HttpResponseMessage insertNewQuestion(HttpRequestMessage req, eQuestionDetail question) { return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; if (!ModelState.IsValid) { res = req.CreateResponse(HttpStatusCode.BadRequest, ModelState); } else { bool insertResult = aQuestionAccess.inserNewQuestion(question); res = req.CreateResponse(HttpStatusCode.Created, insertResult); } return res; })); }
public static eQuestionDetail getQuestionDetail(string questionCode) { string spName = "SP_T_QUESTION_GET_DETAIL"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@pQuestionCode", questionCode); DataSet result = DBHelper.getDataSet_SP(spName, param); DataTable dtQuestion = result.Tables[0]; DataTable dtAnswer = result.Tables[1]; eQuestionDetail eResult = new eQuestionDetail(); if (dtQuestion.Rows.Count > 0) { int PART = 0; int.TryParse(dtQuestion.Rows[0]["PART"].ToString(), out PART); eResult.PART = PART; eResult.EXAM_CODE = dtQuestion.Rows[0]["EXAM_CODE"].ToString(); eResult.CLASSIFY = dtQuestion.Rows[0]["CLASSIFY"].ToString(); int.TryParse(dtQuestion.Rows[0]["IDX_IN_EXAM"].ToString(), out PART); eResult.IDX_IN_EXAM = PART; eResult.QUESTION_CODE = dtQuestion.Rows[0]["QUESTION_CODE"].ToString(); eResult.QUESTION_CONTENT = dtQuestion.Rows[0]["QUESTION_CONTENT"].ToString(); eResult.CORRECT_ANSWER = dtQuestion.Rows[0]["CORRECT_ANSWER"].ToString(); } if (dtAnswer.Rows.Count > 0) { eResult.ANSWER_A = dtAnswer.Rows[0]["ANSWER_CONTENT"].ToString(); } if (dtAnswer.Rows.Count > 1) { eResult.ANSWER_B = dtAnswer.Rows[1]["ANSWER_CONTENT"].ToString(); } if (dtAnswer.Rows.Count > 2) { eResult.ANSWER_C = dtAnswer.Rows[2]["ANSWER_CONTENT"].ToString(); } if (dtAnswer.Rows.Count > 3) { eResult.ANSWER_D = dtAnswer.Rows[3]["ANSWER_CONTENT"].ToString(); } return(eResult); }