[Intellenum(typeof(string))]
public partial class CustomerType {
    public static readonly CustomerType Basic = new ("Basic");
}

[Intellenum(typeof(string))]
public partial class CustomerType {
    public static readonly CustomerType Basic = new ("Basic");
}

    public async Task<Result<IEnumerable<AuthTokenDTO>>> GetTokensByUser(int idUser, AuthTokenStatus[]? statuses = null, AuthProvider[]? providers = null) {
        statuses ??= [AuthTokenStatus.ACTIVE];
        
        
        Result<IEnumerable<AuthTokenDTO>> tokens =  await Result.Try(() => {
                string query = """
                    SELECT id, idUser, provider, authToken, createdAt, updatedAt, status 
                    FROM crud.auth 
                    WHERE idUser = @idUser
                    AND status IN (@statuses)
                """;
                
                if (providers is { Length: > 0 }) {
                    query += " AND provider IN (@providers)";
                }

                return this._context.GetConnection().QueryAsync<AuthTokenDTO>(query, new {
                    providers,
                    statuses,
                    idUser
                });
            });

        if (tokens.IsFailed) {
            return Result.Fail("Failed to fetch auth tokens").WithErrors(tokens.Errors);
        }

        return tokens;
    }

    public async Task<Result<IEnumerable<AuthTokenDTO>>> GetTokensByUser(int idUser, AuthTokenStatus[]? statuses = null, AuthProvider[]? providers = null) {
        statuses ??= [AuthTokenStatus.ACTIVE];
        
        
        Result<IEnumerable<AuthTokenDTO>> tokens =  await Result.Try(() => {
                string query = """
                    SELECT id, idUser, provider, authToken, createdAt, updatedAt, status 
                    FROM crud.auth 
                    WHERE idUser = @idUser
                    AND status IN (@statuses)
                """;
                
                if (providers is { Length: > 0 }) {
                    query += " AND provider IN (@providers)";
                }

                return this._context.GetConnection().QueryAsync<AuthTokenDTO>(query, new {
                    providers,
                    statuses,
                    idUser
                });
            });

        if (tokens.IsFailed) {
            return Result.Fail("Failed to fetch auth tokens").WithErrors(tokens.Errors);
        }

        return tokens;
    }

public class CardType
    : Enumeration
{
    public static CardType Amex = new(1, nameof(Amex));
    public static CardType Visa = new(2, nameof(Visa));
    public static CardType MasterCard = new(3, nameof(MasterCard));

    public CardType(int id, string name)
        : base(id, name)
    {
    }
}

public class CardType
    : Enumeration
{
    public static CardType Amex = new(1, nameof(Amex));
    public static CardType Visa = new(2, nameof(Visa));
    public static CardType MasterCard = new(3, nameof(MasterCard));

    public CardType(int id, string name)
        : base(id, name)
    {
    }
}

public abstract class Enumeration : IComparable
{
    public string Name { get; private set; }

    public int Id { get; private set; }

    protected Enumeration(int id, string name) => (Id, Name) = (id, name);

    public override string ToString() => Name;

    public static IEnumerable<T> GetAll<T>() where T : Enumeration =>
        typeof(T).GetFields(BindingFlags.Public |
                            BindingFlags.Static |
                            BindingFlags.DeclaredOnly)
                 .Select(f => f.GetValue(null))
                 .Cast<T>();

    public override bool Equals(object obj)
    {
        if (obj is not Enumeration otherValue)
        {
            return false;
        }

        var typeMatches = GetType().Equals(obj.GetType());
        var valueMatches = Id.Equals(otherValue.Id);

        return typeMatches && valueMatches;
    }

    public int CompareTo(object other) => Id.CompareTo(((Enumeration)other).Id);

    // Other utility methods ...
}

public abstract class Enumeration : IComparable
{
    public string Name { get; private set; }

    public int Id { get; private set; }

    protected Enumeration(int id, string name) => (Id, Name) = (id, name);

    public override string ToString() => Name;

    public static IEnumerable<T> GetAll<T>() where T : Enumeration =>
        typeof(T).GetFields(BindingFlags.Public |
                            BindingFlags.Static |
                            BindingFlags.DeclaredOnly)
                 .Select(f => f.GetValue(null))
                 .Cast<T>();

    public override bool Equals(object obj)
    {
        if (obj is not Enumeration otherValue)
        {
            return false;
        }

        var typeMatches = GetType().Equals(obj.GetType());
        var valueMatches = Id.Equals(otherValue.Id);

        return typeMatches && valueMatches;
    }

    public int CompareTo(object other) => Id.CompareTo(((Enumeration)other).Id);

    // Other utility methods ...
}