/// <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(); } }