protected void btSalvar_Click(object sender, EventArgs e) { try { DALFinanca dal = new DALFinanca(); Financa obj = new Financa(); obj.Data = CData.SelectedDate; obj.Descricao = txbDescricao.Text; obj.Tipo = DLTipo.SelectedItem.Text; obj.Valor = Convert.ToDouble(txbValor.Text); obj.Usuario = Convert.ToInt32(Session["id"]); string msg = "<script> alert('Registro atualizado com sucesso!!!!'); </script>"; if (txbId.Text == "") { //inserir dal.Inserir(obj); msg = "<script> alert('O código gerado foi: " + obj.Id.ToString() + "'); </script>"; } else { obj.Id = Convert.ToInt32(txbId.Text); dal.Alterar(obj); } Response.Write(msg); LimpaCampos(); } catch (Exception erro) { Response.Write("<script> alert('" + erro.Message + "'); </script>"); } }
public void AtualizaGrid() { DALFinanca dal = new DALFinanca(); GridView1.DataSource = dal.Listar(); GridView1.DataBind(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); int cod = Convert.ToInt32(GridView1.Rows[index].Cells[2].Text); DALFinanca dal = new DALFinanca(); dal.Excluir(cod); AtualizaGrid(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { int index = GridView1.SelectedIndex; int cod = Convert.ToInt32(GridView1.Rows[index].Cells[2].Text); DALFinanca dal = new DALFinanca(); Financa f = dal.GetRegistro(cod); txbId.Text = f.Id.ToString(); txbDescricao.Text = f.Descricao; txbValor.Text = f.Valor.ToString(); if (f.Tipo == "Receita") { DLTipo.SelectedIndex = 0; } else { DLTipo.SelectedIndex = 1; } CData.SelectedDate = f.Data; btSalvar.Text = "Alterar"; }