PositionRepositoryAsyncTests.cs

namespace TalentManagementAPI.Infrastructure.Tests.Repositories
{
    public class PositionRepositoryAsyncTests : IDisposable
    {
        private readonly ApplicationDbContext _context;
        private readonly PositionRepositoryAsync _repository;

        public PositionRepositoryAsyncTests()
        {
            var options = new DbContextOptionsBuilder<ApplicationDbContext>()
                .UseInMemoryDatabase(Guid.NewGuid().ToString())
                .Options;

            var dateTime = new DateTimeService();
            var loggerFactory = LoggerFactory.Create(builder => { });
            _context = new ApplicationDbContext(options, dateTime, loggerFactory);
            _context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.TrackAll;

            var dataShaper = new DataShapeHelper<Position>();
            var mockService = new Mock<IMockService>();

            _repository = new PositionRepositoryAsync(_context, dataShaper, mockService.Object);
        }

        [Fact]
        public async Task IsUniquePositionNumberAsync_ShouldDetectExistingNumber()
        {
            var position = new Position
            {
                Id = Guid.NewGuid(),
                PositionNumber = "ENG-01",
                PositionTitle = new PositionTitle("Engineer"),
                PositionDescription = "Builds things",
                DepartmentId = Guid.NewGuid(),
                SalaryRangeId = Guid.NewGuid()
            };

            _context.Positions.Add(position);
            await _context.SaveChangesAsync();

            (await _repository.IsUniquePositionNumberAsync("ENG-99")).Should().BeTrue();
            (await _repository.IsUniquePositionNumberAsync("ENG-01")).Should().BeFalse();
        }

        [Fact]
        public async Task GetPositionReponseAsync_ShouldShapeDataAndReturnRecordCounts()
        {
            _context.Positions.Add(new Position
            {
                Id = Guid.NewGuid(),
                PositionNumber = "QA-01",
                PositionTitle = new PositionTitle("QA Engineer"),
                PositionDescription = "Tests things",
                DepartmentId = Guid.NewGuid(),
                SalaryRangeId = Guid.NewGuid(),
                Department = new Department { Id = Guid.NewGuid(), Name = new DepartmentName("Engineering") },
                SalaryRange = new SalaryRange { Id = Guid.NewGuid(), MinSalary = 1, MaxSalary = 2 }
            });
            await _context.SaveChangesAsync();

            var query = new GetPositionsQuery
            {
                Fields = "Id,PositionTitle",
                PageNumber = 1,
                PageSize = 10
            };

            var (data, count) = await _repository.GetPositionReponseAsync(query);

            data.Should().HaveCount(1);
            data.First()["PositionTitle"].Should().BeOfType<PositionTitle>().Which.Value.Should().Be("QA Engineer");
            count.Should().BeEquivalentTo(new RecordsCount { RecordsFiltered = 1, RecordsTotal = 1 });
        }

        [Fact]
        public async Task UpdateAsync_ShouldPersistChanges()
        {
            var position = new Position
            {
                Id = Guid.NewGuid(),
                PositionNumber = "ENG-02",
                PositionTitle = new PositionTitle("Engineer"),
                PositionDescription = "Builds",
                DepartmentId = Guid.NewGuid(),
                SalaryRangeId = Guid.NewGuid()
            };
            _context.Positions.Add(position);
            await _context.SaveChangesAsync();

            position.PositionTitle = new PositionTitle("Senior Engineer");
            await _repository.UpdateAsync(position);

            var updated = await _context.Positions.FindAsync(position.Id);
            updated!.PositionTitle.Value.Should().Be("Senior Engineer");
        }

        [Fact]
        public async Task DeleteAsync_ShouldRemoveEntity()
        {
            var position = new Position
            {
                Id = Guid.NewGuid(),
                PositionNumber = "ENG-03",
                PositionTitle = new PositionTitle("Engineer"),
                PositionDescription = "Builds",
                DepartmentId = Guid.NewGuid(),
                SalaryRangeId = Guid.NewGuid()
            };
            _context.Positions.Add(position);
            await _context.SaveChangesAsync();

            await _repository.DeleteAsync(position);

            (await _context.Positions.FindAsync(position.Id)).Should().BeNull();
        }

        public void Dispose()
        {
            _context.Database.EnsureDeleted();
            _context.Dispose();
        }
    }

}