GuildMemberRepository.cs

using BaseBotService.Data.Interfaces;
using BaseBotService.Data.Models;
using LiteDB;

namespace BaseBotService.Data.Repositories;

public class GuildMemberRepository : IGuildMemberRepository
{
    private readonly ILiteCollection<GuildMemberHC> _guildMembers;

    public GuildMemberRepository(ILiteCollection<GuildMemberHC> guildMembers) => _guildMembers = guildMembers;

    public GuildMemberHC GetUser(ulong guildId, ulong userId)
        => _guildMembers
            .FindOne(a => a.GuildId == guildId && a.MemberId == userId);

    public void AddUser(GuildMemberHC user) => _guildMembers.Insert(user);

    public bool UpdateUser(GuildMemberHC user)
    => _guildMembers.Update(user);

    public bool DeleteUser(ulong guildId, ulong userId)
    {
        var user = GetUser(guildId, userId);
        if (user != null)
        {
            return _guildMembers.Delete(user.Id);
        }
        return false;
    }

    public int DeleteGuild(ulong guildId)
    {
        var users = _guildMembers.Find(a => a.GuildId == guildId);
        if (users != null)
        {
            return _guildMembers.DeleteMany(a => a.GuildId == guildId);
        }
        return 0;
    }

    public IEnumerable<GuildMemberHC> GetTopUsers(ulong guildId, int limit)
        => _guildMembers
            .Find(a => a.GuildId == guildId)
            .OrderByDescending(u => u.ActivityPoints)
            .Take(limit);
}