public override PaginationResult <Compra> GetPagined(IPaginationQuery filter)
        {
            var filterSql = this.BuildGenericsFilter(filter as CompraPaginationQuery) + this.BuildAdvancedFilter(filter as CompraPaginationQuery);

            var sql = $@"SELECT compras.numero, compras.modelo, compras.serie, compras.fornecedorid, compras.dataemissao, compras.datachegada, compras.frete, compras.seguro, 
		                    compras.outrasdespesas, compras.observacoes, compras.datacancelamento, compras.usercancelamento, compras.justificativacancelamento, 
	                        compras.datacriacao, compras.dataatualizacao, compras.usercriacao, compras.useratualizacao,
		
	                        fornecedores.id as ""fornecedor.id"", fornecedores.nome as ""fornecedor.nome"", fornecedores.apelido as ""fornecedor.apelido"", 
                            fornecedores.bairro as ""fornecedor.bairro"", fornecedores.cep as ""fornecedor.cep"", fornecedores.cidadeid as ""fornecedor.cidadeid"", 
	                        fornecedores.complemento as ""fornecedor.complemento"", fornecedores.contato as ""fornecedor.contato"", 
	                        fornecedores.condicaopagamentoid as ""fornecedor.condicaopagamentoid"", fornecedores.cpfcpnj as ""fornecedor.cpfcpnj"", 
	                        fornecedores.email as ""fornecedor.email"", fornecedores.endereco as ""fornecedor.endereco"", fornecedores.numero as ""fornecedor.numero"", 
	                        fornecedores.rginscricaoestadual as ""fornecedor.rginscricaoestadual"", fornecedores.telefone as ""fornecedor.telefone"", 
	                        fornecedores.tipo as ""fornecedor.tipo"", fornecedores.limitecredito as ""fornecedor.limitecredito"", fornecedores.observacao as ""fornecedor.observacao"", 
	                        fornecedores.situacao as ""fornecedor.situacao"" , fornecedores.datacriacao as ""fornecedor.datacriacao"", 
	                        fornecedores.dataatualizacao as ""fornecedor.dataatualizacao"", fornecedores.usercriacao as ""fornecedor.usercriacao"", 
	                        fornecedores.useratualizacao as ""fornecedor.useratualizacao""


                    FROM compras
                        INNER JOIN fornecedores ON fornecedores.id = compras.fornecedorid
                    WHERE 1 = 1 {filterSql}";



            return(this.ExecuteGetPaginated(sql, $"SELECT  COUNT(*) AS TotalItem FROM compras WHERE 1 = 1 {filterSql}", filter, filter));
        }
        public override (string query, object @params) GetQueryListPagined(IPaginationQuery filter)
        {
            var sql = @"SELECT Estados.Id, Estados.Nome, Estados.UF, Estados.PaisId, Estados.Situacao,
                        Paises.Id as ""Pais.Id"", Paises.Nome as ""Pais.Nome"", Paises.Sigla as ""Pais.Sigla"", Paises.DDI as ""Pais.DDI""
                            FROM Estados 
                            INNER JOIN Paises ON Paises.id = Estados.paisId 
                        WHERE 1=1 ";

            int?byId = default;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                byId = filter.Filter.ConvertValue <int>();

                if (byId != null)
                {
                    sqlId += $" OR {this.TableName}.id = @id ";
                }

                filter.Filter = $"%{filter.Filter.Replace(" ", "%")}%";
                sql          += $" AND ({this.TableName}.Nome ilike @Filter {sqlId}) ";
            }

            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Habilitado)
            {
                sql += " AND Estados.situacao is null";
            }
            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Desabilitado)
            {
                sql += " AND Estados.situacao is not null";
            }

            return(sql, new { id = byId, filter.Filter });
        }
        public override PaginationResult <CondicaoPagamento> GetPagined(IPaginationQuery filter)
        {
            var sql = $@"SELECT *
                          FROM CondicaoPagamentos 
                        WHERE 1=1 ";

            int id = 0;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                if (Int32.TryParse(filter.Filter, out id))
                {
                    sqlId += $" OR id = @id ";
                }
                filter.Filter = "%" + filter.Filter + "%";
                sql          += $" AND nome ilike @Filter {sqlId} ";
            }

            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Habilitado)
            {
                sql += " AND CondicaoPagamentos.situacao is null";
            }
            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Desabilitado)
            {
                sql += " AND CondicaoPagamentos.situacao is not null";
            }

            return(base.ExecuteGetPaginated(sql, "SELECT  COUNT(*) AS TotalItem FROM CondicaoPagamentos", new { id, filter.Filter }, filter));
        }
