public string[] GetAllSharePointPeople()
{
SPSite Site = new SPSite("http://crm-srv:6677/");
SPUserCollection AllUsers = Site.RootWeb.AllUsers;
string strUserName = string.Empty;
foreach (SPUser user in AllUsers)
{
if (strUserName == string.Empty)
{
strUserName = user.Name.ToString();
}
else
{
strUserName += "/" + user.Name.ToString();
}
}
return strUserName.Split('/');
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dtTable = new DataTable();
dtTable.Columns.Add("DocumentName");
dtTable.Columns.Add("UnViewedPeopleName");
string[] arrAllUsers = GetAllSharePointPeople().Distinct().ToArray();
SPSite oSiteCollection = new SPSite("http://crm-srv:6677/");
SPWebCollection collWebsites = oSiteCollection.AllWebs;
foreach (SPWeb oWebsite in collWebsites)
{
SPListCollection collLists = oWebsite.Lists;
foreach (SPList oList in collLists)
{
if (oList.BaseType == SPBaseType.DocumentLibrary)
{
SPDocumentLibrary oDocumentLibrary = (SPDocumentLibrary)oList;
if (oList.BaseTemplate == SPListTemplateType.DocumentLibrary)
{
SPListItemCollection collListItems = oDocumentLibrary.Items;
string viewedUserName = string.Empty;
foreach (SPListItem oListItem in collListItems)
{
if (oList.Title != "Site Collection Images" &&
oList.Title != "Images" &&
oList.Title != "Style Library" &&
oList.Title != "Reporting Templates" &&
oList.Title != "Application Pages")
{
string strWebSiteName = oWebsite.Name;
string strListTitle = oList.Title;
string strListItemName = oListItem.Name;
SPAuditQuery wssQuery;
SPAuditEntryCollection auditCol;
wssQuery = new SPAuditQuery(oSiteCollection);
wssQuery.RestrictToListItem(oListItem);
auditCol = oWebsite.Audit.GetEntries(wssQuery);
foreach (SPAuditEntry oAuditEntry in auditCol)
{
if (oAuditEntry.Event.ToString() == "View")
{
string[] strArray = oAuditEntry.DocLocation.ToString().Split('/');
if (strArray[strArray.Length - 1] == strListItemName)
{
if (viewedUserName == string.Empty)
{
viewedUserName = oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
}
else
{
viewedUserName += "/" + oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
}
strListItemName = string.Empty;
}
}
}
}
string[] arrViewedUsers=viewedUserName.Split('/');
string[] arrNotViewUsers = arrAllUsers.Except(arrViewedUsers).ToArray();
foreach (string arr in arrNotViewUsers)
{
DataRow dr = dtTable.NewRow();
dr["DocumentName"]=oListItem.Name;
dr["UnViewedPeopleName"] = arr;
dtTable.Rows.Add(dr);
}
viewedUserName = string.Empty;
}
}
}
}
oWebsite.Dispose();
}
DataTable dt = dtTable;
}
{
SPSite Site = new SPSite("http://crm-srv:6677/");
SPUserCollection AllUsers = Site.RootWeb.AllUsers;
string strUserName = string.Empty;
foreach (SPUser user in AllUsers)
{
if (strUserName == string.Empty)
{
strUserName = user.Name.ToString();
}
else
{
strUserName += "/" + user.Name.ToString();
}
}
return strUserName.Split('/');
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dtTable = new DataTable();
dtTable.Columns.Add("DocumentName");
dtTable.Columns.Add("UnViewedPeopleName");
string[] arrAllUsers = GetAllSharePointPeople().Distinct().ToArray();
SPSite oSiteCollection = new SPSite("http://crm-srv:6677/");
SPWebCollection collWebsites = oSiteCollection.AllWebs;
foreach (SPWeb oWebsite in collWebsites)
{
SPListCollection collLists = oWebsite.Lists;
foreach (SPList oList in collLists)
{
if (oList.BaseType == SPBaseType.DocumentLibrary)
{
SPDocumentLibrary oDocumentLibrary = (SPDocumentLibrary)oList;
if (oList.BaseTemplate == SPListTemplateType.DocumentLibrary)
{
SPListItemCollection collListItems = oDocumentLibrary.Items;
string viewedUserName = string.Empty;
foreach (SPListItem oListItem in collListItems)
{
if (oList.Title != "Site Collection Images" &&
oList.Title != "Images" &&
oList.Title != "Style Library" &&
oList.Title != "Reporting Templates" &&
oList.Title != "Application Pages")
{
string strWebSiteName = oWebsite.Name;
string strListTitle = oList.Title;
string strListItemName = oListItem.Name;
SPAuditQuery wssQuery;
SPAuditEntryCollection auditCol;
wssQuery = new SPAuditQuery(oSiteCollection);
wssQuery.RestrictToListItem(oListItem);
auditCol = oWebsite.Audit.GetEntries(wssQuery);
foreach (SPAuditEntry oAuditEntry in auditCol)
{
if (oAuditEntry.Event.ToString() == "View")
{
string[] strArray = oAuditEntry.DocLocation.ToString().Split('/');
if (strArray[strArray.Length - 1] == strListItemName)
{
if (viewedUserName == string.Empty)
{
viewedUserName = oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
}
else
{
viewedUserName += "/" + oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
}
strListItemName = string.Empty;
}
}
}
}
string[] arrViewedUsers=viewedUserName.Split('/');
string[] arrNotViewUsers = arrAllUsers.Except(arrViewedUsers).ToArray();
foreach (string arr in arrNotViewUsers)
{
DataRow dr = dtTable.NewRow();
dr["DocumentName"]=oListItem.Name;
dr["UnViewedPeopleName"] = arr;
dtTable.Rows.Add(dr);
}
viewedUserName = string.Empty;
}
}
}
}
oWebsite.Dispose();
}
DataTable dt = dtTable;
}
No comments:
Post a Comment