private void btnExcluir_Click(object sender, EventArgs e) { if (lvVoos.SelectedItems.Count > 0) { int deleteId = Convert.ToInt32(labelId.Text); DalHelper.Delete(deleteId); ExibirDados(); LimpaCampos(); } }
private void ExibirDados() { DataTable dt = new DataTable(); dt = DalHelper.GetVoos(); lvVoos.Items.Clear(); foreach (DataRow dr in dt.Rows) { ListViewItem lvi = new ListViewItem(); lvi.Text = dr["DATA_VOO"].ToString().Replace("00:00:00", ""); lvi.SubItems.Add(dr["CAPTURA"].ToString()); lvi.SubItems.Add(dr["NIVEL_DOR"].ToString()); lvi.SubItems.Add(dr["ID_VOO"].ToString()); lvi.SubItems.Add(dr["Distancia"].ToString()); lvi.SubItems.Add(dr["Custo"].ToString()); lvVoos.Items.Add(lvi); } lvVoos.View = View.Details; }
private void btnSalvar_Click(object sender, EventArgs e) { if (lvVoos.SelectedItems.Count > 0) { if (int.Parse(txtDor.Text) > 10)// | (int.Parse(txtDor.Text) < 0)) { MessageBox.Show("Valor digitado deve ser de 1 a 10!", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDor.Clear(); txtDor.Focus(); } else { try { Voo voo = new Voo(); int updateId = Convert.ToInt32(labelId.Text); voo.Id = updateId; voo.Data = Convert.ToDateTime(mtxtData.Text); voo.Custo = Convert.ToDouble(txtCusto.Text); voo.Distancia = Convert.ToInt32(txtDistancia.Text); voo.Captura = Convert.ToString(rbSim.Checked ? "S" : "N"); voo.Dor = Convert.ToInt32(txtDor.Text); DalHelper.Update(voo); ExibirDados(); LimpaCampos(); } catch (Exception ex) { MessageBox.Show("Erro : " + ex.Message); } } } if (lvVoos.SelectedItems.Count == 0) { if (int.Parse(txtDor.Text) > 10)// | (int.Parse(txtDor.Text) < 0)) { MessageBox.Show("Valor digitado deve ser de 1 a 10!", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDor.Clear(); txtDor.Focus(); } else { try { Voo voo = new Voo(); voo.Data = Convert.ToDateTime(mtxtData.Text); voo.Custo = Convert.ToDouble(txtCusto.Text); voo.Distancia = Convert.ToInt32(txtDistancia.Text); voo.Captura = Convert.ToString(rbSim.Checked ? "S" : "N"); voo.Dor = Convert.ToInt32(txtDor.Text); DalHelper.Add(voo); } catch (Exception ex) { MessageBox.Show("Erro : " + ex.Message); } LimpaCampos(); DesativaCampos(); ExibirDados(); } } }