Ejemplo n.º 4
0
        private static int?GetNextSkip(IPaginationQuery query, int defaultPageSize)
        {
            var top  = query.Top.IsNullOrZero() || query.Top > defaultPageSize ? defaultPageSize : query.Top;
            var skip = query.Skip ?? query.RunningCount;

            return(skip + top);
        }
Ejemplo n.º 5
0
        private static void SetRunningCount(IPaginationQuery requestQuery, int resultCount)
        {
            if (!requestQuery.RunningCount.HasValue || requestQuery.Skip.IsNullOrZero() || requestQuery.Top.IsNullOrZero())
            {
                requestQuery.RunningCount = 0;
            }

            requestQuery.RunningCount += resultCount;
        }
Ejemplo n.º 6
0
        private static int?GetTop(IPaginationQuery requestQuery, int defaultPageSize)
        {
            if (requestQuery.Top.IsNullOrZero())
            {
                return(defaultPageSize);
            }

            return(requestQuery.Top > defaultPageSize ? defaultPageSize : requestQuery.Top);
        }
        public PaginationResult <ApplicationUser> GetPagined(IPaginationQuery filter)
        {
            var listUser = this.UserManager.Users
                           .Where(e => string.IsNullOrEmpty(filter.Filter) || e.UserName.Contains(filter.Filter)).ToList();

            return(new PaginationResult <ApplicationUser>()
            {
                Result = listUser
            });
        }
