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 BtnActivateFormulas_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($"Activated formulas count: {count}"); } var id = en.Id; var entityName = en.GetAttributeValue <string>("north52_sourceentityname"); var name = en.GetAttributeValue <string>("north52_name"); try { CrmHelper.ActivateRecord("north52_formula", id, CrmConnManager.RService); } catch (Exception ex) { txtLog.AppendText($"**** Exception while activating formula: {name} {Environment.NewLine}"); txtLog.AppendText($"**** Message: {ex.Message} {Environment.NewLine}"); } } }