1 files changed, 0 insertions, 127 deletions
diff --git a/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs b/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs
deleted file mode 100644
index b9ecf17..0000000
--- a/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs
+++ /dev/null
@@ -1,127 +0,0 @@
-using Gestor.Model.Domain.Financeiro;
-using Gestor.Model.Domain.Generic;
-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.Helpers
-{
-	public static class AuxiliarFinanceiro
-	{
-		public static List<Centro> Centros
-		{
-			get;
-			set;
-		}
-
-		public static List<BancosContas> Contas
-		{
-			get;
-			set;
-		}
-
-		public static List<Gestor.Model.Domain.Financeiro.Plano> Plano
-		{
-			get;
-			set;
-		}
-
-		public static List<Gestor.Model.Domain.Financeiro.Planos> Planos
-		{
-			get;
-			set;
-		}
-
-		public static List<TipoConta> TiposConta
-		{
-			get;
-			set;
-		}
-
-		public static void Criar(SqlCommand sqlCommand)
-		{
-			DataTable dataTable = new DataTable();
-			sqlCommand.CommandText = "SELECT DISTINCT idcplano as id, descricao as nome, ativo FROM cplano;";
-			using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
-			{
-				sqlDataAdapter.SelectCommand = sqlCommand;
-				sqlDataAdapter.Fill(dataTable);
-			}
-			AuxiliarFinanceiro.Plano = new List<Gestor.Model.Domain.Financeiro.Plano>();
-			dataTable.AsEnumerable().ToList<DataRow>().ForEach((DataRow a) => AuxiliarFinanceiro.Plano.Add(new Gestor.Model.Domain.Financeiro.Plano()
-			{
-				Id = a.Field<long>("id"),
-				Descricao = a.Field<string>("nome"),
-				Ativo = (a.Field<object>("ativo") == null ? true : a.Field<object>("ativo").ToString() == "1")
-			}));
-			dataTable = new DataTable();
-			sqlCommand.CommandText = "SELECT DISTINCT cs.idcplanos as id, cs.descricao as nome, cs.ativo, cs.idcplano, cp.descricao FROM cplanos cs INNER JOIN cplano cp ON cs.idcplano = cp.idcplano;";
-			using (SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter())
-			{
-				sqlDataAdapter1.SelectCommand = sqlCommand;
-				sqlDataAdapter1.Fill(dataTable);
-			}
-			AuxiliarFinanceiro.Planos = new List<Gestor.Model.Domain.Financeiro.Planos>();
-			dataTable.AsEnumerable().ToList<DataRow>().ForEach((DataRow a) => AuxiliarFinanceiro.Planos.Add(new Gestor.Model.Domain.Financeiro.Planos()
-			{
-				Id = a.Field<long>("id"),
-				Descricao = a.Field<string>("nome"),
-				Nome = a.Field<string>("descricao"),
-				Ativo = (a.Field<object>("ativo") == null ? true : a.Field<object>("ativo").ToString() == "1"),
-				Plano = AuxiliarFinanceiro.Plano.FirstOrDefault<Gestor.Model.Domain.Financeiro.Plano>((Gestor.Model.Domain.Financeiro.Plano x) => {
-					if (x == null)
-					{
-						return false;
-					}
-					return x.Id == a.Field<long>("idcplano");
-				})
-			}));
-			dataTable = new DataTable();
-			sqlCommand.CommandText = "SELECT DISTINCT idconta as id, descricao as nome, ativo FROM conta;";
-			using (SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter())
-			{
-				sqlDataAdapter2.SelectCommand = sqlCommand;
-				sqlDataAdapter2.Fill(dataTable);
-			}
-			AuxiliarFinanceiro.Contas = new List<BancosContas>();
-			dataTable.AsEnumerable().ToList<DataRow>().ForEach((DataRow a) => AuxiliarFinanceiro.Contas.Add(new BancosContas()
-			{
-				Id = a.Field<long>("id"),
-				Descricao = a.Field<string>("nome"),
-				Ativo = (a.Field<object>("ativo") == null ? true : a.Field<object>("ativo").ToString() == "1")
-			}));
-			dataTable = new DataTable();
-			sqlCommand.CommandText = "SELECT DISTINCT idcentro as id, descricao as nome, ativo FROM centro;";
-			using (SqlDataAdapter sqlDataAdapter3 = new SqlDataAdapter())
-			{
-				sqlDataAdapter3.SelectCommand = sqlCommand;
-				sqlDataAdapter3.Fill(dataTable);
-			}
-			AuxiliarFinanceiro.Centros = new List<Centro>();
-			dataTable.AsEnumerable().ToList<DataRow>().ForEach((DataRow a) => AuxiliarFinanceiro.Centros.Add(new Centro()
-			{
-				Id = a.Field<long>("id"),
-				Descricao = a.Field<string>("nome"),
-				Ativo = (a.Field<object>("ativo") == null ? true : a.Field<object>("ativo").ToString() == "1")
-			}));
-			dataTable = new DataTable();
-			sqlCommand.CommandText = "SELECT DISTINCT idtipoconta as id, descricao as nome, ativo FROM tipoconta;";
-			using (SqlDataAdapter sqlDataAdapter4 = new SqlDataAdapter())
-			{
-				sqlDataAdapter4.SelectCommand = sqlCommand;
-				sqlDataAdapter4.Fill(dataTable);
-			}
-			AuxiliarFinanceiro.TiposConta = new List<TipoConta>();
-			dataTable.AsEnumerable().ToList<DataRow>().ForEach((DataRow a) => AuxiliarFinanceiro.TiposConta.Add(new TipoConta()
-			{
-				Id = a.Field<long>("id"),
-				Descricao = a.Field<string>("nome"),
-				Ativo = (a.Field<object>("ativo") == null ? true : a.Field<object>("ativo").ToString() == "1")
-			}));
-		}
-	}
-}
-\ No newline at end of file