Ejemplo n.º 8
0
        /// <summary>
        /// Filter results
        /// </summary>
        /// <param name="queryable"></param>
        /// <param name="paginationQuery"></param>
        /// <typeparam name="TModel"></typeparam>
        /// <returns></returns>
        public static IQueryable <TModel> Where <TModel>(this IQueryable <TModel> queryable,
                                                         IPaginationQuery paginationQuery)
        {
            if (!string.IsNullOrEmpty(paginationQuery.Where))
            {
                queryable = WhereExpressionFactory.CreateFromString(queryable, paginationQuery.Where);
            }

            return(queryable);
        }
        public override PaginationResult <Venda> GetPagined(IPaginationQuery filter)
        {
            var filterSql = this.BuildGenericsFilter(filter as VendaPaginationQuery) + this.BuildAdvancedFilter(filter as VendaPaginationQuery);

            var orderby = " ORDER BY Vendas.Numero::int DESC, Vendas.Serie";
            var sql     = @$ "SELECT {this.Property.FormatProperty(e => $" Vendas.{ e } ")} ,
                            clientes.id AS " "cliente.id" ", clientes.nome AS " "cliente.nome" ", clientes.apelido AS " "cliente.apelido" "

                        FROM Vendas
                            INNER JOIN public.clientes ON clientes.id = vendas.clienteid 
Ejemplo n.º 10
0
        private static IQueryable <TIn> BuildPagedQueryable <TIn>(this IQueryable <TIn> source,
                                                                  IPaginationQuery request, int maxItemsPerResult
                                                                  )
        {
            var max = request.Top.HasValue && request.Top.Value <= maxItemsPerResult ? request.Top.Value : maxItemsPerResult;

            source = request.Skip is null ? source : source.Skip(request.Skip.Value);
            source = source.Take(max);

            return(source);
        }
Ejemplo n.º 11
0
        internal PaginationResult <Compra> GetPagined(IPaginationQuery filter)
        {
            var result = this.CompraDAO.GetPagined(filter);

            foreach (var compra in result.Result)
            {
                compra.Produtos = this.CompraProdutoDAO.ListByCompraId(compra.GetId());
            }

            return(result);
        }
Ejemplo n.º 12
0
        /// <summary>
        ///     Builds a paged result from a queryable as an asynchronous operation, where server side paging is enforced.
        /// </summary>
        /// <typeparam name="TIn">The type of the t in.</typeparam>
        /// <typeparam name="TOut">The type of the t out.</typeparam>
        /// <param name="qry">The qry.</param>
        /// <param name="request">The request.</param>
        /// <param name="maxItemsPerResult">max items that should override the queries top.</param>
        /// <param name="projection">Select projection</param>
        /// <param name="serializeSettings">Map serialize settings</param>
        /// <returns>Task&lt;List&lt;dynamic&gt;&gt;.</returns>
        public static IQueryable PagedResultsQuery <TIn, TOut>(this IQueryable <TIn> qry,
                                                               IPaginationQuery request, int maxItemsPerResult,
                                                               Func <TIn, TOut> projection = null,
                                                               JsonSerializerSettings serializeSettings = null
                                                               )
            where TOut : new()
        {
            var result = qry.BuildPagedQueryable(request, maxItemsPerResult)
                         .BuildOutputQueryable(projection, serializeSettings);

            Console.WriteLine(result.Expression.ToString());

            return(result);
        }
Ejemplo n.º 13
0
        private static int?GetPreviousSkip(IPaginationQuery query, int defaultPageSize)
        {
            if (query.Skip.IsNullOrZero())
            {
                return(null);
            }

            // ReSharper disable once PossibleInvalidOperationException
            var skip = query.Skip.Value;
            var top  = query.Top > defaultPageSize ? defaultPageSize : query.Top;

            var nextSkip = skip - top;

            return(nextSkip > 0 ? nextSkip : null);
        }
Ejemplo n.º 14
0
        /// <summary>
        /// Sort and paginate results
        /// </summary>
        /// <param name="queryable"></param>
        /// <param name="paginationQuery"></param>
        /// <typeparam name="TModel"></typeparam>
        /// <returns></returns>
        public static IQueryable <TModel> TransformBy <TModel>(this IQueryable <TModel> queryable,
                                                               IPaginationQuery paginationQuery)
        {
            var pageSize = paginationQuery.PageSize > PaginationSettings.MaxPageSize
                ? PaginationSettings.MaxPageSize
                : paginationQuery.PageSize;

            if (!string.IsNullOrEmpty(paginationQuery.OrderBy))
            {
                queryable = SortExpressionFactory.SortBy(queryable, paginationQuery.OrderBy);
            }

            queryable = queryable
                        .Skip(pageSize * paginationQuery.Page)
                        .Take(pageSize);

            return(queryable);
        }
        public override (string query, object @params) GetQueryListPagined(IPaginationQuery filter)
        {
            var sql = $@"SELECT Produtos.Id, Produtos.Nome, Produtos.UnidadeMedidaId, Produtos.CodigoBarras, Produtos.Referencia, Produtos.Descricao, 
                                Produtos.Observacao, Produtos.MarcaId, Produtos.CategoriaId, Produtos.QuantidadeMinima, Produtos.ValorCompra, Produtos.ValorVenda, 
                                Produtos.Quantidade, Produtos.DataCriacao, Produtos.DataAtualizacao, Produtos.Situacao,
		
		                        categorias.id AS ""categoria.id"", categorias.nome AS ""categoria.nome"", categorias.datacriacao AS ""categoria.datacriacao"", 
		                        categorias.dataatualizacao AS ""categorias.dataatualizacao"", categorias.Situacao AS ""categoria.Situacao"",

                                marcas.id AS ""marca.id"", marcas.nome AS ""marca.nome"", marcas.datacriacao AS ""marca.datacriacao"", 
                                marcas.dataatualizacao AS ""marca.dataatualizacao"", marcas.Situacao AS ""marca.Situacao""

                        FROM Produtos
                            INNER JOIN categorias ON categorias.id = Produtos.CategoriaId
                            INNER JOIN marcas ON marcas.id = Produtos.marcaId
                        WHERE 1=1 ";

            int?byId = default;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                byId = filter.Filter.ConvertValue <int>();

                if (byId != null)
                {
                    sqlId += $" OR {this.TableName}.id = @id ";
                }

                filter.Filter = $"%{filter.Filter.Replace(" ", "%")}%";
                sql          += $" AND ({this.TableName}.Nome ilike @Filter {sqlId}) ";
            }

            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Habilitado)
            {
                sql += " AND Produtos.situacao is null";
            }
            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Desabilitado)
            {
                sql += " AND Produtos.situacao is not null";
            }

            return(sql, new { id = byId, filter.Filter });
        }
        public override (string query, object @params) GetQueryListPagined(IPaginationQuery filter)
        {
            var sql = $@" SELECT funcionarios.Id, funcionarios.EstadoCivil, funcionarios.Sexo, funcionarios.Nacionalidade, funcionarios.IsBrasileiro, funcionarios.DataNascimento, 
	                        funcionarios.Cnh, funcionarios.DataValidadeCNH, funcionarios.FuncaoFuncionarioId, funcionarios.Salario, funcionarios.DataAdmissao, 
	                        funcionarios.DataDemissao, funcionarios.CidadeId, funcionarios.Apelido, funcionarios.Bairro, funcionarios.Cep, funcionarios.Complemento, 
	                        funcionarios.CPFCPNJ, funcionarios.Email, funcionarios.Endereco, funcionarios.Nome, funcionarios.Numero, funcionarios.Observacao, 
	                        funcionarios.RgInscricaoEstadual, funcionarios.Telefone, funcionarios.DataCriacao, funcionarios.DataAtualizacao, funcionarios.Situacao,
	
	                        funcaofuncionarios.id as ""FuncaoFuncionario.id"", funcaofuncionarios.nome as ""FuncaoFuncionario.nome"", 
	                        funcaofuncionarios.cargahoraria as ""FuncaoFuncionario.cargahoraria"", funcaofuncionarios.requercnh as ""FuncaoFuncionario.requercnh"", 
	                        funcaofuncionarios.descricao as ""FuncaoFuncionario.descricao"", funcaofuncionarios.observacao as ""FuncaoFuncionario.observacao"", 
	                        funcaofuncionarios.datacriacao as ""FuncaoFuncionario.datacriacao"", funcaofuncionarios.dataatualizacao as ""FuncaoFuncionario.dataatualizacao""
                        FROM funcionarios
                            INNER JOIN funcaofuncionarios ON funcaofuncionarios.id = funcionarios.FuncaoFuncionarioId 
                        WHERE  1=1 ";

            int?byId = default;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                byId = filter.Filter.ConvertValue <int>();

                if (byId != null)
                {
                    sqlId += $" OR {this.TableName}.id = @id ";
                }

                filter.Filter = $"%{filter.Filter.Replace(" ", "%")}%";
                sql          += $" AND ({this.TableName}.Nome ilike @Filter {sqlId}) ";
            }

            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Habilitado)
            {
                sql += " AND funcionarios.situacao is null";
            }
            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Desabilitado)
            {
                sql += " AND funcionarios.situacao is not null";
            }

            return(sql, new { id = byId, filter.Filter });
        }
        public override PaginationResult <CondicaoPagamentoParcela> GetPagined(IPaginationQuery filter)
        {
            var sql = $@"SELECT CondicaoPagamentoParcelas.*,  formapagamentos.nome as ""formapagamentos.nome""
                        FROM CondicaoPagamentoParcelas
                            INNER JOIN formapagamentos ON formapagamentos.id = CondicaoPagamentoParcelas.formapagamentoid ";

            int id = 0;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                if (Int32.TryParse(filter.Filter, out id))
                {
                    sqlId += $" OR CondicaoPagamentoParcelas.id = @id ";
                }
                filter.Filter = "%" + filter.Filter + "%";
                sql          += $" WHERE CondicaoPagamentoParcelas.nome ilike @Filter {sqlId} ";
            }

            return(base.ExecuteGetPaginated(sql, "SELECT  COUNT(*) AS TotalItem FROM CondicaoPagamentoParcelas", new { id, filter.Filter }, filter));
        }
        public IList <IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
        {
            var blocks = new List <IPersistedBlock>();

            try
            {
                if (!IsEnabled)
                {
                    return(null);
                }

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query <PersistedBlock>(
                        @"SELECT b.Height, b.Orphaned, b.Confirmed, b.Accounted, b.BlockHash, b.TxHash, b.Amount, b.Reward, b.CreatedAt 
                            From Block b
	                            INNER JOIN Payment as p ON p.Block = b.Height
	                            WHERE b.Accounted = true and p.Completed = true
                                GROUP BY b.Height
	                            ORDER BY b.Height DESC LIMIT @offset, @count"    ,
                        new
                    {
                        offset = paginationQuery.Offset,
                        count  = paginationQuery.Count
                    });

                    blocks.AddRange(results);
                }
            }
            catch (InvalidOperationException) // fires when no result is found.
            {
                return(null);
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting block; {0:l}", e.Message);
            }

            return(blocks);
        }
