private string CreateFile(ConnectionData connectionData, string name, Guid id, string fieldTitle, string xmlContent)
{
string fileName = EntityFileNameFormatter.GetReportFileName(connectionData.Name, name, id, fieldTitle, FileExtension.xml);
string filePath = Path.Combine(_commonConfig.FolderForExport, FileOperations.RemoveWrongSymbols(fileName));
if (!string.IsNullOrEmpty(xmlContent))
{
try
{
if (ContentComparerHelper.TryParseXml(xmlContent, out var doc))
{
xmlContent = doc.ToString();
}
File.WriteAllText(filePath, xmlContent, new UTF8Encoding(false));
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.InConnectionEntityFieldExportedToFormat5, connectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle, filePath);
}
catch (Exception ex)
{
this._iWriteToOutput.WriteErrorToOutput(connectionData, ex);
}
}
else
{
filePath = string.Empty;
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, connectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle);
}
return(filePath);
}
protected override void CommandAction(DTEHelper helper, Tuple <ConnectionData, ConnectionData> connectionDataPair)
{
List <SelectedFile> selectedFiles = helper.GetOpenedFileInCodeWindow(FileOperations.SupportsXmlType).Take(2).ToList();
if (selectedFiles.Count == 1)
{
string fileText = File.ReadAllText(selectedFiles[0].FilePath);
if (ContentComparerHelper.TryParseXml(fileText, out var doc))
{
var attribute = doc.Attribute(Intellisense.Model.IntellisenseContext.IntellisenseContextAttributeEntityName);
string entityName = attribute?.Value;
if (!string.IsNullOrEmpty(entityName))
{
helper.HandleOpenEntityMetadataOrganizationComparerCommand(connectionDataPair.Item1, connectionDataPair.Item2, entityName);
}
else
{
helper.HandleOpenApplicationRibbonOrganizationComparerCommand(connectionDataPair.Item1, connectionDataPair.Item2);
}
}
}
}
protected override void CommandAction(DTEHelper helper, Tuple <ConnectionData, ConnectionData> connectionDataPair)
{
List <SelectedFile> selectedFiles = helper.GetOpenedFileInCodeWindow(FileOperations.SupportsXmlType).Take(2).ToList();
if (selectedFiles.Count == 1)
{
string fileText = File.ReadAllText(selectedFiles[0].FilePath);
if (ContentComparerHelper.TryParseXml(fileText, out var doc))
{
var webResourceNameAttribute = doc.Attribute(Intellisense.Model.IntellisenseContext.IntellisenseContextAttributeWebResourceName);
helper.HandleOpenWebResourceOrganizationComparerCommand(connectionDataPair.Item1, connectionDataPair.Item2, webResourceNameAttribute?.Value);
}
}
}
protected override void CommandAction(DTEHelper helper)
{
List <SelectedFile> selectedFiles = helper.GetOpenedFileInCodeWindow(FileOperations.SupportsXmlType).Take(2).ToList();
if (selectedFiles.Count == 1)
{
string fileText = File.ReadAllText(selectedFiles[0].FilePath);
if (ContentComparerHelper.TryParseXml(fileText, out var doc))
{
var attribute = doc.Attribute(Intellisense.Model.IntellisenseContext.IntellisenseContextAttributeWorkflowId);
helper.HandleExplorerWorkflows(attribute?.Value);
}
}
}
protected override void CommandAction(DTEHelper helper)
{
List <SelectedFile> selectedFiles = helper.GetOpenedFileInCodeWindow(FileOperations.SupportsXmlType).Take(2).ToList();
if (selectedFiles.Count == 1)
{
string fileText = File.ReadAllText(selectedFiles[0].FilePath);
if (ContentComparerHelper.TryParseXml(fileText, out var doc))
{
var pluginTypeName = doc.XPathSelectElements("./CustomActivityInfo/TypeName").Where(e => !string.IsNullOrEmpty(e.Value)).Select(e => e.Value).FirstOrDefault();
helper.HandleOpenPluginTypeExplorer(pluginTypeName);
}
}
}
private string CreateFile(string folder, string name, Guid id, string fieldTitle, string xmlContent)
{
ConnectionData connectionData = null;
cmBCurrentConnection.Dispatcher.Invoke(() =>
{
connectionData = cmBCurrentConnection.SelectedItem as ConnectionData;
});
if (connectionData == null)
{
return null;
}
string fileName = EntityFileNameFormatter.GetReportFileName(connectionData.Name, name, id, fieldTitle, FileExtension.xml);
string filePath = Path.Combine(folder, FileOperations.RemoveWrongSymbols(fileName));
if (!string.IsNullOrEmpty(xmlContent))
{
try
{
if (ContentComparerHelper.TryParseXml(xmlContent, out var doc))
{
xmlContent = doc.ToString();
}
File.WriteAllText(filePath, xmlContent, new UTF8Encoding(false));
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.InConnectionEntityFieldExportedToFormat5, connectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle, filePath);
}
catch (Exception ex)
{
this._iWriteToOutput.WriteErrorToOutput(connectionData, ex);
}
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, connectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle);
this._iWriteToOutput.ActivateOutputWindow(connectionData);
}
return filePath;
}
private void ExportEntityXml(string entityName, string filePath)
{
var request = new OrganizationRequest("RetrieveEntityXml");
request.Parameters["EntityName"] = entityName;
var response = _service.Execute(request);
if (response.Results.ContainsKey("EntityXml"))
{
var text = response.Results["EntityXml"].ToString();
if (ContentComparerHelper.TryParseXml(text, out var doc))
{
text = doc.ToString();
}
File.WriteAllText(filePath, text, new UTF8Encoding(false));
}
}
protected override void CommandAction(DTEHelper helper)
{
List <SelectedFile> selectedFiles = helper.GetOpenedFileInCodeWindow(FileOperations.SupportsXmlType).Take(2).ToList();
if (selectedFiles.Count == 1)
{
string siteMapNameUnique = string.Empty;
string fileText = File.ReadAllText(selectedFiles[0].FilePath);
if (ContentComparerHelper.TryParseXml(fileText, out var doc))
{
var attribute = doc.Attribute(Intellisense.Model.IntellisenseContext.IntellisenseContextAttributeSiteMapNameUnique);
if (attribute != null && !string.IsNullOrEmpty(attribute.Value))
{
siteMapNameUnique = attribute.Value;
}
}
helper.HandleExplorerSiteMap(siteMapNameUnique);
}
}
private async Task PerformUpdateEntityField(string folder, Guid idCustomControl, string name, string fieldName, string fieldTitle, FileExtension extension)
{
if (!this.IsControlsEnabled)
{
return;
}
var service = await GetService();
if (service == null)
{
return;
}
ToggleControls(service.ConnectionData, false, Properties.OutputStrings.InConnectionUpdatingFieldFormat2, service.ConnectionData.Name, fieldName);
try
{
var repository = new CustomControlRepository(service);
var customControl = await repository.GetByIdAsync(idCustomControl, new ColumnSet(fieldName));
string xmlContent = customControl.GetAttributeValue <string>(fieldName);
if (string.Equals(fieldName, CustomControl.Schema.Attributes.manifest, StringComparison.InvariantCultureIgnoreCase))
{
if (ContentComparerHelper.TryParseXml(xmlContent, out var tempDoc))
{
xmlContent = tempDoc.ToString();
}
}
else if (string.Equals(fieldName, CustomControl.Schema.Attributes.clientjson, StringComparison.InvariantCultureIgnoreCase))
{
xmlContent = ContentComparerHelper.FormatJson(xmlContent);
}
{
string backUpXmlContent = xmlContent;
if (string.Equals(fieldName, CustomControl.Schema.Attributes.manifest, StringComparison.InvariantCultureIgnoreCase))
{
backUpXmlContent = ContentComparerHelper.FormatXmlByConfiguration(
backUpXmlContent
, _commonConfig
, XmlOptionsControls.CustomControlXmlOptions
, schemaName: AbstractDynamicCommandXsdSchemas.ManifestSchema
, customControlId: idCustomControl
);
}
else if (string.Equals(fieldName, CustomControl.Schema.Attributes.clientjson, StringComparison.InvariantCultureIgnoreCase))
{
backUpXmlContent = ContentComparerHelper.FormatJson(backUpXmlContent);
}
await CreateFileAsync(folder, idCustomControl, name, fieldTitle + " BackUp", extension, backUpXmlContent);
}
var newText = string.Empty;
bool?dialogResult = false;
this.Dispatcher.Invoke(() =>
{
var form = new WindowTextField("Enter " + fieldTitle, fieldTitle, xmlContent);
dialogResult = form.ShowDialog();
newText = form.FieldText;
});
if (dialogResult.GetValueOrDefault() == false)
{
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldCanceledFormat2, service.ConnectionData.Name, fieldName);
return;
}
newText = ContentComparerHelper.RemoveInTextAllCustomXmlAttributesAndNamespaces(newText);
UpdateStatus(service.ConnectionData, Properties.OutputStrings.ValidatingXmlForFieldFormat1, fieldName);
if (!ContentComparerHelper.TryParseXmlDocument(newText, out var doc))
{
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.TextIsNotValidXml);
_iWriteToOutput.ActivateOutputWindow(service.ConnectionData);
return;
}
newText = doc.ToString(SaveOptions.DisableFormatting);
var updateEntity = new CustomControl
{
Id = idCustomControl
};
updateEntity.Attributes[fieldName] = newText;
await service.UpdateAsync(updateEntity);
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldCompletedFormat2, service.ConnectionData.Name, fieldName);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldFailedFormat2, service.ConnectionData.Name, fieldName);
}
}
private async Task PerformUpdateEntityField(string folder, Organization organization, string fieldName, string fieldTitle)
{
if (!this.IsControlsEnabled)
{
return;
}
var service = await GetService();
if (service == null)
{
return;
}
ToggleControls(service.ConnectionData, false, Properties.OutputStrings.InConnectionUpdatingFieldFormat2, service.ConnectionData.Name, fieldName);
try
{
string xmlContent = organization.GetAttributeValue <string>(fieldName);
string filePath = await CreateFileAsync(service.ConnectionData, folder, organization.Name, fieldTitle + " BackUp", xmlContent);
var newText = string.Empty;
bool?dialogResult = false;
this.Dispatcher.Invoke(() =>
{
var form = new WindowTextField("Enter " + fieldTitle, fieldTitle, xmlContent);
dialogResult = form.ShowDialog();
newText = form.FieldText;
});
if (dialogResult.GetValueOrDefault() == false)
{
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldFailedFormat2, service.ConnectionData.Name, fieldName);
return;
}
newText = ContentComparerHelper.RemoveInTextAllCustomXmlAttributesAndNamespaces(newText);
if (ContentComparerHelper.TryParseXml(newText, out var doc))
{
newText = doc.ToString(SaveOptions.DisableFormatting);
}
var updateEntity = new Organization
{
Id = organization.Id
};
updateEntity.Attributes[fieldName] = newText;
await service.UpdateAsync(updateEntity);
organization.Attributes[fieldName] = newText;
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldCompletedFormat2, service.ConnectionData.Name, fieldName);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldFailedFormat2, service.ConnectionData.Name, fieldName);
}
}
private async Task ThreeFileDifferenceReport(SelectedFile selectedFile, string fieldName, string fieldTitle, ConnectionData connectionData1, ConnectionData connectionData2, ShowDifferenceThreeFileType differenceType, CommonConfiguration commonConfig)
{
if (differenceType == ShowDifferenceThreeFileType.ThreeWay)
{
if (!File.Exists(selectedFile.FilePath))
{
this._iWriteToOutput.WriteToOutput(null, Properties.OutputStrings.FileNotExistsFormat1, selectedFile.FilePath);
return;
}
}
var doubleConnection = await ConnectAndWriteToOutputDoubleConnectionAsync(connectionData1, connectionData2);
if (doubleConnection == null)
{
return;
}
var service1 = doubleConnection.Item1;
var service2 = doubleConnection.Item2;
if (string.IsNullOrEmpty(fieldName))
{
fieldName = Report.Schema.Attributes.originalbodytext;
fieldTitle = Report.Schema.Headers.originalbodytext;
}
// Репозиторий для работы с веб-ресурсами
ReportRepository reportRepository1 = new ReportRepository(service1);
ReportRepository reportRepository2 = new ReportRepository(service2);
var taskReport1 = reportRepository1.FindAsync(selectedFile.FileName);
var taskReport2 = reportRepository2.FindAsync(selectedFile.FileName);
Report reportEntity1 = await taskReport1;
Report reportEntity2 = await taskReport2;
if (reportEntity1 != null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report founded by name.", connectionData1.Name);
connectionData1.AddMapping(reportEntity1.Id, selectedFile.FriendlyFilePath);
connectionData1.Save();
}
else
{
Guid?reportId = connectionData1.GetLastLinkForFile(selectedFile.FriendlyFilePath);
if (reportId.HasValue)
{
reportEntity1 = await reportRepository1.GetByIdAsync(reportId.Value);
if (reportEntity1 != null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report not founded by name. Last link report is selected for difference.", connectionData1.Name);
connectionData1.AddMapping(reportEntity1.Id, selectedFile.FriendlyFilePath);
connectionData1.Save();
}
}
}
if (reportEntity2 != null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report founded by name.", connectionData2.Name);
connectionData2.AddMapping(reportEntity2.Id, selectedFile.FriendlyFilePath);
connectionData2.Save();
}
else
{
Guid?reportId = connectionData2.GetLastLinkForFile(selectedFile.FriendlyFilePath);
if (reportId.HasValue)
{
reportEntity2 = await reportRepository2.GetByIdAsync(reportId.Value);
if (reportEntity2 != null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report not founded by name. Last link report is selected for difference.", connectionData2.Name);
connectionData2.AddMapping(reportEntity2.Id, selectedFile.FriendlyFilePath);
connectionData2.Save();
}
}
}
if (!File.Exists(selectedFile.FilePath))
{
this._iWriteToOutput.WriteToOutput(null, Properties.OutputStrings.FileNotExistsFormat1, selectedFile.FilePath);
}
if (reportEntity1 == null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report not founded in CRM: {1}", connectionData1.Name, selectedFile.FileName);
}
if (reportEntity2 == null)
{
this._iWriteToOutput.WriteToOutput(null, "{0}: Report not founded in CRM: {1}", connectionData2.Name, selectedFile.FileName);
}
string fileLocalPath = selectedFile.FilePath;
string fileLocalTitle = selectedFile.FileName;
string filePath1 = string.Empty;
string fileTitle1 = string.Empty;
string filePath2 = string.Empty;
string fileTitle2 = string.Empty;
if (reportEntity1 != null)
{
var textReport = reportEntity1.GetAttributeValue <string>(fieldName);
if (ContentComparerHelper.TryParseXml(textReport, out var doc))
{
textReport = doc.ToString();
}
var reportName = EntityFileNameFormatter.GetReportFileName(connectionData1.Name, reportEntity1.Name, reportEntity1.Id, fieldTitle, selectedFile.Extension);
filePath1 = FileOperations.GetNewTempFilePath(Path.GetFileNameWithoutExtension(reportName), selectedFile.Extension);
fileTitle1 = connectionData1.Name + "." + selectedFile.FileName + " - " + filePath1;
File.WriteAllText(filePath1, textReport, new UTF8Encoding(false));
}
if (reportEntity2 != null)
{
var textReport = reportEntity2.GetAttributeValue <string>(fieldName);
if (ContentComparerHelper.TryParseXml(textReport, out var doc))
{
textReport = doc.ToString();
}
var reportName = EntityFileNameFormatter.GetReportFileName(connectionData2.Name, reportEntity2.Name, reportEntity2.Id, fieldTitle, selectedFile.Extension);
filePath2 = FileOperations.GetNewTempFilePath(Path.GetFileNameWithoutExtension(reportName), selectedFile.Extension);
fileTitle1 = connectionData2.Name + "." + selectedFile.FileName + " - " + filePath2;
File.WriteAllText(filePath2, textReport, new UTF8Encoding(false));
}
switch (differenceType)
{
case ShowDifferenceThreeFileType.OneByOne:
ShowDifferenceOneByOne(commonConfig, connectionData1, connectionData2, fileLocalPath, fileLocalTitle, filePath1, fileTitle1, filePath2, fileTitle2);
break;
case ShowDifferenceThreeFileType.TwoConnections:
await this._iWriteToOutput.ProcessStartProgramComparerAsync(connectionData1, filePath1, filePath2, fileTitle1, fileTitle2, connectionData2);
break;
case ShowDifferenceThreeFileType.ThreeWay:
ShowDifferenceThreeWay(commonConfig, connectionData1, connectionData2, fileLocalPath, fileLocalTitle, filePath1, fileTitle1, filePath2, fileTitle2);
break;
default:
break;
}
}
private async Task DifferenceReport(ConnectionData connectionData, CommonConfiguration commonConfig, SelectedFile selectedFile, string fieldName, string fieldTitle, bool withSelect)
{
if (!File.Exists(selectedFile.FilePath))
{
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.FileNotExistsFormat1, selectedFile.FilePath);
return;
}
var service = await ConnectAndWriteToOutputAsync(connectionData);
if (service == null)
{
return;
}
if (string.IsNullOrEmpty(fieldName))
{
fieldName = Report.Schema.Attributes.originalbodytext;
fieldTitle = Report.Schema.Headers.originalbodytext;
}
Report reportEntity = null;
using (service.Lock())
{
// Репозиторий для работы с веб-ресурсами
var reportRepository = new ReportRepository(service);
if (withSelect)
{
Guid?reportId = connectionData.GetLastLinkForFile(selectedFile.FriendlyFilePath);
bool?dialogResult = null;
Guid?selectedReportId = null;
string selectedPath = string.Empty;
var thread = new Thread(() =>
{
try
{
var form = new Views.WindowReportSelect(this._iWriteToOutput, service, selectedFile, reportId);
dialogResult = form.ShowDialog();
selectedReportId = form.SelectedReportId;
}
catch (Exception ex)
{
DTEHelper.WriteExceptionToOutput(connectionData, ex);
}
});
thread.SetApartmentState(ApartmentState.STA);
thread.Start();
thread.Join();
if (dialogResult.GetValueOrDefault())
{
if (selectedReportId.HasValue)
{
this._iWriteToOutput.WriteToOutput(connectionData, "Custom report is selected.");
reportEntity = await reportRepository.GetByIdAsync(selectedReportId.Value);
connectionData.AddMapping(reportEntity.Id, selectedFile.FriendlyFilePath);
connectionData.Save();
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, "!Warning. Report not exists. name: {0}.", selectedFile.Name);
}
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.DifferenceWasCancelled);
return;
}
}
else
{
reportEntity = await reportRepository.FindAsync(selectedFile.FileName);
if (reportEntity != null)
{
this._iWriteToOutput.WriteToOutput(connectionData, "Report founded by name.");
connectionData.AddMapping(reportEntity.Id, selectedFile.FriendlyFilePath);
connectionData.Save();
}
else
{
Guid?reportId = connectionData.GetLastLinkForFile(selectedFile.FriendlyFilePath);
if (reportId.HasValue)
{
reportEntity = await reportRepository.GetByIdAsync(reportId.Value);
}
if (reportEntity != null)
{
this._iWriteToOutput.WriteToOutput(connectionData, "Report not founded by name. Last link report is selected for difference.");
connectionData.AddMapping(reportEntity.Id, selectedFile.FriendlyFilePath);
connectionData.Save();
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, "Report not founded by name and has not Last link.");
this._iWriteToOutput.WriteToOutput(connectionData, "Starting Custom Report selection form.");
bool?dialogResult = null;
Guid?selectedReportId = null;
string selectedPath = string.Empty;
var thread = new Thread(() =>
{
try
{
var form = new Views.WindowReportSelect(this._iWriteToOutput, service, selectedFile, reportId);
dialogResult = form.ShowDialog();
selectedReportId = form.SelectedReportId;
}
catch (Exception ex)
{
DTEHelper.WriteExceptionToOutput(connectionData, ex);
}
});
thread.SetApartmentState(ApartmentState.STA);
thread.Start();
thread.Join();
if (dialogResult.GetValueOrDefault())
{
if (selectedReportId.HasValue)
{
this._iWriteToOutput.WriteToOutput(connectionData, "Custom report is selected.");
reportEntity = await reportRepository.GetByIdAsync(selectedReportId.Value);
connectionData.AddMapping(reportEntity.Id, selectedFile.FriendlyFilePath);
connectionData.Save();
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, "!Warning. Report not exists. name: {0}.", selectedFile.Name);
}
}
else
{
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.DifferenceWasCancelled);
return;
}
}
}
}
}
if (reportEntity == null)
{
this._iWriteToOutput.WriteToOutput(connectionData, Properties.OutputStrings.InConnectionReportWasNotFoundFormat2, connectionData.Name, selectedFile.FileName);
return;
}
var reportName = EntityFileNameFormatter.GetReportFileName(connectionData.Name, reportEntity.Name, reportEntity.Id, fieldTitle, selectedFile.Extension);
string temporaryFilePath = FileOperations.GetNewTempFilePath(Path.GetFileNameWithoutExtension(reportName), selectedFile.Extension);
var textReport = reportEntity.GetAttributeValue <string>(fieldName);
if (ContentComparerHelper.TryParseXml(textReport, out var doc))
{
textReport = doc.ToString();
}
File.WriteAllText(temporaryFilePath, textReport, new UTF8Encoding(false));
//DownloadReportDefinitionRequest rdlRequest = new DownloadReportDefinitionRequest
//{
// ReportId = reportEntity.Id
//};
//DownloadReportDefinitionResponse rdlResponse = (DownloadReportDefinitionResponse)service.Execute(rdlRequest);
//using (XmlTextWriter reportDefinitionFile = new XmlTextWriter(temporaryFilePath, System.Text.Encoding.UTF8))
//{
// reportDefinitionFile.WriteRaw(rdlResponse.BodyText);
// reportDefinitionFile.Close();
//}
this._iWriteToOutput.WriteToOutput(connectionData, "Starting Compare Program for {0} and {1}", selectedFile.FriendlyFilePath, reportName);
string fileLocalPath = selectedFile.FilePath;
string fileLocalTitle = selectedFile.FileName;
string filePath2 = temporaryFilePath;
string fileTitle2 = connectionData.Name + "." + selectedFile.FileName + " - " + temporaryFilePath;
await this._iWriteToOutput.ProcessStartProgramComparerAsync(connectionData, fileLocalPath, filePath2, fileLocalTitle, fileTitle2);
}
private async Task PerformUpdateEntityField(string folder, Guid idSavedQueryVisualization, string entityName, string name, string fieldName, string fieldTitle)
{
if (!this.IsControlsEnabled)
{
return;
}
var service = await GetService();
if (service == null)
{
return;
}
ToggleControls(service.ConnectionData, false, Properties.OutputStrings.InConnectionUpdatingFieldFormat2, service.ConnectionData.Name, fieldName);
try
{
var repository = new SavedQueryVisualizationRepository(service);
var savedQueryVisualization = await repository.GetByIdAsync(idSavedQueryVisualization, new ColumnSet(fieldName));
string xmlContent = savedQueryVisualization.GetAttributeValue <string>(fieldName);
{
if (ContentComparerHelper.TryParseXml(xmlContent, out var doc))
{
xmlContent = doc.ToString();
}
}
string filePath = await CreateFileAsync(folder, entityName, name, fieldTitle + " BackUp", xmlContent);
var newText = string.Empty;
bool?dialogResult = false;
this.Dispatcher.Invoke(() =>
{
var form = new WindowTextField("Enter " + fieldTitle, fieldTitle, xmlContent);
dialogResult = form.ShowDialog();
newText = form.FieldText;
});
if (dialogResult.GetValueOrDefault() == false)
{
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldFailedFormat2, service.ConnectionData.Name, fieldName);
return;
}
newText = ContentComparerHelper.RemoveInTextAllCustomXmlAttributesAndNamespaces(newText);
{
if (ContentComparerHelper.TryParseXml(newText, out var doc))
{
newText = doc.ToString(SaveOptions.DisableFormatting);
}
}
var updateEntity = new SavedQueryVisualization
{
Id = idSavedQueryVisualization
};
updateEntity.Attributes[fieldName] = newText;
await service.UpdateAsync(updateEntity);
UpdateStatus(service.ConnectionData, Properties.OutputStrings.InConnectionPublishingEntitiesFormat2, service.ConnectionData.Name, entityName);
{
var repositoryPublish = new PublishActionsRepository(service);
await repositoryPublish.PublishEntitiesAsync(new[] { entityName });
}
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldCompletedFormat2, service.ConnectionData.Name, fieldName);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.InConnectionUpdatingFieldFailedFormat2, service.ConnectionData.Name, fieldName);
}
}
private async Task PerformSearchAsync()
{
try
{
lstVwEntities.Items.DetachFromSourceCollection();
lstVwEntities.ItemsSource = null;
if (cmBEntityName.SelectedItem == null)
{
return;
}
string entityName = cmBEntityName.SelectedItem.ToString();
if (!_entityMetadataCache.ContainsKey(entityName))
{
return;
}
var entityMetadata = _entityMetadataCache[entityName];
var savedQuery = cmBSearchView.SelectedItem as EntityViewItem;
if (savedQuery == null)
{
return;
}
string searchText = txtBFilter.Text.Trim();
if (!ContentComparerHelper.TryParseXml(savedQuery.SavedQuery.FetchXml, out _, out var fetchXmlDoc))
{
return;
}
FillParametersInFetch(entityMetadata, fetchXmlDoc, searchText);
var response = await _service.ExecuteAsync <RetrieveMultipleResponse>(new RetrieveMultipleRequest()
{
Query = new FetchExpression(fetchXmlDoc.ToString()),
});
var columnsInFetch = EntityDescriptionHandler.GetColumnsFromFetch(_service.ConnectionData, fetchXmlDoc);
var entityCollection = response.EntityCollection;
var dataTable = EntityDescriptionHandler.ConvertEntityCollectionToDataTable(_service.ConnectionData, entityCollection, out Dictionary <string, string> columnMapping);
this.Dispatcher.Invoke(() =>
{
lstVwEntities.Columns.Clear();
foreach (var attributeName in columnsInFetch)
{
if (!columnMapping.ContainsKey(attributeName))
{
continue;
}
var dataColumnName = columnMapping[attributeName];
if (!dataTable.Columns.Contains(dataColumnName))
{
continue;
}
AddNewColumnInDataGrid(dataTable, attributeName, dataColumnName);
}
foreach (var attributeName in columnMapping.Keys)
{
if (columnsInFetch.Contains(attributeName))
{
continue;
}
var dataColumnName = columnMapping[attributeName];
if (!dataTable.Columns.Contains(dataColumnName))
{
continue;
}
AddNewColumnInDataGrid(dataTable, attributeName, dataColumnName);
}
lstVwEntities.ItemsSource = dataTable.DefaultView;
});
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(_service.ConnectionData, ex);
}
}