private void txtChecar_Click(object sender, EventArgs e) { chart1.Series.Clear(); a.setNome(cbMoeda.SelectedItem.ToString()); int aux = b.getIds(a); chart1.Series.Add("Preco"); chart1.Series["Preco"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; chart1.Series["Preco"].XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.DateTime; listarHistorico(aux); }
private void btnCad_Click(object sender, EventArgs e) { if (txt_Nome.Text != "" && txt_Valor.Text != "") { a.setNome(txt_Nome.Text); string bufunfa = txt_Valor.Text; bufunfa = bufunfa.Replace("R$", string.Empty); bufunfa = bufunfa.Replace(" ", string.Empty); a.setValor(Double.Parse(bufunfa)); b.criarMoeda(a); } }
private void btnEditar_Click(object sender, EventArgs e) { CadastroMoeda a = new CadastroMoeda(); a.setId(int.Parse(txtId.Text)); a.setNome(txtNome.Text); a.setValor(Double.Parse(txtValor.Text)); a.setAttt(DateTime.Parse(txtAtt.Text)); consultaDao.atualizarMoeda(a); listarTable(); txtId.Clear(); txtNome.Clear(); txtAtt.Clear(); txtValor.Clear(); }
public CadastroMoeda listarMoeda(int id) { conn1 = classeConexão.obterConexao(); if (conn1.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand("select * from Moeda where idMoeda = @id", conn1); cmd.Parameters.AddWithValue("@id", id); try { CadastroMoeda a = new CadastroMoeda(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { a.setId(int.Parse(reader[0].ToString())); a.setNome(reader[1].ToString()); a.setValor(Double.Parse(reader[2].ToString())); a.setAttt(DateTime.Parse(reader[3].ToString())); return(a); } else { return(null); } } catch (Exception error) { MessageBox.Show("Erro: " + error); return(null); } finally { classeConexão.fecharConexao(); } } else { MessageBox.Show("Erro: " + conn1.State.ToString()); return(null); } }