feat: upload files

1 files changed, 220 insertions, 0 deletions

diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteTelefoneRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteTelefoneRepository.cs
new file mode 100644
index 0000000..1a5fb3c
--- /dev/null
+++ b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ClienteTelefoneRepository.cs
@@ -0,0 +1,220 @@
+using AutoMapper;

+using Gestor.Infrastructure.Entities.Generic;

+using Gestor.Infrastructure.Entities.Seguros;

+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.Generic;

+using Gestor.Model.Domain.Seguros;

+using Gestor.Model.Helper;

+using System;

+using System.Collections.Generic;

+using System.Linq;

+using System.Linq.Expressions;

+using System.Runtime.CompilerServices;

+

+namespace Gestor.Infrastructure.Repository.Logic

+{

+	public class ClienteTelefoneRepository : GenericRepository<ClienteTelefoneDb>, IClienteTelefoneRepository, IGenericRepository<ClienteTelefoneDb>

+	{

+		private readonly GenericUnitOfWork _unitOfWork;

+

+		public ClienteTelefoneRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session)

+		{

+			this._unitOfWork = unitOfWork;

+		}

+

+		public void Delete(long id)

+		{

+			base.Delete(base.FindEntityById(id));

+		}

+

+		public List<ClienteTelefone> DeleteFone(long clienteId, List<ClienteTelefone> telefones)

+		{

+			if (telefones == null || telefones.Count == 0)

+			{

+				return null;

+			}

+			List<ClienteTelefoneDb> list = (

+				from cliente in base.All()

+				where cliente.Cliente.Id == clienteId

+				select cliente).ToList<ClienteTelefoneDb>().Where<ClienteTelefoneDb>((ClienteTelefoneDb fone) => {

+				List<ClienteTelefone> clienteTelefones = telefones;

+				Func<ClienteTelefone, long> u003cu003e9_103 = ClienteTelefoneRepository.u003cu003ec.u003cu003e9__10_3;

+				if (u003cu003e9_103 == null)

+				{

+					u003cu003e9_103 = (ClienteTelefone t) => t.Id;

+					ClienteTelefoneRepository.u003cu003ec.u003cu003e9__10_3 = u003cu003e9_103;

+				}

+				return !clienteTelefones.Select<ClienteTelefone, long>(u003cu003e9_103).Contains<long>(fone.Id);

+			}).ToList<ClienteTelefoneDb>();

+			list.ForEach((ClienteTelefoneDb fonesExcluido) => base.Delete(fonesExcluido));

+			return ApplicationMapper.Mapper.Map<List<ClienteTelefoneDb>, List<ClienteTelefone>>(list);

+		}

+

+		public List<ClienteTelefone> Find(string telefone, long idempresa = 0L)

+		{

+			List<Condicao> condicaos = new List<Condicao>()

+			{

+				new Condicao()

+				{

+					Campo = "REPLACE(ISNULL(ct.fone, ''), '-','')",

+					Valores = telefone.Clear().CriarValor<string>(),

+					Operador = Operador.Like

+				}

+			};

+			if (idempresa > (long)0)

+			{

+				condicaos.Add(new Condicao()

+				{

+					Campo = "c.idempresa",

+					Valores = idempresa.CriarValor<long>()

+				});

+			}

+			return this.Select(condicaos.CreateParameters(0));

+		}

+

+		private List<ClienteTelefone> FindByCliente(long id)

+		{

+			return this.Select((new List<Condicao>()

+			{

+				new Condicao()

+				{

+					Campo = "ct.idcliente",

+					Valores = id.CriarValor<long>()

+				}

+			}).CreateParameters(0));

+		}

+

+		public List<ClienteTelefone> FindByClienteId(long id)

+		{

+			return this.FindByCliente(id);

+		}

+

+		public ClienteTelefone FindById(long id)

+		{

+			ClienteTelefoneDb clienteTelefoneDb = base.FindEntityById(id);

+			return ApplicationMapper.Mapper.Map<ClienteTelefoneDb, ClienteTelefone>(clienteTelefoneDb);

+		}

+

+		public List<ClienteTelefone> Inserir(List<ClienteTelefone> telefones)

+		{

+			List<ClienteTelefoneDb> clienteTelefoneDbs = ApplicationMapper.Mapper.Map<List<ClienteTelefone>, List<ClienteTelefoneDb>>(telefones);

+			clienteTelefoneDbs.ForEach((ClienteTelefoneDb x) => {

+				string str;

+				ClienteTelefoneDb clienteTelefoneDb = x;

+				string observacao = x.Observacao;

+				if (observacao != null)

+				{

+					str = observacao.Trim();

+				}

+				else

+				{

+					str = null;

+				}

+				clienteTelefoneDb.Observacao = str;

+				if (x.Id == 0)

+				{

+					this.SaveOrUpdate(x);

+					return;

+				}

+				base.Merge(x);

+			});

+			return ApplicationMapper.Mapper.Map<List<ClienteTelefoneDb>, List<ClienteTelefone>>(clienteTelefoneDbs);

+		}

+

+		public List<ClienteTelefone> Inserir(List<ClienteTelefone> telefones, Cliente cliente)

+		{

+			telefones.ForEach((ClienteTelefone x) => {

+				string str;

+				x.Cliente = cliente;

+				ClienteTelefone clienteTelefone = x;

+				string observacao = x.Observacao;

+				if (observacao != null)

+				{

+					str = observacao.Trim();

+				}

+				else

+				{

+					str = null;

+				}

+				clienteTelefone.Observacao = str;

+			});

+			List<ClienteTelefoneDb> clienteTelefoneDbs = ApplicationMapper.Mapper.Map<List<ClienteTelefone>, List<ClienteTelefoneDb>>(telefones);

+			base.AddRange(clienteTelefoneDbs);

+			return ApplicationMapper.Mapper.Map<List<ClienteTelefoneDb>, List<ClienteTelefone>>(clienteTelefoneDbs);

+		}

+

+		public ClienteTelefone Merge(ClienteTelefone telefone)

+		{

+			ClienteTelefoneDb clienteTelefoneDb = ApplicationMapper.Mapper.Map<ClienteTelefone, ClienteTelefoneDb>(telefone);

+			clienteTelefoneDb.Observacao = clienteTelefoneDb.Observacao.Trim();

+			base.Merge(clienteTelefoneDb);

+			return ApplicationMapper.Mapper.Map<ClienteTelefoneDb, ClienteTelefone>(clienteTelefoneDb);

+		}

+

+		public List<ClienteTelefone> Merge(List<ClienteTelefone> telefones, Cliente cliente)

+		{

+			List<ClienteTelefoneDb> clienteTelefoneDbs = ApplicationMapper.Mapper.Map<List<ClienteTelefone>, List<ClienteTelefoneDb>>(telefones);

+			clienteTelefoneDbs.ForEach((ClienteTelefoneDb x) => {

+				string str;

+				ClienteTelefoneDb clienteTelefoneDb = x;

+				string observacao = x.Observacao;

+				if (observacao != null)

+				{

+					str = observacao.Trim();

+				}

+				else

+				{

+					str = null;

+				}

+				clienteTelefoneDb.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<ClienteTelefoneDb>, List<ClienteTelefone>>(clienteTelefoneDbs);

+		}

+

+		public ClienteTelefone SaveOrUpdate(ClienteTelefone telefone)

+		{

+			string str;

+			ClienteTelefoneDb clienteTelefoneDb = ApplicationMapper.Mapper.Map<ClienteTelefone, ClienteTelefoneDb>(telefone);

+			ClienteTelefoneDb clienteTelefoneDb1 = clienteTelefoneDb;

+			string observacao = clienteTelefoneDb.Observacao;

+			if (observacao != null)

+			{

+				str = observacao.Trim();

+			}

+			else

+			{

+				str = null;

+			}

+			clienteTelefoneDb1.Observacao = str;

+			this.SaveOrUpdate(clienteTelefoneDb);

+			return ApplicationMapper.Mapper.Map<ClienteTelefoneDb, ClienteTelefone>(clienteTelefoneDb);

+		}

+

+		private List<ClienteTelefone> Select(SqlQueryCondition condition)

+		{

+			List<ClienteTelefone> clienteTelefones = CustomMap.MapTelefone(this._unitOfWork.Select(condition, "SELECT ct.idclitelefone AS Id, ct.idcliente as IdCliente, ct.ddd AS Prefixo, ct.fone AS Numero, ISNULL(ct.tipo , 0) AS Tipo, ct.obs AS Observacao, ct.ordem AS Ordem, c.nome as NomeCliente FROM clitelefone ct INNER JOIN cliente c ON c.idcliente = ct.idcliente WHERE ", ""));

+			int? nullable1 = new int?(0);

+			clienteTelefones.ForEach((ClienteTelefone x) => {

+				int? ordem = nullable1;

+				int? nullable = ordem;

+				nullable1 = (nullable.HasValue ? new int?(nullable.GetValueOrDefault() + 1) : null);

+				ClienteTelefone clienteTelefone = x;

+				ordem = x.Ordem;

+				clienteTelefone.Ordem = (ordem.HasValue ? ordem : nullable1);

+			});

+			return clienteTelefones;

+		}

+	}

+}
\ No newline at end of file