C:/Data/Projects/MCS EPM Global Practice/Frameworks/Public/mpfX/1.0/Libraries/Mcs.Epm.MicrosoftProject.mpFx/SecurityFilters.cs

/*  ----------------------------------------------------------------------------
 *  Microsoft Corporation
 *  ----------------------------------------------------------------------------
 *  Microsoft Project Server mpFx (mpFx)
 *  ----------------------------------------------------------------------------
 *  Author: Colby Africa
 *  ----------------------------------------------------------------------------
 *  License: http://code.msdn.microsoft.com/mpFx/Project/License.aspx
 *  ----------------------------------------------------------------------------
 */

using System;
using System.Collections.ObjectModel;
using System.Data;
using Mcs.Epm.MicrosoftProject.mpFx.SecurityWebService;
using Microsoft.Office.Project.Server.Library;

namespace Mcs.Epm.MicrosoftProject.mpFx
{
    /// <summary>
    /// Create commonly used filters for security information
    /// </summary>
    public static class SecurityFilters
    {
        #region Public Static Properties

        /// <summary>
        /// Create minimum filter for use with ReadResources
        /// </summary>
        public static string ListMinimumCategoryInformation
        {
            get
            {
                Filter filter = new Filter();

                using (SecurityCategoriesDataSet securityCategoriesDataSet = new SecurityCategoriesDataSet())
                {
                    filter.FilterTableName = securityCategoriesDataSet.SecurityCategories.TableName;

                    filter.Fields.Add(new Filter.Field(securityCategoriesDataSet.SecurityCategories.WSEC_CAT_UIDColumn.ColumnName));
                    filter.Fields.Add(new Filter.Field(securityCategoriesDataSet.SecurityCategories.WSEC_CAT_NAMEColumn.ColumnName));

                    return filter.GetXml();
                }
            }
        }

        #endregion

        #region Public Static Methods

        /// <summary>
        /// Create filter for the specified security category
        /// </summary>
        /// <param name="categoryGuid">The security category's GUID</param>
        /// <returns></returns>
        public static string ItemCategoryBasicInformation(Guid categoryGuid)
        {
            Filter filter = new Filter();

            using (SecurityCategoriesDataSet securityCategoriesDataSet = new SecurityCategoriesDataSet())
            {
                filter.FilterTableName = securityCategoriesDataSet.SecurityCategories.TableName;

                filter.Fields.Add(new Filter.Field(securityCategoriesDataSet.SecurityCategories.WSEC_CAT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(securityCategoriesDataSet.SecurityCategories.WSEC_CAT_NAMEColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(securityCategoriesDataSet.SecurityCategories.WSEC_CAT_DESCColumn.ColumnName));

                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             securityCategoriesDataSet.SecurityCategories.WSEC_CAT_UIDColumn.ColumnName,
                                             new object[] {categoryGuid.ToString()});

                filter.Criteria = equalResGuid;
                return filter.GetXml();
            }
        }

        /// <summary>
        /// Create a security categor filter from specified columns
        /// </summary>
        /// <param name="categoryGuid">The security category's GUID</param>
        /// <param name="columns">The collection of columns</param>
        /// <returns></returns>
        public static string CreateFilterFromColumns(Guid categoryGuid,
                                                     Collection<string> columns)
        {
            Filter filter = new Filter();

            using (SecurityCategoriesDataSet securityCategoriesDataSet = new SecurityCategoriesDataSet())
            {
                filter.FilterTableName = securityCategoriesDataSet.SecurityCategories.TableName;

                foreach (string column in columns)
                {
                    filter.Fields.Add(new Filter.Field(column));
                }

                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             securityCategoriesDataSet.SecurityCategories.WSEC_CAT_UIDColumn.ColumnName,
                                             new object[] {categoryGuid.ToString()});

                filter.Criteria = equalResGuid;
                return filter.GetXml();
            }
        }

        /// <summary>
        /// Create a category filter which returns all fields
        /// </summary>
        /// <param name="categoryGuid">The security category's GUID</param>
        /// <returns></returns>
        public static string CreateGetAllResourceInfoFilter(Guid categoryGuid)
        {
            Filter filter = new Filter();


            using (SecurityCategoriesDataSet securityCategoriesDataSet = new SecurityCategoriesDataSet())
            {
                foreach (DataColumn column in securityCategoriesDataSet.SecurityCategories.Columns)
                {
                    filter.Fields.Add(new Filter.Field(column.ColumnName));
                }


                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             securityCategoriesDataSet.SecurityCategories.WSEC_CAT_UIDColumn.ColumnName,
                                             new object[] {categoryGuid.ToString()});

                filter.Criteria = equalResGuid;
                return filter.GetXml();
            }
        }

        #endregion
    }
}

/* ------------------------------------------------------------------------------------------------------- 
 * Change Log
 * -------------------------------------------------------------------------------------------------------
 */

---