ANTOOZA-BACKEND/Application/Features/Admin/Faq/Item/Get/Handler.cs

using Application.Abstractions.Messaging;
using Application.Abstractions.Data;
using Microsoft.EntityFrameworkCore;

namespace Application.Features.Admin.Faq.Item.Get;

public sealed class Handler(IAppDbContext db) : IQueryHandler<Query, Response?>
{
    public async Task<Response?> Handle(Query request, CancellationToken ct)
    {
        var item = await db.FaqItem
            .AsNoTracking()
            .Include(i => i.FaqCategory)
            .Where(i => i.ID == request.ID)
            .Select(i => new
            {
                i.ID,
                i.CategoryID,
                CategoryCode = i.FaqCategory.Code,
                CategorySubject = i.FaqCategory.Subject,
                i.Question,
                i.Answer,
                i.Order,
                i.IsActive,
                i.UpdatedAt,
                i.CreatedAt
            })
            .FirstOrDefaultAsync(ct);

        if (item is null)
        {
            return null;
        }

        return new Response(
            item.ID,
            item.CategoryID,
            item.CategoryCode,
            item.CategorySubject,
            item.Question,
            item.Answer,
            item.Order,
            item.IsActive,
            item.UpdatedAt,
            item.CreatedAt
        );
    }
}