private void btnEditar_Click(object sender, EventArgs e)
{
CadastroTrans a = new CadastroTrans();
a.setId(int.Parse(txtId.Text));
a.setdataTrans(DateTime.Parse(txtData.Text));
a.setDestino(cbDestino.SelectedItem.ToString());
a.setMoeda(cbMoeda.SelectedItem.ToString());
a.setOrigem(cbOrigem.SelectedItem.ToString());
a.setValor(Double.Parse(txtValord.Text));
TransacaoDAO.atualizarTrans(a);
listarTable();
txtId.Clear();
txtData.Clear();
txtValord.Clear();
}
public CadastroTrans listarUsu(int id)
{
if (conn.State == ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand("select * from Transacao where idTransacao = @id", conn);
cmd.Parameters.AddWithValue("@id", id);
try
{
CadastroTrans a = new CadastroTrans();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
a.setId(int.Parse(reader[0].ToString()));
a.setValor(double.Parse(reader[1].ToString()));
a.setdataTrans(DateTime.Parse(reader[2].ToString()));
SqlCommand cmd1 = new SqlCommand("SELECT Nome FROM Usuario WHERE idCarteira=@1", conn1);
cmd1.Parameters.AddWithValue("@1", reader[3]);
SqlDataReader reader1 = cmd.ExecuteReader();
if (reader1.Read())
{
a.setOrigem(reader[0].ToString());
}
cmd1.Dispose();
reader1.Close();
cmd1 = new SqlCommand("SELECT NomeMoeda FROM Moeda WHERE idMoeda=@1", conn1);
cmd1.Parameters.AddWithValue("@1", reader[4]);
reader1 = cmd.ExecuteReader();
if (reader1.Read())
{
a.setMoeda(reader[0].ToString());
}
cmd1.Dispose();
reader1.Close();
cmd1 = new SqlCommand("SELECT Nome FROM Usuario WHERE idCarteira=@1", conn1);
cmd1.Parameters.AddWithValue("@1", reader[5]);
reader1 = cmd.ExecuteReader();
if (reader1.Read())
{
a.setDestino(reader[0].ToString());
}
cmd1.Dispose();
reader1.Close();
return(a);
}
else
{
return(null);
}
}
catch (Exception error)
{
MessageBox.Show("Erro: " + error);
return(null);
}
finally
{
classeConexão.fecharConexao();
}
}
else
{
return(null);
}
}
