public CourseModel AddCourse(CourseModel courseModel) { if (GetOneCourseByCode(courseModel.courseCode) == null) { _course.InsertOne(courseModel); } CourseModel tmpCourseModel = GetOneCourseByCode(courseModel.courseCode); return(tmpCourseModel); }
public HttpResponseMessage GetOneCourseByCode(string courseCode) { try { CourseModel courseModel = courseRepository.GetOneCourseByCode(courseCode); return(Request.CreateResponse(HttpStatusCode.OK, courseModel)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public CourseModel UpdateCourse(CourseModel courseModel) { DataTable dt = new DataTable(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(CourseStringsMySql.UpdateCourse(courseModel)); } foreach (DataRow ms in dt.Rows) { courseModel = CourseModel.ToObject(ms); } return(courseModel); }
public List <CourseModel> GetAllCourses() { DataTable dt = new DataTable(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(CourseStringsInner.GetAllCourses()); } List <CourseModel> arrCourse = new List <CourseModel>(); foreach (DataRow ms in dt.Rows) { arrCourse.Add(CourseModel.ToObject(ms)); } return(arrCourse); }
public HttpResponseMessage AddCourse(CourseModel courseModel) { try { HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(courseRepository.AddCourse(courseModel))) }; return(hrm); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); HttpResponseMessage hr = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(errors.ToString()) }; return(hr); } }
public CourseModel GetOneCourseByCode(string courseCode) { DataTable dt = new DataTable(); if (courseCode.Equals(string.Empty) || courseCode.Equals("")) { throw new ArgumentOutOfRangeException(); } CourseModel courseModel = new CourseModel(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(CourseStringsInner.GetOneCourseByCode(courseCode)); } foreach (DataRow ms in dt.Rows) { courseModel = CourseModel.ToObject(ms); } return(courseModel); }
public HttpResponseMessage UpdateCourse(string updateByCourseCode, CourseModel courseModel) { try { courseModel.courseCode = updateByCourseCode; CourseModel updatedCourse = courseRepository.UpdateCourse(courseModel); HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(JsonConvert.SerializeObject(updatedCourse)) }; return(hrm); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); HttpResponseMessage hr = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(errors.ToString()) }; return(hr); } }
public HttpResponseMessage AddCourse(CourseModel courseModel) { try { if (courseModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } CourseModel addedCourse = courseRepository.AddCourse(courseModel); return(Request.CreateResponse(HttpStatusCode.Created, addedCourse)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public CourseModel AddCourse(CourseModel courseModel) { var resultSP = DB.AddCourse(courseModel.courseCode, courseModel.courseName).Select(c => new CourseModel { courseCode = c.courseCode, courseName = c.courseName }); if (GlobalVariable.queryType == 0) { COURS course = new COURS { courseCode = courseModel.courseCode, courseName = courseModel.courseName }; DB.COURSES.Add(course); DB.SaveChanges(); return(GetOneCourseByCode(course.courseCode)); } else { return(resultSP.SingleOrDefault()); } }
public HttpResponseMessage UpdateCourse(string courseCode, CourseModel courseModel) { try { if (courseModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } courseModel.courseCode = courseCode; CourseModel updatedCourse = courseRepository.UpdateCourse(courseModel); return(Request.CreateResponse(HttpStatusCode.OK, updatedCourse)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
static public OleDbCommand UpdateCourse(CourseModel courseModel) { return(CreateOleDbCommand(courseModel, queryCoursesUpdate)); }
static public OleDbCommand AddCourse(CourseModel courseModel) { return(CreateOleDbCommand(courseModel, queryCoursesPost)); }