❔ Querying Department Names using DepartmentID from User Queries

public class GetUserByStatus
{
    public class GetUserByStatusQuery : IRequest<IEnumerable<GetUserByStatusResult>>
    {
        public bool IsActive { get; set; }
    }

    public class GetUserByStatusResult
    {
        public int Id { get; set; }
        public string FullName { get; set; }
        public string UserName { get; set; }
        public string Password { get; set; }
        public bool IsActive { get; set; }
        public string DepartmentName { get; set; }
        public string DateAdded { get; set; }
        public string AddedBy { get; set; }
        public string ModifiedBy { get; set; }
        public string Reason { get; set; }
    }

    public class Handler : IRequestHandler<GetUserByStatusQuery, IEnumerable<GetUserByStatusResult>>
    {
        private readonly IServiceManager _serviceManager;
        private readonly IMapper _mapper;

        public Handler(IServiceManager serviceManager, IMapper mapper)
        {
            _serviceManager = serviceManager;
            _mapper = mapper;
        }

        public async Task<IEnumerable<GetUserByStatusResult>> Handle(GetUserByStatusQuery request,
            CancellationToken cancellationToken)
        {
            var user = await _serviceManager.User.GetUserByStatus(request.IsActive);
            if (user == null)
                throw new NoUserFoundException();

            var result = _mapper.Map<IEnumerable<GetUserByStatusResult>>(user);
            return result;
        }
    }
}