/// <summary> /// ObterDadosIndice - busca dados de índice /// </summary> /// <returns></returns> public List <ComposicaoIndice.ItemIndice> ObterDadosIndice() { List <ComposicaoIndice.ItemIndice> listaIndice = new List <ComposicaoIndice.ItemIndice>(); SqlConnection conn = null; try { conn = new SqlConnection(ConfigurationManager.AppSettings["OMS"]); conn.Open(); SqlCommand Command = new SqlCommand(); Command.CommandType = CommandType.StoredProcedure; Command.Connection = conn; Command.CommandText = "prc_TB_ATIVO_indices_sel"; SqlDataReader dtDados = Command.ExecuteReader(); if (dtDados.HasRows) { while (dtDados.Read()) { ComposicaoIndice.ItemIndice item = new ComposicaoIndice.ItemIndice(); item.indice = dtDados.GetSqlString(0).Value; item.codigoIndice = dtDados.IsDBNull(1) ? 0 : dtDados.GetInt32(1); item.fechamento = dtDados.IsDBNull(2) ? 0 : dtDados.GetSqlDecimal(2).ToDouble(); item.oscilacao = dtDados.IsDBNull(3) ? 0 : dtDados.GetSqlDecimal(3).ToDouble(); item.dataCotacao = dtDados.IsDBNull(4) ? new DateTime(1970, 1, 1) : dtDados.GetDateTime(4); listaIndice.Add(item); } } } catch (SqlException ex) { logger.Error("ObterDadosIndice(): " + ex.Message + "-" + ex.ErrorCode, ex); } catch (Exception ex) { logger.Error("ObterDadosIndice(): " + ex.Message, ex); } finally { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); conn.Dispose(); } } return(listaIndice); }
/// <summary> /// AtualizarTbAtivo - atualiza item na tabela TB_ATIVO. /// </summary> /// <returns></returns> public void InserirTbHistoricoAtivo(ComposicaoIndice.ItemIndice item) { SqlConnection conn = null; try { conn = new SqlConnection(ConfigurationManager.AppSettings["OMS"]); conn.Open(); SqlCommand Command = new SqlCommand(); Command.CommandType = CommandType.StoredProcedure; Command.Connection = conn; Command.CommandText = "prc_TB_HISTORICO_INDICE_ins"; Command.Parameters.AddWithValue("@id_indice", item.codigoIndice); Command.Parameters.AddWithValue("@dt_cotacao", item.dataCotacao.Date); Command.Parameters.AddWithValue("@vl_fechamento", item.valor); Command.Parameters.AddWithValue("@vl_oscilacao", item.oscilacao); Command.ExecuteNonQuery(); Command.Dispose(); } catch (SqlException ex) { logger.Error("InserirTbHistoricoAtivo(): " + ex.Message + "-" + ex.ErrorCode, ex); } catch (Exception ex) { logger.Error("InserirTbHistoricoAtivo(): " + ex.Message, ex); } finally { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); conn.Dispose(); } } }
/// <summary> /// AtualizarTbAtivo - atualiza item na tabela TB_ATIVO. /// </summary> /// <returns></returns> public void AtualizarTbAtivo(ComposicaoIndice.ItemIndice item) { SqlConnection conn = null; try { conn = new SqlConnection(ConfigurationManager.AppSettings["OMS"]); conn.Open(); SqlCommand Command = new SqlCommand(); Command.CommandType = CommandType.StoredProcedure; Command.Connection = conn; Command.CommandText = "prc_TB_ATIVO_upd"; Command.Parameters.AddWithValue("@id_Ativo", item.codigoIndice); Command.Parameters.AddWithValue("@vl_fechamento", item.valor); Command.ExecuteNonQuery(); Command.Dispose(); } catch (SqlException ex) { logger.Error("AtualizarTbAtivo(): " + ex.Message + "-" + ex.ErrorCode, ex); } catch (Exception ex) { logger.Error("AtualizarTbAtivo(): " + ex.Message, ex); } finally { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); conn.Dispose(); } } }