private void GetAllActionsOwed()
{
List<ActionOwed> actionsOwed = new List<ActionOwed>();
string[] actionsOwedSites = sites.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
if (this.WebPart.NamesOfUsers.Length > 0)
{
string[] namesOfUsers = this.WebPart.NamesOfUsers.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
StringBuilder sbQueryForUser = new StringBuilder();
foreach (string nameOfUser in namesOfUsers)
{
foreach (string site in actionsOwedSites)
{
using (SPSite emisSite = new SPSite(site))
{
using (SPWeb emisRootWeb = emisSite.OpenWeb())
{
//Get all agendas
SPList baList = emisRootWeb.Lists["Board Agenda"];
SPQuery queryFutureAgendas = new SPQuery()
{
Query = string.Format(@"<Query>
<Where>
<Geq><FieldRef Name='MeetingDate' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{0}</Value>
</Geq>
</Where>
</Query>", SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Today))
};
foreach (SPListItem futureAgenda in baList.GetItems(queryFutureAgendas))
{
if (futureAgenda["MeetingDate"] != null)
{
if (DateTime.Parse(futureAgenda["MeetingDate"].ToString()) > DateTime.Today)
{
SPFieldUrlValue workspaceURLField = new SPFieldUrlValue(futureAgenda["DocumentWorkspace"].ToString());
string workspaceURL = workspaceURLField.Url;
if (workspaceURL.IndexOf("Shared Documents") > 0)
{
workspaceURL = workspaceURL.Substring(0, workspaceURL.IndexOf("Shared Documents") - 1);
}
string relativeWSURL = workspaceURL.Remove(0, site.Length);
relativeWSURL = relativeWSURL.Replace("/", "");
//Now open up the workspace
using (SPWeb subSite = emisSite.OpenWeb(relativeWSURL))
{
try
{
SPList agendaTaskList = subSite.Lists["Agenda Tasks"];
if (agendaTaskList != null)
{
SPQuery queryForActionsOwed = new SPQuery()
{
Query = string.Format(@"<Where>
<And>
<Eq>
<FieldRef Name='AssignedTo' />
<Value Type='User'>{0}</Value>
</Eq>
<Neq>
<FieldRef Name='Status' />
<Value Type='Choice'>Completed</Value>
</Neq>
</And>
</Where>
<OrderBy>
<FieldRef Name='DueDate'/>
</OrderBy>", nameOfUser)
};
foreach (SPListItem activeTask in agendaTaskList.GetItems(queryForActionsOwed))
{
ActionOwed action = new ActionOwed()
{
TaskID = activeTask["ID"].ToString(),
Title = activeTask["Title"].ToString(),
DueDate = DateTime.Parse(activeTask["DueDate"].ToString()),
Status = activeTask["Status"].ToString(),
OriginalAssignee = (activeTask["OriginalAssignee"] != null) ? activeTask["OriginalAssignee"].ToString() : String.Empty,
Action = (activeTask["ActionOwed"] != null) ? activeTask["ActionOwed"].ToString() : String.Empty,
Source = (activeTask["TaskSource"] != null) ? activeTask["TaskSource"].ToString() : String.Empty,
FileRef = activeTask["FileRef"].ToString(),
TaskSite = site
};
if (activeTask["IsDelegated"] == null)
{
action.IsDelegated = false;
}
else if (string.IsNullOrEmpty(activeTask["IsDelegated"].ToString()))
{
action.IsDelegated = false;
}
else if (activeTask["IsDelegated"].ToString() == "1")
{
action.IsDelegated = true;
}
else if (bool.Parse(activeTask["IsDelegated"].ToString()))
{
action.IsDelegated = true;
}
string taskRelativeLink = activeTask["FileRef"].ToString().Substring(activeTask["FileRef"].ToString().IndexOf("#") + 1, (activeTask["FileRef"].ToString().Length - activeTask["FileRef"].ToString().IndexOf("#") - 1));
action.TaskLink = taskRelativeLink;
action.AssignedTo = activeTask["AssignedTo"].ToString().Substring(activeTask["AssignedTo"].ToString().IndexOf("#") + 1, (activeTask["AssignedTo"].ToString().Length - activeTask["AssignedTo"].ToString().IndexOf("#") - 1));
actionsOwed.Add(action);
}
}
}
catch (Exception exc)
{
Microsoft.Office.Server.Diagnostics.PortalLog.LogString("ActionsOwed WebPart: There was an error while getting data out from {0}. The error was {1}. The stack trace is {2}.", subSite.Url, exc.Message, exc.StackTrace);
}
}
}
}
}
}
}
}
}
grdActionsOwed.DataSource = actionsOwed;
grdActionsOwed.DataBind();
}
}
private void GetAllActionsOwed(string userID)
{
List<ActionOwed> actionsOwed = new List<ActionOwed>();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
string[] actionsOwedSites = sites.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string site in actionsOwedSites)
{
using (SPSite emisSite = new SPSite(site))
{
using (SPWeb emisRootWeb = emisSite.OpenWeb())
{
SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = "<Lists ServerTemplate=\"107\" />";
query.ViewFields = "<FieldRef Name=\"Title\" />" +
"<FieldRef Name=\"ID\" />" +
"<FieldRef Name=\"AssignedTo\" Nullable=\"TRUE\" Type=\"User\" />" +
"<FieldRef Name=\"Status\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"DueDate\" Nullable=\"TRUE\" Type=\"DateTime\" />" +
"<FieldRef Name=\"IsDelegated\" Nullable=\"TRUE\" Type=\"Boolean\" />" +
"<FieldRef Name=\"OriginalAssignee\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"ActionOwed\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"TaskSource\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"FileRef\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"Related Content\" Nullable=\"TRUE\" Type=\"Text\" />";
query.Query =
"<Where>" +
"<And>" +
"<Eq>" +
"<FieldRef Name='AssignedTo' />" +
" <Value Type='User'>" + userID + "</Value>" +
"</Eq>" +
"<Neq>" +
"<FieldRef Name='Status' />" +
"<Value Type='Choice'>Completed</Value>" +
"</Neq>" +
"</And>" +
"</Where>" +
"<OrderBy>" +
"<FieldRef Name=\"DueDate\" />" +
"</OrderBy>";
query.Webs = "<Webs Scope=\"SiteCollection\" />";
Microsoft.Office.Server.Diagnostics.PortalLog.LogString("ActionsOwed WebPart: About to get data from all subsites for {0}", site);
Microsoft.Office.Server.Diagnostics.PortalLog.LogString("ActionsOwed WebPart: SPSiteDataQuery = {0}", query.Query);
DataTable dt = emisRootWeb.GetSiteData(query);
Microsoft.Office.Server.Diagnostics.PortalLog.LogString("ActionsOwed WebPart: Got data from all subsites for {0}", site);
foreach (DataRow row in dt.Rows)
{
ActionOwed action = new ActionOwed()
{
TaskID = row["ID"].ToString(),
Title = row["Title"].ToString(),
DueDate = DateTime.Parse(row["DueDate"].ToString()),
Status = row["Status"].ToString(),
OriginalAssignee = row["OriginalAssignee"].ToString(),
Action = row["ActionOwed"].ToString(),
Source = row["TaskSource"].ToString(),
FileRef = row["FileRef"].ToString(),
TaskSite = site
};
if (string.IsNullOrEmpty(row["IsDelegated"].ToString()))
{
action.IsDelegated = false;
}
else if (row["IsDelegated"].ToString() == "1")
{
action.IsDelegated = true;
}
else if (bool.Parse(row["IsDelegated"].ToString()))
{
action.IsDelegated = true;
}
string taskRelativeLink = row["FileRef"].ToString().Substring(row["FileRef"].ToString().IndexOf("#") + 1, (row["FileRef"].ToString().Length - row["FileRef"].ToString().IndexOf("#") - 1));
action.TaskLink = taskRelativeLink;
action.AssignedTo = row["AssignedTo"].ToString().Substring(row["AssignedTo"].ToString().IndexOf("#") + 1, (row["AssignedTo"].ToString().Length - row["AssignedTo"].ToString().IndexOf("#") - 1));
actionsOwed.Add(action);
}
}
}
}
});
grdActionsOwed.DataSource = actionsOwed;
grdActionsOwed.DataBind();
}
void chkRecentTasksOnly_CheckedChanged(object sender, EventArgs e)
{
chkMyDelegatedTasks.Checked = false;
InitializeWebAppProperties();
if (chkRecentTasksOnly.Checked)
{
string[] actionsOwedSites = sites.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
List<ActionOwed> actionsOwed = new List<ActionOwed>();
DateTime yesterday = DateTime.Today.AddDays(-1);
foreach (string site in actionsOwedSites)
{
using (SPSite emisSite = new SPSite(site))
{
using (SPWeb emisRootWeb = emisSite.OpenWeb())
{
SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = "<Lists ServerTemplate=\"107\" />";
query.ViewFields = "<FieldRef Name=\"Title\" />" +
"<FieldRef Name=\"ID\" />" +
"<FieldRef Name=\"AssignedTo\" Nullable=\"TRUE\" Type=\"User\" />" +
"<FieldRef Name=\"Status\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"DueDate\" Nullable=\"TRUE\" Type=\"DateTime\" />" +
"<FieldRef Name=\"IsDelegated\" Nullable=\"TRUE\" Type=\"Boolean\" />" +
"<FieldRef Name=\"OriginalAssignee\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"ActionOwed\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"TaskSource\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"FileRef\" Nullable=\"TRUE\" Type=\"Text\" />" +
"<FieldRef Name=\"Related Content\" Nullable=\"TRUE\" Type=\"Text\" />";
query.Query =
"<Where>" +
"<And>" +
"<Geq>" +
"<FieldRef Name='Created' />" +
"<Value IncludeTimeValue='FALSE' Type='DateTime'>" + SPUtility.CreateISO8601DateTimeFromSystemDateTime(yesterday) + "</Value>" +
"</Geq>" +
"<And>" +
"<Eq>" +
"<FieldRef Name='AssignedTo' />" +
" <Value Type='User'><UserID/></Value>" +
"</Eq>" +
"<Neq>" +
"<FieldRef Name='Status' />" +
"<Value Type='Choice'>Completed</Value>" +
"</Neq>" +
"</And>" +
"</And>" +
"</Where>" +
"<OrderBy>" +
"<FieldRef Name=\"DueDate\" />" +
"</OrderBy>";
query.Webs = "<Webs Scope=\"SiteCollection\" />";
DataTable dt = emisRootWeb.GetSiteData(query);
foreach (DataRow row in dt.Rows)
{
ActionOwed action = new ActionOwed()
{
TaskID = row["ID"].ToString(),
Title = row["Title"].ToString(),
DueDate = DateTime.Parse(row["DueDate"].ToString()),
Status = row["Status"].ToString(),
OriginalAssignee = row["OriginalAssignee"].ToString(),
Action = row["ActionOwed"].ToString(),
Source = row["TaskSource"].ToString(),
FileRef = row["FileRef"].ToString(),
TaskSite = site
};
if (string.IsNullOrEmpty(row["IsDelegated"].ToString()))
{
action.IsDelegated = false;
}
else if (row["IsDelegated"].ToString() == "1")
{
action.IsDelegated = true;
}
else if (bool.Parse(row["IsDelegated"].ToString()))
{
action.IsDelegated = true;
}
string taskRelativeLink = row["FileRef"].ToString().Substring(row["FileRef"].ToString().IndexOf("#") + 1, (row["FileRef"].ToString().Length - row["FileRef"].ToString().IndexOf("#") - 1));
action.TaskLink = taskRelativeLink;
action.AssignedTo = row["AssignedTo"].ToString().Substring(row["AssignedTo"].ToString().IndexOf("#") + 1, (row["AssignedTo"].ToString().Length - row["AssignedTo"].ToString().IndexOf("#") - 1));
actionsOwed.Add(action);
}
}
}
}
grdActionsOwed.DataSource = actionsOwed;
grdActionsOwed.DataBind();
}
else
{
GetAllActionsOwed(SPContext.Current.Web.CurrentUser.Name);
}
}