Ejemplo n.º 19
0
        public override (string query, object @params) GetQueryListPagined(IPaginationQuery filter)
        {
            var sql = $@"SELECT Cidades.Id, Cidades.Nome, Cidades.DDD, Cidades.EstadoId, Cidades.Situacao,
				        Estados.Id as ""Estado.Id"", Estados.Nome as ""Estado.Nome"", Estados.UF as ""Estado.UF"", Estados.Situacao as ""Estado.Situacao""
                                    FROM Cidades
                        INNER JOIN Estados ON Cidades.EstadoID = Estados.Id
                        WHERE 1=1";

            int?byId = default;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                byId = filter.Filter.ConvertValue <int>();

                if (byId != null)
                {
                    sqlId += $" OR {this.TableName}.id = @id ";
                }

                filter.Filter = $"%{filter.Filter.Replace(" ", "%")}%";
                sql          += $" AND ({this.TableName}.Nome ilike @Filter {sqlId}) ";
            }

            if (filter is PaginationQuery <SituacaoType?> filterSituacao)
            {
                if (filterSituacao.Situacao == SituacaoType.Habilitado)
                {
                    sql += " AND Cidades.situacao is null";
                }
                if (filterSituacao.Situacao == SituacaoType.Desabilitado)
                {
                    sql += " AND Cidades.situacao is not null";
                }
            }

            return(sql, new { id = byId, filter.Filter });
        }
