1 files changed, 125 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/MetaVendedorRepository.cs b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/MetaVendedorRepository.cs
new file mode 100644
index 0000000..04be6b1
--- /dev/null
+++ b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Repository.Logic/MetaVendedorRepository.cs
@@ -0,0 +1,125 @@
+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.Relatorios;
+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.Runtime.CompilerServices;
+
+namespace Gestor.Infrastructure.Repository.Logic
+{
+	public class MetaVendedorRepository : GenericRepository<MetaVendedorDb>, IMetaVendedorRepository, IGenericRepository<MetaVendedorDb>
+	{
+		private readonly GenericUnitOfWork _unitOfWork;
+
+		public MetaVendedorRepository(GenericUnitOfWork unitOfWork) : base(unitOfWork.Session)
+		{
+			this._unitOfWork = unitOfWork;
+		}
+
+		public void Delete(long id)
+		{
+			base.Delete(base.FindEntityById(id));
+		}
+
+		public List<MetaVendedor> Find(long id)
+		{
+			return (
+				from x in this._unitOfWork.Session.CreateQuery(string.Format("from MetaVendedorDb WHERE idvendedor = {0}", id)).List<MetaVendedorDb>()
+				select new MetaVendedor()
+				{
+					Id = x.Id,
+					Mes = x.Mes,
+					Ano = x.Ano,
+					Valor = x.Valor
+				}).ToList<MetaVendedor>();
+		}
+
+		public MetaVendedor FindById(long id)
+		{
+			MetaVendedorDb metaVendedorDb = base.FindEntityById(id);
+			return ApplicationMapper.Mapper.Map<MetaVendedorDb, MetaVendedor>(metaVendedorDb);
+		}
+
+		public List<MetaVendedor> FindByMeta(Filtros filtro)
+		{
+			List<MetaVendedor> metaVendedors;
+			object connection;
+			string str = (filtro.Vendedores == null || filtro.Vendedores.Count == 0 ? "" : string.Concat(" AND idvendedor IN (", string.Join<long>(",", 
+				from v in filtro.Vendedores
+				select v), ")"));
+			SessionFactoryImpl sessionFactory = this._unitOfWork.Session.SessionFactory as SessionFactoryImpl;
+			DataTable dataTable = new DataTable();
+			if (sessionFactory != null)
+			{
+				connection = sessionFactory.ConnectionProvider.GetConnection();
+			}
+			else
+			{
+				connection = null;
+			}
+			using (SqlConnection sqlConnection = connection as SqlConnection)
+			{
+				using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
+				{
+					Auxiliar.CriarAuxiliar(sqlCommand, false);
+					object month = filtro.Fim.Month;
+					DateTime fim = filtro.Fim;
+					sqlCommand.CommandText = string.Format("SELECT IdMetaVendedor, IdVendedor, Mes, Ano, Valor\r\n                                                FROM MetaVendedor\r\n                                                WHERE Mes = {0} AND Ano = {1} {2};", month, fim.Year, str);
+					using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
+					{
+						sqlDataAdapter.SelectCommand = sqlCommand;
+						sqlDataAdapter.Fill(dataTable);
+					}
+					if (dataTable.Rows.Count != 0)
+					{
+						return (
+							from x in dataTable.AsEnumerable().ToList<DataRow>()
+							select new MetaVendedor()
+							{
+								Id = x.Field<long>("IdMetaVendedor"),
+								Mes = (Mes)x.Field<int>("Mes"),
+								Ano = long.Parse(x.Field<object>("Ano").ToString()),
+								Valor = x.Field<decimal>("Valor"),
+								Vendedor = Auxiliar.Vendedores.FirstOrDefault<Vendedor>((Vendedor v) => v.Id == x.Field<long>("idvendedor"))
+							}).ToList<MetaVendedor>();
+					}
+					else
+					{
+						metaVendedors = new List<MetaVendedor>();
+					}
+				}
+			}
+			return metaVendedors;
+		}
+
+		public MetaVendedor Merge(MetaVendedor metaVendedor)
+		{
+			MetaVendedorDb metaVendedorDb = ApplicationMapper.Mapper.Map<MetaVendedor, MetaVendedorDb>(metaVendedor);
+			base.Merge(metaVendedorDb);
+			return ApplicationMapper.Mapper.Map<MetaVendedorDb, MetaVendedor>(metaVendedorDb);
+		}
+
+		public MetaVendedor SaveOrUpdate(MetaVendedor metaVendedor)
+		{
+			MetaVendedorDb metaVendedorDb = ApplicationMapper.Mapper.Map<MetaVendedor, MetaVendedorDb>(metaVendedor);
+			this.SaveOrUpdate(metaVendedorDb);
+			return ApplicationMapper.Mapper.Map<MetaVendedorDb, MetaVendedor>(metaVendedorDb);
+		}
+	}
+}
+\ No newline at end of file