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

            int ano = Convert.ToInt32(drpAno.SelectedItem.Value);
            int mes = Convert.ToInt32(drpMeses.SelectedIndex + 1);


            if (drpSalao.SelectedItem.Text == "Festa")
            {
                dvFesta.Visible     = true;
                dvChurrasco.Visible = false;
                //grdAgendaMorador.DataSource = oAgenda.listaReservaDetalhadaFesta(ano,  mes);
                //grdAgendaMorador.DataBind();

                grdReservaProgramadaFesta.DataSource = oAgenda.listaReservaDetalhadaFesta(ano, mes);
                grdReservaProgramadaFesta.DataBind();

                // lblMesAnoFesta.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
            }
            else if (drpSalao.SelectedItem.Text == "Churrasqueira")
            {
                grdReservaProgramadaChurras.DataSource = oAgenda.listaReservaDetalhadaChurrasco(ano, mes);
                grdReservaProgramadaChurras.DataBind();
                dvChurrasco.Visible = true;
                dvFesta.Visible     = false;

                // lbMesAnoChurras.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
            }
            else if (drpSalao.SelectedItem.Value == "1")
            {
                grdReservaProgramadaFesta.DataSource = oAgenda.listaReservaDetalhadaFesta(ano, mes);
                grdReservaProgramadaFesta.DataBind();


                grdReservaProgramadaChurras.DataSource = oAgenda.listaReservaDetalhadaChurrasco(ano, mes);
                grdReservaProgramadaChurras.DataBind();

                // grdChurras.DataSource = oAgenda.listaReservaDetalhadaChurrasco(ano, mes);
                // grdChurras.DataBind();

                dvFesta.Visible = true;

                //lblMesAnoFesta.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;

                dvChurrasco.Visible = true;
                // grdAgendaMorador.DataSource = oAgenda.listaReservaDetalhadaFesta( ano, mes);
                // grdAgendaMorador.DataBind();

                //lbMesAnoChurras.Text = drpMeses.SelectedItem.Text + " / " + drpAno.SelectedItem.Text;
            }

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