public EntCarteira Inserir(EntCarteira objCarteira, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_CarteiraInserir");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddOutParameter(dbCommand, "@CDA_CARTEIRA", DbType.Int32, objCarteira.IdCarteira);
db.AddInParameter(dbCommand, "@TX_CARTEIRA", DbType.String, objCarteira.Carteira);
db.AddInParameter(dbCommand, "@CEA_USUARIO", DbType.Int32, IntUtils.ToIntNullProc(objCarteira.Usuario.IdUsuario));
db.AddInParameter(dbCommand, "@SALDO_REAIS", DbType.Decimal, objCarteira.SaldoReais);
db.AddInParameter(dbCommand, "@SALDO_DOLAR", DbType.Decimal, objCarteira.SaldoDolar);
db.AddInParameter(dbCommand, "@SALDO_BITCOIN", DbType.Decimal, objCarteira.SaldoBitcoin);
db.AddInParameter(dbCommand, "@SALDO_REAIS2", DbType.Decimal, objCarteira.SaldoReais2);
db.AddInParameter(dbCommand, "@SALDO_DOLAR2", DbType.Decimal, objCarteira.SaldoDolar2);
db.AddInParameter(dbCommand, "@SALDO_BITCOIN2", DbType.Decimal, objCarteira.SaldoBitcoin2);
db.AddInParameter(dbCommand, "@PERCENTUAL_TAXA_COMPRA", DbType.Decimal, objCarteira.PercentualTaxaCompra);
db.AddInParameter(dbCommand, "@PERCENTUAL_TAXA_VENDA", DbType.Decimal, objCarteira.PercentualTaxaVenda);
db.AddInParameter(dbCommand, "@PERCENTUAL_LUCRO", DbType.Decimal, objCarteira.PercentualLucro);
db.AddInParameter(dbCommand, "@CEA_MOEDA", DbType.Int32, IntUtils.ToIntNullProc(objCarteira.Moeda.IdMoeda));
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objCarteira.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
objCarteira.IdCarteira = ObjectUtils.ToInt(db.GetParameterValue(dbCommand, "@CDA_CARTEIRA"));
return(objCarteira);
}
public EntResumoDiario Inserir(EntResumoDiario objResumoDiario, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_ResumoDiarioInserir");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddOutParameter(dbCommand, "@CDA_RESUMO_DIARIO", DbType.Int32, objResumoDiario.IdResumoDiario);
db.AddInParameter(dbCommand, "@TX_RESUMO_DIARIO", DbType.String, objResumoDiario.ResumoDiario);
db.AddInParameter(dbCommand, "@QUANTIDADE", DbType.Decimal, objResumoDiario.Quantidade);
db.AddInParameter(dbCommand, "@MELHOR_COMPRA", DbType.Decimal, objResumoDiario.MelhorCompra);
db.AddInParameter(dbCommand, "@MELHOR_VENDA", DbType.Decimal, objResumoDiario.MelhorVenda);
db.AddInParameter(dbCommand, "@VOLUME", DbType.Decimal, objResumoDiario.Volume);
db.AddInParameter(dbCommand, "@PRECO_ULTIMA_TRANSACAO", DbType.Decimal, objResumoDiario.PrecoUltimaTransacao);
db.AddInParameter(dbCommand, "@VALOR_MAXIMO", DbType.Decimal, objResumoDiario.ValorMaximo);
db.AddInParameter(dbCommand, "@VALOR_MINIMO", DbType.Decimal, objResumoDiario.ValorMinimo);
db.AddInParameter(dbCommand, "@DT_DATA", DbType.DateTime, objResumoDiario.Data);
db.AddInParameter(dbCommand, "@CEA_MOEDA", DbType.Int32, IntUtils.ToIntNullProc(objResumoDiario.Moeda.IdMoeda));
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objResumoDiario.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
objResumoDiario.IdResumoDiario = ObjectUtils.ToInt(db.GetParameterValue(dbCommand, "@CDA_RESUMO_DIARIO"));
return(objResumoDiario);
}
public EntOperacao Inserir(EntOperacao objOperacao, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_OperacaoInserir");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddOutParameter(dbCommand, "@CDA_OPERACAO", DbType.Int32, objOperacao.IdOperacao);
db.AddInParameter(dbCommand, "@TX_OPERACAO", DbType.String, objOperacao.Operacao);
db.AddInParameter(dbCommand, "@DT_DATA_CRIACAO", DbType.DateTime, objOperacao.DataCriacao);
db.AddInParameter(dbCommand, "@DT_DATA_INICIO_EXECUCAO", DbType.DateTime, DateUtils.ToDateObject(objOperacao.DataInicioExecucao));
db.AddInParameter(dbCommand, "@DT_DATA_FIM_EXECUCAO", DbType.DateTime, DateUtils.ToDateObject(objOperacao.DataFimExecucao));
db.AddInParameter(dbCommand, "@VALOR_REAIS", DbType.Decimal, objOperacao.ValorReais);
db.AddInParameter(dbCommand, "@VALOR_DOLAR", DbType.Decimal, objOperacao.ValorDolar);
db.AddInParameter(dbCommand, "@VALOR_BITCOIN", DbType.Decimal, objOperacao.ValorBitcoin);
db.AddInParameter(dbCommand, "@CEA_CARTEIRA", DbType.Int32, IntUtils.ToIntNullProc(objOperacao.Carteira.IdCarteira));
db.AddInParameter(dbCommand, "@FL_IS_VENDA", DbType.Boolean, objOperacao.IsVenda);
db.AddInParameter(dbCommand, "@TAXA", DbType.Decimal, objOperacao.Taxa);
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objOperacao.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
objOperacao.IdOperacao = ObjectUtils.ToInt(db.GetParameterValue(dbCommand, "@CDA_OPERACAO"));
return(objOperacao);
}
public void Alterar(EntIndicador objIndicador, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_IndicadorAlterar");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@CDA_INDICADOR", DbType.Int32, objIndicador.IdIndicador);
db.AddInParameter(dbCommand, "@TX_INDICADOR", DbType.String, objIndicador.Indicador);
db.AddInParameter(dbCommand, "@DT_DATA", DbType.DateTime, objIndicador.Data);
db.AddInParameter(dbCommand, "@NU_VALOR", DbType.Decimal, objIndicador.Valor);
db.AddInParameter(dbCommand, "@CEA_MOEDA", DbType.Int32, IntUtils.ToIntNullProc(objIndicador.Moeda.IdMoeda));
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objIndicador.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
}
public void Alterar(EntMoeda objMoeda, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_MoedaAlterar");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@CDA_MOEDA", DbType.Int32, objMoeda.IdMoeda);
db.AddInParameter(dbCommand, "@TX_MOEDA", DbType.String, objMoeda.Moeda);
db.AddInParameter(dbCommand, "@TX_CODIGO", DbType.String, objMoeda.Codigo);
db.AddInParameter(dbCommand, "@CEA_OPERACAO_COMPRA", DbType.Int32, IntUtils.ToIntNullProc(objMoeda.OperacaoCompraAberta.IdOperacao));
db.AddInParameter(dbCommand, "@CEA_OPERACAO_VENDA", DbType.Int32, IntUtils.ToIntNullProc(objMoeda.OperacaoVendaAberta.IdOperacao));
db.AddInParameter(dbCommand, "@NU_CASAS_APOS_VIRGULA", DbType.Int32, objMoeda.CasasDepoisDaVirgula);
db.AddInParameter(dbCommand, "@FL_ATIVO", DbType.Boolean, objMoeda.Ativo);
db.ExecuteNonQuery(dbCommand, transaction);
}
public EntLog Inserir(EntLog objLog, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_LogInserir");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddOutParameter(dbCommand, "@CDA_LOG", DbType.Int32, objLog.IdLog);
db.AddInParameter(dbCommand, "@TX_LOG", DbType.String, objLog.Log);
db.AddInParameter(dbCommand, "@NU_TIPO_LOG", DbType.Int32, IntUtils.ToIntNullProc(objLog.TipoLog));
db.AddInParameter(dbCommand, "@DT_EVENTO", DbType.DateTime, DateTime.Now);
db.AddInParameter(dbCommand, "@CEA_USUARIO", DbType.Int32, IntUtils.ToIntNullProc(objLog.Usuario.IdUsuario));
db.ExecuteNonQuery(dbCommand, transaction);
objLog.IdLog = ObjectUtils.ToInt(db.GetParameterValue(dbCommand, "@CDA_LOG"));
return(objLog);
}
/// <summary>
/// Retorna uma lista de entidade de EntUsuario
/// </summary>
/// <autor>Fernando Carvalho</autor>
/// <param name="transaction">Transaction</param>
/// <param name="db">DataBase</param>
/// <returns><list type="EntUsuario">Lista de EntUsuario</list></returns>
public List <EntAdmUsuario> ObterPorFuncionalidade(String nomePagina, Int32 IdEstado, Int32 IdPrograma, Int32 IdTurma, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_SelecionaUsuarioPorFuncionalidade");
db.AddInParameter(dbCommand, "@sNOME_PAGINA", DbType.String, nomePagina);
db.AddInParameter(dbCommand, "@nCEA_ESTADO", DbType.Int32, IntUtils.ToIntNullProc(IdEstado));
db.AddInParameter(dbCommand, "@nCEA_PROGRAMA", DbType.Int32, IdPrograma);
db.AddInParameter(dbCommand, "@nCEA_TURMA", DbType.Int32, IntUtils.ToIntNullProc(IdTurma));
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
using (DbDataReader dtrDados = (System.Data.Common.DbDataReader)db.ExecuteReader(dbCommand, transaction))
{
if (dtrDados != null && dtrDados.HasRows)
{
return(this.Popular(dtrDados));
}
else
{
return(new List <EntAdmUsuario>());
}
}
}
public List <EntLog> ObterTodos(String Log, Int32 IdUsuario, Int32 TipoLog, DateTime DateInicio, DateTime DateFim, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_LogSelecionarTodos");
db.AddInParameter(dbCommand, "@Log", DbType.String, Log);
db.AddInParameter(dbCommand, "@IdUsuario", DbType.Int32, IntUtils.ToIntNullProc(IdUsuario));
db.AddInParameter(dbCommand, "@TipoLog", DbType.Int32, IntUtils.ToIntNullProc(TipoLog));
db.AddInParameter(dbCommand, "@DateInicio", DbType.DateTime, DateInicio);
db.AddInParameter(dbCommand, "@DateFim", DbType.DateTime, DateFim);
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
using (DbDataReader dtrDados = (System.Data.Common.DbDataReader)db.ExecuteReader(dbCommand, transaction))
{
if (dtrDados != null && dtrDados.HasRows)
{
return(this.Popular(dtrDados));
}
else
{
return(new List <EntLog>());
}
}
}
public List <EntCarteira> ObterTodos(String Carteira, Int32 Usuario, Int32 Moeda, Int32 Status, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_CarteiraSelecionarTodos");
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Carteira"), DbType.String, Carteira);
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Usuario"), DbType.Int32, IntUtils.ToIntNullProc(Usuario));
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Moeda"), DbType.Int32, IntUtils.ToIntNullProc(Moeda));
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Status"), DbType.Boolean, IntUtils.ToBooleanNullProc(Status));
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
using (DbDataReader dtrDados = (System.Data.Common.DbDataReader)db.ExecuteReader(dbCommand, transaction))
{
if (dtrDados != null && dtrDados.HasRows)
{
return(this.Popular(dtrDados));
}
else
{
return(new List <EntCarteira>());
}
}
}
public List <EntIndicador> ObterTodos(String Indicador, Int32 Moeda, DateTime DataInicio, DateTime DataFim, Int32 Status, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_IndicadorSelecionarTodos");
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Indicador"), DbType.String, Indicador);
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Moeda"), DbType.Int32, IntUtils.ToIntNullProc(Moeda));
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("Status"), DbType.Boolean, IntUtils.ToBooleanNullProc(Status));
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("DataInicio"), DbType.DateTime, DataInicio);
db.AddInParameter(dbCommand, StringUtils.TrataParametroProc("DataFim"), DbType.DateTime, DataFim);
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
using (DbDataReader dtrDados = (System.Data.Common.DbDataReader)db.ExecuteReader(dbCommand, transaction))
{
if (dtrDados != null && dtrDados.HasRows)
{
return(this.Popular(dtrDados));
}
else
{
return(new List <EntIndicador>());
}
}
}
/// <summary>
/// Inclui um registro na tabela TurmaEmpresa
/// </summary>
/// <autor>Fernando Carvalho</autor>
/// <param name="objTurmaEmpresa">Entidade que representa a tabela TurmaEmpresa</param>
/// <param name="transaction">Transaction</param>
/// <param name="db">DataBase</param>
/// <returns>Entidade de TurmaEmpresa</returns>
public EntTurmaEmpresa Inserir(EntTurmaEmpresa objTurmaEmpresa, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_InsereTurmaEmpresa");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@nCEA_EMP_CADASTRO", DbType.Int32, objTurmaEmpresa.EmpresaCadastro.IdEmpresaCadastro);
db.AddInParameter(dbCommand, "@nCEA_CATEGORIA", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Categoria.IdCategoria));
db.AddInParameter(dbCommand, "@nCEA_ATIVIDADE_ECONOMICA", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.AtividadeEconomica.IdAtividadeEconomica));
db.AddInParameter(dbCommand, "@nCEA_FATURAMENTO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Faturamento.IdFaturamento));
db.AddInParameter(dbCommand, "@nNU_FUNCIONARIO", DbType.Int32, IntUtils.ToIntNullColaborador(objTurmaEmpresa.NumeroFuncionario));
db.AddInParameter(dbCommand, "@sTX_CEP", DbType.String, StringUtils.ToObject(objTurmaEmpresa.CEP));
db.AddInParameter(dbCommand, "@sTX_ENDERECO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.Endereco));
db.AddInParameter(dbCommand, "@sTX_COMPLEMENTO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.Complemento));
db.AddInParameter(dbCommand, "@sTX_NUMERO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.NumeroEndereco));
db.AddInParameter(dbCommand, "@bFL_ATIVO", DbType.Boolean, true);
db.AddInParameter(dbCommand, "@nCEA_USUARIO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Usuario.IdUsuario));
db.AddInParameter(dbCommand, "@nCEA_CIDADE", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Cidade.IdCidade));
db.AddInParameter(dbCommand, "@dDT_ULTIMA_ALTERACAO", DbType.DateTime, System.DateTime.Now);
db.AddInParameter(dbCommand, "@nCEA_ESTADO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Estado.IdEstado));
db.AddInParameter(dbCommand, "@nCEA_PAIS", DbType.Int32, 1);
db.AddInParameter(dbCommand, "@dDT_CADASTRO", DbType.DateTime, System.DateTime.Now);
db.AddInParameter(dbCommand, "@sTX_ATIVIDADE_ECONOMICA", DbType.String, StringUtils.ToObject(objTurmaEmpresa.AtividadeEconomicaComplemento));
db.AddInParameter(dbCommand, "@bFL_PARTICIPA_PROGRAMA", DbType.Boolean, objTurmaEmpresa.ParticipaPrograma);
db.AddInParameter(dbCommand, "@sTX_NOME_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.NomeContato));
db.AddInParameter(dbCommand, "@sTX_TELEFONE_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.TelefoneContato));
db.AddInParameter(dbCommand, "@sTX_CELULAR_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.CelularContato));
db.AddInParameter(dbCommand, "@sTX_EMAIL_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.EmailContato));
db.AddInParameter(dbCommand, "@sTX_MENSAGEM_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.MensagemContato));
if (objTurmaEmpresa.CPFContato != null)
{
db.AddInParameter(dbCommand, "@sTX_CPF_CONTATO", DbType.String, StringUtils.ToObject(StringUtils.removePontuacaoCpfCnpj(objTurmaEmpresa.CPFContato)));
}
else
{
db.AddInParameter(dbCommand, "@sTX_CPF_CONTATO", DbType.String, DBNull.Value);
}
if (objTurmaEmpresa.NascimentoContato.Year > 1900)
{
db.AddInParameter(dbCommand, "@dDT_DATA_NASCIMENTO_CONTATO", DbType.DateTime, DateUtils.ToObject(objTurmaEmpresa.NascimentoContato));
}
else
{
db.AddInParameter(dbCommand, "@dDT_DATA_NASCIMENTO_CONTATO", DbType.DateTime, DBNull.Value);
}
db.AddInParameter(dbCommand, "@sTX_ENDERECO_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.EnderecoContato));
db.AddInParameter(dbCommand, "@sTX_COMPLEMENTO_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.ComplementoContato));
db.AddInParameter(dbCommand, "@sTX_NUMERO_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.NumeroEnderecoContato));
db.AddInParameter(dbCommand, "@sTX_SEXO_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.SexoContato));
db.AddInParameter(dbCommand, "@nCEA_NIVEL_ESCOLARIDADE", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.ContatoNivelEscolaridade.IdContatoNivelEscolaridade));
db.AddInParameter(dbCommand, "@nCEA_FAIXA_ETARIA", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.FaixaEtaria.IdContatoFaixaEtaria));
db.AddInParameter(dbCommand, "@nCEA_TURMA", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Turma.IdTurma));
db.AddInParameter(dbCommand, "@nCEA_TIPO_EMPRESA", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.TipoEmpresa.IdTipoEmpresa));
db.AddInParameter(dbCommand, "@nCEA_BAIRRO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Bairro.IdBairro));
db.AddInParameter(dbCommand, "@nCEA_CARGO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.Cargo.IdCargo));
db.AddInParameter(dbCommand, "@sTX_CEP_CONTATO", DbType.String, StringUtils.ToObject(objTurmaEmpresa.CEPContato));
db.AddInParameter(dbCommand, "@bFL_PERGUNTA1", DbType.Boolean, BooleanUtils.ToObject(objTurmaEmpresa.Pergunta1));
db.AddInParameter(dbCommand, "@bFL_PERGUNTA2", DbType.Boolean, BooleanUtils.ToObject(objTurmaEmpresa.Pergunta2));
db.AddInParameter(dbCommand, "@bFL_PERGUNTA3", DbType.Boolean, BooleanUtils.ToObject(objTurmaEmpresa.Pergunta3));
db.AddInParameter(dbCommand, "@bFL_PERGUNTA4", DbType.Boolean, BooleanUtils.ToObject(objTurmaEmpresa.Pergunta4));
db.AddInParameter(dbCommand, "@nCEA_ESTADO_CONTATO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.EstadoContato.IdEstado));
db.AddInParameter(dbCommand, "@nCEA_CIDADE_CONTATO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.CidadeContato.IdCidade));
db.AddInParameter(dbCommand, "@nCEA_BAIRRO_CONTATO", DbType.Int32, IntUtils.ToIntNullProc(objTurmaEmpresa.BairroContato.IdBairro));
db.ExecuteNonQuery(dbCommand, transaction);
return(objTurmaEmpresa);
}
