public Response GetAllCourses(GetAllCoursesRequest request)
{
List <string> coursesList = new List <string>();
try
{
var dataSet = _dal.GetAllCourses(request);
var table = dataSet.Tables[0];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
string temp = table.Rows[i]["Course"].ToString();
coursesList.Add(temp);
}
GetAllCoursesResponse ret = new GetAllCoursesResponseOk
{
Courses = coursesList.ToArray()
};
return(ret);
}
catch (Exception ex)
{
return(new AppResponseError(ex.Message));
}
}
public DataSet GetAllCourses(GetAllCoursesRequest request)
{
var cmd = new MySqlCommand
{
Connection = _conn,
CommandText = "getAllCourses"
};
return(_infraDal.ExecSpQuery(cmd));
}
// GET: /Courses/
public GetAllCoursesResponse GetAll(GetAllCoursesRequest getAllCoursesRequest)
{
var courses = _unitOfWork.CourseRepository.GetAll(getAllCoursesRequest.SearchString);
if (courses == null)
{
return(new GetAllCoursesResponse()
{
IsSuccess = false,
});
}
else
{
return(new GetAllCoursesResponse()
{
CourseViews = _mapper.Map <List <CourseView> >(courses.ToList()),
IsSuccess = true,
});
}
}
public Response GetAllCourses([FromBody] GetAllCoursesRequest request)
{
var ret = _service.GetAllCourses(request);
return(ret);
}
