/// <summary>
/// Open connection k2.
/// </summary>
/// <param name="model">The value for connect k2.</param>
/// <param name="retry">The round of try to connect k2.</param>
/// <returns></returns>
private SourceCode.Workflow.Client.Connection Connection(K2ConnectModel model, int retry = 0)
{
var connection = new SourceCode.Workflow.Client.Connection();
int retryNum = retry;
try
{
string connectionString = this.GetConnectionString(model);
connection.Open(model.Url, connectionString);
if (model.K2Profile.Impersonate)
{
connection.ImpersonateUser(model.SecurityLabelName + ":" + model.K2Profile.ImpersonateUser);
}
}
catch (System.Exception ex)
{
connection = null;
retryNum++;
if (retryNum == 2)
{
throw new System.Exception("Unable to create connection (retry:" + retryNum.ToString() + ") : " + ex.ToString());
}
else
{
System.Threading.Thread.Sleep(50);
return(Connection(model, retryNum));
}
}
return(connection);
}
private void StartProcessInstance(bool startGeneric)
{
string processName = ServiceBroker.Service.ServiceObjects[0].Methods[0].Name;
if (!startGeneric)
{
processName = GetStringProperty(Constants.SOProperties.ProcessInstanceClient.ProcessName, true);
}
int processVersion = GetIntProperty(Constants.SOProperties.ProcessInstanceClient.ProcessVersion);
ServiceObject serviceObject = ServiceBroker.Service.ServiceObjects[0];
serviceObject.Properties.InitResultTable();
DataTable results = ServiceBroker.ServicePackage.ResultTable;
using (CLIENT.Connection k2Con = new CLIENT.Connection())
{
k2Con.Open(K2ClientConnectionSetup);
CLIENT.ProcessInstance pi;
if (processVersion > 0)
{
pi = k2Con.CreateProcessInstance(processName, processVersion);
}
else
{
pi = k2Con.CreateProcessInstance(processName);
}
string folio = GetStringProperty(Constants.SOProperties.ProcessInstanceClient.ProcessFolio);
if (!string.IsNullOrEmpty(folio))
{
pi.Folio = folio;
}
if (startGeneric)
{
MethodParameters mParams = ServiceBroker.Service.ServiceObjects[0].Methods[0].MethodParameters;
foreach (CLIENT.DataField df in pi.DataFields)
{
df.Value = GetDataFieldValue(mParams[df.Name].Value, df.ValueType);
}
}
k2Con.StartProcessInstance(pi, GetBoolProperty(Constants.SOProperties.ProcessInstanceClient.StartSync));
DataRow dr = results.NewRow();
dr[Constants.SOProperties.ProcessInstanceClient.ProcessInstanceId] = pi.ID;
dr[Constants.SOProperties.ProcessInstanceClient.ProcessFolio] = pi.Folio;
results.Rows.Add(dr);
k2Con.Close();
}
}
private void SetFolio()
{
ServiceObject serviceObject = ServiceBroker.Service.ServiceObjects[0];
string folio = base.GetStringProperty(Constants.SOProperties.ProcessInstanceClient.ProcessFolio, false);
int procId = base.GetIntProperty(Constants.SOProperties.ProcessInstanceClient.ProcessInstanceId, true);
using (CLIENT.Connection k2Con = new CLIENT.Connection())
{
k2Con.Open(K2ClientConnectionSetup);
CLIENT.ProcessInstance pi = k2Con.OpenProcessInstance(procId);
pi.Folio = folio;
pi.Update();
k2Con.Close();
}
}
public void Execute(IServiceProvider serviceProvider)
{
//Create the context
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
SourceCode.Workflow.Client.Connection conn = null;
SourceCode.Workflow.Client.ProcessInstance procInst = null;
string K2EntityIdDataField = string.Empty;
string K2EntityNameDataField = string.Empty;
string K2ContextXMLDataField = string.Empty;
Entity currentEntity = new Entity();
if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
{
// Obtain the target business entity from the input parameters.
currentEntity = (Entity)context.InputParameters["Target"];
}
if (context.OutputParameters.Contains("id"))
{
EntityID = new Guid(context.OutputParameters["id"].ToString());
}
else if (currentEntity.Id != null)
{
EntityID = currentEntity.Id;
}
// Get K2 Associations
#region K2 Associations
string K2AssociationsFetchXML = Resources.K2AssociationsFetchXML.Replace("[startoption]", context.MessageName);
K2AssociationsFetchXML = K2AssociationsFetchXML.Replace("[entityname]", currentEntity.LogicalName.ToLower());
EntityCollection k2associations = service.RetrieveMultiple(new FetchExpression(K2AssociationsFetchXML));
#endregion
// if an K2 Association is found then get K2 Settings and start K2 process for each association
if (k2associations.Entities.Count > 0)
{
// Get K2 Settings
#region K2 Settings
//Get Connection Settings
EntityCollection k2settings = service.RetrieveMultiple(new FetchExpression(Resources.K2SettingsFetchXML));
foreach (Entity setting in k2settings.Entities)
{
string name = setting["k2_name"].ToString();
string value = setting["k2_value"].ToString();
switch (name)
{
case "WorkflowServerConnectionString":
K2WorkflowServerConnectionString = value;
break;
case "HostServerConnectionString":
K2HostServerConnectionString = value;
break;
case "K2ServerName":
K2Server = value;
break;
}
}
#endregion K2 Settings
bool StartProcess = false;
// start process for each association returned
foreach (Entity entity in k2associations.Entities)
{
StartProcess = MustStartForMessage(entity["k2_startoption"].ToString(), context.MessageName);
if (StartProcess)
{
if (entity.Contains("k2_processfullname"))
{
K2ProcessName = entity["k2_processfullname"].ToString();
}
if (entity.Contains("k2_entityiddatafield"))
{
K2EntityIdDataField = entity["k2_entityiddatafield"].ToString();
}
if (entity.Contains("k2_entitynamedatafield"))
{
K2EntityNameDataField = entity["k2_entitynamedatafield"].ToString();
}
if (entity.Contains("k2_contextxmldatafield"))
{
K2ContextXMLDataField = entity["k2_contextxmldatafield"].ToString();
}
#region Create XML Context
XmlDocument EntityDoc = null;
ColumnSet allColumns = new ColumnSet(true);
//Entity currentEntity = service.Retrieve(CRMEntityName, EntityID, allColumns);
Entity originatorUserEntity = service.Retrieve("systemuser", context.InitiatingUserId, allColumns);
XmlDocument inputDataDoc = new XmlDocument();
//Create instantiation data for Entity
EntityDoc = new XmlDocument();
XmlElement EntElement = EntityDoc.CreateElement("CRMContext");
//Create Item element
XmlElement xmlItem = EntityDoc.CreateElement("Context");
//Create Name Element
XmlElement xmlName = EntityDoc.CreateElement("EntityId");
xmlName.InnerText = EntityID.HasValue ? EntityID.Value.ToString() : "";
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("EntityType");
xmlName.InnerText = currentEntity.LogicalName;
xmlItem.AppendChild(xmlName);
XmlElement xmlOrgName = EntityDoc.CreateElement("Organization");
xmlOrgName.InnerText = context.OrganizationName;
xmlItem.AppendChild(xmlOrgName);
xmlName = EntityDoc.CreateElement("CRMUserId");
xmlName.InnerText = context.InitiatingUserId.ToString();
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("UserFQN");
xmlName.InnerText = originatorUserEntity["domainname"] != null ? originatorUserEntity["domainname"].ToString() : "";
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("UserDisplayName");
xmlName.InnerText = originatorUserEntity["fullname"] != null ? originatorUserEntity["fullname"].ToString() : "";
xmlItem.AppendChild(xmlName);
//Add Item to main doc
EntElement.AppendChild(xmlItem);
EntityDoc.AppendChild(EntElement);
EntElement = null;
xmlName = null;
#endregion Create XML Context
#region Start K2 Process
conn = new SourceCode.Workflow.Client.Connection();
try
{
//Open connection to K2 Server
ConnectionSetup connectSetup = new ConnectionSetup();
connectSetup.ConnectionString = K2WorkflowServerConnectionString;
conn.Open(connectSetup);
// impersonate as originators if domainname retrieved from CRM systemuser
if (originatorUserEntity != null && originatorUserEntity.Contains("domainname"))
{
if (!string.IsNullOrEmpty(originatorUserEntity["domainname"].ToString()))
{
conn.ImpersonateUser(originatorUserEntity["domainname"].ToString());
}
}
//Create new process instance
procInst = conn.CreateProcessInstance(K2ProcessName);
//Set CRM context field value
if (!string.IsNullOrEmpty(K2ContextXMLDataField))
{
try
{
procInst.XmlFields[K2ContextXMLDataField].Value = EntityDoc.OuterXml.ToString();
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to XMLField " + K2ContextXMLDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
if (!string.IsNullOrEmpty(K2EntityIdDataField))
{
try
{
procInst.DataFields[K2EntityIdDataField].Value = context.PrimaryEntityId;
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to DataField " + K2EntityIdDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
if (!string.IsNullOrEmpty(K2EntityNameDataField))
{
try
{
procInst.DataFields[K2EntityNameDataField].Value = context.PrimaryEntityName.ToLower();
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to DataField " + K2EntityNameDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
conn.StartProcessInstance(procInst);
try
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "Process Started: " + K2ProcessName, System.Diagnostics.EventLogEntryType.Information);
}
catch { }
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "Entity Name - " + context.PrimaryEntityName.ToString() + " - " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
throw;
}
finally
{
if (service != null)
{
service = null;
}
if (conn != null)
{
conn.Dispose();
}
conn = null;
if (procInst != null)
{
procInst = null;
}
EntityDoc = null;
}
#endregion Start K2 Process
}
}
}
}
public void Execute(IServiceProvider serviceProvider)
{
//Create the context
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
SourceCode.Workflow.Client.Connection conn = null;
SourceCode.Workflow.Client.ProcessInstance procInst = null;
string K2EntityIdDataField = string.Empty;
string K2EntityNameDataField = string.Empty;
string K2ContextXMLDataField = string.Empty;
Entity currentEntity = new Entity();
if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
{
// Obtain the target business entity from the input parameters.
currentEntity = (Entity)context.InputParameters["Target"];
}
if (context.OutputParameters.Contains("id"))
{
EntityID = new Guid(context.OutputParameters["id"].ToString());
}
else if (currentEntity.Id != null)
{
EntityID = currentEntity.Id;
}
// Get K2 Associations
#region K2 Associations
string K2AssociationsFetchXML = Resources.K2AssociationsFetchXML.Replace("[startoption]", context.MessageName);
K2AssociationsFetchXML = K2AssociationsFetchXML.Replace("[entityname]", currentEntity.LogicalName.ToLower());
EntityCollection k2associations = service.RetrieveMultiple(new FetchExpression(K2AssociationsFetchXML));
#endregion
// if an K2 Association is found then get K2 Settings and start K2 process for each association
if (k2associations.Entities.Count > 0)
{
// Get K2 Settings
#region K2 Settings
//Get Connection Settings
EntityCollection k2settings = service.RetrieveMultiple(new FetchExpression(Resources.K2SettingsFetchXML));
foreach (Entity setting in k2settings.Entities)
{
string name = setting["k2_name"].ToString();
string value = setting["k2_value"].ToString();
switch (name)
{
case "WorkflowServerConnectionString":
K2WorkflowServerConnectionString = value;
break;
case "HostServerConnectionString":
K2HostServerConnectionString = value;
break;
case "K2ServerName":
K2Server = value;
break;
}
}
#endregion K2 Settings
bool StartProcess = false;
// start process for each association returned
foreach (Entity entity in k2associations.Entities)
{
StartProcess = MustStartForMessage(entity["k2_startoption"].ToString(), context.MessageName);
if (StartProcess)
{
if (entity.Contains("k2_processfullname"))
{
K2ProcessName = entity["k2_processfullname"].ToString();
}
if (entity.Contains("k2_entityiddatafield"))
{
K2EntityIdDataField = entity["k2_entityiddatafield"].ToString();
}
if (entity.Contains("k2_entitynamedatafield"))
{
K2EntityNameDataField = entity["k2_entitynamedatafield"].ToString();
}
if (entity.Contains("k2_contextxmldatafield"))
{
K2ContextXMLDataField = entity["k2_contextxmldatafield"].ToString();
}
#region Create XML Context
XmlDocument EntityDoc = null;
ColumnSet allColumns = new ColumnSet(true);
//Entity currentEntity = service.Retrieve(CRMEntityName, EntityID, allColumns);
Entity originatorUserEntity = service.Retrieve("systemuser", context.InitiatingUserId, allColumns);
XmlDocument inputDataDoc = new XmlDocument();
//Create instantiation data for Entity
EntityDoc = new XmlDocument();
XmlElement EntElement = EntityDoc.CreateElement("CRMContext");
//Create Item element
XmlElement xmlItem = EntityDoc.CreateElement("Context");
//Create Name Element
XmlElement xmlName = EntityDoc.CreateElement("EntityId");
xmlName.InnerText = EntityID.HasValue ? EntityID.Value.ToString() : "";
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("EntityType");
xmlName.InnerText = currentEntity.LogicalName;
xmlItem.AppendChild(xmlName);
XmlElement xmlOrgName = EntityDoc.CreateElement("Organization");
xmlOrgName.InnerText = context.OrganizationName;
xmlItem.AppendChild(xmlOrgName);
xmlName = EntityDoc.CreateElement("CRMUserId");
xmlName.InnerText = context.InitiatingUserId.ToString();
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("UserFQN");
xmlName.InnerText = originatorUserEntity["domainname"] != null ? originatorUserEntity["domainname"].ToString() : "";
xmlItem.AppendChild(xmlName);
xmlName = EntityDoc.CreateElement("UserDisplayName");
xmlName.InnerText = originatorUserEntity["fullname"] != null ? originatorUserEntity["fullname"].ToString() : "";
xmlItem.AppendChild(xmlName);
//Add Item to main doc
EntElement.AppendChild(xmlItem);
EntityDoc.AppendChild(EntElement);
EntElement = null;
xmlName = null;
#endregion Create XML Context
#region Start K2 Process
conn = new SourceCode.Workflow.Client.Connection();
try
{
//Open connection to K2 Server
ConnectionSetup connectSetup = new ConnectionSetup();
connectSetup.ConnectionString = K2WorkflowServerConnectionString;
conn.Open(connectSetup);
// impersonate as originators if domainname retrieved from CRM systemuser
if (originatorUserEntity != null && originatorUserEntity.Contains("domainname"))
{
if (!string.IsNullOrEmpty(originatorUserEntity["domainname"].ToString()))
{
conn.ImpersonateUser(originatorUserEntity["domainname"].ToString());
}
}
//Create new process instance
procInst = conn.CreateProcessInstance(K2ProcessName);
//Set CRM context field value
if (!string.IsNullOrEmpty(K2ContextXMLDataField))
{
try
{
procInst.XmlFields[K2ContextXMLDataField].Value = EntityDoc.OuterXml.ToString();
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to XMLField " + K2ContextXMLDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
if (!string.IsNullOrEmpty(K2EntityIdDataField))
{
try
{
procInst.DataFields[K2EntityIdDataField].Value = context.PrimaryEntityId;
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to DataField " + K2EntityIdDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
if (!string.IsNullOrEmpty(K2EntityNameDataField))
{
try
{
procInst.DataFields[K2EntityNameDataField].Value = context.PrimaryEntityName.ToLower();
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "K2 CRM Plugin - Entity Name - " + context.PrimaryEntityName.ToString() + " - " + "Error writing to DataField " + K2EntityNameDataField + " :::: " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
conn.StartProcessInstance(procInst);
try
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "Process Started: " + K2ProcessName, System.Diagnostics.EventLogEntryType.Information);
}
catch { }
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("SourceCode.Logging.Extension.EventLogExtension", "Entity Name - " + context.PrimaryEntityName.ToString() + " - " + ex.Message, System.Diagnostics.EventLogEntryType.Error);
throw;
}
finally
{
if (service != null)
service = null;
if (conn != null)
conn.Dispose();
conn = null;
if (procInst != null)
procInst = null;
EntityDoc = null;
}
#endregion Start K2 Process
}
}
}
}
/// <summary>
/// Method to check K2 for process errors since the last scheduled internal.
/// </summary>
public void RetrieveNewErrors()
{
k2Mgnt.WorkflowManagementServer server = new k2Mgnt.WorkflowManagementServer();
server.Connection = server.CreateConnection();
server.Connection.Open(connectionString);
// client connection to K2 server.
k2Client.Connection k2Conn = new k2Client.Connection();
try
{
// Search for new process errors in the specified profile and update the error list.
k2Mgnt.ErrorLogs els = server.GetErrorLogs(server.GetErrorProfile(_errorProfileName).ID);
// Open client connection to K2 server.
string host = Regex.Replace(connectionString, @"(.+)(Host\=)(.+)(;)(.+)", "$3");
k2Conn.Open(host);
// check every error in the error log
foreach (k2Mgnt.ErrorLog el in els)
{
Update(el, k2Conn);
}
if (ErrorsToBeReported.Count > 0)
{
//
// Pull in the related tasks into the error collection.
//
k2Mgnt.WorklistItems worklistItems =
server.GetWorklistItems(
new DateTime(1900, 1, 1),
DateTime.Now,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty);
foreach (SourceCode.Workflow.Management.WorklistItem worklistItem in worklistItems)
{
if (worklistItem.ProcessInstanceStatus == k2Mgnt.ProcessInstanceStatus.Error)
{
Update(worklistItem);
}
}
}
//Finally, prune the errors collection.
Prune(k2Conn, server);
}
finally
{
if (server.Connection != null)
{
server.Connection.Close();
}
if (k2Conn != null)
{
k2Conn.Close();
}
}
}
private void StartProcessInstance(bool startGeneric)
{
string processName = ServiceBroker.Service.ServiceObjects[0].Methods[0].Name;
if (!startGeneric)
{
processName = GetStringProperty(Constants.SOProperties.ProcessInstanceClient.ProcessName, true);
}
int processVersion = GetIntProperty(Constants.SOProperties.ProcessInstanceClient.ProcessVersion);
ServiceObject serviceObject = ServiceBroker.Service.ServiceObjects[0];
serviceObject.Properties.InitResultTable();
DataTable results = ServiceBroker.ServicePackage.ResultTable;
using (CLIENT.Connection k2Con = new CLIENT.Connection())
{
k2Con.Open(K2ClientConnectionSetup);
CLIENT.ProcessInstance pi;
if (processVersion > 0)
{
pi = k2Con.CreateProcessInstance(processName, processVersion);
}
else
{
pi = k2Con.CreateProcessInstance(processName);
}
string folio = GetStringProperty(Constants.SOProperties.ProcessInstanceClient.ProcessFolio);
if (!string.IsNullOrEmpty(folio))
{
pi.Folio = folio;
}
if (startGeneric)
{
MethodParameters mParams = ServiceBroker.Service.ServiceObjects[0].Methods[0].MethodParameters;
foreach (CLIENT.DataField df in pi.DataFields)
{
df.Value = GetDataFieldValue(mParams[df.Name].Value, df.ValueType);
}
}
k2Con.StartProcessInstance(pi, GetBoolProperty(Constants.SOProperties.ProcessInstanceClient.StartSync));
DataRow dr = results.NewRow();
dr[Constants.SOProperties.ProcessInstanceClient.ProcessInstanceId] = pi.ID;
dr[Constants.SOProperties.ProcessInstanceClient.ProcessFolio] = pi.Folio;
results.Rows.Add(dr);
k2Con.Close();
}
}
private void StartProcessInstance()
{
string processName = base.GetStringProperty(Constants.SOProperties.ProcessInstanceManagement.ProcessName, true);
int processVersion = base.GetIntProperty(Constants.SOProperties.ProcessInstanceManagement.ProcessVersion, false);
ServiceObject serviceObject = base.ServiceBroker.Service.ServiceObjects[0];
serviceObject.Properties.InitResultTable();
DataTable results = base.ServiceBroker.ServicePackage.ResultTable;
using (CLIENT.Connection k2Con = new CLIENT.Connection())
{
k2Con.Open(base.K2ClientConnectionSetup);
CLIENT.ProcessInstance pi;
if (processVersion > 0)
{
pi = k2Con.CreateProcessInstance(processName, processVersion);
}
else
{
pi = k2Con.CreateProcessInstance(processName);
}
string folio = base.GetStringProperty(Constants.SOProperties.ProcessInstanceManagement.ProcessFolio);
if (string.IsNullOrEmpty(folio))
{
pi.Folio = folio;
}
k2Con.StartProcessInstance(pi, base.GetBoolProperty(Constants.SOProperties.ProcessInstanceManagement.StartSync));
DataRow dr = results.NewRow();
dr[Constants.SOProperties.ProcessInstanceManagement.ProcessInstanceId] = pi.ID;
dr[Constants.SOProperties.ProcessInstanceManagement.ProcessFolio] = pi.Folio;
results.Rows.Add(dr);
}
}
