protected void Page_Load(object sender, EventArgs e)
{
string lDapDomainName = FriendlyDomainToLdapDomain("MIT.SPF.COM");
SaveAllDepartmentsToList(GetAllAuthenticatedUsers(lDapDomainName));
SaveDataToEmployeeList(GetAllAuthenticatedUsers(lDapDomainName));
}
//Get LDAP domain name
public static string FriendlyDomainToLdapDomain(string friendlyDomainName)
{
string ldapPath = null;
try
{
DirectoryContext objContext = new DirectoryContext(
DirectoryContextType.Domain, friendlyDomainName);
Domain objDomain = Domain.GetDomain(objContext);
ldapPath = objDomain.Name;
}
catch (DirectoryServicesCOMException e)
{
ldapPath = e.Message.ToString();
}
return ldapPath;
}
//Get all users from AD
private List<Principal> GetAllAuthenticatedUsers(string domainName)
{
List<Principal> lstUsers = new List<Principal>();
try
{
PrincipalContext context = new PrincipalContext(ContextType.Domain, domainName);
// Create search condition for all enabled users
PrincipalSearcher searcher = new PrincipalSearcher();
UserPrincipal user = new UserPrincipal(context);
user.Enabled = true;
user.Name = "*";
searcher.QueryFilter = user;
// Get the users
System.DirectoryServices.AccountManagement.PrincipalSearchResult<Principal> results = searcher.FindAll();
foreach (Principal principal in results)
{
lstUsers.Add(principal);
}
}
catch
{
}
return lstUsers;
}
//Save all departments(Insert/Update)
private void SaveAllDepartmentsToList(List<Principal> allUsers)
{
using (SPSite site = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists["Department"];
Hashtable objHash = new Hashtable();
//GET all departments using AD
foreach (Principal objP in allUsers)
{
DirectoryEntry dirEntry = (objP.GetUnderlyingObject() as DirectoryEntry);
if (dirEntry != null)
{
if (dirEntry.Properties.Contains("department"))
{
if (!objHash.ContainsKey(dirEntry.Properties["department"].Value))
{
objHash.Add(dirEntry.Properties["department"].Value, dirEntry.Properties["department"].Value);
}
}
}
}
foreach (string depName in objHash.Keys)
{
SPItem item = GetCorrectListItemOrNewListItem(depName, list);
//Save all departments to List
item["Title"] = depName;
item["Name"] = depName;
item["Active"] = true;
web.AllowUnsafeUpdates = true;
item.Update();
web.AllowUnsafeUpdates = false;
}
}
}
}
//Save Employee inforamtion(Insert/Update)
private void SaveDataToEmployeeList(List<Principal> allUsers)
{
using (SPSite site = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb web = site.OpenWeb())
{
SPList empList = web.Lists["Employee"];
//Set all departments using AD
foreach (Principal objP in allUsers)
{
DirectoryEntry de = (objP.GetUnderlyingObject() as DirectoryEntry);
if (de != null)
{
SPListItem item = null;
if (de.Properties.Contains("givenName") && de.Properties.Contains("department"))
{
item = GetCorrectListItemOrNewListItem(de.Properties["givenName"].Value.ToString(), empList);
SPList depList = web.Lists["Department"];
item["Department"] = CreateEmployeeDepartmentLookupString(de.Properties["department"].Value.ToString(), depList);
}
else//No name || No department, can't add to the system
{
continue;
}
if (de.Properties.Contains("manager"))
{
string ibName = de.Properties["manager"].Value.ToString().Split(',')[0];
ibName = ibName.Remove(0, 3);//Removing 'CN='
SPUser ibUser = SPContext.Current.Web.EnsureUser(ibName);
item["Immediate Superior"] = ibUser;
}
if (de.Properties.Contains("givenName"))
{
item["First Name"] = de.Properties["givenName"].Value;
}
if (de.Properties.Contains("sn"))
{
item["Last Name"] = de.Properties["sn"].Value;
}
if (de.Properties.Contains("telephoneNumber"))
{
item["Mobile Number"] = de.Properties["telephoneNumber"].Value;
}
if (de.Properties.Contains("mail"))
{
item["Email"] = de.Properties["mail"].Value;
}
item["Title"] = de.Properties["givenName"].Value;
item["Active"] = true;
web.AllowUnsafeUpdates = true;
item.Update();
web.AllowUnsafeUpdates = false;
}
}
}
}
}
private SPListItem GetCorrectListItemOrNewListItem(string entryName, SPList empList)
{
SPQuery query = new SPQuery();
query.Query = ""
SPListItemCollection objCol = empList.GetItems(query);
SPListItem empItem = null;
if (objCol != null && objCol.Count > 0)
{
//Return current item
empItem = objCol[0];
}
else
{
//no data found, so creating new item
empItem = empList.Items.Add();
}
return empItem;
}
//Create Lookup between "Employee" list and "Department" list
private string CreateEmployeeDepartmentLookupString(string entryName, SPList depList)
{
SPQuery query = new SPQuery();
query.Query = ""
SPListItemCollection objCol = depList.GetItems(query);
if (objCol != null && objCol.Count >= 1)
{
SPListItem depItem = objCol[0];
string depName = depItem["Name"].ToString();
int spItemID = depItem.ID;
return spItemID.ToString() + ";#" + depName;
}
else
return string.Empty;
}
All Departments
2 comments:
How would one input this code into a sharepoint list? I am new to sharepoint.
This is a working solution, thanks, appreciate your effort.
For those who get error in the page_load code, put (HostingEnvironment.Impersonate()){ } around the code.
Example:
protected void Page_Load(object sender, EventArgs e)
{
using (HostingEnvironment.Impersonate())
{
string lDapDomainName = FriendlyDomainToLdapDomain("YOURDOMAIN.local");
SaveDataToEmployeeList(GetAllAuthenticatedUsers(lDapDomainName));
}
}
That will get it to work!
Post a Comment