Ejemplo n.º 20
0
        //@" SELECT Id, Nome, MarcaId, Situacao, DataCriacao, UserCriacao, DataAtualizacao, UserAtualizacao
        //                  FROM Equipamentos"
        public override (string query, object @params) GetQueryListPagined(IPaginationQuery filter)
        {
            var sql = $@"SELECT {this.TableName}.{this.PropertyId}, 
                            {this.Property.FormatProperty(e => $"{this.TableName}.{e}")},
                            marcas.id AS ""marca.id"", marcas.nome AS ""marca.nome""

                        FROM {this.TableName} 
                            INNER JOIN marcas ON marcas.id = equipamentos.marcaid
                        WHERE 1 = 1 ";

            int byId = default;

            if (!string.IsNullOrEmpty(filter.Filter))
            {
                var sqlId = "";
                byId = filter.Filter.ConvertValue <int>();

                if (byId != null)
                {
                    sqlId += $" OR {this.TableName}.id = @id ";
                }

                filter.Filter = $"%{filter.Filter.Replace(" ", "%")}%";
                sql          += $" AND ({this.TableName}.nome ilike @Filter {sqlId}) ";
            }

            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Habilitado)
            {
                sql += $" AND {this.TableName}.situacao is null";
            }
            if ((filter as PaginationQuery <SituacaoType?>).Situacao == DTO.Filters.SituacaoType.Desabilitado)
            {
                sql += $" AND {this.TableName}.situacao is not null";
            }

            return(sql, new { id = byId, filter.Filter });
        }
