/// <summary>
/// Gets the share point task updates.
/// </summary>
/// <param name="viewName">Name of the view.</param>
private void GetSharePointTaskUpdates(string viewName)
{
TraceManager.TraceInformation("WSSWIT:AP:GetSharePointTaskUpdates");
using (SharePoint.Lists sharePointList = new SharePoint.Lists())
{
sharePointList.Url = string.Format(CultureInfo.CurrentCulture, "{0}/_vti_bin/lists.asmx", configurationService.ServerUrl);
string listName = configurationService.MigrationSource.SourceIdentifier;
string username = string.Empty;
string password = string.Empty;
foreach (CustomSetting customSetting in configurationService.MigrationSource.CustomSettings.CustomSetting)
{
switch (customSetting.SettingKey)
{
case "username":
{
username = customSetting.SettingValue;
break;
}
case "password":
{
password = customSetting.SettingValue;
break;
}
}
}
sharePointList.Credentials = new System.Net.NetworkCredential(username, password);
TraceManager.TraceInformation("\tWSSWIT:AP:Getting items from the list {0} on {1} with username {2}", listName, sharePointList.Url, username);
XElement rawListItems = XDocument.Parse(sharePointList.GetListItems(listName, viewName, (XmlNode)SharePointHelpers.Query, (XmlNode)SharePointHelpers.ViewFields, "0", (XmlNode)SharePointHelpers.QueryOptions, string.Empty).OuterXml).Root;
Collection <SharePointListItem> listItems = SharePointHelpers.ParseItems(rawListItems);
foreach (SharePointListItem task in listItems)
{
Guid actionGuid = WellKnownChangeActionId.Add;
if (highWaterMarkDelta.Value != DateTime.MinValue && task.ModifiedOn.CompareTo(highWaterMarkDelta.Value) > 0)
{
actionGuid = WellKnownChangeActionId.Edit;
}
else
{
actionGuid = WellKnownChangeActionId.Add;
}
ChangeGroup changeGroup = CreateChangeGroup(highWaterMarkChangeSet.Value, 0);
changeGroup.CreateAction(actionGuid, task, string.Empty, listName, string.Empty, string.Empty,
WellKnownContentType.WorkItem.ReferenceName, CreateFieldRevisionDescriptionDoc(task));
changeGroup.Save();
highWaterMarkChangeSet.Update(highWaterMarkChangeSet.Value + 1);
}
}
}
/// <summary>
/// Processes the change group.
/// </summary>
/// <param name="changeGroup">The change group.</param>
/// <returns></returns>
public override ConversionResult ProcessChangeGroup(ChangeGroup changeGroup)
{
TraceManager.TraceInformation("WSSWIT:MP:ProcessChangeGroup");
ConversionResult conversionResult = new ConversionResult(configurationService.MigrationPeer, configurationService.SourceId);
using (SharePoint.Lists sharePointList = new SharePoint.Lists())
{
SharePointList list = new SharePointList();
sharePointList.Url = string.Format(CultureInfo.CurrentCulture, "{0}/_vti_bin/lists.asmx", configurationService.ServerUrl);
list.Name = configurationService.MigrationSource.SourceIdentifier;
string username = string.Empty;
string password = string.Empty;
foreach (CustomSetting customSetting in configurationService.MigrationSource.CustomSettings.CustomSetting)
{
switch (customSetting.SettingKey)
{
case "username":
{
username = customSetting.SettingValue;
break;
}
case "password":
{
password = customSetting.SettingValue;
break;
}
}
}
sharePointList.Credentials = new System.Net.NetworkCredential(username, password);
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Updating/Inserting items to the list {0} on {1} with username {2}", list.Name, sharePointList.Url, username);
XmlNode listViewNode = sharePointList.GetListAndView(list.Name, string.Empty);
list.ListId = listViewNode.ChildNodes[0].Attributes["Name"].Value;
list.ViewId = listViewNode.ChildNodes[1].Attributes["Name"].Value;
foreach (MigrationAction action in changeGroup.Actions)
{
System.Xml.Linq.XElement batchNode = list.Batch;
string sourceSystemId = changeGroup.Name;
Dictionary <string, object> fieldList = BuildFieldList(action);
string taskId = GetSharePointID(action);
switch (action.Action.ToString().ToUpperInvariant())
{
case "CB71D043-BEDE-4092-AA87-CF0F14586625": //ADD
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Building method to add WIT to SharePoint");
batchNode.AddInsertMethodToBatch(fieldList);
break;
}
case "E876681D-8FF1-4342-A0A1-DB91513116B5": //Edit
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Update WIT in SharePoint");
if (!string.IsNullOrEmpty(taskId))
{
batchNode.AddUpdateMethodToBatch(taskId, fieldList);
}
else
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Problem with SharePoint ID - skipping update");
}
break;
}
case "DBF96ACF-871E-43aa-83E4-534BCC14D71F": // Add Attachment
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Add Attachment in SharePoint");
//batchNode.AddAttachement("id",file);
//todo: (RJM) Add attachments
break;
}
case "7FEB5531-4A7D-46c6-81EF-AF2B7CB997C8": // Delete Attachment
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Delete Attachment in SharePoint");
//todo: (RJM) Delete attachments
break;
}
case "45213A63-DE99-4eab-A255-1B477C8C52C9": // Delete
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Delete WIT in SharePoint");
if (!string.IsNullOrEmpty(taskId))
{
batchNode.AddDeleteMethodToBatch(taskId);
}
else
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Problem with SharePoint ID - skipping delete");
}
break;
}
default:
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Recieved action which we do not cater for: {0}", action.Action);
break;
}
}
if (batchNode.DescendantNodes().Count() > 0)
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Inserting and updating SharePoint list items to {0}", list.ListId);
XmlNode resultsNode;
try
{
resultsNode = sharePointList.UpdateListItems(list.ListId, (XmlNode)batchNode.ToXPathNavigable());
}
catch (System.Web.Services.Protocols.SoapException err)
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:SOAP Exception from SharePoint. Details {0}", err.Detail.InnerText);
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Batch: {0}", batchNode);
throw;
}
if (action.Action == WellKnownChangeActionId.Add || action.Action == WellKnownChangeActionId.Edit)
{
XmlNamespaceManager rowsetNameSpace = new XmlNamespaceManager(resultsNode.OwnerDocument.NameTable);
rowsetNameSpace.AddNamespace("z", "#RowsetSchema");
XmlNode rowNode = resultsNode.SelectSingleNode("//z:row", rowsetNameSpace);
if ((rowNode != null) && (rowNode.Attributes["ows_ID"] != null))
{
string newSharePointId = rowNode.Attributes["ows_ID"].Value;
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:SharePoint ID is {0}", newSharePointId);
conversionResult.ItemConversionHistory.Add(new ItemConversionHistory(sourceSystemId, string.Empty, newSharePointId.ToString(), string.Empty));
}
else
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Unabled to get SharePoint ID");
}
}
XmlNamespaceManager sharePointNameSpace = new XmlNamespaceManager(resultsNode.OwnerDocument.NameTable);
sharePointNameSpace.AddNamespace("s", resultsNode.NamespaceURI);
string errorCode = resultsNode.SelectSingleNode("//s:ErrorCode", sharePointNameSpace).InnerText;
if (errorCode != "0x00000000")
{
string errorMessage = resultsNode.SelectSingleNode("//s:ErrorText", sharePointNameSpace).InnerText;
throw new Exception(string.Format(CultureInfo.CurrentCulture, "Error inserting/updating SharePoint. Message: {1}{0}" +
"Code: {2}{0}" +
"Batch XML: {3}", Environment.NewLine, errorMessage, errorCode, batchNode));
}
}
else
{
TraceManager.TraceInformation("\tWSSWIT:MP:ProcessChangeGroup:Nothing to do to SharePoint");
}
}
}
conversionResult.ChangeId = changeGroup.ReflectedChangeGroupId.Value.ToString(CultureInfo.CurrentCulture);
return(conversionResult);
}
