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));
}
