private void consultaReserva()
        {
            SomaChurraqueira = 0;
            SomaFesta        = 0;

            oAgendaModel.dataAgendamento = Convert.ToDateTime(drpAno.SelectedItem.Value + "-" + drpMeses.SelectedItem.Value + "01");
            oAP.bloco       = Convert.ToInt32(Session["Bloco"]);
            oAP.apartamento = Convert.ToInt32(Session["AP"]);

            if (drpSalao.SelectedItem.Text == "Festa")
            {
                dvFesta.Visible     = true;
                dvChurrasco.Visible = false;
                grdReservaProgramadaFesta.DataSource = oAgenda.listaReservaByMoradorFesta(oAP, oAgendaModel);
                grdReservaProgramadaFesta.DataBind();

                //lblMsg.Visible = false;
                // lblMesAnoFesta.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
            }
            else if (drpSalao.SelectedItem.Text == "Churrasqueira")
            {
                grdReservaProgramadaChurras.DataSource = oAgenda.listaReservaByMorador(oAP, oAgendaModel);
                grdReservaProgramadaChurras.DataBind();
                dvChurrasco.Visible = true;
                dvFesta.Visible     = false;
                //  lblMsg.Visible = false;
                // lbMesAnoChurras.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
            }
            else if (drpSalao.SelectedItem.Value == "1")
            {
                grdReservaProgramadaChurras.DataSource = oAgenda.listaReservaByMorador(oAP, oAgendaModel);
                grdReservaProgramadaChurras.DataBind();

                grdReservaProgramadaFesta.DataSource = oAgenda.listaReservaByMoradorFesta(oAP, oAgendaModel);
                grdReservaProgramadaFesta.DataBind();

                dvFesta.Visible = true;
                // lblMsg.Visible = false;
                // lblMesAnoFesta.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
                // lbMesAnoChurras.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
                dvChurrasco.Visible = true;

                //  lblMsg.Visible = false;
            }
            lblTotalAreas.Text = "Valor total do mês: (Churrasqueira/Salão): R$ " + (SomaFesta + SomaChurraqueira).ToString("N2");
        }