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 --- .../ControleSinistroRepository.cs | 161 --------------------- 1 file changed, 161 deletions(-) delete mode 100644 Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ControleSinistroRepository.cs (limited to 'Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ControleSinistroRepository.cs') diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ControleSinistroRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ControleSinistroRepository.cs deleted file mode 100644 index 5d23145..0000000 --- a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/ControleSinistroRepository.cs +++ /dev/null @@ -1,161 +0,0 @@ -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 NHibernate; -using NHibernate.Connection; -using NHibernate.Impl; -using System; -using System.Collections.Generic; -using System.Data; -using System.Data.SqlClient; -using System.Linq; -using System.Linq.Expressions; -using System.Runtime.CompilerServices; - -namespace Gestor.Infrastructure.Repository.Logic -{ - public class ControleSinistroRepository : GenericRepository, IControleSinistroRepository, IGenericRepository - { - private readonly GenericUnitOfWork _unitOfWork; - - public ControleSinistroRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session) - { - this._unitOfWork = unitOfWork; - } - - public void Delete(long id) - { - ControleSinistroDb controleSinistroDb = base.FindEntityById(id); - if (controleSinistroDb == null) - { - return; - } - base.Delete(controleSinistroDb); - } - - public void DeleteByItem(long id) - { - object connection; - List list = ( - from s in this._unitOfWork.Query() - where s.ControleSinistro.Item.Id == id - select s).ToList(); - 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.Format("DELETE FROM controlesinistro WHERE iditem = {0}", id); - sqlCommand.ExecuteNonQuery(); - list.ForEach((SinistroDb x) => { - sqlCommand.CommandText = string.Format("DELETE FROM sinistro WHERE idsinistro = {0}", x.Id); - sqlCommand.ExecuteNonQuery(); - sqlCommand.CommandText = string.Format("DELETE FROM sinistroauto WHERE idsinistro = {0}", x.Id); - sqlCommand.ExecuteNonQuery(); - sqlCommand.CommandText = string.Format("DELETE FROM sinistrovida WHERE idsinistro = {0}", x.Id); - sqlCommand.ExecuteNonQuery(); - }); - } - } - } - - public void DeleteRange(List ids) - { - List list = ( - from x in base.All() - where ids.Contains(x.Item.Id) - select x).ToList(); - if (list == null || list.Count == 0) - { - return; - } - base.DeleteRange(list); - } - - public bool DocumentoHasSinistro(long id) - { - return base.All().Any((ControleSinistroDb x) => x.Item.Documento.Id == id); - } - - public ControleSinistro FindById(long id) - { - ControleSinistroDb controleSinistroDb = base.FindEntityById(id); - return ApplicationMapper.Mapper.Map(controleSinistroDb); - } - - public List FindByIdItem(long id) - { - List list = ( - from c in base.All() - where c.Item.Id == id - select c into x - select new ControleSinistro() - { - Id = x.Id, - DataSinistro = x.DataSinistro, - Item = ApplicationMapper.Mapper.Map(x.Item) - }).ToList(); - list.ForEach((ControleSinistro x) => x.Sinistros = (new SinistroRepository(this._unitOfWork)).FindByControleId(x.Id)); - return list; - } - - public List HasSinistro(List ids) - { - List nums = new List(); - while (ids.Count > 0) - { - List list = ids.Take(1000).ToList(); - List condicaos = new List() - { - new Condicao() - { - Campo = "d.idcontrole", - Valores = list.CriarValor() - } - }; - DataTable dataTable = this._unitOfWork.Select(condicaos.CreateParameters(0), "SELECT DISTINCT d.idcontrole as id FROM controlesinistro c CROSS APPLY (select idcontrole FROM item i INNER JOIN documento d on d.iddocumento = i.iddocumento WHERE i.iditem = c.iditem) d WHERE ", ""); - if (dataTable != null && dataTable.Rows.Count > 0) - { - nums.AddRange(dataTable.AsEnumerable().Select((DataRow x) => x.Field("id")).ToList()); - } - ids = (list.Count < 1000 ? new List() : ids.Except(list).ToList()); - } - return nums; - } - - public bool HasSinistro(long id) - { - return base.All().Any((ControleSinistroDb x) => x.Item.Documento.Controle.Id == id); - } - - public ControleSinistro Merge(ControleSinistro controleSinistro) - { - ControleSinistroDb controleSinistroDb = ApplicationMapper.Mapper.Map(controleSinistro); - base.Merge(controleSinistroDb); - return ApplicationMapper.Mapper.Map(controleSinistroDb); - } - - public ControleSinistro SaveOrUpdate(ControleSinistro controleSinistro) - { - ControleSinistroDb controleSinistroDb = ApplicationMapper.Mapper.Map(controleSinistro); - this.SaveOrUpdate(controleSinistroDb); - return ApplicationMapper.Mapper.Map(controleSinistroDb); - } - } -} \ No newline at end of file -- cgit v1.2.3