/// <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();
}
}
}
