//Evento responsavel por cadastrar um novo registro ou atualizar o registro jс existente
    protected void BtnCadastrar_Click(object sender, EventArgs e)
    {
        try
        {
            ConvenioBE convenioBE = new ConvenioBE();
            convenioBE.id = Convert.ToInt32(Request.QueryString["id"]);
            convenioBE.Nome = Convert.ToString(txtNome.Text);
            convenioBE.Valor = Convert.ToDouble(txtValor.Text);

            ConvenioDAL convenioDAL = new ConvenioDAL();
            if (Request.QueryString["id"] != null)
            {
                //Chamo o metodo que altera o registro
                convenioDAL.Alterar(convenioBE);
            }
            else
            {
                //Chamo o metodo que insere um novo registro
                convenioDAL.Incluir(convenioBE);

            }
            Response.Redirect("Convenio.aspx");
        }
        catch (Exception ex)
        {
            Label lblErro = (Label)Master.FindControl("lblErro");
            lblErro.Text = ex.ToString();
        }
    }
 public void MontaComboConvenio()
 {
     ConvenioDAL convenioDAL = new ConvenioDAL();
     ddlConvenio.DataSource = convenioDAL.Listar(null);
     ddlConvenio.DataTextField = "Nome";
     ddlConvenio.DataValueField = "ID";
     ddlConvenio.DataBind();
     ddlConvenio.Items.Insert(0, new ListItem("<--Selecione-->", string.Empty)); //Texto Inicial do combo
 }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Editar")
        {
            Response.Redirect("ConvenioCadastrar.aspx?id=" + e.CommandArgument);
        }

        if (e.CommandName == "Apagar")
        {
            ConvenioDAL convenioDAL = new ConvenioDAL();
            convenioDAL.Excluir(Convert.ToInt32(e.CommandArgument));
            MontaGridView();
        }
    }
 //Monta o GridView
 public void MontaGridView()
 {
     try
     {
         ConvenioDAL convenioDAL = new ConvenioDAL();
         GridView1.DataSource = convenioDAL.Listar(txtConvenio.Text);
         GridView1.DataBind();
     }
     catch (Exception ex)
     {
         Label lblErro = (Label)Master.FindControl("lblErro");
         lblErro.Text = ex.ToString();
     }
 }
    //Metodo responsavel por carregar um determinado registro para ediчуo
    public void ObtemDados()
    {
        try
        {
            ConvenioBE convenioBE = new ConvenioBE();
            ConvenioDAL convenioDAL = new ConvenioDAL();
            convenioBE = convenioDAL.Obter(Convert.ToInt32(Request.QueryString["id"]));

            txtNome.Text = convenioBE.Nome;
            txtValor.Text = Convert.ToString(convenioBE.Valor.ToString("00.00"));
        }
        catch (Exception ex)
        {
            Label lblErro = (Label)Master.FindControl("lblErro");
            lblErro.Text = ex.ToString();
        }
    }