Esempio n. 1
0
        /// <summary>
        /// Finds SP UserProfile by INN
        /// </summary>
        /// <param name="profile">RecordUserProfile record wich is imported from 1C</param>
        /// <returns>Returns RecordUserProfile (which is imported from SP) if found, otherwise returns null</returns>
        RecordUserProfile GetProfileByINN(RecordUserProfile profile)
        {
            string sINN = profile.INN.Trim().ToLower();

            foreach (RecordUserProfile profileRecord in usersExisting.GetProfiles())
            {
                if (profileRecord.INN.Trim().ToLower() == sINN)
                {
                    return(profileRecord);
                }
            }
            return(null);
        }
Esempio n. 2
0
 /// <summary>
 /// Finds SP UserProfile by: Last Name, First Name, Middle Nam and Birthday
 /// </summary>
 /// <param name="profile">RecordUserProfile record wich is imported from 1C</param>
 /// <returns>Returns RecordUserProfile (which is imported from SP) if found, otherwise returns null</returns>
 RecordUserProfile GetProfileByPersonName(RecordUserProfile profile)
 {
     foreach (RecordUserProfile profileRecord in usersExisting.GetProfiles())
     {
         if (profileRecord.FirstName.Trim().ToLower() == profile.FirstName.Trim().ToLower() &&
             profileRecord.MiddleName.Trim().ToLower() == profile.MiddleName.Trim().ToLower() &&
             profileRecord.LastName.Trim().ToLower() == profile.LastName.Trim().ToLower() &&
             DateTime.Compare(profileRecord.BirthdayDT, profile.BirthdayDT) == 0)
         {
             return(profileRecord);
         }
     }
     return(null);
 }
Esempio n. 3
0
        /// <summary>
        /// Updates existing SharePoint user profile
        /// </summary>
        /// <param name="site">SPSite objec</param>
        /// <param name="p">The existing SP profile to be updated</param>
        /// <param name="profile">Profile record, which is imported from 1C</param>
        /// <returns>true on success, false on failed</returns>
        bool UpdateUserProfile(SPSite site, UserProfile p, RecordUserProfile profile)
        {
            string strDisplayName = "";

            try
            {
                strDisplayName = string.Format("{0} {1}{2}",
                                               profile.FirstName.Trim(), (profile.MiddleName.Trim().Length > 0) ? (profile.MiddleName.Trim() + " ") : (""),
                                               profile.LastName);

                if (Properties.Settings.Default.updateProfileDisplayName && p.DisplayName != strDisplayName)
                {
                    p.DisplayName = strDisplayName;
                }

                if (Properties.Settings.Default.updateFirstName)
                {
                    UpdateSPStringProfileField(ref p, "FirstName", profile.FirstName);
                }
                if (Properties.Settings.Default.updateLastName)
                {
                    UpdateSPStringProfileField(ref p, "LastName", profile.LastName);
                }
                if (Properties.Settings.Default.updateBirthday)
                {
                    UpdateSPProfileField(ref p, "SPS-Birthday", profile.Birthday);
                }

                if (Properties.Settings.Default.updatePhoneWork)
                {
                    UpdateSPStringProfileField(ref p, "WorkPhone", profile.PhoneWork);
                }
                if (Properties.Settings.Default.updatePhoneHome)
                {
                    UpdateSPStringProfileField(ref p, "HomePhone", profile.PhoneHome);
                }
                if (Properties.Settings.Default.updateEmailWork)
                {
                    UpdateSPStringProfileField(ref p, "WorkEmail", profile.EmailWork);
                }
                if (Properties.Settings.Default.updateSeparateDivision)
                {
                    UpdateSPStringProfileField(ref p, "Office", profile.SeparateDivision);
                }
                if (Properties.Settings.Default.updateSubDivision)
                {
                    UpdateSPStringProfileField(ref p, "Department", profile.SubDivision);
                }
                if (Properties.Settings.Default.updatePosition)
                {
                    UpdateSPStringProfileField(ref p, "Title", profile.Position);
                    UpdateSPStringProfileField(ref p, "SPS-JobTitle", profile.Position);
                }
                if (Properties.Settings.Default.updateDateOfEmployment && profile.EmploymentDate != null)
                {
                    UpdateSPProfileField(ref p, "SPS-HireDate", profile.EmploymentDate);
                }

                // Custom fields
                if (Properties.Settings.Default.updateMiddleName)
                {
                    UpdateSPStringProfileField(ref p, "Mr-MiddleName", profile.MiddleName);
                }
                if (Properties.Settings.Default.updateINN)
                {
                    UpdateSPStringProfileField(ref p, "Mr-Inn", profile.INN);
                }
                if (Properties.Settings.Default.updateSSN)
                {
                    UpdateSPStringProfileField(ref p, "Mr-Ssn", profile.SSN);
                }
                if (Properties.Settings.Default.updateOrganization)
                {
                    UpdateSPStringProfileField(ref p, "Mr-Organization", profile.Organization);
                }

                // Photos
                if (Properties.Settings.Default.updatePhoto && profile.Photo != null)
                {
                    if (Properties.Settings.Default.forceUpdatePhoto == true ||
                        p["PictureUrl"].Value == null || p["PictureUrl"].Value.ToString().Length < 1)
                    {
                        if (imageUploader != null)
                        {
                            imageUploader.UploadPhoto(p, profile.Photo);
                            string pictureUrl = String.Format("{0}/{1}/{2}_MThumb.jpg", site.Url,
                                                              imageUploader.GetSubfolderName(), imageUploader.GetFileNameFromAccount(p));
                            WriteSPProfileField(ref p, "PictureUrl", pictureUrl);
                        }
                    }
                }
                else
                {
                    if (Properties.Settings.Default.forceUpdatePhoto == true &&
                        p["PictureUrl"].Value != null && p["PictureUrl"].Value.ToString().Length > 0)
                    {
                        // TODO: Remove image?
                        WriteSPProfileField(ref p, "PictureUrl", null);
                    }
                }

                p.Commit();
            }
            catch (Exception ex)
            {
                string sError = string.Format("UpdateUserProfile() The error was occured while updating profile:\nAccount name: {0}\nDisplayName: {1}\nError:\n\n{2}\n---\n",
                                              (p != null && p["AccountName"].Value != null) ? (" \"" + p["AccountName"].Value.ToString() + "\"") : (""),
                                              strDisplayName, ex.ToString());

                TextWriter errorWriter = Console.Error;
                Console.WriteLine(sError);
                errorWriter.WriteLine(sError);
                return(false);
            }
            return(true);
        }
