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