public List <Purchase> GetCustomerPurchases(Guid customerId)
    {
        var purchaseDbModelList = _context.Purchases.Where(p => p.CustomerId.Equals(customerId)).ToList();
        var purchaseList        =
            (from purchaseDbModel in purchaseDbModelList select _purchaseMapper.DbToDomain(purchaseDbModel)).ToList();

        return(purchaseList);
    }
        public async Task <List <Purchase> > GetClientPurchases(Guid clientId)
        {
            CustomValidator.ValidateId(clientId);
            await using var context = new MyDbContext(_options);
            var purchaseDbModels = await context.Purchases.Where(p => p.ClientId.Equals(clientId)).ToListAsync();

            var purchases = (from purchaseDbModel in purchaseDbModels
                             select _purchaseMapper.DbToDomain(purchaseDbModel)).ToList();

            return(purchases);
        }