public List <SpFarmGroupIdentifier> GetAllowedGroups(string repositoryName, Guid domainId, Guid rootMapId) { List <SpFarmGroupIdentifier> allowedGroups = new List <SpFarmGroupIdentifier>(); using (SqlConnection dbConnection = new SqlConnection(_connectionSetting.GetConnectionString())) { using (SqlCommand dbCommand = new SqlCommand()) { dbCommand.Connection = dbConnection; dbCommand.CommandText = "dbo.GetAllowedGroups"; dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.Add("@DomainId", System.Data.SqlDbType.UniqueIdentifier).Value = domainId; dbCommand.Parameters.Add("@MapId", System.Data.SqlDbType.UniqueIdentifier).Value = rootMapId; dbConnection.Open(); using (SqlDataReader dbReader = dbCommand.ExecuteReader()) { while (dbReader.Read()) { SpFarmGroupIdentifier newGroupId = new SpFarmGroupIdentifier(); newGroupId.SiteCollectionId = dbReader.GetValue <Guid>(_sharePointSiteCollectionIdColumnName); newGroupId.GroupId = dbReader.GetValue <int>(_sharePointGroupIdColumnName); if (!allowedGroups.Contains(newGroupId)) { allowedGroups.Add(newGroupId); } } } } } return(allowedGroups); }
public List <DynamicType> GetRootMaps(string repositoryName, Guid domainId, ITypeDescriptorCollection entityFields) { List <DynamicType> nodes = new List <DynamicType>(); using (SqlConnection dbConnection = new SqlConnection(_connectionSetting.GetConnectionString())) { using (SqlCommand dbCommand = new SqlCommand()) { dbCommand.Connection = dbConnection; dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "dbo.GetRootMaps"; // Get the root maps for all domains unless a domain is specified. if (!domainId.Equals(Guid.Empty)) { dbCommand.Parameters.Add("@DomainId", System.Data.SqlDbType.UniqueIdentifier).Value = @domainId; } dbConnection.Open(); nodes = ReadNodes(dbCommand, repositoryName, entityFields); } } return(nodes); }