From 674ca83ba9243a9e95a7568c797668dab6aee26a Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:35:25 -0300 Subject: feat: upload files --- .../AtividadeRepository.cs | 92 ++++++++++++++++++++++ 1 file changed, 92 insertions(+) create mode 100644 Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/AtividadeRepository.cs (limited to 'Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/AtividadeRepository.cs') diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/AtividadeRepository.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/AtividadeRepository.cs new file mode 100644 index 0000000..d3261c6 --- /dev/null +++ b/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/AtividadeRepository.cs @@ -0,0 +1,92 @@ +using AutoMapper; +using Gestor.Infrastructure.Entities.Common; +using Gestor.Infrastructure.Entities.Generic; +using Gestor.Infrastructure.Mappers; +using Gestor.Infrastructure.Repository.Generic; +using Gestor.Infrastructure.Repository.Interface; +using Gestor.Infrastructure.UnitOfWork.Generic; +using Gestor.Model.Domain.Common; +using Gestor.Model.Domain.Generic; +using NHibernate; +using NHibernate.Connection; +using NHibernate.Impl; +using System; +using System.Collections.Generic; +using System.Data.SqlClient; +using System.Linq; +using System.Linq.Expressions; +using System.Reflection; +using System.Runtime.CompilerServices; + +namespace Gestor.Infrastructure.Repository.Logic +{ + public class AtividadeRepository : GenericRepository, IAtividadeRepository, IGenericRepository + { + private readonly GenericUnitOfWork _unitOfWork; + + public AtividadeRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session) + { + this._unitOfWork = unitOfWork; + } + + public List Find(string filter) + { + AtividadeRepository.u003cu003ec__DisplayClass5_0 variable = null; + IQueryable atividadeDbs = base.All(); + ParameterExpression parameterExpression = Expression.Parameter(typeof(AtividadeDb), "x"); + IQueryable atividadeDbs1 = atividadeDbs.Where(Expression.Lambda>(Expression.OrElse(Expression.Call(Expression.Call(Expression.Call(Expression.Property(parameterExpression, (MethodInfo)MethodBase.GetMethodFromHandle(typeof(AtividadeDb).GetMethod("get_Nome").MethodHandle)), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("Trim").MethodHandle), Array.Empty()), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("ToUpper").MethodHandle), Array.Empty()), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("Contains", new Type[] { typeof(string) }).MethodHandle), new Expression[] { Expression.Field(Expression.Constant(variable, typeof(AtividadeRepository.u003cu003ec__DisplayClass5_0)), FieldInfo.GetFieldFromHandle(typeof(AtividadeRepository.u003cu003ec__DisplayClass5_0).GetField("filter").FieldHandle)) }), Expression.Call(Expression.Call(Expression.Call(Expression.Property(parameterExpression, (MethodInfo)MethodBase.GetMethodFromHandle(typeof(AtividadeDb).GetMethod("get_Cnac").MethodHandle)), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("Trim").MethodHandle), Array.Empty()), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("ToUpper").MethodHandle), Array.Empty()), (MethodInfo)MethodBase.GetMethodFromHandle(typeof(string).GetMethod("Contains", new Type[] { typeof(string) }).MethodHandle), new Expression[] { Expression.Field(Expression.Constant(variable, typeof(AtividadeRepository.u003cu003ec__DisplayClass5_0)), FieldInfo.GetFieldFromHandle(typeof(AtividadeRepository.u003cu003ec__DisplayClass5_0).GetField("filter").FieldHandle)) })), new ParameterExpression[] { parameterExpression })); + parameterExpression = Expression.Parameter(typeof(AtividadeDb), "x"); + return atividadeDbs1.Select(Expression.Lambda>(Expression.MemberInit(Expression.New(typeof(Atividade)), new MemberBinding[] { Expression.Bind((MethodInfo)MethodBase.GetMethodFromHandle(typeof(DomainBase).GetMethod("set_Id", new Type[] { typeof(long) }).MethodHandle), Expression.Property(parameterExpression, (MethodInfo)MethodBase.GetMethodFromHandle(typeof(EntityBase).GetMethod("get_Id").MethodHandle))), Expression.Bind((MethodInfo)MethodBase.GetMethodFromHandle(typeof(Atividade).GetMethod("set_Nome", new Type[] { typeof(string) }).MethodHandle), Expression.Property(parameterExpression, (MethodInfo)MethodBase.GetMethodFromHandle(typeof(AtividadeDb).GetMethod("get_Nome").MethodHandle))), Expression.Bind((MethodInfo)MethodBase.GetMethodFromHandle(typeof(Atividade).GetMethod("set_Cnac", new Type[] { typeof(string) }).MethodHandle), Expression.Property(parameterExpression, (MethodInfo)MethodBase.GetMethodFromHandle(typeof(AtividadeDb).GetMethod("get_Cnac").MethodHandle))) }), new ParameterExpression[] { parameterExpression })).ToList(); + } + + public long FindLastId() + { + long num; + object connection; + SqlCommand sqlCommand; + 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) + { + sqlCommand = sqlConnection.CreateCommand(); + } + else + { + sqlCommand = null; + } + using (SqlCommand sqlCommand1 = sqlCommand) + { + sqlCommand1.CommandText = "SELECT MAX(idatividade) as id FROM atividade"; + SqlDataReader sqlDataReader = sqlCommand1.ExecuteReader(); + sqlDataReader.Read(); + sqlDataReader["id"].ToString(); + num = (sqlDataReader["id"] == null || sqlDataReader["id"].ToString() == "" || sqlDataReader["id"].ToString() == "{}" ? (long)0 : long.Parse(sqlDataReader["id"].ToString())); + } + } + return num; + } + + public Atividade Merge(Atividade atividade) + { + AtividadeDb atividadeDb = ApplicationMapper.Mapper.Map(atividade); + base.Merge(atividadeDb); + return ApplicationMapper.Mapper.Map(atividadeDb); + } + + public Atividade SaveOrUpdate(Atividade atividade) + { + AtividadeDb atividadeDb = ApplicationMapper.Mapper.Map(atividade); + this.SaveOrUpdate(atividadeDb); + return ApplicationMapper.Mapper.Map(atividadeDb); + } + } +} \ No newline at end of file -- cgit v1.2.3