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();
}
}
}
