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