Exemple #1
0
        public List <BlockedInstrumentInfo> CarregarPermissaoAtivo()
        {
            try
            {
                List <BlockedInstrumentInfo> ret = null;
                SqlDataAdapter lAdapter;
                _abrirConexao(_strConnectionStringDefault);
                DataSet lDataSet = new DataSet();
                _sqlCommand             = new SqlCommand("prc_lmt_verificar_permissao_ativo", _sqlConn);
                _sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
                lAdapter = new SqlDataAdapter(_sqlCommand);
                lAdapter.Fill(lDataSet);
                if (lDataSet.Tables.Count > 0)
                {
                    if (lDataSet.Tables[0].Rows.Count > 0)
                    {
                        ret = new List <BlockedInstrumentInfo>();
                    }
                    foreach (DataRow lRow in lDataSet.Tables[0].Rows)
                    {
                        BlockedInstrumentInfo item = new BlockedInstrumentInfo();

                        char sentido = lRow["sentido"].DBToString()[0];
                        switch (sentido)
                        {
                        case 'V':
                            item.Sentido = SentidoBloqueioEnum.Venda; break;

                        case 'C':
                            item.Sentido = SentidoBloqueioEnum.Compra; break;

                        default:
                            item.Sentido = SentidoBloqueioEnum.Ambos; break;
                        }
                        item.Instrumento = lRow["ds_item"].DBToString();
                        ret.Add(item);
                    }
                }
                _fecharConexao();
                lAdapter.Dispose();
                lDataSet.Dispose();
                _sqlCommand.Dispose();
                return(ret);
            }
            catch (Exception ex)
            {
                logger.Error("Erro ao obter permissao global dos instrumentos: " + ex.Message, ex);
                return(null);
            }
        }
Exemple #2
0
        public List <BlockedInstrumentInfo> CarregarPermissaoAtivoCliente(int account)
        {
            try
            {
                List <BlockedInstrumentInfo> ret = null;
                SqlDataAdapter lAdapter;
                _abrirConexao(_strConnectionStringDefault);
                DataSet lDataSet = new DataSet();
                _sqlCommand = new SqlCommand("prc_lmt_sel_cliente_bloqueio_instrumento", _sqlConn);
                _sqlCommand.Parameters.Add(new SqlParameter("@id_cliente", account));
                _sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
                lAdapter = new SqlDataAdapter(_sqlCommand);
                lAdapter.Fill(lDataSet);
                if (lDataSet.Tables.Count > 0)
                {
                    ret = new List <BlockedInstrumentInfo>();
                    foreach (DataRow lRow in lDataSet.Tables[0].Rows)
                    {
                        BlockedInstrumentInfo item = new BlockedInstrumentInfo();
                        char sentido = lRow["Direcao"].DBToString()[0];
                        switch (sentido)
                        {
                        case 'V':
                            item.Sentido = SentidoBloqueioEnum.Venda; break;

                        case 'C':
                            item.Sentido = SentidoBloqueioEnum.Compra; break;

                        default:
                            item.Sentido = SentidoBloqueioEnum.Ambos; break;
                        }
                        item.Instrumento = lRow["cd_ativo"].DBToString();
                        item.IdCliente   = lRow["id_cliente"].DBToInt32();
                        ret.Add(item);
                    }
                }
                _fecharConexao();
                lAdapter.Dispose();
                lDataSet.Dispose();
                _sqlCommand.Dispose();
                return(ret);
            }
            catch (Exception ex)
            {
                logger.Error("Erro ao obter parametros de instrumentos do clientes: " + ex.Message, ex);
                return(null);
            }
        }