qliberace/Modules/qdr.app.qlbrc.base/Repositories/RepoCountry.cs

using Microsoft.EntityFrameworkCore;
using Quadarax.Application.QLiberace.Base.Entities;
using Quadarax.Application.QLiberace.Common.Domain;
using Quadarax.Application.QLiberace.Common.Repositories;
using Quadarax.Foundation.Core.Data;
using Quadarax.Foundation.Core.Data.Domain;
using Quadarax.Foundation.Core.Data.Interface;
using Quadarax.Foundation.Core.Data.Interface.Domain;


namespace Quadarax.Application.QLiberace.Base.Repositories
{
    public class RepoCountry : QlbrcTrackedRepository<Country>
    {


        public RepoCountry(IUnitOfWork<IDataDomain> unitOfWork, QlbrcContext operationContext) : base(unitOfWork, operationContext)
        {
        }

        public Country? GetByCode(string countryCode, bool usingUncommited = false)
        {
            if (string.IsNullOrEmpty(countryCode)) throw new ArgumentNullException(nameof(countryCode));

            var prequery = Query(Paging.NoPaging(), usingUncommited).Include(x=>x.Tenants);
            Country? query;
            if (CurrentTenantId!=null)
                query = prequery
                .FirstOrDefault(x => string.Equals(x.Code, countryCode) && x.Tenants.Any(x=>x.TenantId == CurrentTenantId));
            else
                query = prequery.FirstOrDefault(x => string.Equals(x.Code, countryCode));
            return query;
        }

        public IQueryable<Country> GetAllGlobal(IPaging paging)
        {
            return Query(paging, false).OrderBy(x => x.Name);
        }
    }
}