chore: location

1 files changed, 0 insertions, 152 deletions

diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/TitularesVidaRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/TitularesVidaRepository.cs
deleted file mode 100644
index 4a0f512..0000000
--- a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/TitularesVidaRepository.cs
+++ /dev/null
@@ -1,152 +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.Common;

-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 TitularesVidaRepository : GenericRepository<TitularesVidaDb>, ITitularesVidaRepository, IGenericRepository<TitularesVidaDb>

-	{

-		private readonly GenericUnitOfWork _unitOfWork;

-

-		public TitularesVidaRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session)

-		{

-			this._unitOfWork = unitOfWork;

-		}

-

-		public void Delete(long id)

-		{

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

-		}

-

-		public void DeleteRange(List<long> ids)

-		{

-			for (int i = 0; i < ids.Count; i += 200)

-			{

-				IEnumerable<long> nums = ids.Skip<long>(i).Take<long>(200);

-				List<TitularesVidaDb> list = (

-					from x in base.All()

-					where nums.Contains<long>(x.Id)

-					select x).ToList<TitularesVidaDb>();

-				base.DeleteRange(list);

-			}

-		}

-

-		public List<TitularesVida> Find(long id)

-		{

-			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)

-			{

-				if (sqlConnection != null)

-				{

-					using (SqlCommand sqlCommand = sqlConnection.CreateCommand())

-					{

-						sqlCommand.CommandText = string.Format("SELECT * FROM TitularesVida WHERE IdItem = {0}", id);

-						using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())

-						{

-							sqlDataAdapter.SelectCommand = sqlCommand;

-							sqlDataAdapter.Fill(dataTable);

-						}

-					}

-				}

-			}

-			return dataTable.AsEnumerable().ToList<DataRow>().Select<DataRow, TitularesVida>((DataRow x) => {

-				DateTime? nullable;

-				DateTime? nullable1;

-				DateTime? nullable2;

-				DateTime? nullable3;

-				TitularesVida titularesVida = new TitularesVida()

-				{

-					Id = x.Field<long>("Id"),

-					Codigo = (x.Field<object>("Codigo") != null ? x.Field<object>("Codigo").ToString() : null)

-				};

-				if (x.Field<object>("Inicio") != null)

-				{

-					nullable1 = new DateTime?(DateTime.Parse(x.Field<object>("Inicio").ToString()));

-				}

-				else

-				{

-					nullable = null;

-					nullable1 = nullable;

-				}

-				titularesVida.Inicio = nullable1;

-				if (x.Field<object>("Fim") != null)

-				{

-					nullable2 = new DateTime?(DateTime.Parse(x.Field<object>("Fim").ToString()));

-				}

-				else

-				{

-					nullable = null;

-					nullable2 = nullable;

-				}

-				titularesVida.Fim = nullable2;

-				titularesVida.Fatura = (x.Field<object>("Fatura") != null ? x.Field<object>("Fatura").ToString() : null);

-				titularesVida.Nome = (x.Field<object>("Nome") != null ? x.Field<object>("Nome").ToString() : null);

-				titularesVida.Observacao = (x.Field<object>("Observacao") != null ? x.Field<object>("Observacao").ToString() : null);

-				if (x.Field<object>("Nascimento") != null)

-				{

-					nullable3 = new DateTime?(DateTime.Parse(x.Field<object>("Nascimento").ToString()));

-				}

-				else

-				{

-					nullable = null;

-					nullable3 = nullable;

-				}

-				titularesVida.Nascimento = nullable3;

-				titularesVida.Cpf = (x.Field<object>("Cpf") != null ? x.Field<object>("Cpf").ToString() : null);

-				titularesVida.Matricula = (x.Field<object>("Matricula") != null ? x.Field<object>("Matricula").ToString() : null);

-				titularesVida.Premio = new decimal?((x.Field<object>("Premio") != null ? x.Field<decimal>("Premio") : decimal.Zero));

-				titularesVida.Capital = new decimal?((x.Field<object>("Capital") != null ? x.Field<decimal>("Capital") : decimal.Zero));

-				titularesVida.Tipo = (x.Field<object>("Tipo") != null ? (TipoTitular?)Enum.Parse(typeof(TipoTitular), x.Field<object>("Tipo").ToString()) : null);

-				titularesVida.Dependente = (x.Field<object>("Dependente_id") != null ? this.FindById(x.Field<long>("Dependente_id")) : null);

-				return titularesVida;

-			}).ToList<TitularesVida>();

-		}

-

-		public TitularesVida FindById(long id)

-		{

-			TitularesVidaDb titularesVidaDb = base.FindEntityById(id);

-			return ApplicationMapper.Mapper.Map<TitularesVidaDb, TitularesVida>(titularesVidaDb);

-		}

-

-		public TitularesVida Merge(TitularesVida vida)

-		{

-			TitularesVidaDb titularesVidaDb = ApplicationMapper.Mapper.Map<TitularesVida, TitularesVidaDb>(vida);

-			base.Merge(titularesVidaDb);

-			return ApplicationMapper.Mapper.Map<TitularesVidaDb, TitularesVida>(titularesVidaDb);

-		}

-

-		public TitularesVida SaveOrUpdate(TitularesVida vida)

-		{

-			TitularesVidaDb titularesVidaDb = ApplicationMapper.Mapper.Map<TitularesVida, TitularesVidaDb>(vida);

-			this.SaveOrUpdate(titularesVidaDb);

-			return ApplicationMapper.Mapper.Map<TitularesVidaDb, TitularesVida>(titularesVidaDb);

-		}

-	}

-}
\ No newline at end of file