예제 #1
0
        /// <summary>
        /// Deleta uma configura��o com sua lista de Dominios
        /// </summary>
        /// <param name="configEntity">SYS_LoginProvider_Config</param>
        /// <param name="dominioEntity">SYS_LoginProviderDominioPermitido</param>
        /// <returns>TRUE - se dele��o foi feita com sucesso e caso contrario FALSE</returns>
        public bool DeleteConfiguracoes(SYS_LoginProvider_Config configEntity, SYS_LoginProviderDominioPermitido dominioEntity)
        {
            SYS_LoginProviderDominioPermitidoDAO daoDominio = new SYS_LoginProviderDominioPermitidoDAO();

            bool ret = false;

            try
            {
                if (daoDominio._Banco == null)
                {
                    daoDominio._Banco.Open(IsolationLevel.ReadCommitted);
                }
                dao._Banco = daoDominio._Banco;

                if (daoDominio.Delete(dominioEntity))
                {
                    if (dao.Delete(configEntity))
                    {
                        ret = true;
                    }
                }
            }
            catch (Exception err)
            {
                if (dao._Banco == null)
                {
                    dao._Banco.Close(err);
                }
                if (daoDominio._Banco == null)
                {
                    daoDominio._Banco.Close(err);
                }
                throw;
            }
            finally
            {
                if (dao._Banco == null)
                {
                    dao._Banco.Close();
                }
                if (daoDominio._Banco == null)
                {
                    daoDominio._Banco.Close();
                }
            }

            return(ret);
        }
        /*
         * public List<SYS_LoginProviderDominioPermitido> ObterDominiosPermitidos(Guid entId, string providerName)
         * {
         *  List<SYS_LoginProviderDominioPermitido> lt = new List<SYS_LoginProviderDominioPermitido>();
         *
         *  QuerySelectStoredProcedure qs = new QuerySelectStoredProcedure("", _Banco);
         *  try
         *  {
         #region PARAMETROS
         *
         *      Param = qs.NewParameter();
         *      Param.DbType = DbType.Guid;
         *      Param.ParameterName = "@entId";
         *      Param.Size = 16;
         *      Param.Value = entId;
         *      qs.Parameters.Add(Param);
         *
         *      Param = qs.NewParameter();
         *      Param.DbType = DbType.String;
         *      Param.ParameterName = "@providerName";
         *      Param.Size = 128;
         *      Param.Value = providerName;
         *      qs.Parameters.Add(Param);
         *
         #endregion PARAMETROS
         *
         *      qs.Execute();
         *
         *      foreach (DataRow dr in qs.Return.Rows)
         *      {
         *          SYS_LoginProviderDominioPermitido entity = new SYS_LoginProviderDominioPermitido();
         *          lt.Add(this.DataRowToEntity(dr, entity));
         *      }
         *
         *      return lt;
         *
         *  }
         *  catch
         *  {
         *      throw;
         *  }
         *  finally
         *  {
         *      qs.Parameters.Clear();
         *  }
         *
         * }
         *
         */

        public DataTable DeletarDominios(SYS_LoginProviderDominioPermitido entity)
        {
            QuerySelectStoredProcedure qs = new QuerySelectStoredProcedure("NEW_SYS_LoginProviderDominioPermitido_DELETE", _Banco);

            try
            {
                #region PARAMETROS

                Param               = qs.NewParameter();
                Param.DbType        = DbType.Guid;
                Param.ParameterName = "@ent_id";
                Param.Size          = 16;
                Param.Value         = entity.ent_id;
                qs.Parameters.Add(Param);

                Param               = qs.NewParameter();
                Param.DbType        = DbType.AnsiString;
                Param.ParameterName = "@LoginProvider";
                Param.Size          = 128;
                Param.Value         = entity.LoginProvider;
                qs.Parameters.Add(Param);

                #endregion PARAMETROS

                qs.Execute();

                return(qs.Return);
            }
            catch
            {
                throw;
            }
            finally
            {
                qs.Parameters.Clear();
            }
        }