public PaginationResult <Muscle> Search(SearchMuscleRequest request) { return(_repoService.Search <Muscle>(request, "Muscle", "Title", (sb, parameters) => { sb.AppendNotNull(request.Title, " Title LIKE CONCAT('%',@Title,'%') OR OtherTitle LIKE CONCAT('%',@Title,'%') ", parameters, nameof(request.Title), request.Title) .AppendNotNull(request.ExerciseId, " EXISTS(select * from [ExerciseMuscle] em where em.MuscleId = e.Id AND em.ExerciseId = @ExerciseId)", parameters, nameof(request.ExerciseId), request.ExerciseId) .AppendNotNull(request.Areas, " e.Area in {@Areas}", parameters, nameof(request.Areas), request.Areas); })); }
public PaginationResult <Muscle> Post([FromBody] SearchMuscleRequest request) { return(_muscleServise.Search(request)); }