private static void LocalUsersActivate(DataTable localUsers, DataTable ldapUsers, Guid organizationId, ref Bll.LdapProcess ldapProcess, bool isRealReplication)
{
int count = 0;
DataTable newTable = null;
DataRow[] drm = null;
DataRow newRow = null;
string logMessage = null;
try
{
count = 0;
newTable = localUsers.Clone();
foreach (DataRow dr in localUsers.Rows)
{
drm = ldapUsers.Select(string.Concat("(LdapUserId='", dr["LdapUserId"], "')"));
if (drm.Length > 0)
{
drm = ldapUsers.Select(string.Concat("(LdapUserId='", dr["LdapUserId"], "') AND (Active = 1)"));
if (drm.Length > 0)
{
if (isRealReplication)
{
UserProvider.UpdateUserActive((Guid)dr["LoginId"], organizationId, true);
}
newRow = newTable.NewRow();
newRow.ItemArray = dr.ItemArray;
newTable.Rows.Add(newRow);
count++;
ldapProcess.MessageActivatedLogins = string.Format(CultureInfo.InvariantCulture, isRealReplication ? Resources.OrganizationLdapSettingsControl_RealActivatedLogins_Text : Resources.OrganizationLdapSettingsControl_TestActivatedLogins_Text, count);
}
}
}
ldapProcess.MessageActivatedLogins = string.Format(CultureInfo.InvariantCulture, isRealReplication ? Resources.OrganizationLdapSettingsControl_RealActivatedLogins_Text : Resources.OrganizationLdapSettingsControl_TestActivatedLogins_Text, count);
if (count > 0)
{
newTable.DefaultView.Sort = "LoginName";
ldapProcess.DataActivatedLogins = Micajah.Common.Bll.Support.TrimDataView(newTable.DefaultView, 25);
}
logMessage = string.Format(CultureInfo.CurrentCulture, isRealReplication ? Resources.LdapProcessLog_RealReplicationUsersActivated : Resources.LdapProcessLog_TestReplicationUsersActivated, count);
ldapProcess.Logs.Add(new LdapProcessLog()
{
Date = DateTime.UtcNow, Message = logMessage
});
LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage);
}
finally
{
if (newTable != null)
{
newTable.Dispose();
}
drm = null;
newRow = null;
logMessage = null;
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (new Guid(DomainList.SelectedItem.Value) != new Guid() && new Guid(LdapGroupList.SelectedItem.Value) != new Guid())
{
LdapInfoProvider.InsertGroupMapping(new Guid(AppGroupTreeView.SelectedValue), UserContext.Current.OrganizationId, AppGroupTreeView.SelectedNode.Text, new Guid(DomainList.SelectedItem.Value), DomainList.SelectedItem.Text, new Guid(LdapGroupList.SelectedItem.Value), LdapGroupList.SelectedItem.Text);
CommonGridView1.DataBind();
LdapInfoProvider.UpdateLdapDomains(UserContext.Current.OrganizationId);
AppGroupTreeView.UncheckAllNodes();
AppGroupTreeView.UnselectAllNodes();
DomainList.SelectedIndex = 0;
LdapGroupList.SelectedIndex = 0;
}
}
public Guid CreateLocalUser(IUser user, string groupId)
{
Guid loginId = Guid.Empty;
if (user != null)
{
if (!string.IsNullOrEmpty((string.IsNullOrEmpty(user.EmailAddress) == true) ? user.LdapUserPrinciple : user.EmailAddress))
{
string localGroupId = LdapInfoProvider.GetAppGroupsByLdapGroups(user.OrganizationId, groupId);
loginId = UserProvider.AddUserToOrganization((string.IsNullOrEmpty(user.EmailAddress) == true) ? user.LdapUserPrinciple : user.EmailAddress, user.EmailAddress, user.FirstName, user.LastName, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, localGroupId, user.OrganizationId, user.Password, false, false);
LoginProvider.Current.UpdateUserLdapInfo(user.OrganizationId, loginId, user.FirstName, user.LastName, user.LdapDomain, user.LdapDomainFull, user.LdapUserAlias, user.LdapUserPrinciple, user.UserSid, user.UserId, user.LdapOUPath);
}
}
return(loginId);
}
protected void LdapProcessGetUserGroups(object organizationId)
{
string processId = string.Format("GetUserGroups_{0}_{1}", organizationId, this.UserId);
Bll.LdapProcess ldapProcess = null;
try
{
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.Message = string.Empty;
ldapProcess.Data = null;
LdapInfoProvider.LdapProcesses.Add(ldapProcess);
ldapProcess.Data = LdapInfoProvider.GetUserLdapGroups((Guid)organizationId, this.UserId);
ldapProcess.ThreadStateType = Bll.ThreadStateType.Finished;
}
catch (Exception ex)
{
string error = string.Format(CultureInfo.InvariantCulture, "<br/>{0}", ex.ToString().Replace("\r\n", "<br/>"));
LdapInfoProvider.InsertLdapLog((Guid)organizationId, true, error);
ldapProcess = LdapInfoProvider.LdapProcesses.Find(x => x.ProcessId == processId);
if (ldapProcess != null)
{
ldapProcess.ProcessId = processId;
ldapProcess.ThreadStateType = Bll.ThreadStateType.Failed;
ldapProcess.MessageError = error;
ldapProcess.Message = string.Empty;
ldapProcess.Data = null;
}
}
finally
{
processId = null;
ldapProcess = null;
}
}
public DataSet GetSortedListOfRolesGroupsById(Guid organizationId)
{
ClientDataSet.GroupsInstancesRolesDataTable table = GroupProvider.GetGroupsInstancesRoles(organizationId);
table.Columns.Add("RoleName", typeof(string));
table.Columns.Add("GroupName", typeof(string));
foreach (ClientDataSet.GroupsInstancesRolesRow row in table.Rows)
{
ConfigurationDataSet.RoleRow roleRow = RoleProvider.GetRoleRow((Guid)row["RoleId"]);
if (row != null)
{
row["RoleName"] = roleRow.Name;
}
MasterDataSet.GroupMappingsRow[] groups = LdapInfoProvider.GetGroupMappings(organizationId).Select(string.Format(CultureInfo.InvariantCulture, "GroupId = '{0}' AND OrganizationId = '{1}'", row["GroupId"], organizationId)) as MasterDataSet.GroupMappingsRow[];
if (groups.Length > 0)
{
row["GroupName"] = groups[0].LdapGroupName;
}
}
return(table.DataSet);
}
private static void LocalUsersCheckGroups(Guid organizationId, DataTable localMappedLogins, DomainUserCollection users, MasterDataSet.OrganizationsLdapGroupsDataTable orgTable, MasterDataSet.GroupMappingsDataTable groupMappings)
{
DataView ldapGroups = null;
ClientDataSet.UserRow userRow = null;
StringBuilder newUserGroups = null;
User ldapUser = null;
DomainUser ldapDomainUser = null;
LoginProvider provider = null;
String groupId = null;
Guid ldapUserId = Guid.Empty;
StringBuilder sb = null;
String email = null;
try
{
for (int i = 0; i < users.Count; i++)
{
ldapDomainUser = users[i];
sb = new StringBuilder();
sb.Append("(");
sb.AppendFormat("(LdapUserId='{0}') ", ldapDomainUser.ObjectGuid);
if (!string.IsNullOrEmpty(ldapDomainUser.PrincipalName))
{
sb.AppendFormat(" OR (LoginName = '{0}')", ldapDomainUser.PrincipalName.Replace("'", "''"));
}
else
{
ldapDomainUser.PrincipalName = string.Empty;
}
if (!string.IsNullOrEmpty(ldapDomainUser.EmailAddress))
{
sb.AppendFormat(" OR (LoginName = '{0}')", ldapDomainUser.EmailAddress.Replace("'", "''"));
}
else
{
ldapDomainUser.EmailAddress = string.Empty;
}
sb.Append(")");
foreach (DataRow dr in localMappedLogins.Select(sb.ToString()))
{
try
{
newUserGroups = new StringBuilder(string.Empty);
try { ldapUserId = (Guid)dr["LdapUserId"]; }
catch { ldapUserId = Guid.Empty; }
if (ldapDomainUser.ObjectGuid == ldapUserId ||
ldapDomainUser.PrincipalName.ToLower(CultureInfo.InvariantCulture) == ((string)dr["LoginName"]).ToLower(CultureInfo.InvariantCulture) ||
(ldapDomainUser.EmailAddress != null && ldapDomainUser.EmailAddress.ToLower(CultureInfo.InvariantCulture) == ((string)dr["LoginName"]).ToLower(CultureInfo.InvariantCulture)))
{
foreach (string groupDN in ldapDomainUser.MemberOfGroups)
{
for (int j = 0; j < orgTable.Rows.Count; j++)
{
if (groupDN == orgTable.Rows[j]["DistinguishedName"].ToString())
{
for (int k = 0; k < groupMappings.Rows.Count; k++)
{
if ((Guid)orgTable.Rows[j]["ObjectGUID"] == (Guid)groupMappings.Rows[k]["LdapGroupId"])
{
if (!string.Concat(",", newUserGroups.ToString(), ",").Contains(string.Concat(",", (Guid)groupMappings.Rows[k]["GroupId"], ",")))
{
newUserGroups.AppendFormat(",{0}", (Guid)groupMappings.Rows[k]["GroupId"]);
}
}
}
}
}
}
userRow = UserProvider.GetUserRow((Guid)dr["LoginId"], organizationId, true);
if (userRow == null)
{
continue;
}
UserProvider.UpdateUser((Guid)dr["LoginId"], newUserGroups.ToString(), organizationId, false);
// Check user email
ldapUser = (User)LdapInfoProvider.GetLdapUser(organizationId, ldapDomainUser);
if (ldapUser != null)
{
LoginProvider.Current.UpdateUserLdapInfo(organizationId, (Guid)dr["LoginId"], ldapUser.FirstName, ldapUser.LastName, ldapUser.LdapDomain, ldapUser.LdapDomainFull, ldapUser.LdapUserAlias, ldapUser.LdapUserPrinciple, ldapUser.UserSid, ldapUser.UserId, ldapUser.LdapOUPath);
if (string.IsNullOrEmpty(ldapUser.EmailAddress) == false && string.Compare(userRow.Email, ldapUser.EmailAddress, StringComparison.CurrentCultureIgnoreCase) != 0)
{
provider = new LoginProvider();
if (!provider.LoginNameExists(ldapUser.EmailAddress))
{
email = userRow.Email;
UserProvider.UpdateUser(userRow.UserId, ldapUser.EmailAddress, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, groupId, organizationId, false);
}
if (provider != null)
{
provider = null;
}
}
}
UserProvider.RaiseUserUpdated(userRow.UserId, organizationId, Bll.Support.ConvertStringToGuidList(newUserGroups.ToString()), email);
break;
}
}
catch (Exception ex)
{
LdapInfoProvider.InsertLdapLog(organizationId, true, string.Format(CultureInfo.InvariantCulture, "<br/>{0}", ex.ToString().Replace("\r\n", "<br/>")));
}
}
}
}
finally
{
if (ldapGroups != null)
{
ldapGroups.Dispose();
}
if (newUserGroups != null)
{
newUserGroups.Remove(0, newUserGroups.Length);
newUserGroups = null;
}
if (sb != null)
{
sb.Remove(0, sb.Length);
sb = null;
}
ldapUser = null;
userRow = null;
provider = null;
groupId = null;
email = null;
}
}
private static void LocalUsersCreate(DataTable localUsers, DataTable ldapUsers, Guid organizationId, ref Bll.LdapProcess ldapProcess, DomainUserCollection users, MasterDataSet.OrganizationsLdapGroupsDataTable orgTable, MasterDataSet.GroupMappingsDataTable groupMappings, bool isRealReplication)
{
int count = 0;
DataTable newTable = null;
DataRow[] drm = null;
StringBuilder sb = null;
DataRow[] drm2 = null;
Collection <string> altEmails;
string ldapGroupIds = null;
string localGroupIds = null;
Guid loginId = Guid.Empty;
IUser user = null;
DataRow newRow = null;
DomainUser ldapUser = null;
string email = null;
string logMessage = null;
try
{
count = 0;
newTable = ldapUsers.Clone();
foreach (DataRow dr in ldapUsers.Rows)
{
try
{
if ((bool)dr["Processed"])
{
continue;
}
drm = localUsers.Select(string.Format(CultureInfo.InvariantCulture, "(LdapUserId='{0}') OR (LoginName='{1}')", dr["LdapUserId"].ToString().Replace("'", "''"), dr["LoginName"].ToString().Replace("'", "''")));
if (drm.Length == 0)
{
drm2 = null;
sb = new StringBuilder();
altEmails = new Collection <string>();
for (int i = 0; i < users.Count; i++)
{
ldapUser = users[i];
if (ldapUser.ObjectGuid == (Guid)dr["LdapUserId"])
{
if (ldapUser.AltEmails != null)
{
foreach (string altEmail in ldapUser.AltEmails)
{
if (altEmail.Contains("@"))
{
email = (altEmail.ToUpper(CultureInfo.InvariantCulture).Contains("SMTP")) ? altEmail.Remove(0, 5).ToString() : altEmail;
if (string.Compare(ldapUser.EmailAddress, email, StringComparison.InvariantCultureIgnoreCase) != 0)
{
altEmails.Add(email);
sb.AppendFormat(CultureInfo.InvariantCulture, " OR (LoginName='{0}')", (altEmail.ToUpper(CultureInfo.InvariantCulture).Contains("SMTP")) ? altEmail.Remove(0, 5).ToString().Replace("'", "''") : altEmail.Replace("'", "''"));
}
}
}
}
if (sb.Length > 0)
{
sb.Remove(0, 4);
drm2 = localUsers.Select(sb.ToString());
}
if (drm2 == null || drm2.Length == 0)
{
if (isRealReplication)
{
sb = new StringBuilder();
foreach (string groupDN in ldapUser.MemberOfGroups)
{
for (int j = 0; j < orgTable.Rows.Count; j++)
{
if (groupDN == orgTable.Rows[j]["DistinguishedName"].ToString())
{
sb.AppendFormat(CultureInfo.InvariantCulture, ",{0}", orgTable.Rows[j]["ObjectGUID"]);
}
}
}
if (EmailProvider.IsEmailExists((string)dr["LoginName"]))
{
EmailProvider.DeleteEmails(Guid.Empty, (string)dr["LoginName"]);
}
ldapGroupIds = (sb.Length > 0) ? sb.Remove(0, 1).ToString() : string.Empty;
localGroupIds = LdapInfoProvider.GetAppGroupsByLdapGroups(organizationId, ldapGroupIds);
loginId = UserProvider.AddUserToOrganization((string)dr["LoginName"], ((dr["Email"]).GetType() == typeof(System.DBNull)) ? string.Empty : (string)dr["Email"], ((dr["FirstName"]).GetType() == typeof(System.DBNull)) ? string.Empty : (string)dr["FirstName"], ((dr["LastName"]).GetType() == typeof(System.DBNull)) ? string.Empty : (string)dr["LastName"], string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, localGroupIds, organizationId, DEFAULT_PASSWORD, false, false);
UserProvider.RaiseUserInserted(loginId, organizationId, null, Bll.Support.ConvertStringToGuidList(localGroupIds));
user = LdapInfoProvider.GetLdapUser(organizationId, ldapUser);
if (user != null)
{
LoginProvider.Current.UpdateUserLdapInfo(organizationId, loginId, user.FirstName, user.LastName, user.LdapDomain, user.LdapDomainFull, user.LdapUserAlias, user.LdapUserPrinciple, user.UserSid, user.UserId, user.LdapOUPath);
foreach (string altEmail in altEmails)
{
if (!EmailProvider.IsEmailExists(altEmail))
{
EmailProvider.InsertEmail(altEmail, loginId);
}
}
}
}
dr["Processed"] = true;
newRow = newTable.NewRow();
newRow.ItemArray = dr.ItemArray;
newTable.Rows.Add(newRow);
count++;
ldapProcess.MessageCreatedLogins = string.Format(CultureInfo.InvariantCulture, isRealReplication ? Resources.OrganizationLdapSettingsControl_RealCreatedLogins_Text : Resources.OrganizationLdapSettingsControl_TestCreatedLogins_Text, count);
}
break;
}
}
}
else
{
dr["Processed"] = true;
}
}
catch (Exception ex)
{
dr["Processed"] = true;
LdapInfoProvider.InsertLdapLog(organizationId, true, string.Format(CultureInfo.InvariantCulture, "<br/>{0}", ex.ToString().Replace("\r\n", "<br/>")));
}
}
ldapProcess.MessageCreatedLogins = string.Format(CultureInfo.InvariantCulture, isRealReplication ? Resources.OrganizationLdapSettingsControl_RealCreatedLogins_Text : Resources.OrganizationLdapSettingsControl_TestCreatedLogins_Text, count);
if (count > 0)
{
newTable.DefaultView.Sort = "LoginName";
ldapProcess.DataCreatedLogins = Micajah.Common.Bll.Support.TrimDataView(newTable.DefaultView, 25);
}
logMessage = string.Format(CultureInfo.CurrentCulture, isRealReplication ? Resources.LdapProcessLog_RealReplicationUsersCreated : Resources.LdapProcessLog_TestReplicationUsersCreated, count);
ldapProcess.Logs.Add(new LdapProcessLog()
{
Date = DateTime.UtcNow, Message = logMessage
});
LdapInfoProvider.InsertLdapLog(organizationId, false, logMessage);
}
finally
{
if (newTable != null)
{
newTable.Dispose();
}
drm = null;
if (sb != null)
{
sb.Remove(0, sb.Length);
sb = null;
}
altEmails = null;
drm2 = null;
ldapGroupIds = null;
localGroupIds = null;
loginId = Guid.Empty;
user = null;
newRow = null;
ldapUser = null;
email = 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 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 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();
}
}
}
protected void LdapProcessReconnectUserToLdap(object arg)
{
UserContext userContext = null;
string processId = null;
Bll.LdapProcess ldapProcess = null;
ApplicationLogger log = null;
LdapIntegration ldap = null;
string loginName = null;
LdapAdapter.IUser ldapUser = null;
try
{
userContext = arg as UserContext;
if (userContext != null)
{
processId = string.Format("ReconnectUserToLdap_{0}_{1}", userContext.OrganizationId, this.UserId);
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.Message = string.Empty;
ldapProcess.Data = null;
LdapInfoProvider.LdapProcesses.Add(ldapProcess);
log = new ApplicationLogger();
ldap = new LdapIntegration(log);
loginName = LoginProvider.Current.GetLoginName(this.UserId);
ldapUser = LdapInfoProvider.GetLdapUser(userContext.OrganizationId, loginName);
if (ldapUser != null)
{
ldap.CreateUserEmails(LdapInfoProvider.GetLdapUserAltEmails(userContext.OrganizationId, ldapUser.UserId, false), ldapUser);
LoginProvider.Current.UpdateUserLdapInfo(userContext.OrganizationId, this.UserId, ldapUser.FirstName, ldapUser.LastName, ldapUser.LdapDomain, ldapUser.LdapDomainFull, ldapUser.LdapUserAlias, ldapUser.LdapUserPrinciple, ldapUser.UserSid, ldapUser.UserId, ldapUser.LdapOUPath);
}
ldapProcess.ThreadStateType = Bll.ThreadStateType.Finished;
}
}
catch (Exception ex)
{
string error = string.Format(CultureInfo.InvariantCulture, "<br/>{0}", ex.ToString().Replace("\r\n", "<br/>"));
LdapInfoProvider.InsertLdapLog(userContext.OrganizationId, true, error);
ldapProcess = LdapInfoProvider.LdapProcesses.Find(x => x.ProcessId == processId);
if (ldapProcess != null)
{
ldapProcess.ProcessId = processId;
ldapProcess.ThreadStateType = Bll.ThreadStateType.Failed;
ldapProcess.MessageError = error;
ldapProcess.Message = string.Empty;
ldapProcess.Data = null;
}
}
finally
{
userContext = null;
processId = null;
ldapProcess = null;
log = null;
loginName = null;
ldapUser = null;
}
}