Ejemplo n.º 21
0
        public IList <IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
        {
            var payouts = new List <IPaymentDetails>();

            try
            {
                if (!IsEnabled)
                {
                    return(payouts);
                }

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query <PaymentDetails>(
                        @"SELECT p.Id as PaymentId, t.Id as TransactionId, p.AccountId, a.Address, p.Block, p.Amount as Amount, 
                            t.Amount as SentAmount, t.Currency, t.TxHash, p.CreatedAt as PaymentDate, t.CreatedAt as TransactionDate, p.Completed 
                            FROM Payment p 
                                INNER JOIN Account as a ON p.AccountId = a.Id
                                LEFT OUTER JOIN Transaction t On p.Id = t.PaymentId Where a.Id = @id
                            ORDER BY p.Id DESC LIMIT @offset, @count",
                        new
                    {
                        id,
                        offset = paginationQuery.Offset,
                        count  = paginationQuery.Count
                    });

                    payouts.AddRange(results);
                }
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting payments: {0:l}", e.Message);
            }

            return(payouts);
        }
        public IList <IPersistedBlock> GetBlocks(IPaginationQuery paginationQuery)
        {
            var blocks = new List <IPersistedBlock>();

            try
            {
                if (!IsEnabled)
                {
                    return(null);
                }

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query <PersistedBlock>(
                        @"SELECT Height, Orphaned, Confirmed, Accounted, BlockHash, TxHash, Amount, Reward, CreatedAt From Block 
                            ORDER BY Height DESC LIMIT @offset, @count",
                        new
                    {
                        offset = paginationQuery.Offset,
                        count  = paginationQuery.Count
                    });

                    blocks.AddRange(results);
                }
            }
            catch (InvalidOperationException) // fires when no result is found.
            {
                return(null);
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting block; {0:l}", e.Message);
            }

            return(blocks);
        }
Ejemplo n.º 23
0
 public IList<IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     return new List<IPaymentDetails>();
 }
