diff options
Diffstat (limited to 'Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/RegistroAcaoRepository.cs')
| -rw-r--r-- | Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/RegistroAcaoRepository.cs | 183 |
1 files changed, 0 insertions, 183 deletions
diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/RegistroAcaoRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/RegistroAcaoRepository.cs deleted file mode 100644 index 158bcb9..0000000 --- a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/RegistroAcaoRepository.cs +++ /dev/null @@ -1,183 +0,0 @@ -using AutoMapper;
-using Gestor.Infrastructure.Entities.Common;
-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.Common;
-using Gestor.Model.Domain.Relatorios;
-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 RegistroAcaoRepository : GenericRepository<RegistroAcaoDb>, IRegistroAcaoRepository, IGenericRepository<RegistroAcaoDb>
- {
- private readonly GenericUnitOfWork _unitOfWork;
-
- public RegistroAcaoRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session)
- {
- this._unitOfWork = unitOfWork;
- }
-
- public void Delete(long id)
- {
- RegistroAcaoDb registroAcaoDb = base.FindEntityById(id);
- if (registroAcaoDb == null)
- {
- return;
- }
- base.Delete(registroAcaoDb);
- }
-
- public List<RegistroAcao> Find(Filtros filtros)
- {
- return this.Select(filtros);
- }
-
- public List<RegistroAcao> FindByEntityId(long id, TipoTela tela)
- {
- List<RegistroAcaoDb> list = (
- from x in base.All()
- where x.EntidadeId == id && (int?)x.Tela == (int?)tela
- select x).ToList<RegistroAcaoDb>();
- return ApplicationMapper.Mapper.Map<List<RegistroAcaoDb>, List<RegistroAcao>>(list);
- }
-
- public RegistroAcao FindById(long id)
- {
- RegistroAcaoDb registroAcaoDb = base.FindEntityById(id);
- return ApplicationMapper.Mapper.Map<RegistroAcaoDb, RegistroAcao>(registroAcaoDb);
- }
-
- public List<RegistroAcao> FindOld(Filtros filtros, string connection)
- {
- return this.SelectOld(filtros, connection);
- }
-
- public RegistroAcao SaveOrUpdate(RegistroAcao log)
- {
- RegistroAcaoDb registroAcaoDb = ApplicationMapper.Mapper.Map<RegistroAcao, RegistroAcaoDb>(log);
- this.SaveOrUpdate(registroAcaoDb);
- return ApplicationMapper.Mapper.Map<RegistroAcaoDb, RegistroAcao>(registroAcaoDb);
- }
-
- private List<RegistroAcao> Select(Filtros filtros)
- {
- List<RegistroAcao> registroAcaos;
- object connection;
- DataTable dataTable = new DataTable();
- string str = (filtros.Usuarios == null || filtros.Usuarios.Count == 0 ? "" : string.Concat(" AND IdUsuario IN (", string.Join<long>(",",
- from v in filtros.Usuarios
- select v), ")"));
- string str1 = (filtros.Telas == null || filtros.Telas.Count == 0 ? "" : string.Concat(" AND Tela IN (", string.Join<long>(",",
- from v in filtros.Telas
- select v), ")"));
- string str2 = (filtros.Relatorios == null || filtros.Relatorios.Count == 0 ? "" : string.Concat(" AND Relatorio IN (", string.Join<long>(",",
- from v in filtros.Relatorios
- select v), ")"));
- string str3 = (filtros.Inicio == DateTime.MinValue ? "" : string.Format(" AND CAST(DataHora AS DATE) >= '{0:yyyy-MM-dd}'", filtros.Inicio));
- string str4 = (filtros.Fim == DateTime.MinValue ? "" : string.Format(" AND CAST(DataHora AS DATE) <= '{0:yyyy-MM-dd}'", filtros.Fim));
- 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(new string[] { "SELECT * FROM RegistroAcao WHERE 1=1 ", str3, str4, str, str1, str2 });
- using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
- {
- sqlDataAdapter.SelectCommand = sqlCommand;
- sqlDataAdapter.Fill(dataTable);
- }
- if (dataTable.Rows.Count != 0)
- {
- return CustomMap.MapLogAcao(dataTable);
- }
- else
- {
- registroAcaos = new List<RegistroAcao>();
- }
- }
- }
- return registroAcaos;
- }
-
- private List<RegistroAcao> SelectOld(Filtros filtros, string conn)
- {
- List<RegistroAcao> registroAcaos;
- object connection;
- try
- {
- DataTable dataTable = new DataTable();
- string str = (filtros.Usuarios == null || filtros.Usuarios.Count == 0 ? "" : string.Concat(" AND IDUSUARIO IN (", string.Join<long>(",",
- from v in filtros.Usuarios
- select v), ")"));
- string str1 = (filtros.Inicio == DateTime.MinValue ? "" : string.Format(" AND CAST(DATA AS DATE) >= '{0:yyyy-MM-dd}'", filtros.Inicio));
- string str2 = (filtros.Fim == DateTime.MinValue ? "" : string.Format(" AND CAST(DATA AS DATE) <= '{0:yyyy-MM-dd}'", filtros.Fim));
- 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 = "SELECT TOP 1 * FROM controlelog";
- SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
- sqlDataReader.Read();
- string str3 = sqlDataReader["bdname"].ToString();
- sqlDataReader["tabela"].ToString();
- sqlDataReader.Close();
- if (sqlConnection.Database != str3)
- {
- conn = conn.Replace(sqlConnection.Database, str3);
- }
- }
- }
- using (SqlConnection sqlConnection1 = new SqlConnection(conn))
- {
- sqlConnection1.Open();
- using (SqlCommand sqlCommand1 = sqlConnection1.CreateCommand())
- {
- sqlCommand1.CommandTimeout = 15000;
- sqlCommand1.CommandText = string.Concat("SELECT IDACTION, ID, FORM, IDUSUARIO, DATA, ACAO, historico, maquina FROM actionlog WHERE 1=1 ", str1, str2, str);
- using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
- {
- sqlDataAdapter.SelectCommand = sqlCommand1;
- sqlDataAdapter.Fill(dataTable);
- }
- }
- }
- registroAcaos = (dataTable.Rows.Count != 0 ? CustomMap.MapOldLogAcao(dataTable) : new List<RegistroAcao>());
- }
- catch (Exception exception)
- {
- registroAcaos = new List<RegistroAcao>();
- }
- return registroAcaos;
- }
- }
-}
\ No newline at end of file |