public void GetAllCommentsByCourse()
{
var request = new CourseCommentsRequest
{
CourseId = 1,
};
var res = service.GetCommentsByCourse(request);
Xunit.Assert.True(res.CommentDetails.Count > 0);
}
public HttpResponseMessage GetComments([FromBody] CourseCommentsRequest request)
{
var response = _service.FetchCommentsByCourse(request);
if (response.CommentDetails != null)
{
return(Request.CreateResponse <CourseCommentsResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No Comments found"));
}
}
public CourseCommentsResponse GetCommentsByCourse(CourseCommentsRequest request)
{
string sql = @"Select us.fullname,en.comment From enrolls as en
inner join users as us
on en.userId = us.id
WHERE en.CourseId = @CourseId";
var parameters = new { request.CourseId };
using (var con = GetSqlConnection())
{
var response = con.Query <CommentDetails>(sql, parameters).ToList();
return(new CourseCommentsResponse
{
CommentDetails = response
});
}
}
public CourseCommentsResponse FetchCommentsByCourse(CourseCommentsRequest request)
{
_validation.NotValidId(request.CourseId, $"{nameof(request.CourseId)}");
return(_dbService.GetCommentsByCourse(request));
}
