C:/Data/Projects/MCS EPM Global Practice/Frameworks/Public/mpfX/1.0/Libraries/Mcs.Epm.MicrosoftProject.mpFx.WinForms/SelectLookupTableValueForm.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.Generic;
using System.Windows.Forms;
using Mcs.Epm.MicrosoftProject.mpFx.LookupTablesWebService;
using Microsoft.Office.Project.Server.Library;

namespace Mcs.Epm.MicrosoftProject.mpFx.WinForms
{
    /// <summary>
    /// Implements a user interface for selecting lookup table values
    /// </summary>
    public partial class SelectLookupTableValueForm : Form
    {
        #region Instance Data

        private readonly ProjectServer _ProjectServer;
        private readonly string _LookupTableGUID = string.Empty;
        private LookupTableMultiLangDataSet.LookupTableValuesDataTable _LookupValues;

        #endregion

        #region Private Properties

        private List<string> SelectedItems { get; set; }

        #endregion

        #region Public Properties

        public Dictionary<string, string> SelectedValues { get; private set; }

        public bool AllowMultiSelect { get; private set; }

        #endregion

        #region Constructors

        public SelectLookupTableValueForm(string lookupTableGUID,
                                          ProjectServer projectServer,
                                          bool allowMultiSelect,
                                          List<string> selectedItems)
        {
            InitializeComponent();

            _LookupTableGUID = lookupTableGUID;

            _ProjectServer = projectServer;

            AllowMultiSelect = allowMultiSelect;

            SelectedItems = selectedItems;

            SelectedValues = new Dictionary<string, string>();

            AllowMultiSelect = false;
        }

        #endregion

        #region Private Methods

        private void BuildLookupTableTree()
        {
            Filter filter = new Filter();

            using (LookupTableMultiLangDataSet lookupTable = new LookupTableMultiLangDataSet())
            {
                filter.FilterTableName = lookupTable.LookupTableStructures.TableName;

                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableStructures.LT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableStructures.LT_PARENT_STRUCT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableStructures.LT_STRUCT_UIDColumn.ColumnName));

                Filter.FieldOperator equalUID = new Filter.FieldOperator(Filter.FieldOperationType.Equal, lookupTable.LookupTableStructures.LT_UIDColumn.ColumnName, _LookupTableGUID);

                filter.Criteria = equalUID;

                LookupTableMultiLangDataSet lookupTables = _ProjectServer.LookupTables.MultiLangGetLookupTables(filter.GetXml(), false);

                valuesTree.Nodes.Clear();
                TreeNode root = valuesTree.Nodes.Add("Values");

                foreach (LookupTableMultiLangDataSet.LookupTableStructuresRow structure in lookupTables.LookupTableStructures)
                {
                    if (structure.IsLT_PARENT_STRUCT_UIDNull())
                    {
                        string value = GetLookupValueString(structure.LT_STRUCT_UID);

                        TreeNode newNode = root.Nodes.Add(value);

                        newNode.Tag = structure.LT_STRUCT_UID;

                        Traverse(newNode, lookupTables.LookupTableStructures, structure.LT_STRUCT_UID.ToString());
                    }
                }

                root.ExpandAll();
            }
        }

        private void LoadLookupTableValues()
        {
            Filter filter = new Filter();

            using (LookupTableMultiLangDataSet lookupTable = new LookupTableMultiLangDataSet())
            {
                filter.FilterTableName = lookupTable.LookupTableValues.TableName;
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_STRUCT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_VALUE_TEXTColumn.ColumnName));

                Filter.FieldOperator equalUID = new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                                                         lookupTable.LookupTableValues.LT_UIDColumn.ColumnName, _LookupTableGUID);

                filter.Criteria = equalUID;
                _LookupValues = _ProjectServer.LookupTables.MultiLangGetLookupTableValues(filter.GetXml(), false);
            }
        }

        private string GetLookupValueString(Guid GUID)
        {
            return _LookupValues.FindByLT_STRUCT_UIDLCID(GUID, 1033).LT_VALUE_TEXT;
        }

        private void Traverse(TreeNode node, LookupTableMultiLangDataSet.LookupTableStructuresDataTable structures, string GUID)
        {
            foreach (LookupTableMultiLangDataSet.LookupTableStructuresRow structure in structures)
            {
                if (!structure.IsLT_PARENT_STRUCT_UIDNull() && structure.LT_PARENT_STRUCT_UID.ToString() == GUID)
                {
                    string value = GetLookupValueString(structure.LT_STRUCT_UID);

                    TreeNode newNode = node.Nodes.Add(value);

                    newNode.Tag = structure.LT_STRUCT_UID;

                    Traverse(newNode, structures, structure.LT_STRUCT_UID.ToString());
                }
            }
        }

        private void SelectLookupTableValueForm_Load(object sender, EventArgs e)
        {
            Cursor = Cursors.WaitCursor;

            LoadLookupTableValues();

            BuildLookupTableTree();

            Cursor = Cursors.Default;

            CenterToScreen();
        }

        private void RecursiveAddSelectedItems(TreeNode parent)
        {
            foreach (TreeNode node in parent.Nodes)
            {
                if (node.Checked)
                {
                    SelectedValues.Add(node.Tag.ToString(), node.Text);
                }

                if (node.Nodes.Count > 0)
                {
                    RecursiveAddSelectedItems(node);
                }
            }
        }

        private static void RecursiveUncheck(TreeNode currentNode, TreeNode leaveNode)
        {
            foreach (TreeNode node in currentNode.Nodes)
            {
                if (node != leaveNode)
                {
                    node.Checked = false;
                }

                if (node.Nodes.Count > 0)
                {
                    RecursiveUncheck(node, leaveNode);
                }
            }
        }

        #endregion

        #region Event Handlers

        private void cancelButton_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void valuesTree_AfterCheck(object sender, TreeViewEventArgs e)
        {
            if (AllowMultiSelect == false)
            {
                valuesTree.AfterCheck -= valuesTree_AfterCheck;
                RecursiveUncheck(valuesTree.Nodes[0], e.Node);
                valuesTree.AfterCheck += valuesTree_AfterCheck;
            }
        }

        private void okButton_Click(object sender, EventArgs e)
        {
            RecursiveAddSelectedItems(valuesTree.Nodes[0]);
        }

        #endregion

    }
}

---