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")
			}));
		}
	}
}