How to cancel the deletion of an item (using ItemDeleting event) and set a property instead?

Question

I have a list with requests. This list is monitored by BizzTalk and synced with an external system.

In the list is a status column, which is hidden on the editing/new form, in which the status of the request is stored ('Pending', 'Accepted', ' Denied', 'Cancelled').

The user who file request must be able to alter and delete requests. When a request is new/updated I can set the status to 'Pending' using the itemUpdating/itemAdding events.

I would like to archive the same when a user tries to delete a request (using the itemDeleting event). The request shouldn't be deleted but has its status changed to 'Cancelled'.

How do I set a property in the deleting event and at the same time cancel the deletion of the item?

I tried:

properties.Cancel = true;
properties.Status = SPEventReceiverStatus.Continue;
properties.AfterProperties["GE_AO_Status"] = "Vervallen";

That results in an error that the afterproperties can't be changed in this event.

_{(using MOSS SP2)}

edit I changed my code to (thanks Gomiunik and Cimares):

SPListItem item = properties.ListItem;
item["GE_AO_Status"] = "Vervallen"; 
item.Update();

and it works. Both answer have more complicated ways of getting the ListItem, why?

Answer 1

You can't alter the AfterProperties as they're going to be cancelled.

What you can could try however is instantiate another copy of the item IE using the List object from the properties and then running GetItemByID(properties.item.ID) and then set the properties on that. You might have to use SystemUpdate() to force it through, and also make sure you turn off event firing.

You'll need to test what happens to the cancel event and make sure it finishes cleanly, but I'd have a look at that option.

Paul.

Answer 2

1. Make sure you're not having base.ItemDeleting(properties) after your code.

2. in properties you also have 'properties.ListItem' so what you could do after you cancel is as follows

   SPListItem itm = properties.ListItem.ParentWeb.Lists[properties.ListId].GetItemById(properties.ListItemId); itm["GE_AO_Status"] = "Vervallen"; itm.Update()

Not exactly sure if all proeprties and method naming is exact, but you can rely on intellisense to help.