From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:38:18 -0300 Subject: chore: location --- .../LancamentoRepository.cs | 345 --------------------- 1 file changed, 345 deletions(-) delete mode 100644 Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/LancamentoRepository.cs (limited to 'Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/LancamentoRepository.cs') diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/LancamentoRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/LancamentoRepository.cs deleted file mode 100644 index 82f67fc..0000000 --- a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/LancamentoRepository.cs +++ /dev/null @@ -1,345 +0,0 @@ -using AutoMapper; -using Gestor.Infrastructure.Entities.Financeiro; -using Gestor.Infrastructure.Entities.Generic; -using Gestor.Infrastructure.Helpers; -using Gestor.Infrastructure.Mappers; -using Gestor.Infrastructure.Repository.Generic; -using Gestor.Infrastructure.Repository.Interface; -using Gestor.Infrastructure.UnitOfWork.Generic; -using Gestor.Model.Common; -using Gestor.Model.Domain.Financeiro; -using Gestor.Model.Domain.Financeiro.Relatorios; -using Gestor.Model.Domain.Generic; -using NHibernate; -using NHibernate.Connection; -using NHibernate.Impl; -using System; -using System.Collections.Generic; -using System.Data; -using System.Data.Common; -using System.Data.SqlClient; -using System.Linq; -using System.Linq.Expressions; -using System.Runtime.CompilerServices; - -namespace Gestor.Infrastructure.Repository.Logic -{ - public class LancamentoRepository : GenericRepository, ILancamentoRepository, IGenericRepository - { - private readonly GenericUnitOfWork _unitOfWork; - - public LancamentoRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session) - { - this._unitOfWork = unitOfWork; - } - - public List AddRange(List lancamento) - { - List lancamentoDbs = ApplicationMapper.Mapper.Map, List>(lancamento); - base.AddRange(lancamentoDbs); - return ApplicationMapper.Mapper.Map, List>(lancamentoDbs); - } - - public bool BancosContasUtilizado(long id) - { - return base.All().Any((LancamentoDb x) => x.Conta.Id == id); - } - - public void Delete(long id) - { - LancamentoDb lancamentoDb = base.FindEntityById(id); - if (lancamentoDb == null) - { - return; - } - base.Delete(lancamentoDb); - } - - public List Fechamento(FiltroFinanceiro filtro) - { - string str = (filtro.Centro == null || filtro.Centro.Count == 0 ? "" : string.Concat(" AND c.idcentro IN (", string.Join(",", filtro.Centro), ")")); - string str1 = (filtro.Plano == null || filtro.Plano.Count == 0 ? "" : string.Concat(" AND cp.idcplano IN (", string.Join(",", filtro.Plano), ")")); - string str2 = (filtro.Planos == null || filtro.Planos.Count == 0 ? "" : string.Concat(" AND c.idcplanos IN (", string.Join(",", filtro.Planos), ")")); - string str3 = (filtro.Conta == null || filtro.Conta.Count == 0 ? "" : string.Concat(" AND l.idconta IN (", string.Join(",", filtro.Conta), ")")); - return this.Select(string.Format(" AND {0} >= '{1:yyyy-MM-dd}' AND {2} <= '{3:yyyy-MM-dd}' {4} {5} {6} {7}", new object[] { filtro.Referencia, filtro.Inicio, filtro.Referencia, filtro.Fim, str, str1, str2, str3 })); - } - - public Saldo FecharSaldo(Saldo saldo) - { - object connection; - SessionFactoryImpl sessionFactory = this._unitOfWork.Session.SessionFactory as SessionFactoryImpl; - decimal num = new decimal(); - if (sessionFactory != null) - { - connection = sessionFactory.ConnectionProvider.GetConnection(); - } - else - { - connection = null; - } - using (SqlConnection sqlConnection = connection as SqlConnection) - { - if (sqlConnection != null) - { - using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) - { - sqlCommand.CommandText = string.Format("SELECT sinal, vlrbaixa FROM lancamen WHERE idconta = {0} AND dtbaixa IS NOT NULL AND dtbaixa >= '{1:yyyy-MM-dd}' AND dtbaixa < '{2:yyyy-MM-dd}' ", saldo.Conta.Id, saldo.DataInicio, saldo.DataFinal); - DataTable dataTable = new DataTable(); - using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter()) - { - sqlDataAdapter.SelectCommand = sqlCommand; - sqlDataAdapter.Fill(dataTable); - } - num = (dataTable.Rows.Count == 0 ? decimal.Zero : dataTable.AsEnumerable().ToList().Sum((DataRow x) => { - decimal? nullable; - decimal? nullable1; - if (x.Field("sinal") == "0") - { - nullable = x.Field("vlrbaixa"); - return nullable.GetValueOrDefault(); - } - decimal? nullable2 = x.Field("vlrbaixa"); - if (nullable2.HasValue) - { - nullable1 = new decimal?(-nullable2.GetValueOrDefault()); - } - else - { - nullable = null; - nullable1 = nullable; - } - nullable = nullable1; - return nullable.GetValueOrDefault(); - })); - } - } - } - saldo.ValorFinal = new decimal?(saldo.ValorInicio + num); - return saldo; - } - - public List Find(DateTime inicio, DateTime fim, StatusLancamento status) - { - if (status == StatusLancamento.Baixados) - { - return this.Select(string.Format(" AND CAST(l.dtpre AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtpre AS DATE) <= '{1:yyyy-MM-dd}' AND l.dtbaixa IS NOT NULL", inicio, fim)); - } - if (status != StatusLancamento.Todos) - { - return this.Select(string.Format(" AND CAST(l.dtpre AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtpre AS DATE) <= '{1:yyyy-MM-dd}' AND l.dtbaixa IS NULL", inicio, fim)); - } - return this.Select(string.Format(" AND CAST(l.dtpre AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtpre AS DATE) <= '{1:yyyy-MM-dd}'", inicio, fim)); - } - - public List FindByBaixa(DateTime inicio, DateTime fim) - { - return this.Select(string.Format(" AND CAST(l.dtbaixa AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtbaixa AS DATE) <= '{1:yyyy-MM-dd}'", inicio, fim)); - } - - public List FindByCodigoBanco(List codigos) - { - List strs = codigos; - List lancamentos = new List(); - while (strs.Count > 0) - { - List list = strs.Take(2100).ToList(); - string str = string.Concat(" AND l.CodigoBanco IN ('", string.Join(",", list), "')"); - lancamentos.AddRange(this.Select(str)); - strs = (list.Count < 2100 ? new List() : strs.Except(list).ToList()); - } - return lancamentos; - } - - public List FindByConta(DateTime inicio, DateTime fim, long id) - { - return this.Select(string.Format(" AND l.idconta = {0} AND CAST(l.dtbaixa AS DATE) >= '{1:yyyy-MM-dd}' AND CAST(l.dtbaixa AS DATE) <= '{2:yyyy-MM-dd}'", id, inicio, fim)).Select((Lancamento x) => { - decimal? valorPago; - string nome; - decimal zero; - ExtratoConta extratoContum = new ExtratoConta() - { - IdLancamento = x.Id - }; - DateTime? baixa = x.Baixa; - extratoContum.Baixa = new DateTime?((baixa.HasValue ? baixa.GetValueOrDefault() : DateTime.MinValue)); - ControleFinanceiro controle = x.Controle; - if (controle != null) - { - Fornecedor fornecedor = controle.Fornecedor; - if (fornecedor != null) - { - nome = fornecedor.Nome; - } - else - { - nome = null; - } - } - else - { - nome = null; - } - extratoContum.Fornecedor = nome; - extratoContum.Historico = x.Historico; - extratoContum.TipoPagamento = new TipoPagamento?(x.TipoPagamento); - if (!x.ValorPago.HasValue) - { - zero = decimal.Zero; - } - else if (x.Sinal == Sinal.Credito) - { - valorPago = x.ValorPago; - zero = Math.Abs(valorPago.Value); - } - else - { - valorPago = x.ValorPago; - zero = -Math.Abs(valorPago.Value); - } - extratoContum.Valor = new decimal?(zero); - extratoContum.Sinal = x.Sinal; - return extratoContum; - }).ToList(); - } - - public List FindByControle(long id, StatusLancamento status) - { - if (status == StatusLancamento.Baixados) - { - return this.Select(string.Format(" AND l.idcfinan = {0} AND l.dtbaixa IS NOT NULL", id)); - } - if (status != StatusLancamento.Todos) - { - return this.Select(string.Format(" AND l.idcfinan = {0} AND l.dtbaixa IS NULL", id)); - } - return this.Select(string.Format(" AND l.idcfinan = {0}", id)); - } - - public Lancamento FindByControle(long id, int parcela) - { - return this.Select(string.Format(" AND l.idcfinan = {0} AND l.parcela = {1}", id, parcela)).FirstOrDefault(); - } - - public List FindByFornecedor(long id, StatusLancamento status) - { - if (status == StatusLancamento.Baixados) - { - return this.Select(string.Format(" AND c.idfornecedor = {0} AND l.dtbaixa IS NOT NULL", id)); - } - if (status != StatusLancamento.Todos) - { - return this.Select(string.Format(" AND c.idfornecedor = {0} AND l.dtbaixa IS NULL", id)); - } - return this.Select(string.Format(" AND c.idfornecedor = {0}", id)); - } - - public List FindByFornecedor(long id, DateTime date, Sinal sinal) - { - return this.Select(string.Format(" AND c.idfornecedor = {0} AND l.dtpre >= '{1:yyyy-MM-dd}' AND l.dtpre <= '{2:yyyy-MM-dd}' AND l.sinal = {3}", new object[] { id, date, date.AddMonths(1), (int)sinal })); - } - - public Lancamento FindById(long id) - { - LancamentoDb lancamentoDb = base.FindEntityById(id); - return ApplicationMapper.Mapper.Map(lancamentoDb); - } - - public List FindByLancamento(DateTime inicio, DateTime fim, StatusLancamento status) - { - if (status == StatusLancamento.Baixados) - { - return this.Select(string.Format(" AND CAST(l.datacriacao AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.datacriacao AS DATE) <= '{1:yyyy-MM-dd}' AND l.dtbaixa IS NOT NULL", inicio, fim)); - } - if (status != StatusLancamento.Todos) - { - return this.Select(string.Format(" AND CAST(l.datacriacao AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.datacriacao AS DATE) <= '{1:yyyy-MM-dd}' AND l.dtbaixa IS NULL", inicio, fim)); - } - return this.Select(string.Format(" AND CAST(l.datacriacao AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.datacriacao AS DATE) <= '{1:yyyy-MM-dd}'", inicio, fim)); - } - - public List FindByPagamento(DateTime inicio, DateTime fim) - { - return this.Select(string.Format(" AND CAST(l.dtpagto AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtpagto AS DATE) <= '{1:yyyy-MM-dd}'", inicio, fim)); - } - - public List FindLancamentosByConta(DateTime inicio, DateTime fim, long id) - { - return this.Select(string.Format(" AND CAST(l.dtpre AS DATE) >= '{0:yyyy-MM-dd}' AND CAST(l.dtpre AS DATE) <= '{1:yyyy-MM-dd}' AND l.idconta = {2}", inicio, fim, id)); - } - - public List FindPersonalizado(DateTime inicio, DateTime fim, StatusLancamento status, FiltroLancamentoData filtrodata) - { - string referencia = this.GetReferencia(filtrodata); - if (status == StatusLancamento.Baixados) - { - return this.Select(string.Format(" AND {0} >= '{1:yyyy-MM-dd}' AND {2} <= '{3:yyyy-MM-dd}' AND l.dtbaixa IS NOT NULL", new object[] { referencia, inicio, referencia, fim })); - } - if (status != StatusLancamento.Todos) - { - return this.Select(string.Format(" AND {0} >= '{1:yyyy-MM-dd}' AND {2} <= '{3:yyyy-MM-dd}' AND l.dtbaixa IS NULL", new object[] { referencia, inicio, referencia, fim })); - } - return this.Select(string.Format(" AND {0} >= '{1:yyyy-MM-dd}' AND {2} <= '{3:yyyy-MM-dd}'", new object[] { referencia, inicio, referencia, fim })); - } - - private string GetReferencia(FiltroLancamentoData filtro) - { - if (filtro == FiltroLancamentoData.Baixa) - { - return "CAST(l.dtbaixa AS DATE)"; - } - if (filtro != FiltroLancamentoData.Pagamento) - { - return "CAST(l.dtpre AS DATE)"; - } - return "CAST(l.dtpagto AS DATE)"; - } - - public bool HasByFornecedor(long id) - { - return base.All().Any((LancamentoDb x) => x.Controle.Fornecedor.Id == id); - } - - public Lancamento Merge(Lancamento lancamento) - { - LancamentoDb lancamentoDb = ApplicationMapper.Mapper.Map(lancamento); - base.Merge(lancamentoDb); - return ApplicationMapper.Mapper.Map(lancamentoDb); - } - - public Lancamento SaveOrUpdate(Lancamento lancamento) - { - LancamentoDb lancamentoDb = ApplicationMapper.Mapper.Map(lancamento); - this.SaveOrUpdate(lancamentoDb); - return ApplicationMapper.Mapper.Map(lancamentoDb); - } - - private List Select(string condition) - { - object connection; - DataTable dataTable = new DataTable(); - SessionFactoryImpl sessionFactory = this._unitOfWork.Session.SessionFactory as SessionFactoryImpl; - if (sessionFactory != null) - { - connection = sessionFactory.ConnectionProvider.GetConnection(); - } - else - { - connection = null; - } - using (SqlConnection sqlConnection = connection as SqlConnection) - { - using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) - { - AuxiliarFinanceiro.Criar(sqlCommand); - sqlCommand.CommandText = string.Concat("SELECT DISTINCT c.idfornecedor, f.nome, f.Ativo, c.idfornecedor, c.idcplanos, c.idcentro, c.historico as historicocfinan, c.parcela as parcelas, cp.idcplano, l.* FROM lancamen l INNER JOIN cfinan c on c.idcfinan = l.idcfinan LEFT OUTER JOIN cplanos cp on c.idcplanos = cp.idcplanos LEFT OUTER JOIN fornecedor f on f.idfornecedor = c.idfornecedor WHERE 1=1 ", condition); - using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter()) - { - sqlDataAdapter.SelectCommand = sqlCommand; - sqlDataAdapter.Fill(dataTable); - } - } - } - return CustomMap.MapLancamento(dataTable); - } - } -} \ No newline at end of file -- cgit v1.2.3