private ListaConfiguracaoReserva carregaValores(DataTable dt)
        {
            ListaConfiguracaoReserva oLisConfig = new ListaConfiguracaoReserva();

            foreach (DataRow dr in dt.Rows)
            {
                ConfiguraReserva oConfig = new ConfiguraReserva();

                if (dr.Table.Columns.Contains("ID_PRECO_RESERVA"))
                {
                    oConfig.id_valor = Convert.ToInt32(dr["ID_PRECO_RESERVA"]);
                }

                if (dr.Table.Columns.Contains("TIPO_AREA"))
                {
                    oConfig.area = dr["TIPO_AREA"].ToString();
                }

                if (dr.Table.Columns.Contains("valor"))
                {
                    oConfig.valor = Convert.ToDouble(dr["valor"]);
                }

                oLisConfig.Add(oConfig);
            }

            return(oLisConfig);
        }
 public void deletaReserva(ConfiguraReserva oConfiguraReserva)
 {
     try
     {
         oConfigDao.deletaReserva(oConfiguraReserva);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public void deletaReserva(ConfiguraReserva oConfiguraReserva)
        {
            try
            {
                oConfigDao.deletaReserva(oConfiguraReserva);

            }
            catch (Exception e)
            {

                throw e;
            }
        }
        public void deletaReserva(ConfiguraReserva oConfiguraReserva)
        {
            string clausulaSQL = "SP_DELETA_CONFIGURACAO_RESERVA";

            try
            {
                SqlCommand comandoSql = new SqlCommand(clausulaSQL);
                comandoSql.Parameters.AddWithValue("@ID", oConfiguraReserva.id_valor);

                ExecutaComando(comandoSql);
            }
            catch (Exception e)
            {

                throw e;
            }
        }
        public void deletaReserva(ConfiguraReserva oConfiguraReserva)
        {
            string clausulaSQL = "SP_DELETA_CONFIGURACAO_RESERVA";

            try
            {
                SqlCommand comandoSql = new SqlCommand(clausulaSQL);
                comandoSql.Parameters.AddWithValue("@ID", oConfiguraReserva.id_valor);


                ExecutaComando(comandoSql);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        protected void btnAlteraSenha_Click(object sender, EventArgs e)
        {
            ConfiguraReserva       oConfiguration = new ConfiguraReserva();
            ConfiguracaoReservaBLL oConfigBLL     = new ConfiguracaoReservaBLL();

            oConfiguration.area  = txtArea.Text;
            oConfiguration.valor = Convert.ToDouble(txtValor.Text);

            try
            {
                oConfigBLL.cadastraValorArea(oConfiguration);

                grdConfigArea.DataBind();
            }
            catch (Exception)
            {
                throw;
            }
        }
        protected void btnAlteraSenha_Click(object sender, EventArgs e)
        {
            ConfiguraReserva oConfiguration = new ConfiguraReserva();
            ConfiguracaoReservaBLL oConfigBLL = new ConfiguracaoReservaBLL();

            oConfiguration.area = txtArea.Text;
            oConfiguration.valor = Convert.ToDouble(txtValor.Text);

            try
            {
                oConfigBLL.cadastraValorArea(oConfiguration);

                grdConfigArea.DataBind();

            }
            catch (Exception)
            {

                throw;
            }
        }
        private ListaConfiguracaoReserva carregaValores(DataTable dt)
        {
            ListaConfiguracaoReserva oLisConfig = new ListaConfiguracaoReserva();

            foreach (DataRow dr in dt.Rows)
            {

                ConfiguraReserva oConfig = new ConfiguraReserva();

                if (dr.Table.Columns.Contains("ID_PRECO_RESERVA"))
                    oConfig.id_valor = Convert.ToInt32(dr["ID_PRECO_RESERVA"]);

                if (dr.Table.Columns.Contains("TIPO_AREA"))
                    oConfig.area =  dr["TIPO_AREA"].ToString();

                if (dr.Table.Columns.Contains("valor"))
                     oConfig.valor = Convert.ToDouble(dr["valor"]);

                oLisConfig.Add(oConfig);

            }

            return oLisConfig;
        }