summaryrefslogtreecommitdiff
path: root/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs
diff options
context:
space:
mode:
authorLucas Faria Mendes <lucas.fariamo08@gmail.com>2026-03-30 13:38:18 +0000
committerLucas Faria Mendes <lucas.fariamo08@gmail.com>2026-03-30 13:38:18 +0000
commit1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 (patch)
treee1c3b20ea08f0cf71122a1e73f0d395f8fd83874 /Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs
parent674ca83ba9243a9e95a7568c797668dab6aee26a (diff)
downloadgestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.tar.gz
gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.zip
chore: location
Diffstat (limited to 'Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs')
-rw-r--r--Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs223
1 files changed, 0 insertions, 223 deletions
diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs
deleted file mode 100644
index 9a2ac8e..0000000
--- a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteEnderecoRepository.cs
+++ /dev/null
@@ -1,223 +0,0 @@
-using AutoMapper;
-using Gestor.Infrastructure.Entities.Generic;
-using Gestor.Infrastructure.Entities.Seguros;
-using Gestor.Infrastructure.Mappers;
-using Gestor.Infrastructure.Repository.Generic;
-using Gestor.Infrastructure.Repository.Interface;
-using Gestor.Infrastructure.UnitOfWork.Generic;
-using Gestor.Model.Domain.Generic;
-using Gestor.Model.Domain.Seguros;
-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 ClienteEnderecoRepository : GenericRepository<ClienteEnderecoDb>, IClienteEnderecoRepository, IGenericRepository<ClienteEnderecoDb>
- {
- private readonly GenericUnitOfWork _unitOfWork;
-
- public ClienteEnderecoRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session)
- {
- this._unitOfWork = unitOfWork;
- }
-
- public void Delete(long id)
- {
- base.Delete(base.FindEntityById(id));
- }
-
- public List<ClienteEndereco> DeleteEndereco(long clienteId, List<ClienteEndereco> enderecos)
- {
- if (enderecos == null || enderecos.Count == 0)
- {
- return null;
- }
- List<ClienteEnderecoDb> list = (
- from cliente in base.All()
- where cliente.Cliente.Id == clienteId
- select cliente).ToList<ClienteEnderecoDb>().Where<ClienteEnderecoDb>((ClienteEnderecoDb endereco) => {
- List<ClienteEndereco> clienteEnderecos = enderecos;
- Func<ClienteEndereco, long> u003cu003e9_102 = ClienteEnderecoRepository.u003cu003ec.u003cu003e9__10_2;
- if (u003cu003e9_102 == null)
- {
- u003cu003e9_102 = (ClienteEndereco t) => t.Id;
- ClienteEnderecoRepository.u003cu003ec.u003cu003e9__10_2 = u003cu003e9_102;
- }
- return !clienteEnderecos.Select<ClienteEndereco, long>(u003cu003e9_102).Contains<long>(endereco.Id);
- }).ToList<ClienteEnderecoDb>();
- ClienteEnderecoRepository clienteEnderecoRepository = this;
- list.ForEach(new Action<ClienteEnderecoDb>(clienteEnderecoRepository.Delete));
- return ApplicationMapper.Mapper.Map<List<ClienteEnderecoDb>, List<ClienteEndereco>>(list);
- }
-
- public List<ClienteEndereco> FindByCliente(List<Cliente> clientes)
- {
- string str = string.Concat(" AND ce.idcliente in (", string.Join<long>(",", (
- from x in clientes
- select x.Id).Distinct<long>()), ")");
- List<ClienteEndereco> clienteEnderecos = this.Select(str);
- (
- from x in clienteEnderecos
- orderby x.Ordem
- select x).ToList<ClienteEndereco>().ForEach((ClienteEndereco x) => x.Selecionado = x.Id == clienteEnderecos.First<ClienteEndereco>((ClienteEndereco c) => c.Cliente.Id == x.Cliente.Id).Id);
- return clienteEnderecos;
- }
-
- public List<ClienteEndereco> FindByClienteId(long id)
- {
- return this.Select(string.Format(" AND ce.idcliente = {0}", id));
- }
-
- public ClienteEndereco FindById(long id)
- {
- ClienteEnderecoDb clienteEnderecoDb = base.FindEntityById(id);
- return ApplicationMapper.Mapper.Map<ClienteEnderecoDb, ClienteEndereco>(clienteEnderecoDb);
- }
-
- public List<ClienteEndereco> Inserir(List<ClienteEndereco> endereco, Cliente cliente)
- {
- endereco.ForEach((ClienteEndereco x) => x.Cliente = cliente);
- List<ClienteEnderecoDb> clienteEnderecoDbs = ApplicationMapper.Mapper.Map<List<ClienteEndereco>, List<ClienteEnderecoDb>>(endereco);
- base.AddRange(clienteEnderecoDbs);
- return ApplicationMapper.Mapper.Map<List<ClienteEnderecoDb>, List<ClienteEndereco>>(clienteEnderecoDbs);
- }
-
- public List<ClienteEndereco> Inserir(List<ClienteEndereco> endereco)
- {
- List<ClienteEnderecoDb> clienteEnderecoDbs = ApplicationMapper.Mapper.Map<List<ClienteEndereco>, List<ClienteEnderecoDb>>(endereco);
- clienteEnderecoDbs.ForEach((ClienteEnderecoDb x) => {
- string str;
- ClienteEnderecoDb clienteEnderecoDb = x;
- string observacao = x.Observacao;
- if (observacao != null)
- {
- str = observacao.Trim();
- }
- else
- {
- str = null;
- }
- clienteEnderecoDb.Observacao = str;
- if (x.Id == 0)
- {
- this.SaveOrUpdate(x);
- return;
- }
- base.Merge(x);
- });
- return ApplicationMapper.Mapper.Map<List<ClienteEnderecoDb>, List<ClienteEndereco>>(clienteEnderecoDbs);
- }
-
- public ClienteEndereco Merge(ClienteEndereco clienteEndereco)
- {
- string str;
- ClienteEnderecoDb clienteEnderecoDb = ApplicationMapper.Mapper.Map<ClienteEndereco, ClienteEnderecoDb>(clienteEndereco);
- ClienteEnderecoDb clienteEnderecoDb1 = clienteEnderecoDb;
- string observacao = clienteEnderecoDb.Observacao;
- if (observacao != null)
- {
- str = observacao.Trim();
- }
- else
- {
- str = null;
- }
- clienteEnderecoDb1.Observacao = str;
- base.Merge(clienteEnderecoDb);
- return ApplicationMapper.Mapper.Map<ClienteEnderecoDb, ClienteEndereco>(clienteEnderecoDb);
- }
-
- public List<ClienteEndereco> Merge(List<ClienteEndereco> enderecos, Cliente cliente)
- {
- List<ClienteEnderecoDb> clienteEnderecoDbs = ApplicationMapper.Mapper.Map<List<ClienteEndereco>, List<ClienteEnderecoDb>>(enderecos);
- clienteEnderecoDbs.ForEach((ClienteEnderecoDb x) => {
- string str;
- ClienteEnderecoDb clienteEnderecoDb = x;
- string observacao = x.Observacao;
- if (observacao != null)
- {
- str = observacao.Trim();
- }
- else
- {
- str = null;
- }
- clienteEnderecoDb.Observacao = str;
- if (x.Id != 0)
- {
- base.Merge(x);
- return;
- }
- x.Cliente = ApplicationMapper.Mapper.Map<Cliente, ClienteDb>(cliente);
- this.SaveOrUpdate(x);
- });
- return ApplicationMapper.Mapper.Map<List<ClienteEnderecoDb>, List<ClienteEndereco>>(clienteEnderecoDbs);
- }
-
- public ClienteEndereco SaveOrUpdate(ClienteEndereco clienteEndereco)
- {
- string str;
- ClienteEnderecoDb clienteEnderecoDb = ApplicationMapper.Mapper.Map<ClienteEndereco, ClienteEnderecoDb>(clienteEndereco);
- ClienteEnderecoDb clienteEnderecoDb1 = clienteEnderecoDb;
- string observacao = clienteEnderecoDb.Observacao;
- if (observacao != null)
- {
- str = observacao.Trim();
- }
- else
- {
- str = null;
- }
- clienteEnderecoDb1.Observacao = str;
- this.SaveOrUpdate(clienteEnderecoDb);
- return ApplicationMapper.Mapper.Map<ClienteEnderecoDb, ClienteEndereco>(clienteEnderecoDb);
- }
-
- private List<ClienteEndereco> 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())
- {
- sqlCommand.CommandText = string.Concat("SELECT ce.*, c.nome as NomeCliente FROM cliendereco ce INNER JOIN cliente c ON c.idcliente = ce.idcliente WHERE 1=1 ", condition);
- using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
- {
- sqlDataAdapter.SelectCommand = sqlCommand;
- sqlDataAdapter.Fill(dataTable);
- }
- }
- }
- List<ClienteEndereco> clienteEnderecos = dataTable.MapEndereco();
- int? nullable1 = new int?(0);
- clienteEnderecos.ForEach((ClienteEndereco x) => {
- int? ordem = nullable1;
- int? nullable = ordem;
- nullable1 = (nullable.HasValue ? new int?(nullable.GetValueOrDefault() + 1) : null);
- ClienteEndereco clienteEndereco = x;
- ordem = x.Ordem;
- clienteEndereco.Ordem = (ordem.HasValue ? ordem : nullable1);
- });
- return clienteEnderecos;
- }
- }
-} \ No newline at end of file