diff options
| author | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
|---|---|---|
| committer | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
| commit | 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 (patch) | |
| tree | e1c3b20ea08f0cf71122a1e73f0d395f8fd83874 /Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs | |
| parent | 674ca83ba9243a9e95a7568c797668dab6aee26a (diff) | |
| download | gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.tar.gz gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.zip | |
chore: location
Diffstat (limited to 'Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs')
| -rw-r--r-- | Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs | 127 |
1 files changed, 127 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs new file mode 100644 index 0000000..b9ecf17 --- /dev/null +++ b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/AuxiliarFinanceiro.cs @@ -0,0 +1,127 @@ +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 |