using Indotalent.Infrastructure.Database;
using MediatR;
using Microsoft.EntityFrameworkCore;

namespace Indotalent.Features.Inventory.NegativeAdjustment.Cqrs;

public record DeleteNegativeAdjustmentByIdCommand(string Id) : IRequest<bool>;

public class DeleteNegativeAdjustmentByIdHandler : IRequestHandler<DeleteNegativeAdjustmentByIdCommand, bool>
{
    private readonly AppDbContext _context;
    public DeleteNegativeAdjustmentByIdHandler(AppDbContext context) => _context = context;

    public async Task<bool> Handle(DeleteNegativeAdjustmentByIdCommand request, CancellationToken cancellationToken)
    {
        var entity = await _context.NegativeAdjustment
            .FirstOrDefaultAsync(x => x.Id == request.Id, cancellationToken);

        if (entity == null) return false;

        var items = await _context.InventoryTransaction
            .Where(x => x.ModuleId == request.Id && x.ModuleName == nameof(Data.Entities.NegativeAdjustment))
            .ToListAsync(cancellationToken);

        _context.InventoryTransaction.RemoveRange(items);
        _context.NegativeAdjustment.Remove(entity);
        await _context.SaveChangesAsync(cancellationToken);
        return true;
    }
}