Ejemplo n.º 24
0
 public IList<IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
 {
     return _storageLayer.GetPaidBlocks(paginationQuery);
 }
        public IList<IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
        {
            var payouts = new List<IPaymentDetails>();

            try
            {
                if (!IsEnabled)
                    return payouts;

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query<PaymentDetails>(
                        @"SELECT p.Id as PaymentId, t.Id as TransactionId, p.AccountId, a.Address, p.Block, p.Amount as Amount, 
                            t.Amount as SentAmount, t.Currency, t.TxHash, p.CreatedAt as PaymentDate, t.CreatedAt as TransactionDate, p.Completed 
                            FROM Payment p 
                                INNER JOIN Account as a ON p.AccountId = a.Id
                                LEFT OUTER JOIN Transaction t On p.Id = t.PaymentId Where a.Id = @id
                            ORDER BY p.Id DESC LIMIT @offset, @count",
                        new
                        {
                            id,
                            offset = paginationQuery.Offset,
                            count = paginationQuery.Count
                        });

                    payouts.AddRange(results);
                }
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting payments: {0:l}", e.Message);
            }

            return payouts;
        }
        public IList<IPersistedBlock> GetBlocks(IPaginationQuery paginationQuery)
        {
            var blocks = new List<IPersistedBlock>();

            try
            {
                if (!IsEnabled)
                    return null;

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query<PersistedBlock>(
                        @"SELECT Height, Orphaned, Confirmed, Accounted, BlockHash, TxHash, Amount, Reward, CreatedAt From Block 
                            ORDER BY Height DESC LIMIT @offset, @count",
                        new
                        {
                            offset = paginationQuery.Offset,
                            count = paginationQuery.Count
                        });

                    blocks.AddRange(results);
                }
            }
            catch (InvalidOperationException) // fires when no result is found.
            {
                return null;
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting block; {0:l}", e.Message);
            }

            return blocks;
        }
        public IList<IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
        {
            var blocks = new List<IPersistedBlock>();

            try
            {
                if (!IsEnabled)
                    return null;

                using (var connection = new MySqlConnection(_mySqlProvider.ConnectionString))
                {
                    var results = connection.Query<PersistedBlock>(
                        @"SELECT b.Height, b.Orphaned, b.Confirmed, b.Accounted, b.BlockHash, b.TxHash, b.Amount, b.Reward, b.CreatedAt 
                            From Block b
	                            INNER JOIN Payment as p ON p.Block = b.Height
	                            WHERE b.Accounted = true and p.Completed = true
                                GROUP BY b.Height
	                            ORDER BY b.Height DESC LIMIT @offset, @count",
                        new
                        {
                            offset = paginationQuery.Offset,
                            count = paginationQuery.Count
                        });

                    blocks.AddRange(results);
                }
            }
            catch (InvalidOperationException) // fires when no result is found.
            {
                return null;
            }
            catch (Exception e)
            {
                _logger.Error("An exception occured while getting block; {0:l}", e.Message);
            }

            return blocks;
        }
Ejemplo n.º 28
0
 public IList<IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     return _storageLayer.GetPaymentsForAccount(id, paginationQuery);
 }
Ejemplo n.º 29
0
 public IList <IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     return(new List <IPaymentDetails>());
 }
Ejemplo n.º 30
0
 public override PaginationResult <CompraProduto> GetPagined(IPaginationQuery filter)
 {
     throw new NotImplementedException();
 }
Ejemplo n.º 31
0
 public abstract PaginationResult <TEntity> GetPagined(IPaginationQuery filter);
Ejemplo n.º 32
0
 public IList <IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
 {
     return(_storageLayer.GetPaidBlocks(paginationQuery));
 }
Ejemplo n.º 33
0
 public IList<IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
 {
     throw new System.NotImplementedException();
 }
Ejemplo n.º 34
0
        public override PaginationResult<ContaReceber> GetPagined(IPaginationQuery genericsFilter)
        {
            var filter = genericsFilter as PaginationQuery<List<SituacaoContaReceberType>>;

            var sql = @$"SELECT {this.Property.FormatProperty(e => $"ContasReceber.{e}")}, 
                            {typeof(Cliente).Property().FormatProperty(e => $"clientes.{e} as \"cliente.{e}\"")},
Ejemplo n.º 35
0
 public IList <IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     throw new NotImplementedException();
 }
 public IList<IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     throw new NotImplementedException();
 }
Ejemplo n.º 37
0
 public IList <IPaymentDetails> GetPaymentsForAccount(int id, IPaginationQuery paginationQuery)
 {
     return(_storageLayer.GetPaymentsForAccount(id, paginationQuery));
 }
Ejemplo n.º 38
0
 public IList <IPersistedBlock> GetPaidBlocks(IPaginationQuery paginationQuery)
 {
     throw new NotImplementedException();
 }