Programmatically access Sitecore user's workbox

I would like to access a user's workbox from C# so that I can loop through all of the items in his workbox and update the workflow state for each version of the items.

I'm using Sitecore 6.2.0 (rev.开发者_StackOverflow中文版 101105)

Thank you for your attention!

---

EDIT: The following code needs to be run under under a master context - "From inside the sitecore admin". If you are running it from a web context (a page on the site) and Context.Database is "web" then you need to replace all instances of Sitecore.Context.Database with Factory.GetDatabase("master")

---

First you need to get all the workflows

Sitecore.Context.Database.WorkflowProvider.GetWorkflows();

Then foreach workflow you need to get all the states:

workflow.GetStates();

Then for each state you can get all the items

var itemDataUris = workflow.GetItems(state);

GetItems returns a list of dataUris So if you are currently logged in with the user in question you can just do

foreach (var dataUri in itemDataUris)
{
    var item = Context.Database.GetItem(dataUri);
    //check if the item is null (if null the user doesn't have access to it
    if (item != null)
       usersWorkflowItems.Add(item); //Here you also need to somehow add which state the item is in
}

If are running as an admin and want to get the item for another user you need to wrap the above code in a UserSwitcher

Sitecore.Security.Accounts.UserSwitcher.Enter(Sitecore.Security.Accounts.User.FromName("sitecore\User", true));
foreach (var dataUri in itemDataUris)
    {
        var item = Context.Database.GetItem(dataUri);
        //check if the item is null (if null the user doesn't have access to it
        if (item != null)
           usersWorkflowItems.Add(item); //Here you also need to somehow add which state the item is in
    }
Sitecore.Security.Accounts.UserSwitcher.Exit();

Hope that helps!

---

Not sure the context of where your code is running, or how often, but could you utilize the RSS feed from the user's workbox?