public static void testeInserirAcaoNaCarteira(Acao stock)
{
//Carteira cart = new Carteira();
//cart.ICodigo = 0;
//cart.StrNome = "Carteira_lol";
//cart.Usuario.ICodigo = 0;
//AcaoAPL.inserirAcaoCarteira(cart, stock);
}
internal static void inserirAcaoCarteira(Carteira cart, Acao stock)
{
MySqlConnection msc = new MySqlConnection("Server=cusko.db.8505846.hostedresource.com;Database=cusko;Uid=cusko;Pwd=Teste1234;");
string sql = "insert into cusko.Carteira_has_Acao (Carteira_idCarteira, Acao_idAcao) values (" + cart.ICodigo + "," + stock.ICodigo + ")";
MySqlCommand msCommand = new MySqlCommand(sql, msc);
try
{
msc.Open();
msCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
msc.Close();
MySqlConnection.ClearAllPools();
}
}
internal static HistMovimentacao listarUltimaNegociacaoAcao(Acao item)
{
MySqlConnection msc = new MySqlConnection("Server=cusko.db.8505846.hostedresource.com;Database=cusko;Uid=cusko;Pwd=Teste1234;");
string sql = "select * from HistoricoMovimentacao hm inner join Acao a on (a.idAcao = hm.Acao_idAcao) where Acao_idAcao = " + item.ICodigo + " order by data desc limit 1 ";
HistMovimentacao asd = new HistMovimentacao();
MySqlCommand msCommand = new MySqlCommand(sql, msc);
try
{
msc.Open();
MySqlDataReader lol = msCommand.ExecuteReader();
if (lol.HasRows)
{
while (lol.Read())
{
asd = new HistMovimentacao();
asd.Acao.ICodigo = int.Parse(lol["Acao_idAcao"].ToString());
asd.DtNegociada = DateTime.Parse(lol["data"].ToString());
asd.FValorNegociado = float.Parse(lol["valor"].ToString());
asd.Acao.StrSimbolo = lol["symbol"].ToString();
asd.IQuantidadeNegociada = int.Parse(lol["volume"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
MySqlConnection.ClearAllPools();
msc.Close();
}
return asd;
}
internal static List<Acao> listarAcoes()
{
List<Acao> LstAcao = new List<Acao>();
MySqlConnection msc = new MySqlConnection("Server=cusko.db.8505846.hostedresource.com;Database=cusko;Uid=cusko;Pwd=Teste1234;");
string sql = "select * from Acao ac inner join Bolsa bl on (ac.Bolsa_idBolsa = bl.idBolsa) ";
MySqlCommand msCommand = new MySqlCommand(sql, msc);
try
{
msc.Open();
MySqlDataReader lol = msCommand.ExecuteReader();
Acao stock = new Acao();
if (lol.HasRows)
{
while (lol.Read())
{
stock = new Acao();
stock.ICodigo = int.Parse(lol["idAcao"].ToString());
stock.StrSimbolo = lol["symbol"].ToString();
stock.StrBolsa = lol["nome"].ToString();
LstAcao.Add(stock);
}
}
}
catch
{
}
finally
{
msc.Close();
}
return LstAcao;
}
internal static List<Acao> listarAcoesCarteira(Carteira cart)
{
string sql = "select * from Carteira_has_Acao where Carteira_idCarteira = " + cart.ICodigo;
MySqlConnection msc = new MySqlConnection("Server=cusko.db.8505846.hostedresource.com;Database=cusko;Uid=cusko;Pwd=Teste1234;");
MySqlCommand msCommand = new MySqlCommand(sql, msc);
List<Acao> LstAcao = new List<Acao>();
try
{
msc.Open();
MySqlDataReader mdr = msCommand.ExecuteReader();
if (mdr.HasRows)
{
Acao stock = new Acao();
while (mdr.Read())
{
stock = new Acao();
stock.ICodigo = int.Parse(mdr["Acao_idAcao"].ToString());
stock = AcaoDAO.obterAcao(stock);
LstAcao.Add(stock);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
msc.Close();
}
return LstAcao;
}
private static Acao obterAcao(Acao stock)
{
string sql = "select * from Acao ac inner join Bolsa bl on (bl.idBolsa = ac.Bolsa_idBolsa) where ac.idAcao = " + stock.ICodigo;
MySqlConnection msc = new MySqlConnection("Server=cusko.db.8505846.hostedresource.com;Database=cusko;Uid=cusko;Pwd=Teste1234;");
MySqlCommand msCommand = new MySqlCommand(sql, msc);
Acao acao = new Acao();
try
{
msc.Open();
MySqlDataReader mdr = msCommand.ExecuteReader();
if (mdr.HasRows)
{
while (mdr.Read())
{
acao = stock;
acao.StrSimbolo = mdr["symbol"].ToString();
acao.StrBolsa = mdr["nome"].ToString();
//acao.DDividendos = double.Parse(mdr["dividendos"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
msc.Close();
}
return acao;
}
public static void inserirAcaoCarteira(Carteira cart, Acao stock)
{
AcaoDAO.inserirAcaoCarteira(cart, stock);
}
