private static void UpdateSipAddresses(IRepository consoleRepository)
        {
            Dictionary <String, String> userSipAddresses = DatabaseInit.GetUserSipAddresses();

            foreach (User u in consoleRepository.Query <User>(u => u.IsActive))
            {
                String shortName = WebSiteModuleManager.ExtractUserName(u.DomainLogon);
                if (userSipAddresses.ContainsKey(shortName))
                {
                    String sipAddress = userSipAddresses[shortName];
                    if (String.IsNullOrEmpty(u.SipAddress))
                    {
                        if (!String.IsNullOrEmpty(sipAddress))
                        {
                            u.SipAddress = sipAddress;
                        }
                    }
                    else
                    {
                        if (!u.SipAddress.Equals(sipAddress, StringComparison.InvariantCultureIgnoreCase))
                        {
                            u.SipAddress = sipAddress;
                        }
                    }
                }
            }
        }
        private static void UpdateUserPictures(IRepository consoleRepository)
        {
            Dictionary <String, byte[]> userPictures = DatabaseInit.GetUserPictures();

            foreach (User u in consoleRepository.Query <User>(u => u.IsActive))
            {
                String shortName = WebSiteModuleManager.ExtractUserName(u.DomainLogon);
                if (userPictures.ContainsKey(shortName))
                {
                    byte[] userPic = userPictures[shortName];
                    if ((userPic != null) && (userPic.Length > 0))
                    {
                        if ((u.UserThumbnail == null) || (u.UserThumbnail.Length <= 0))
                        {
                            u.UserThumbnail = userPic;
                        }
                        else
                        {
                            if (!u.UserThumbnail.Equals(userPic))
                            {
                                u.UserThumbnail = userPic;
                            }
                        }
                    }
                }
            }
        }