protected void Page_Load(object sender, EventArgs e)
{
ContextBusClient cbClient = new ContextBusClient();
//Get Employee definition from adventure works:
ConnectionParam[] parameters = cbClient.LoadConnection("advworks", AdvWorksConnectorId);
cbClient.Login(parameters, AdvWorksConnectorId);
FlyweightObjectDefinition flyweight = new FlyweightObjectDefinition() { Id = "HumanResources.Employee" };
ObjectDefinition employeeObjDef = cbClient.GetObjectDefinitionList(new FlyweightObjectDefinition[] { flyweight }, AdvWorksConnectorId).First();
//Get Team definition from Sharepoint
parameters = cbClient.LoadConnection("Sharepoint-Team", "SharePoint");
cbClient.Login(parameters, "SharePoint");
flyweight = new FlyweightObjectDefinition() { Id = "SP|List|/sites/SiteCollection1|Team" };
ObjectDefinition sharepointObjDef = cbClient.GetObjectDefinitionList(new FlyweightObjectDefinition[] { flyweight }, "SharePoint").First();
//build the workflow.
TaskManagerClient taskClient = new TaskManagerClient();
//1. Create login task
LoginTask login = taskClient.CreateLoginTask(AdvWorksConnectorId, "advworks");
//2. Create Mapping Task
MappingTask map = taskClient.CreateMappingTask(sharepointObjDef, employeeObjDef);
MappableField field = map.TargetFields.SingleOrDefault(f => f.Id == "p.BusinessEntityID");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = 1;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.EmailPromotion");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = 0;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.Demographics");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = "";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.NameStyle");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = false;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.PersonType");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = "EM";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.FirstName");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "First_x0020_Name";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.LastName");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "Last_x0020_Name";
field = map.TargetFields.SingleOrDefault(f => f.Id == "e.JobTitle");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "Title";
//3. Save Task
SaveObjectInstanceTask saveSharepointToEktron = taskClient.CreateSaveObjectTask(AdvWorksConnectorId);
//4. Logout Task
LogoutTask logout = taskClient.CreateLogoutTask(AdvWorksConnectorId);
//5. Assemble and save workflow
string workflowName = string.Concat("My Test Workflow");
Workflow workflow = taskClient.CreateWorkflow(workflowName);
List<ContextBusTask> tasks = new List<ContextBusTask>();
tasks.Add(login);
tasks.Add(map);
tasks.Add(saveSharepointToEktron);
tasks.Add(logout);
workflow.Tasks = tasks.ToArray();
taskClient.SaveWorkflow(workflow);
//3. Create associated Event Definitions for workflow.
EventManagerClient eventClient = new EventManagerClient();
EventDefinition eventDef = new EventDefinition()
{
Id = workflowName,
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new string[] { workflow.WorkflowName }, eventDef);
//
//Now raise the event to perform the workflow!
//
//first get sharpeoint item
ObjectInstanceCriteriaFilter criteria = new ObjectInstanceCriteriaFilter();
criteria.Filters = new CriteriaFilter[0];
ObjectInstanceList sharepointObjInstance = cbClient.GetObjectInstanceList(sharepointObjDef, criteria, "SharePoint");
//create event instance with sharepoint item
EventInstance itemEvent = new EventInstance()
{
Id = workflowName,
Payload = sharepointObjInstance.Results.First()
};
//raise the event.
eventClient.RaiseEvent(itemEvent);
}
protected void Page_Load(object sender, EventArgs e)
{
ContextBusClient cbClient = new ContextBusClient();
//Get Employee definition from adventure works:
ConnectionParam[] parameters = cbClient.LoadConnection("advworks", AdvWorksConnectorId);
cbClient.Login(parameters, AdvWorksConnectorId);
FlyweightObjectDefinition flyweight = new FlyweightObjectDefinition()
{
Id = "HumanResources.Employee"
};
ObjectDefinition employeeObjDef = cbClient.GetObjectDefinitionList(new FlyweightObjectDefinition[] { flyweight }, AdvWorksConnectorId).First();
//Get Team definition from Sharepoint
parameters = cbClient.LoadConnection("Sharepoint-Team", "SharePoint");
cbClient.Login(parameters, "SharePoint");
flyweight = new FlyweightObjectDefinition()
{
Id = "SP|List|/sites/SiteCollection1|Team"
};
ObjectDefinition sharepointObjDef = cbClient.GetObjectDefinitionList(new FlyweightObjectDefinition[] { flyweight }, "SharePoint").First();
//build the workflow.
TaskManagerClient taskClient = new TaskManagerClient();
//1. Create login task
LoginTask login = taskClient.CreateLoginTask(AdvWorksConnectorId, "advworks");
//2. Create Mapping Task
MappingTask map = taskClient.CreateMappingTask(sharepointObjDef, employeeObjDef);
MappableField field = map.TargetFields.SingleOrDefault(f => f.Id == "p.BusinessEntityID");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = 1;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.EmailPromotion");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = 0;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.Demographics");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = "";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.NameStyle");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = false;
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.PersonType");
field.Mapping.MappingType = MappingType.ConstMapping;
field.Mapping.Value = "EM";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.FirstName");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "First_x0020_Name";
field = map.TargetFields.SingleOrDefault(f => f.Id == "p.LastName");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "Last_x0020_Name";
field = map.TargetFields.SingleOrDefault(f => f.Id == "e.JobTitle");
field.Mapping.MappingType = MappingType.FieldMapping;
field.Mapping.Value = "Title";
//3. Save Task
SaveObjectInstanceTask saveSharepointToEktron = taskClient.CreateSaveObjectTask(AdvWorksConnectorId);
//4. Logout Task
LogoutTask logout = taskClient.CreateLogoutTask(AdvWorksConnectorId);
//5. Assemble and save workflow
string workflowName = string.Concat("My Test Workflow");
Workflow workflow = taskClient.CreateWorkflow(workflowName);
List <ContextBusTask> tasks = new List <ContextBusTask>();
tasks.Add(login);
tasks.Add(map);
tasks.Add(saveSharepointToEktron);
tasks.Add(logout);
workflow.Tasks = tasks.ToArray();
taskClient.SaveWorkflow(workflow);
//3. Create associated Event Definitions for workflow.
EventManagerClient eventClient = new EventManagerClient();
EventDefinition eventDef = new EventDefinition()
{
Id = workflowName,
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new string[] { workflow.WorkflowName }, eventDef);
//
//Now raise the event to perform the workflow!
//
//first get sharpeoint item
ObjectInstanceCriteriaFilter criteria = new ObjectInstanceCriteriaFilter();
criteria.Filters = new CriteriaFilter[0];
ObjectInstanceList sharepointObjInstance = cbClient.GetObjectInstanceList(sharepointObjDef, criteria, "SharePoint");
//create event instance with sharepoint item
EventInstance itemEvent = new EventInstance()
{
Id = workflowName,
Payload = sharepointObjInstance.Results.First()
};
//raise the event.
eventClient.RaiseEvent(itemEvent);
}
private static void Start()
{
try
{
CurrentPage = 1;
TotalPages = 1;
ContextBusThreadCount = 5;
ObjectInstanceList spItemList = null;
ContextBusClient contextbusClient = new ContextBusClient();
EventManagerClient eventClient = new EventManagerClient();
contextbusClient.Login(ConnectionId, AdapterName);
ObjectInstanceCriteriaFilter criteria = new ObjectInstanceCriteriaFilter(SharePointObjectDefinition);
criteria.AddFilter("FSObjType", ObjectInstanceCriteriaFilterOperator.EqualTo, 0);
criteria.AddFilter("FileDirRef", ObjectInstanceCriteriaFilterOperator.EqualTo, "EntireListWithPagination");
criteria.Paging = new PagingInformation();
criteria.Paging.CurrentPage = CurrentPage;
criteria.Paging.RecordsPerPage = ContextBusThreadCount;
while (CurrentPage <= TotalPages)
{
try
{
spItemList = contextbusClient.GetObjectInstanceList(SharePointObjectDefinition, criteria, AdapterName);
TotalPages = spItemList.Paging.TotalPages;
}
catch (Exception exp)
{
EkException.LogException(exp);
}
if (spItemList != null && spItemList.Results.Any())
{
foreach (ObjectInstance spItem in spItemList.Results)
{
spItem.Fields.Where(p => p.Id.Equals("DxHSource")).FirstOrDefault().Value = "FromEktron";
EventInstance itemEvent = new EventInstance()
{
Id = WorkflowName,
Payload = spItem
};
eventClient.RaiseEvent(itemEvent);
}
}
CurrentPage++;
criteria.Paging.CurrentPage = CurrentPage;
}
contextbusClient.Logout(AdapterName);
//Forcing a garbage collection
GC.Collect();
GC.Collect();
GC.Collect();
}
catch (ThreadAbortException tx)
{
//Threadaborts are ok...ASP.Net aborts thread when unloading application
EkException.LogException(tx, System.Diagnostics.EventLogEntryType.Warning);
}
catch (Exception ex)
{
EkException.LogException(ex);
}
Thread.Sleep(1000);
}
public void UpdateSharePointContent(string sharepointconnectionid, string objectdefinitionid, int sharepointobjectid, long folderid, string workflowname)
{
Log.WriteVerbose(string.Format(BeginLogMessage, CLASS_NAME, "UpdateSharePointContent(string sharepointconnectionid, string objectdefinitionid, int sharepointobjectid, long folderid)"));
EventManagerClient eventClient = new EventManagerClient();
ObjectInstance eksharepointobjInstance = this.GetFilteredObjectInstanceList(sharepointconnectionid, objectdefinitionid, new List<int> { sharepointobjectid })
.FirstOrDefault();
eksharepointobjInstance.Fields.Where(p => p.Id.Equals("DxHSource")).FirstOrDefault().Value = "UpdateEktron";
Action action = delegate()
{
if (eksharepointobjInstance != null)
{
EventInstance itemEvent = new EventInstance()
{
Id = workflowname,
Payload = eksharepointobjInstance
};
eventClient.RaiseEvent(itemEvent);
}
};
Log.WriteVerbose(string.Format(FinishLogMessage, CLASS_NAME, "UpdateSharePointContent(string sharepointconnectionid, string objectdefinitionid, int sharepointobjectid, long folderid)"));
action.Invoke();
}
public void ImportListToFolder(string ektronConnectionId, string sharepointConnectionId, long folderId, MappingTask map, bool isDeleteallowed, int languageid)
{
Log.WriteVerbose(string.Format(BeginLogMessage, CLASS_NAME, "ImportListToFolder(string ektronConnectionId, string sharepointConnectionId, string objectDefinitionId, long folderId, List<ObjectInstance> objectinstancelist, Dictionary<string, string> SharePointFieldToMetaId = null)"));
TaskManagerClient taskClient = new TaskManagerClient();
EventManagerClient eventClient = new EventManagerClient();
string workflowName = string.Empty;
if (isDeleteallowed)
workflowName = string.Concat("SharepointDeleteAllowed|Ektron|", map.SourceObject.Id, "|", folderId, "|ListDependant;" + languageid);
else
workflowName = string.Concat("Sharepoint|Ektron|", map.SourceObject.Id, "|", folderId, "|ListDependant;" + languageid);
//check workflow and delete if it already exists.
DxhWorkflow workflow = taskClient.GetWorkflow(workflowName);
if (workflow != null)
{
taskClient.DeleteWorkflow(workflowName);
}
//1. Create workflow tasks
LoginTask login = taskClient.CreateLoginTask("Ektron", ektronConnectionId);
SaveObjectInstanceTask saveSharepointToEktron = taskClient.CreateSaveObjectTask("Ektron");
LogoutTask logout = taskClient.CreateLogoutTask("Ektron");
//2. Assemble and save workflow
workflow = taskClient.CreateWorkflow(workflowName);
((ICollection<ContextBusTask>)workflow.Tasks).Add(login);
((ICollection<ContextBusTask>)workflow.Tasks).Add(map);
((ICollection<ContextBusTask>)workflow.Tasks).Add(saveSharepointToEktron);
((ICollection<ContextBusTask>)workflow.Tasks).Add(logout);
taskClient.SaveWorkflow(workflow);
DxHUtils.SaveMapping(AdapterName, sharepointConnectionId, map, workflow, Ektron.Cms.Common.EkEnumeration.CMSObjectTypes.Folder, folderId, "", languageid);
//3. Create associated Event Defintions for workflow.
EventDefinition eventDef = new EventDefinition()
{
Id = workflowName,
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
if (this.GetListType(map.SourceObject.Id).ToLower() == "list")
{
eventDef = new EventDefinition()
{
Id = string.Concat("SP|List|SPReceiverEvent|", this.GetSiteUrlandListTitle(map.SourceObject.Id)),
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
eventDef = new EventDefinition()
{
Id = string.Concat("SP|ListItemAttachment|SPReceiverEvent|", this.GetSiteUrlandListTitle(map.SourceObject.Id)),
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
}
else if (this.GetListType(map.SourceObject.Id).ToLower() == "documentlibrary")
{
eventDef = new EventDefinition()
{
Id = string.Concat("SP|DocumentLibrary|SPReceiverEvent|", this.GetSiteUrlandListTitle(map.SourceObject.Id)),
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
}
if (isDeleteallowed)
{
string deleteworkflowname = string.Concat("SharepointDelete|Ektron|", map.SourceObject.Id, "|", folderId, "|ListDependant;" + languageid);
DxhWorkflow deleteworkflow = taskClient.GetWorkflow(deleteworkflowname);
if (deleteworkflow != null)
{
taskClient.DeleteWorkflow(deleteworkflowname);
}
// Create Delete Workflow Tasks
LoginTask deletelogin = taskClient.CreateLoginTask("Ektron", ektronConnectionId);
DeleteObjectInstanceTask deleteObjecttask = taskClient.CreateDeleteObjectTask("Ektron");
LogoutTask deletelogout = taskClient.CreateLogoutTask("Ektron");
//Assemble the Workflow
deleteworkflow = taskClient.CreateWorkflow(deleteworkflowname);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deletelogin);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(map);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deleteObjecttask);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deletelogout);
taskClient.SaveWorkflow(deleteworkflow);
eventDef = new EventDefinition()
{
Id = string.Concat("SPReceiverEvent|Delete|", this.GetSiteUrlandListTitle(map.SourceObject.Id)),
Payload = map.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { deleteworkflow.WorkflowName }, eventDef);
}
////4. Retrieve Sharepoint items and raise event for each one.
SharePointClientImportHelper.GetInstance().StartImport(sharepointConnectionId, AdapterName, workflowName, map.SourceObject);
Log.WriteVerbose(string.Format(FinishLogMessage, CLASS_NAME, "ImportListToFolder(string ektronConnectionId, string sharepointConnectionId, string objectDefinitionId, long folderId, List<ObjectInstance> objectinstancelist, Dictionary<string, string> SharePointFieldToMetaId = null)"));
}
public void ImportItemsToFolderWithOutListDependency(string ektronConnectionId, string sharepointConnectionId, string objectDefinitionId, long folderId, ConcurrentDictionary<int, MappingTask> listIdWithMappingTask, bool isDeleteallowed, int languageid)
{
Log.WriteVerbose(string.Format(BeginLogMessage, CLASS_NAME, "ImportItemsToFolderWithOutListDependency(string ektronConnectionId, string sharepointConnectionId, string objectDefinitionId, long folderId, IEnumerable<int> objectsharepointIdList)"));
foreach (var listAndMapping in listIdWithMappingTask)
{
List<ObjectInstance> objectinstancelist = this.GetFilteredObjectInstanceList(sharepointConnectionId, listAndMapping.Value.SourceObject, new List<int>() { listAndMapping.Key });
TaskManagerClient taskClient = new TaskManagerClient();
EventManagerClient eventClient = new EventManagerClient();
foreach (ObjectInstance item in objectinstancelist)
{
string id = item.Fields.Single(p => p.Id.ToLower().Equals("id")).Value.ToString();
string workflowName = string.Empty;
if (isDeleteallowed)
workflowName = string.Concat("SharepointDeleteAllowed|Ektron|", objectDefinitionId, "|", folderId, "|ItemDependant|" + id + ";" + languageid);
else
workflowName = string.Concat("Sharepoint|Ektron|", objectDefinitionId, "|", folderId, "|ItemDependant|" + id + ";" + languageid);
//check workflow and delete if it already exists.
DxhWorkflow workflow = taskClient.GetWorkflow(workflowName);
if (workflow != null)
{
taskClient.DeleteWorkflow(workflowName);
}
//1. Create workflow tasks
LoginTask login = taskClient.CreateLoginTask("Ektron", ektronConnectionId);
SaveObjectInstanceTask saveSharepointToEktron = taskClient.CreateSaveObjectTask("Ektron");
LogoutTask logout = taskClient.CreateLogoutTask("Ektron");
//2. Assemble and save workflow
workflow = taskClient.CreateWorkflow(workflowName);
((ICollection<ContextBusTask>)workflow.Tasks).Add(login);
((ICollection<ContextBusTask>)workflow.Tasks).Add(listAndMapping.Value);
((ICollection<ContextBusTask>)workflow.Tasks).Add(saveSharepointToEktron);
((ICollection<ContextBusTask>)workflow.Tasks).Add(logout);
taskClient.SaveWorkflow(workflow);
DxHUtils.SaveMapping(AdapterName, sharepointConnectionId, listAndMapping.Value, workflow, Ektron.Cms.Common.EkEnumeration.CMSObjectTypes.Folder, folderId, "", languageid);
//3. Create associated Event Defintions for workflow.
EventDefinition eventDef = new EventDefinition()
{
Id = workflowName,
Payload = listAndMapping.Value.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
if (this.GetListType(objectDefinitionId).ToLower() == "list")
{
eventDef = new EventDefinition()
{
Id = string.Concat("SP|List|SPReceiverEvent|", this.GetSiteUrlandListTitle(objectDefinitionId)),
Payload = listAndMapping.Value.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
eventDef = new EventDefinition()
{
Id = string.Concat("SP|ListItemAttachment|SPReceiverEvent|", this.GetSiteUrlandListTitle(objectDefinitionId)),
Payload = listAndMapping.Value.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
}
else if (this.GetListType(objectDefinitionId).ToLower() == "documentlibrary")
{
eventDef = new EventDefinition()
{
Id = string.Concat("SP|DocumentLibrary|SPReceiverEvent|", this.GetSiteUrlandListTitle(objectDefinitionId)),
Payload = listAndMapping.Value.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { workflow.WorkflowName }, eventDef);
}
if (isDeleteallowed)
{
string deleteworkflowname = string.Concat("SharepointDelete|Ektron|", objectDefinitionId, "|", folderId, "|ItemDependant|" + id + ";" + languageid);
DxhWorkflow deleteworkflow = taskClient.GetWorkflow(deleteworkflowname);
if (deleteworkflow != null)
{
taskClient.DeleteWorkflow(deleteworkflowname);
}
// Create Delete Workflow Tasks
LoginTask deletelogin = taskClient.CreateLoginTask("Ektron", ektronConnectionId);
DeleteObjectInstanceTask deleteObjecttask = taskClient.CreateDeleteObjectTask("Ektron");
LogoutTask deletelogout = taskClient.CreateLogoutTask("Ektron");
//Assemble the Workflow
deleteworkflow = taskClient.CreateWorkflow(deleteworkflowname);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deletelogin);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(listAndMapping.Value);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deleteObjecttask);
((ICollection<ContextBusTask>)deleteworkflow.Tasks).Add(deletelogout);
taskClient.SaveWorkflow(deleteworkflow);
eventDef = new EventDefinition()
{
Id = string.Concat("SPReceiverEvent|Delete|", this.GetSiteUrlandListTitle(objectDefinitionId)),
Payload = listAndMapping.Value.SourceObject
};
eventClient.AssociateWorkflowsToEvent(new List<string> { deleteworkflow.WorkflowName }, eventDef);
}
item.Fields.Where(p => p.Id.Equals("DxHSource")).FirstOrDefault().Value = "FromEktron";
EventInstance itemEvent = new EventInstance()
{
Id = workflowName,
Payload = item
};
eventClient.RaiseEvent(itemEvent);
}
Log.WriteVerbose(string.Format(FinishLogMessage, CLASS_NAME, "ImportItemsToFolderWithOutListDependency(string ektronConnectionId, string sharepointConnectionId, string objectDefinitionId, long folderId, IEnumerable<int> objectsharepointIdList)"));
}
}