Esempio n. 4
0
        /// <summary>
        /// Enumerates list of imported from 1C profile records and updates SP profiles
        /// </summary>
        /// <returns>true on success, false on failed</returns>
        bool UpdateProfiles()
        {
            int nAdded    = 0;
            int nModified = 0;

            try
            {
                string strSiteURL = Properties.Settings.Default.sharePointUserProfilesUrl;
                using (SPSite site = new SPSite(strSiteURL))
                {
                    SPWeb                 web     = site.OpenWeb();
                    SPServiceContext      context = SPServiceContext.GetContext(site);
                    UserProfileManager    upm     = new UserProfileManager(context);
                    ProfileSubtypeManager psm     = ProfileSubtypeManager.Get(context);

                    web.AllowUnsafeUpdates = true;

                    // choose default user profile subtype as the subtype
                    string         subtypeName = ProfileSubtypeManager.GetDefaultProfileName(ProfileType.User);
                    ProfileSubtype subType     = psm.GetProfileSubtype(subtypeName);

                    try
                    {
                        imageUploader = new SPProfilePhotoUploader(web);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("{0}\nImages will not be updated", ex.ToString());
                        imageUploader = null;
                    }

                    double total   = users1C.Count;
                    double rec     = 100.0 / total;
                    double current = 0.0;

                    Console.Write("Updated 0%");
                    foreach (RecordUserProfile profile in users1C.GetProfiles())
                    {
                        RecordUserProfile profileFound       = null;
                        string            profileAccountName = "";
                        bool profileExists = false;

                        // If LDAP is refer to account name then verify if such account is existing
                        if (profile.AccountName != null &&
                            profile.AccountName.Trim().Length > 0 &&
                            Properties.Settings.Default.accountNameIsAKey == true)
                        {
                            if (upm.UserExists(profile.AccountName.Trim()))
                            {
                                profileAccountName = profile.AccountName.Trim();
                                profileExists      = true;
                            }
                        }
                        // If innIsAKey option is true and account is not found then try to find
                        // profile by INN
                        if (profileExists == false &&
                            profile.INN != null &&
                            profile.INN.Trim().Length > 0 &&
                            Properties.Settings.Default.innIsAKey)
                        {
                            profileFound = GetProfileByINN(profile);
                            if (profileFound != null)
                            {
                                profileAccountName = profileFound.AccountName;
                                profileExists      = true;
                            }
                        }
                        // Find by Last name, First name, Middle name (FIO) and Birthday
                        if (profileExists == false)
                        {
                            profileFound = GetProfileByPersonName(profile);
                            if (profileFound != null)
                            {
                                profileAccountName = profileFound.AccountName;
                                profileExists      = true;
                            }
                        }

                        if (profileExists)
                        {
                            // get existing profile
                            UserProfile p = upm.GetUserProfile(profileAccountName);

                            if (UpdateUserProfile(site, p, profile))
                            {
                                nModified++;
                            }
                        }
                        else
                        {
                            // create a user profile and set properties
                            if (CreateUserProfile(site, upm, profile, subType))
                            {
                                nAdded++;
                            }
                        }
                        current += rec;
                        Console.Write("\rUpdated {0:F}%", current);
                    }
                    Console.Write("\r");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
                return(false);
            }
            Console.WriteLine("Updated {0} records.", nModified);
            Console.WriteLine("Added {0} new records.", nAdded);
            return(true);
        }
Esempio n. 5
0
        /// <summary>
        /// Creates new SharePoint user profile record
        /// </summary>
        /// <param name="site">SPSite object</param>
        /// <param name="upm">UserProfileManager object</param>
        /// <param name="profile">Profile record (imported from 1C) to be added</param>
        /// <param name="subType">Type of UserProfile</param>
        /// <returns>true on success, false on failed</returns>
        bool CreateUserProfile(SPSite site, UserProfileManager upm, RecordUserProfile profile, ProfileSubtype subType)
        {
            UserProfile p = null;
            string      strAccountName = "";
            string      strDisplayName = "";

            try
            {
                // create a user profile and set properties
                if (profile.AccountName.Trim().Length > 0)
                {
                    strAccountName = profile.AccountName;
                }
                else
                {
                    strAccountName = string.Format("SqlMembershipProvider:imported1c{0}", ++nAccount);
                }

                strDisplayName = string.Format("{0} {1}{2}",
                                               profile.FirstName.Trim(), (profile.MiddleName.Trim().Length > 0) ? (profile.MiddleName.Trim() + " ") : (""),
                                               profile.LastName);

                p = upm.CreateUserProfile(strAccountName);

                p.DisplayName = strDisplayName;
                WriteSPProfileField(ref p, "FirstName", profile.FirstName);
                WriteSPProfileField(ref p, "LastName", profile.LastName);
                WriteSPProfileField(ref p, "SPS-Birthday", profile.Birthday);

                WriteSPProfileField(ref p, "WorkPhone", profile.PhoneWork);
                WriteSPProfileField(ref p, "HomePhone", profile.PhoneHome);
                WriteSPProfileField(ref p, "WorkEmail", profile.EmailWork);
                WriteSPProfileField(ref p, "Office", profile.SeparateDivision);
                WriteSPProfileField(ref p, "Department", profile.SubDivision);
                WriteSPProfileField(ref p, "Title", profile.Position);
                WriteSPProfileField(ref p, "SPS-JobTitle", profile.Position);
                WriteSPProfileField(ref p, "SPS-HireDate", profile.DateOfEmployment);

                // Custom fields
                WriteSPProfileField(ref p, "Mr-MiddleName", profile.MiddleName);
                WriteSPProfileField(ref p, "Mr-Inn", profile.INN);
                WriteSPProfileField(ref p, "Mr-Ssn", profile.SSN);
                WriteSPProfileField(ref p, "Mr-Organization", profile.Organization);

                // Photos
                if (profile.Photo != null)
                {
                    if (imageUploader != null)
                    {
                        imageUploader.UploadPhoto(p, profile.Photo);
                        string pictureUrl = String.Format("{0}/{1}/{2}_MThumb.jpg", site.Url,
                                                          imageUploader.GetSubfolderName(), imageUploader.GetFileNameFromAccount(p));
                        p["PictureUrl"].Value = pictureUrl;
                    }
                }
                else
                {
                }

                p.ProfileSubtype = subType;

                p.Commit();
            }
            catch (Exception ex)
            {
                string sError = string.Format("CreateUserProfile() The error was occured while updating profile:\nAccount name: {0}\nDisplayName: {1}\nError:\n\n{2}\n---\n",
                                              strAccountName, strDisplayName, ex.ToString());

                TextWriter errorWriter = Console.Error;
                Console.WriteLine(sError);
                errorWriter.WriteLine(sError);
                return(false);
            }
            return(true);
        }