ANTOOZA-BACKEND/Application/Features/Api/Notification/GetUnreadCounts/Handler.cs

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

namespace Application.Features.Api.Notification.GetUnreadCounts;

internal sealed class Handler(IAppDbContext db) : IQueryHandler<Query, Result<Response>>
{
    public async Task<Result<Response>> Handle(Query request, CancellationToken ct)
    {
        var unreadNotif = await db.Notification.AsNoTracking().CountAsync(n => n.MemberID == request.MemberID && !n.IsRead, ct);
        var unreadNote = await db.Note.AsNoTracking().CountAsync(n => n.ReceiverMemberID == request.MemberID && !n.IsDeletedByReceiver && !n.IsRead, ct);

        return Result.Success(new Response(unreadNotif, unreadNote));
    }
}