C:/Data/Projects/MCS EPM Global Practice/Frameworks/Public/mpfX/1.0/Libraries/Mcs.Epm.MicrosoftProject.mpFx/CustomFieldFilters.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.CustomFieldsWebService;
using Microsoft.Office.Project.Server.Library;

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

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

                using (CustomFieldDataSet customFieldDataSet = new CustomFieldDataSet())
                {
                    filter.FilterTableName = customFieldDataSet.CustomFields.TableName;
                    filter.Fields.Add(new Filter.Field(customFieldDataSet.CustomFields.MD_PROP_UIDColumn.ColumnName));
                    filter.Fields.Add(new Filter.Field(customFieldDataSet.CustomFields.MD_PROP_NAMEColumn.ColumnName));

                    return filter.GetXml();
                }
            }
        }

        #endregion

        #region Publc Static Methods

        /// <summary>
        /// Create basic information filter for the specified custom field
        /// </summary>
        /// <param name="customFieldGuid">The custom field's GUID</param>
        /// <returns></returns>
        public static string ItemBasicInformation(Guid customFieldGuid)
        {
            Filter filter = new Filter();

            using (CustomFieldDataSet customFieldDataSet = new CustomFieldDataSet())
            {
                filter.FilterTableName = customFieldDataSet.CustomFields.TableName;

                filter.Fields.Add(new Filter.Field(customFieldDataSet.CustomFields.MD_PROP_UIDColumn.ColumnName));

                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             customFieldDataSet.CustomFields.MD_PROP_UIDColumn.ColumnName,
                                             customFieldGuid.ToString());

                filter.Criteria = equalResGuid;

                return filter.GetXml();
            }
        }

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

            using (CustomFieldDataSet customFieldDataSet = new CustomFieldDataSet())
            {
                filter.FilterTableName = customFieldDataSet.CustomFields.TableName;

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

                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             customFieldDataSet.CustomFields.MD_PROP_UIDColumn.ColumnName,
                                             customFieldGuid);

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

        /// <summary>
        /// Create a custom field filter which returns all fields
        /// </summary>
        /// <param name="customFieldGuid">The custom field's GUID</param>
        /// <returns></returns>
        public static string CreateGetAllInfoFilter(Guid customFieldGuid)
        {
            Filter filter = new Filter();

            using (CustomFieldDataSet customFieldDataSet = new CustomFieldDataSet())
            {
                filter.FilterTableName = customFieldDataSet.CustomFields.TableName;

                foreach (DataColumn column in customFieldDataSet.CustomFields.Columns)
                {
                    filter.Fields.Add(new Filter.Field(column.ColumnName));    
                }
                
                Filter.IOperator equalResGuid =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             customFieldDataSet.CustomFields.MD_PROP_UIDColumn.ColumnName,
                                             customFieldGuid);

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

        #endregion
    }
}

---