public HttpResponseMessage updateSemester(HttpRequestMessage req, eSemester semester) { DateTime mDate = DateTime.ParseExact(semester.OPENING_DATE, "dd/MM/yyyy", null); semester.OPENING_DATE = mDate.ToString("yyyyMMdd"); mDate = DateTime.ParseExact(semester.REGISTER_FROM, "dd/MM/yyyy", null); semester.REGISTER_FROM = mDate.ToString("yyyyMMdd"); mDate = DateTime.ParseExact(semester.REGISTER_TO, "dd/MM/yyyy", null); semester.REGISTER_TO = mDate.ToString("yyyyMMdd"); return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; if (!ModelState.IsValid) { res = req.CreateResponse(HttpStatusCode.BadRequest, ModelState); return res; } DataTable dtResult = aSemesterAccess.updateSemester(semester); eResult insertResult = new eResult { dbResult = dtResult.Rows[0][0].ToString(), dbMessage = dtResult.Rows[0][1].ToString() }; res = req.CreateResponse(HttpStatusCode.Created, insertResult); return res; })); }
public HttpResponseMessage getDetailSemester(HttpRequestMessage req) { return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; DataTable dtResult = aSemesterAccess.semesterQuery(); List <eSemester> lsResult = new List <eSemester>(); for (int i = 0; i < dtResult.Rows.Count; i++) { eSemester eResult = new eSemester { SMT_ID = dtResult.Rows[i]["SMT_ID"].ToString(), SMT_NAME = dtResult.Rows[i]["SMT_NAME"].ToString(), OPENING_DATE = dtResult.Rows[i]["OPENING_DATE"].ToString(), REGISTER_FROM = dtResult.Rows[i]["REGISTER_FROM"].ToString(), REGISTER_TO = dtResult.Rows[i]["REGISTER_TO"].ToString(), SMT_DESC = dtResult.Rows[i]["SMT_DESC"].ToString(), REMARK = dtResult.Rows[i]["REMARK"].ToString() }; lsResult.Add(eResult); } res = req.CreateResponse(HttpStatusCode.OK, lsResult); return res; })); }
public static DataTable insertNew(eSemester semester) { string spName = "SP_T_SEMESTER_INSERT"; SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@PNAME", semester.SMT_NAME); param[1] = new SqlParameter("@POPENDATE", semester.OPENING_DATE); param[2] = new SqlParameter("@PREGFROM", semester.REGISTER_FROM); param[3] = new SqlParameter("@PREGTO", semester.REGISTER_TO); param[4] = new SqlParameter("@PDESC", semester.SMT_DESC); param[5] = new SqlParameter("@PREMARK", semester.REMARK); DataTable dtResult = DBHelper.getDataTable_SP(spName, param); return(dtResult); }
public HttpResponseMessage getDetailSemester(HttpRequestMessage req, string semesterCode) { return(CreateHttpResponse(req, () => { HttpResponseMessage res = null; DataTable dtResult = aSemesterAccess.getDetailTest(); eSemester eResult = new eSemester { SMT_ID = dtResult.Rows[0]["SMT_ID"].ToString(), SMT_NAME = dtResult.Rows[0]["SMT_NAME"].ToString(), OPENING_DATE = dtResult.Rows[0]["OPENING_DATE"].ToString(), REGISTER_FROM = dtResult.Rows[0]["REGISTER_FROM"].ToString(), REGISTER_TO = dtResult.Rows[0]["REGISTER_TO"].ToString(), SMT_DESC = dtResult.Rows[0]["SMT_DESC"].ToString(), REMARK = dtResult.Rows[0]["REMARK"].ToString() }; res = req.CreateResponse(HttpStatusCode.OK, eResult); return res; })); }