private void BtnDeactivateFormulas_Click(object sender, EventArgs e)
{
var fetchXml = string.Empty;
if (string.IsNullOrEmpty(txtInput.Text))
{
fetchXml = CrmHelper.GetFormulaFetchForMigrationEntities();
}
else
{
fetchXml = txtInput.Text;
}
var result = CrmConnManager.LService.RetrieveMultiple(new FetchExpression(fetchXml)).Entities;
txtLog.AppendText($"Number of active formulas: {result.Count}");
int count = 0;;
foreach (var en in result)
{
if (count++ % 50 == 0)
{
txtLog.AppendText($"Deactivated formulas count: {count}");
}
var id = en.Id;
var entityName = en.GetAttributeValue <string>("north52_sourceentityname");
var name = en.GetAttributeValue <string>("north52_name");
var formula = new CrmFormula()
{
Id = id,
Name = name,
Type = new MigrationHelper.Option()
{
Value = en.GetAttributeValue <OptionSetValue>("north52_formulatype").Value,
Name = en.FormattedValues["north52_formulatype"]
},
StatusCode = new MigrationHelper.Option()
{
Value = en.GetAttributeValue <OptionSetValue>("statuscode").Value,
Name = en.FormattedValues["statuscode"]
},
StateCode = new MigrationHelper.Option()
{
Value = en.GetAttributeValue <OptionSetValue>("statecode").Value,
Name = en.FormattedValues["statecode"]
},
};
//txtLog.AppendText($"Formula Name: {entityName}:{formula.Name}, Type: {formula.Type.Name} {Environment.NewLine}");
CrmHelper.DeactivateRecord("north52_formula", formula.Id, CrmConnManager.LService);
}
}
private void BtnDeactivateFormulas_Click(object sender, EventArgs e)
{
var sb = new StringBuilder();
int count = 0;
foreach (var f in mgr.FormulaDiffRecords)
{
if (f.RFormula != null)
{
var ff = f.RFormula;
if (!ff.Type.Name.StartsWith("Client") && ff.StateCode.Value == 0)
{
CrmHelper.DeactivateRecord("north52_formula", ff.Id, CrmConnManager.RService);
}
}
}
MessageBox.Show(sb.ToString());
}