private void CarregarListaClientes()
{
Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Info, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment });
Gradual.Generico.Dados.AcessaDados lAcessaDados = new Gradual.Generico.Dados.AcessaDados();
string lCommand = "SELECT DISTINCT ID_CLIENTE FROM TB_SUITA_REL ORDER BY ID_CLIENTE";
lAcessaDados.ConnectionStringName = "Cadastro";
using (System.Data.Common.DbCommand lDbCommand = lAcessaDados.CreateCommand(System.Data.CommandType.Text, lCommand))
{
System.Data.DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand);
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i <= lDataTable.Rows.Count - 1; i++)
{
if (!gListaClientes.Contains((lDataTable.Rows[i]["id_cliente"]).DBToString()))
{
gListaClientes.Add((lDataTable.Rows[i]["id_cliente"]).DBToString());
}
}
}
}
}
public string GetCpf(string Codigo)
{
using (var acessaDados = new Gradual.Generico.Dados.AcessaDados())
{
acessaDados.ConnectionStringName = base.ConexaoTrade;
try
{
using (DbCommand dbCommand = acessaDados.CreateCommand(CommandType.StoredProcedure, "prc_get_cpf_by_codigo"))
{
acessaDados.AddInParameter(dbCommand, "pCodigo", DbType.Int64, Codigo.DBToInt64());
acessaDados.AddOutParameter(dbCommand, "pCPF", DbType.Int64, 8);
acessaDados.ExecuteNonQuery(dbCommand);
return(dbCommand.Parameters["pCPF"].Value.ToString());
}
}
catch (System.Data.OracleClient.OracleException) { return("00000"); }
}
}
private void CarregarListaClientePerfil()
{
try
{
Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Info, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment });
Gradual.Generico.Dados.AcessaDados lAcessaDados = new Gradual.Generico.Dados.AcessaDados();
//string lCommand = "SELECT * FROM TB_SUITA_REL where dt_realizacao is not null";
string lCommand = "select id_cliente, ds_nome, ds_cpfcnpj, ds_fonte, cd_codigo, ds_perfil, CONVERT(DATETIME, ISNULL(dt_realizacao, '1900-01-01')) as dt_realizacao from tb_suita_rel";
lAcessaDados.ConnectionStringName = "Cadastro";
using (System.Data.Common.DbCommand lDbCommand = lAcessaDados.CreateCommand(System.Data.CommandType.Text, lCommand))
{
System.Data.DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand);
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i <= lDataTable.Rows.Count - 1; i++)
{
//id_cliente, ds_nome, ds_cpfcnpj, cd_codigo, ds_perfil, dt_realizacao
ClientePerfil lClientePerfil = new ClientePerfil();
lClientePerfil.id_cliente = (lDataTable.Rows[i]["id_cliente"]).DBToString();
lClientePerfil.ds_nome = (lDataTable.Rows[i]["ds_nome"]).DBToString();
lClientePerfil.ds_cpfcnpj = (lDataTable.Rows[i]["ds_cpfcnpj"]).DBToString();
lClientePerfil.cd_codigo = (lDataTable.Rows[i]["cd_codigo"]).DBToString();
lClientePerfil.ds_fonte = (lDataTable.Rows[i]["ds_fonte"]).DBToString();
lClientePerfil.ds_perfil = (lDataTable.Rows[i]["ds_perfil"]).DBToString();
lClientePerfil.dt_realizacao = Convert.ToDateTime((lDataTable.Rows[i]["dt_realizacao"]).DBToString());
gListaCLientePerfil.Add(lClientePerfil);
}
}
}
}
catch (Exception ex)
{
Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Error, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment }, ex);
}
}
