public void RunADReplication(Guid organizationId, bool isRealReplication) { string processId = null; Bll.LdapProcess ldapProcess = null; DomainUserCollection users = null; DataTable localLogins = null; DataTable ldapLogins = null; //DataTable localMappedLogins = null; DataTable activeLMLogins = null; DataTable inactiveLMLogins = null; DataTable ldapActiveLogins = null; DataColumn newColumn = null; DataRow row = null; DataRow newRow = null; MasterDataSet.OrganizationsLdapGroupsDataTable orgTable = null; MasterDataSet.GroupMappingsDataTable groupMappings = null; Bll.Handlers.LdapHandler ldapHendler = null; string logMessage = null; try { if (isRealReplication) { processId = string.Format(CultureInfo.InvariantCulture, "RealADReplication_{0}", organizationId); } else { processId = string.Format(CultureInfo.InvariantCulture, "TestADReplication_{0}", organizationId); } ldapProcess = LdapInfoProvider.LdapProcesses.Find(x => x.ProcessId == processId); if (ldapProcess != null) { LdapInfoProvider.LdapProcesses.Remove(ldapProcess); } ldapProcess = new Bll.LdapProcess(); ldapProcess.ProcessId = processId; ldapProcess.ThreadStateType = Bll.ThreadStateType.Running; ldapProcess.MessageError = string.Empty; ldapProcess.MessageCreatedLogins = string.Empty; ldapProcess.MessageActivatedLogins = string.Empty; ldapProcess.MessageDeactivatedLogins = string.Empty; ldapProcess.DataCreatedLogins = null; ldapProcess.DataActivatedLogins = null; ldapProcess.DataDeactivatedLogins = null; ldapProcess.Logs = new List <LdapProcessLog>(); LdapInfoProvider.LdapProcesses.Add(ldapProcess); if (isRealReplication) { ldapProcess.MessageDeactivatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_RealDeactivatedLogins_Text, 0); ldapProcess.MessageActivatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_RealActivatedLogins_Text, 0); ldapProcess.MessageCreatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_RealCreatedLogins_Text, 0); } else { ldapProcess.MessageDeactivatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_TestDeactivatedLogins_Text, 0); ldapProcess.MessageActivatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_TestActivatedLogins_Text, 0); ldapProcess.MessageCreatedLogins = string.Format(CultureInfo.InvariantCulture, Resources.OrganizationLdapSettingsControl_TestCreatedLogins_Text, 0); } DateTime startDate = DateTime.UtcNow; logMessage = string.Format(CultureInfo.CurrentCulture, Resources.LdapProcessLog_ReplicationStarted); ldapProcess.Logs.Add(new LdapProcessLog() { Date = startDate, Message = logMessage }); LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage); // Get all mapped ldap groups users users = LdapInfoProvider.GetMappedGroupsUsers(organizationId, ref ldapProcess); if (users != null) { // Get all local users localLogins = LoginProvider.Current.GetLoginsByOrganizationId(organizationId); localLogins.Columns.Add("Name", typeof(string)); foreach (DataRow dataRow in localLogins.Rows) { dataRow["Name"] = string.Concat(dataRow["FirstName"], " ", dataRow["LastName"]); } ldapLogins = localLogins.Clone(); ldapLogins.Columns.Add("Email", typeof(string)); foreach (DomainUser user in users) { if (!string.IsNullOrEmpty(user.EmailAddress) || !string.IsNullOrEmpty(user.PrincipalName)) { row = ldapLogins.NewRow(); row["LoginId"] = Guid.NewGuid(); row["LoginName"] = (string.IsNullOrEmpty(user.EmailAddress)) ? user.PrincipalName : user.EmailAddress; row["Name"] = string.Concat(user.FirstName, " ", user.LastName); row["FirstName"] = user.FirstName ?? string.Empty; row["LastName"] = user.LastName ?? string.Empty; row["Email"] = (string.IsNullOrEmpty(user.EmailAddress)) ? ((user.PrincipalName ?? string.Empty).Contains("@") ? user.PrincipalName : string.Empty) : user.EmailAddress; row["LdapUserId"] = user.ObjectGuid; row["Active"] = user.IsActive; row["Password"] = DEFAULT_PASSWORD; row["ProfileUpdated"] = DateTime.Now; row["Deleted"] = false; ldapLogins.Rows.Add(row); } } // Get active mapped local users activeLMLogins = localLogins.Clone(); foreach (DataRow activeLM in localLogins.Select("(Active = 1)")) { newRow = activeLMLogins.NewRow(); newRow.ItemArray = activeLM.ItemArray; activeLMLogins.Rows.Add(newRow); } LocalUsersDeactivate(activeLMLogins, ldapLogins, organizationId, ref ldapProcess, isRealReplication); // Get inactive mapped local users inactiveLMLogins = localLogins.Clone(); foreach (DataRow inactiveLM in localLogins.Select("(Active = 0)")) { newRow = inactiveLMLogins.NewRow(); newRow.ItemArray = inactiveLM.ItemArray; inactiveLMLogins.Rows.Add(newRow); } LocalUsersActivate(inactiveLMLogins, ldapLogins, organizationId, ref ldapProcess, isRealReplication); // Get active ldap users ldapActiveLogins = ldapLogins.Clone(); foreach (DataRow ldapActive in ldapLogins.Select("(Active = 1)")) { if (!string.IsNullOrEmpty(ldapActive["LoginName"] != null ? ldapActive["LoginName"].ToString() : string.Empty)) { newRow = ldapActiveLogins.NewRow(); newRow.ItemArray = ldapActive.ItemArray; ldapActiveLogins.Rows.Add(newRow); } } newColumn = new DataColumn("Processed", typeof(bool)); newColumn.DefaultValue = false; ldapActiveLogins.Columns.Add(newColumn); using (OrganizationsLdapGroupsTableAdapter adapter = new OrganizationsLdapGroupsTableAdapter()) { orgTable = adapter.GetOrganizationsLdapGroupsByOrganizationId(organizationId); if (orgTable.Rows.Count == 0) { ldapHendler = new Bll.Handlers.LdapHandler(); ldapHendler.ImportLdapGroups(organizationId); orgTable = adapter.GetOrganizationsLdapGroupsByOrganizationId(organizationId); } } groupMappings = LdapInfoProvider.GetGroupMappings(organizationId); if (isRealReplication) { logMessage = string.Format(CultureInfo.CurrentCulture, Resources.LdapProcessLog_UpdatingUserAccounts, users.Count); ldapProcess.Logs.Add(new LdapProcessLog() { Date = DateTime.UtcNow, Message = logMessage }); LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage); LocalUsersCheckGroups(organizationId, activeLMLogins, users, orgTable, groupMappings); logMessage = string.Format(CultureInfo.CurrentCulture, Resources.LdapProcessLog_UpdateFinished); ldapProcess.Logs.Add(new LdapProcessLog() { Date = DateTime.UtcNow, Message = logMessage }); LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage); } LocalUsersCreate(localLogins, ldapActiveLogins, organizationId, ref ldapProcess, users, orgTable, groupMappings, isRealReplication); } ldapProcess.ThreadStateType = Bll.ThreadStateType.Finished; logMessage = string.Format(CultureInfo.CurrentCulture, Resources.LdapProcessLog_ReplicationFinished, Math.Round((DateTime.UtcNow - startDate).TotalMinutes, 1)); ldapProcess.Logs.Add(new LdapProcessLog() { Date = DateTime.UtcNow, Message = logMessage }); LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage); } catch (Exception ex) { ldapProcess = LdapInfoProvider.LdapProcesses.Find(x => x.ProcessId == processId); if (ldapProcess != null) { ldapProcess.ProcessId = processId; ldapProcess.ThreadStateType = Bll.ThreadStateType.Failed; ldapProcess.MessageError = string.Format(CultureInfo.InvariantCulture, "<br/>{0}", ex.ToString().Replace("\r\n", "<br/>")); ldapProcess.MessageCreatedLogins = string.Empty; ldapProcess.MessageActivatedLogins = string.Empty; ldapProcess.MessageDeactivatedLogins = string.Empty; ldapProcess.DataCreatedLogins = null; ldapProcess.DataActivatedLogins = null; ldapProcess.DataDeactivatedLogins = null; LdapInfoProvider.InsertLdapLog(organizationId, true, ldapProcess.MessageError); } } finally { processId = null; ldapProcess = null; users = null; if (localLogins != null) { localLogins.Dispose(); } if (ldapLogins != null) { ldapLogins.Dispose(); } //if (localMappedLogins != null) localMappedLogins.Dispose(); if (activeLMLogins != null) { activeLMLogins.Dispose(); } if (inactiveLMLogins != null) { inactiveLMLogins.Dispose(); } if (ldapActiveLogins != null) { ldapActiveLogins.Dispose(); } if (newColumn != null) { newColumn.Dispose(); } if (orgTable != null) { orgTable.Dispose(); } row = null; newRow = null; if (groupMappings != null) { groupMappings.Dispose(); } ldapHendler = null; logMessage = null; } }
public void ReplicateAllOrganizations() { if (!FrameworkConfiguration.Current.WebApplication.Integration.Ldap.Enabled) { throw new InvalidOperationException("Ldap integration is not enabled in the application configuration file."); } int replicated = 0; int errors = 0; int count = 0; using (OrganizationsLdapGroupsTableAdapter adapter = new OrganizationsLdapGroupsTableAdapter()) { OrganizationCollection organizationCollection = OrganizationProvider.GetOrganizations(false, false); DateTime startDate = DateTime.UtcNow; LdapInfoProvider.InsertLdapLog(null, false, Resources.LdapProcessLog_ReplicationAllStarted); foreach (Organization org in organizationCollection) { if (String.IsNullOrEmpty(org.LdapServerAddress) == true || String.IsNullOrEmpty(org.LdapServerPort) == true || String.IsNullOrEmpty(org.LdapUserName) == true || String.IsNullOrEmpty(org.LdapPassword) == true || String.IsNullOrEmpty(org.LdapDomain) == true || !org.Beta) { continue; } //Get All Groups DataView dvDomains = LdapInfoProvider.GetDomains(org.OrganizationId); if (dvDomains.Table.Rows.Count > 0) { for (int i = 0; i < dvDomains.Table.Rows.Count; i++) { DataRow drDomain = dvDomains.Table.Rows[i]; DataView dvGroups = LdapInfoProvider.GetGroupsByDomainDistinguishedName(org.OrganizationId, drDomain["DistinguishedName"].ToString()); if (dvGroups.Table.Rows.Count > 0) { adapter.Delete(org.OrganizationId, drDomain["DomainName"].ToString()); for (int j = 0; j < dvGroups.Table.Rows.Count; j++) { DataRow drGroup = dvGroups.Table.Rows[j]; adapter.Insert(Guid.NewGuid(), org.OrganizationId, (Guid)drDomain["Id"], drDomain["DomainName"].ToString(), (Guid)drGroup["Id"], drGroup["GroupName"].ToString(), drGroup["DistinguishedName"].ToString(), DateTime.UtcNow); } } } } count++; RunADReplication(org.OrganizationId, true); Bll.LdapProcess ldapProcess = LdapInfoProvider.LdapProcesses.Find(x => x.ProcessId == string.Format(CultureInfo.InvariantCulture, "RealADReplication_{0}", org.OrganizationId)); if (ldapProcess != null) { if (ldapProcess.ThreadStateType == ThreadStateType.Failed) { replicated++; } else { errors++; } } } LdapInfoProvider.InsertLdapLog(null, false, string.Format(Resources.LdapProcessLog_ReplicationAllFinished, Math.Round((DateTime.UtcNow - startDate).TotalMinutes, 1), count, replicated, errors)); } }
public void ImportLdapGroups(Guid organizationId) { Organization organization = null; DataView dvDomains = null; DataView dvGroups = null; DataRow drDomain = null; DataRow drGroup = null; try { this.ThreadState = ThreadStateType.Running; if (FrameworkConfiguration.Current.WebApplication.Integration.Ldap.Enabled) { organization = OrganizationProvider.GetOrganization(organizationId); if (organization != null) { if (String.IsNullOrEmpty(organization.LdapServerAddress) == true || String.IsNullOrEmpty(organization.LdapServerPort) == true || String.IsNullOrEmpty(organization.LdapUserName) == true || String.IsNullOrEmpty(organization.LdapPassword) == true || String.IsNullOrEmpty(organization.LdapDomain) == true || !organization.Beta) { return; } dvDomains = LdapInfoProvider.GetDomains(organization.OrganizationId); if (dvDomains.Table.Rows.Count > 0) { using (OrganizationsLdapGroupsTableAdapter adapter = new OrganizationsLdapGroupsTableAdapter()) { for (int i = 0; i < dvDomains.Table.Rows.Count; i++) { drDomain = dvDomains.Table.Rows[i]; dvGroups = LdapInfoProvider.GetGroupsByDomainDistinguishedName(organization.OrganizationId, drDomain["DistinguishedName"].ToString()); if (dvGroups.Table.Rows.Count > 0) { adapter.Delete(organization.OrganizationId, drDomain["DomainName"].ToString()); for (int j = 0; j < dvGroups.Table.Rows.Count; j++) { drGroup = dvGroups.Table.Rows[j]; adapter.Insert(Guid.NewGuid(), organization.OrganizationId, (Guid)drDomain["Id"], drDomain["DomainName"].ToString(), (Guid)drGroup["Id"], drGroup["GroupName"].ToString(), drGroup["DistinguishedName"].ToString(), DateTime.UtcNow); } } } } } } } this.ThreadState = ThreadStateType.Finished; } catch (Exception ex) { this.ThreadState = ThreadStateType.Failed; this.ErrorException = ex; LdapInfoProvider.InsertLdapLog(organizationId, true, ex.Message); } finally { organization = null; drDomain = null; if (dvDomains != null) { dvDomains.Dispose(); } if (dvGroups != null) { dvGroups.Dispose(); } } }