Hi Vikas here is the full code for this
Source :http://mayankp.wordpress.com/2010/03/02/removing-email-from-crm-queue/
Currently if there is email in queue and if user manually creates case then case gets creates but email remains in the CRM queue.
Another scenario is that there is automated workflow which creates case for the email which comes in queue and workflow creates case fine but email remains in the queue.
For above two problems there is not out of the box method to remove or detach the email from the queue. However when I check CRM 4.0 SDK there is API DetachFromQueueEmailRequest Based on which I have created following generic custom workflow which
takes queue id and email id as Input and removes the relevant email from the relevant queue.
using System;
using System.Workflow.Activities;
using System.Workflow.ComponentModel;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.SdkTypeProxy;
using Microsoft.Crm.Workflow;
using Microsoft.Crm.Sdk.Query;
namespace DynamicWorkflow
{
[CrmWorkflowActivity("Remove the Email from the Queue")]
public class RemoveEmailFromQueue : System.Workflow.Activities.SequenceActivity
{
//Email Id Property
public static DependencyProperty activityIdProperty = DependencyProperty.Register("activityId", typeof(Lookup), typeof(RemoveEmailFromQueue));
[CrmInput("ActivityId")]
[CrmReferenceTarget("email")]
public Lookup activityId
{
get { return (Lookup)base.GetValue(activityIdProperty); }
set { base.SetValue(activityIdProperty, value); }
}
//Queue Id Property
public static DependencyProperty queueIdProperty = DependencyProperty.Register("queueId", typeof(Lookup), typeof(RemoveEmailFromQueue));
[CrmInput("queueId")]
[CrmReferenceTarget("queue")]
public Lookup queueId
{
get { return (Lookup)base.GetValue(queueIdProperty); }
set { base.SetValue(queueIdProperty, value); }
}
//output Property
public static DependencyProperty resultProperty = DependencyProperty.Register("result", typeof(string), typeof(RemoveEmailFromQueue));
[CrmOutput("result")]
public string result
{
get { return (string)base.GetValue(resultProperty); }
set { base.SetValue(resultProperty, value); }
}
/// <summary>
/// Execute Method of Workflow
/// </summary>
/// <param name="executionContext"></param>
/// <returns></returns>
protected override System.Workflow.ComponentModel.ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
{
try
{
IContextService contextService = (IContextService)executionContext.GetService(typeof(IContextService));
IWorkflowContext context = contextService.Context;
// Obtain IcrmService so we can call into CRM SDK to retrieve
ICrmService crmService = context.CreateCrmService();
// this property will have the email address that needs to be matched.
string strEmailGUID = activityId.Value.ToString(); //"305c2ecb-c26b-de11-9ba7-0003ff2b38e4";
// this property will have queue that needs to be matched
string strQueueID = queueId.Value.ToString();// "D0B55822-436A-DE11-8911-0003FF2B38E4";
DetachFromQueueEmailRequest objEmail = new DetachFromQueueEmailRequest();
// Assign Email GUID
objEmail.EmailId = new Guid(strEmailGUID.Trim());
// Assign Queue GUID
objEmail.QueueId = new Guid(strQueueID.Trim());
//execute request to removed it from queue
DetachFromQueueEmailResponse response= (DetachFromQueueEmailResponse)crmService.Execute(objEmail);
this.result = "Success";
return ActivityExecutionStatus.Closed;
}
catch(Exception ex)
{
return ActivityExecutionStatus.Canceling;
}
}
}
}
Source : http://mayankp.wordpress.com/2010/03/02/removing-email-from-crm-queue/
Mahain
