Thursday, July 08, 2010 3:05 PM
I'm doing a customization in PWA 2010, and I need change the resource of the task using a simple update in SQL Server. Currently I'm updating MSP_ASSIGNMENTS table, but it isn't sufficient to change de resource, anyone can help me?
I could use the Project Web Services, but I cant found anything like that.
PS: I enabled the trace of SQL Server to discovery all tables that can be update, and changed the resource by pwa interface, but I can't discovery anything.
PS2: Sorry about my english, I'm brazilian and I don't speak english very well. =D
Thursday, July 08, 2010 11:41 PMModerator
In general, we don't support changes to the data going directly to the database. You will miss out on any business rule logic that we have in the app tier. If you can shed some light on what you need to change, we may be able to help out pointing you to samples or code snippets that will help you accomplish what you need.
Monday, July 12, 2010 6:03 PM
Hi, tks for your help.
So, I'll explain about my app. I created a webPart that have a vizualization look like My Tasks of PWA, but this tasks don't have anyone resource, when I loggin in PWA I can get any tasks, but I don't found anything like that, so I created the new WebPart, but I have this problem.
Monday, July 12, 2010 7:54 PMModerator
Your Web Part needs to call the PSI to change the task assignment to the current user, or to another resource. Depending on what you want to do, the methods might include DelegateAssignments, ReadProject, ReadProjectEntities, QueueUpdateProject, and others (CheckOutProject, QueuePublishProject, CheckInProject, GetCurrentUserUid, and so forth).
You should use the WCF interface with the ProjectServerServices.dll proxy assembly, and programmatically configure the service, as explained in Walkthrough: Developing PSI Applications Using WCF.
Whatever you do, don't directly change the Draft or Published databases, or you could corrupt Project Server data. See About Accessing the Project Server Databases in Project Server Programmability.
- Marked As Answer by Jim CorbinModerator Monday, July 12, 2010 7:55 PM