using FreeSql;
using F9WebAiTest.Domain.Entities.SYS.Departments;
using F9WebAiTest.Domain.Interfaces.SYS.Departments;

namespace F9WebAiTest.Infrastructure.FreeSqls.Repositories.SYS.Departments;

internal class DepartmentUserRepository : F9RepositoryBase, IDepartmentUserRepository
{
    public DepartmentUserRepository(IFreeSql fsql) : base(fsql) { }

    public async Task<bool> AssignAsync(DepartmentUser depUser)
    {
        depUser.CreatedAt = DateTime.Now;
        return await Orm.Insert(depUser).ExecuteAffrowsAsync() > 0;
    }

    public async Task<bool> RemoveAsync(long depId, long userId)
        => await Orm.Delete<DepartmentUser>()
            .Where(x => x.DepartmentId == depId && x.UserId == userId)
            .ExecuteAffrowsAsync() > 0;
}