It's been tough finding good material on Project Server/SharePoint integration from a development standpoint.
What I'd like to do is create a web part that can be deployed to any sharepoint site, that gets all reminders (Tasks, timelines, timecards, issues, risks etc...) for a given SPUser.
It seems to me I need to be able to do the following:
- Find Project Server Site in current Farm/Site Collection
- Find all List Items where AssignedTo = SPUser
- Returns this collection for sorting, rendering etc...
I've seen a couple walkthroughs that demand you have a Project Server Web Part on the page to get that information, and I need to be able to do this without that dependency. Where do I start?
Can I do something like:
var rootSiteCol =SPContext.Current.Web.Site.WebApplication.Sites[0].Url
var ProjectSite = rootSiteCol.AllSitesAndWeb["Project"];
var Lists = ProjectSite.AllLists;
foreach(List in Lists)
{
//Enumerate and win!!
}