public static string GetSubdivision(SPList list, string email)
        {
            Resource    ResourceSvc;
            LookupTable LookupTable;
            ListConf    cfg = new ListConf(list);

            CreateServices(cfg, out ResourceSvc, out LookupTable);
            var usersData = ResourceSvc.ReadResources(string.Empty, false);

            Guid userUid = Guid.Empty;

            foreach (DataRow row in usersData.Resources.Rows)
            {
                if (Convert.ToString(row["WRES_EMAIL"]) == email)
                {
                    userUid = new Guid(Convert.ToString(row["RES_UID"]));
                }
            }

            if (userUid == Guid.Empty)
            {
                return(string.Empty);
            }

            Guid customFieldGuid = new Guid("000039b7-8bbe-4ceb-82c4-fa8c0c400284");
            Guid valueUid        = Guid.Empty;

            foreach (DataRow row in usersData.ResourceCustomFields.Rows)
            {
                if ((Guid)row["MD_PROP_UID"] == customFieldGuid &&
                    (Guid)row["RES_UID"] == userUid)
                {
                    valueUid = (Guid)row["CODE_VALUE"];
                    break;
                }
            }

            if (valueUid == Guid.Empty)
            {
                return(string.Empty);
            }

            var tables = LookupTable.ReadLookupTablesByUids(new Guid[] { new Guid("00008e67-65a3-4898-baaa-d82d995bbb02") }, false, 1049);

            foreach (DataRow row in tables.LookupTableTrees.Rows)
            {
                if ((Guid)row["LT_STRUCT_UID"] == valueUid)
                {
                    return(Convert.ToString(row["LT_VALUE_TEXT"]));
                }
            }

            return(string.Empty);
        }
        private static void CreateServices(ListConf cfg, out Resource ResourceSvc, out LookupTable LookupTable)
        {
            string       projectServerUri = cfg.UrlServer;
            const string lookupTablePath  = "/_vti_bin/PSI/LookupTable.asmx";
            const string ServicePath      = "/_vti_bin/PSI/Resource.asmx";

            ResourceSvc     = new Resource();
            ResourceSvc.Url = projectServerUri + ServicePath;
            SPLog.Write("ProjectService.Url = {0}", ResourceSvc.Url);
            ResourceSvc.Credentials = new NetworkCredential("users", "password", "domen");

            LookupTable             = new SvcLookupTable.LookupTable();
            LookupTable.Url         = projectServerUri + lookupTablePath;
            LookupTable.Credentials = new NetworkCredential("users", "password", "domen");
            SPLog.Write("QueueService.Url = {0}", LookupTable.Url);
        }