public void DiffForms()
{
#region Forms
var qe = new QueryExpression("systemform");
qe.Criteria.AddCondition(new ConditionExpression("ismanaged", ConditionOperator.Equal, false));
qe.ColumnSet = new ColumnSet("name", "publishedon", "type", "objecttypecode");
var forms1 = LeftService.RetrieveMultiple(qe).Entities;
var forms2 = RightService.RetrieveMultiple(qe).Entities;
List <ComponentDiff <Entity> > formsDiff = new List <ComponentDiff <Entity> >();
mainForm.ProgressStart("Forms", 1, forms1.Count + forms2.Count);
foreach (var f1 in forms1)
{
var f2 = forms2.Where(x => x.Id == f1.Id).FirstOrDefault();
if (f2 == null)
{
_diffResult.Forms.Add(new ComponentDiff <Entity>()
{
EntityName = f1.GetAttributeValue <string>("objecttypecode"),
Name = f1.GetAttributeValue <string>("name"),
Left = f1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var f2 in forms2)
{
var f1 = forms1.Where(x => x.Id == f2.Id).FirstOrDefault();
if (f1 == null)
{
_diffResult.Forms.Add(new ComponentDiff <Entity>()
{
EntityName = f2.GetAttributeValue <string>("objecttypecode"),
Name = f2.GetAttributeValue <string>("name"),
Right = f2,
});
}
mainForm.ProgressPerformStep();
}
#endregion
}
public void DiffViews()
{
#region Views
// Instantiate QueryExpression QEsavedquery
var qe = new QueryExpression("savedquery");
qe.Criteria.AddCondition(new ConditionExpression("iscustom", ConditionOperator.Equal, true));
qe.Criteria.AddCondition(new ConditionExpression("iscustomizable", ConditionOperator.Equal, true));
qe.Criteria.AddCondition(new ConditionExpression("ismanaged", ConditionOperator.Equal, false));
qe.ColumnSet.AddColumns("name", "querytype", "returnedtypecode", "iscustom");
var views1 = LeftService.RetrieveMultiple(qe).Entities;
var views2 = RightService.RetrieveMultiple(qe).Entities;
List <ComponentDiff <Entity> > viewsDiff = new List <ComponentDiff <Entity> >();
mainForm.ProgressStart("Views", 1, views1.Count + views2.Count);
foreach (var v1 in views1)
{
var v2 = views2.Where(x => x.GetAttributeValue <string>("name") == v1.GetAttributeValue <string>("name")).FirstOrDefault();
if (v2 == null)
{
_diffResult.Views.Add(new ComponentDiff <Entity>()
{
EntityName = v1.GetAttributeValue <string>("returnedtypecode"),
Name = v1.GetAttributeValue <string>("name"),
Left = v1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var v2 in views2)
{
var v1 = views1.Where(x => x.GetAttributeValue <string>("name") == v2.GetAttributeValue <string>("name")).FirstOrDefault();
if (v1 == null)
{
_diffResult.Views.Add(new ComponentDiff <Entity>()
{
EntityName = v2.GetAttributeValue <string>("returnedtypecode"),
Name = v2.GetAttributeValue <string>("name"),
Right = v2,
});
}
mainForm.ProgressPerformStep();
}
#endregion
}
public void DiffSdkMessageProcessingSteps()
{
var qe = new QueryExpression("sdkmessageprocessingstep");
qe.TopCount = 50;
qe.ColumnSet.AddColumns("statecode", "name", "sdkmessageid", "ismanaged", "plugintypeid", "sdkmessageprocessingstepid");
qe.Criteria.AddCondition("ismanaged", ConditionOperator.Equal, false);
var pluginTypeLink = qe.AddLink("plugintype", "plugintypeid", "plugintypeid");
pluginTypeLink.EntityAlias = "plugintype";
pluginTypeLink.Columns.AddColumns("name");
var smpss1 = LeftService.RetrieveMultiple(qe).Entities;
var smpss2 = RightService.RetrieveMultiple(qe).Entities;
mainForm.ProgressStart("Messages Processing Steps", 1, smpss1.Count + smpss2.Count);
foreach (var smps1 in smpss1)
{
var s2 = smpss2.Where(x => x.GetAttributeValue <string>("name") == smps1.GetAttributeValue <string>("name")).FirstOrDefault();
if (s2 == null)
{
_diffResult.SdkMessageProcessingSteps.Add(new ComponentDiff <Entity>()
{
Name = smps1.GetAttributeValue <string>("name"),
Left = smps1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var smps2 in smpss2)
{
var s1 = smpss1.Where(x => x.GetAttributeValue <string>("name") == smps2.GetAttributeValue <string>("name")).FirstOrDefault();
if (s1 == null)
{
_diffResult.SdkMessageProcessingSteps.Add(new ComponentDiff <Entity>()
{
Name = smps2.GetAttributeValue <string>("name"),
Right = smps2,
});
}
mainForm.ProgressPerformStep();
}
}
public void DiffWorkflows()
{
var qe = new QueryExpression("workflow");
qe.ColumnSet.AddColumns(new string[] { "mode", "primaryentity", "name", "statecode", "type", "uniquename", "category" });
qe.Criteria.AddCondition("statecode", ConditionOperator.Equal, 1);
qe.Criteria.AddCondition("type", ConditionOperator.Equal, 1);
//query.Criteria.AddCondition("category", ConditionOperator.In, 0, 3);
var wfls1 = LeftService.RetrieveMultiple(qe).Entities;
var wfls2 = RightService.RetrieveMultiple(qe).Entities;
mainForm.ProgressStart("Workflows", 1, wfls1.Count + wfls2.Count);
foreach (var w1 in wfls1)
{
var w2 = wfls2.Where(x => x.Id == w1.Id).FirstOrDefault();
if (w2 == null)
{
_diffResult.Workflows.Add(new ComponentDiff <Entity>()
{
Name = w1.GetAttributeValue <string>("name"),
Left = w1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var w2 in wfls2)
{
var w1 = wfls1.Where(x => x.Id == w2.Id).FirstOrDefault();
if (w1 == null)
{
_diffResult.Workflows.Add(new ComponentDiff <Entity>()
{
Name = w2.GetAttributeValue <string>("name"),
Right = w2,
});
}
mainForm.ProgressPerformStep();
}
}
public void DiffRoles()
{
// Instantiate QueryExpression QEplugintype
var qe = new QueryExpression("role");
qe.ColumnSet.AddColumns("name");
var roles1 = LeftService.RetrieveMultiple(qe).Entities;
var roles2 = RightService.RetrieveMultiple(qe).Entities;
mainForm.ProgressStart("Security Roles", 1, roles1.Count + roles2.Count);
foreach (var r1 in roles1)
{
var r2 = roles2.Where(x => x.Id == r1.Id).FirstOrDefault();
if (r2 == null)
{
_diffResult.Roles.Add(new ComponentDiff <Entity>()
{
Name = r1.GetAttributeValue <string>("name"),
Left = r1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var r2 in roles2)
{
var r1 = roles1.Where(x => x.Id == r2.Id).FirstOrDefault();
if (r1 == null)
{
_diffResult.Roles.Add(new ComponentDiff <Entity>()
{
Name = r2.GetAttributeValue <string>("name"),
Right = r2,
});
}
mainForm.ProgressPerformStep();
}
}
public void DiffTemapltes(string entityName, List <ComponentDiff <Entity> > diffList, string[] columns, string key)
{
var qe = new QueryExpression(entityName);
qe.ColumnSet.AddColumns(columns);
qe.Criteria.AddCondition("ismanaged", ConditionOperator.Equal, false);
var temps1 = LeftService.RetrieveMultiple(qe).Entities;
var temps2 = RightService.RetrieveMultiple(qe).Entities;
foreach (var temp1 in temps1)
{
var s2 = temps2.Where(x => x.GetAttributeValue <string>(key) == temp1.GetAttributeValue <string>(key)).FirstOrDefault();
if (s2 == null)
{
diffList.Add(new ComponentDiff <Entity>()
{
EntityName = entityName,
Name = temp1.GetAttributeValue <string>(key),
Left = temp1,
});
}
}
foreach (var temp2 in temps2)
{
var s1 = temps1.Where(x => x.GetAttributeValue <string>(key) == temp2.GetAttributeValue <string>(key)).FirstOrDefault();
if (s1 == null)
{
diffList.Add(new ComponentDiff <Entity>()
{
EntityName = entityName,
Name = temp2.GetAttributeValue <string>(key),
Right = temp2,
});
}
}
}
public void DiffPlugins()
{
// Instantiate QueryExpression QEplugintype
var qe = new QueryExpression("plugintype");
qe.ColumnSet.AddColumns("friendlyname", "name", "assemblyname", "isworkflowactivity", "plugintypeid", "typename", "plugintypeidunique", "pluginassemblyid");
var pls1 = LeftService.RetrieveMultiple(qe).Entities;
var pls2 = RightService.RetrieveMultiple(qe).Entities;
mainForm.ProgressStart("Plugins", 1, pls1.Count + pls2.Count);
foreach (var p1 in pls1)
{
var p2 = pls2.Where(x => x.GetAttributeValue <string>("name") == p1.GetAttributeValue <string>("name")).FirstOrDefault();
if (p2 == null)
{
_diffResult.Plugins.Add(new ComponentDiff <Entity>()
{
Name = p1.GetAttributeValue <string>("name"),
Left = p1,
});
}
mainForm.ProgressPerformStep();
}
foreach (var p2 in pls2)
{
var p1 = pls1.Where(x => x.GetAttributeValue <string>("name") == p2.GetAttributeValue <string>("name")).FirstOrDefault();
if (p1 == null)
{
_diffResult.Plugins.Add(new ComponentDiff <Entity>()
{
Name = p2.GetAttributeValue <string>("name"),
Right = p2,
});
}
mainForm.ProgressPerformStep();
}
}