public GetEnrollsByUserResponse GetEnrollsByStudent(GetEnrollsByUserRequest request)
{
string sqlcourse = @"select cr.id,cr.title,cr.description,cr.rating,cr.price,fr.name as frameworkName,cat.name as categoryName,ins.fullname as instructorName
from users as us
inner join enrolls as en
on us.id = en.userId
inner join course as cr
on en.courseId = cr.id
inner join category as cat
on cr.categoryId = cat.categoryId
inner join framework as fr
on cr.frameworkId = fr.frameworkId
inner join instructor as ins
on cr.instructorId = ins.id
where us.id =@id";
string sqlUser = @"select * from users where id=@id";
var parameters = new { id = request.UserId };
using (var con = GetSqlConnection())
{
var courses = con.Query <CourseResponse>(sqlcourse, parameters);//course or courseresponse????
var user = con.Query <Users>(sqlUser, parameters).FirstOrDefault();
return(new GetEnrollsByUserResponse
{
User = user,
Courses = courses.ToList()
});
}
}
public void GetCoursesByUser()
{
var request = new GetEnrollsByUserRequest
{
UserId = 1,
};
var res = service.GetEnrollsByStudent(request);
Xunit.Assert.NotNull(res.User);
Xunit.Assert.NotNull(res.Courses);
}
public HttpResponseMessage GetCoursesByUser([FromBody] GetEnrollsByUserRequest request)
{
var response = _service.FetchEnrollsByStudent(request);
if (response.Courses != null && response.User != null)
{
return(Request.CreateResponse <GetEnrollsByUserResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Something went wrong..."));
}
}
public GetEnrollsByUserResponse FetchEnrollsByStudent(GetEnrollsByUserRequest request)
{
_validation.NotValidId(request.UserId, $"{nameof(request.UserId)}");
return(_dbService.GetEnrollsByStudent(request));
}
