public HttpResponseMessage createNewExam(HttpRequestMessage req, eExam _exam) { return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; if (!ModelState.IsValid) { res = req.CreateResponse(HttpStatusCode.BadRequest, ModelState); } else { bool insertResult = aExamAccess.createNewExam(_exam); res = req.CreateResponse(HttpStatusCode.Created, insertResult); } return res; })); }
public static bool createNewExam(eExam _exam) { string spName = "SP_T_EXAM_INSERT"; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@pExamName", _exam.EXAM_NAME); param[1] = new SqlParameter("@pExamCodeValue", _exam.EXAM_CODE_VALUE); param[2] = new SqlParameter("@pExamDesc", _exam.EXAM_DESC); DataTable dtResult = DBHelper.getDataTable_SP(spName, param); bool result = false; if (dtResult.Rows[0][0].ToString() == "OK") { result = true; } return(result); }
public static List <eExam> getAllExam() { string spName = "SP_T_EXAM_GET_ALL"; SqlParameter[] param = new SqlParameter[1]; DataTable result = DBHelper.getDataTable_SP(spName, null); List <eExam> lstResult = new List <eExam>(); foreach (DataRow row in result.Rows) { eExam item = new eExam(); item.EXAM_NAME = row["EXAM_NAME"].ToString(); item.EXAM_CODE = row["EXAM_CODE"].ToString(); item.EXAM_CODE_VALUE = row["EXAM_CODE_VALUE"].ToString(); item.EXAM_DESC = row["EXAM_DESC"].ToString(); lstResult.Add(item); } return(lstResult); }