예제 #1
0
        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>");
            }
        }
예제 #2
0
        public void AtualizaGrid()
        {
            DALFinanca dal = new DALFinanca();

            GridView1.DataSource = dal.Listar();
            GridView1.DataBind();
        }
예제 #3
0
        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();
        }
예제 #4
0
        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";
        }