private async Task UpdateSavedQueryXml(IOrganizationServiceExtented service, CommonConfiguration commonConfig, XDocument doc, string filePath, SavedQuery savedQuery)
{
string fieldName = SavedQueryRepository.GetFieldNameByXmlRoot(doc.Root.Name.ToString());
string fieldTitle = SavedQueryRepository.GetFieldTitleByXmlRoot(doc.Root.Name.ToString());
if (string.Equals(fieldName, SavedQuery.Schema.Attributes.layoutxml, StringComparison.InvariantCulture) &&
!string.IsNullOrEmpty(savedQuery.ReturnedTypeCode)
)
{
var entityData = service.ConnectionData.GetEntityIntellisenseData(savedQuery.ReturnedTypeCode);
if (entityData != null && entityData.ObjectTypeCode.HasValue)
{
XAttribute attr = doc.Root.Attribute("object");
if (attr != null)
{
attr.Value = entityData.ObjectTypeCode.ToString();
}
}
}
{
string xmlContent = savedQuery.GetAttributeValue <string>(fieldName);
if (!string.IsNullOrEmpty(xmlContent))
{
commonConfig.CheckFolderForExportExists(this._iWriteToOutput);
string fileNameBackUp = EntityFileNameFormatter.GetSavedQueryFileName(service.ConnectionData.Name, savedQuery.ReturnedTypeCode, savedQuery.Name, fieldTitle + " BackUp", FileExtension.xml);
string filePathBackUp = Path.Combine(commonConfig.FolderForExport, FileOperations.RemoveWrongSymbols(fileNameBackUp));
try
{
xmlContent = ContentComparerHelper.FormatXmlByConfiguration(
xmlContent
, commonConfig
, XmlOptionsControls.SavedQueryXmlOptions
, schemaName: AbstractDynamicCommandXsdSchemas.FetchSchema
, savedQueryId: savedQuery.Id
, entityName: savedQuery.ReturnedTypeCode
);
File.WriteAllText(filePathBackUp, xmlContent, new UTF8Encoding(false));
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldExportedToFormat5, service.ConnectionData.Name, SavedQuery.Schema.EntityLogicalName, savedQuery.Name, fieldTitle, filePathBackUp);
}
catch (Exception ex)
{
this._iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
}
}
else
{
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, service.ConnectionData.Name, SavedQuery.Schema.EntityLogicalName, savedQuery.Name, fieldTitle);
this._iWriteToOutput.ActivateOutputWindow(service.ConnectionData);
}
}
var newText = doc.ToString(SaveOptions.DisableFormatting);
if (string.Equals(fieldName, SavedQuery.Schema.Attributes.fetchxml, StringComparison.InvariantCulture))
{
try
{
_iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.ExecutingValidateSavedQueryRequest);
var request = new ValidateSavedQueryRequest()
{
FetchXml = newText,
QueryType = savedQuery.QueryType.GetValueOrDefault()
};
service.Execute(request);
}
catch (Exception ex)
{
this._iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
}
}
_iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.SavingEntityFormat1, savedQuery.LogicalName);
_iWriteToOutput.WriteToOutputEntityInstance(service.ConnectionData, savedQuery.LogicalName, savedQuery.Id);
var updateEntity = new SavedQuery
{
Id = savedQuery.Id,
};
updateEntity.Attributes[fieldName] = newText;
await service.UpdateAsync(updateEntity);
_iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.SavingEntityCompletedFormat1, savedQuery.LogicalName);
_iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionPublishingEntitiesFormat2, service.ConnectionData.Name, savedQuery.ReturnedTypeCode);
{
var repositoryPublish = new PublishActionsRepository(service);
await repositoryPublish.PublishEntitiesAsync(new[] { savedQuery.ReturnedTypeCode });
}
service.TryDispose();
}
[STAThread] // Added to support UX
static void Main(string[] args)
{
CrmServiceClient service = null;
try
{
service = SampleHelpers.Connect("Connect");
if (service.IsReady)
{
#region Sample Code
//////////////////////////////////////////////
#region Set up
SetUpSample(service);
#endregion Set up
#region Demonstrate
// Create the request
var validateRequest = new ValidateSavedQueryRequest()
{
FetchXml = savedQuery.FetchXml,
QueryType = savedQuery.QueryType.Value
};
// Send the request
Console.WriteLine(" Validating Saved Query");
try
{
// executing the request will throw an exception if the fetch xml is invalid
var validateResponse = (ValidateSavedQueryResponse)service.Execute(validateRequest);
Console.WriteLine(" Saved Query validated successfully");
}
catch (Exception)
{
Console.WriteLine(" Invalid Saved Query");
throw;
}
#endregion
#region Execute saved query
// Create the request
var executeSavedQueryRequest = new ExecuteByIdSavedQueryRequest()
{
EntityId = savedQuery.Id
};
// Execute the request
Console.WriteLine(" Executing Saved Query");
var executeSavedQueryResponse =
(ExecuteByIdSavedQueryResponse)service.Execute(executeSavedQueryRequest);
// Check results
if (String.IsNullOrEmpty(executeSavedQueryResponse.String))
{
throw new Exception("Saved Query did not return any results");
}
PrintResults(service, executeSavedQueryResponse.String);
#endregion
#region Execute user query
// Create the request
var executeUserQuery = new ExecuteByIdUserQueryRequest()
{
EntityId = userQuery.ToEntityReference()
};
// Send the request
Console.WriteLine(" Executing User Query");
var executeUserQueryResponse =
(ExecuteByIdUserQueryResponse)service.Execute(executeUserQuery);
if (String.IsNullOrEmpty(executeUserQueryResponse.String))
{
throw new Exception("User Query did not return any results");
}
// validate results
PrintResults(service, executeUserQueryResponse.String);
#region Clean up
CleanUpSample(service);
#endregion Clean up
}
#endregion Demonstrate
else
{
const string UNABLE_TO_LOGIN_ERROR = "Unable to Login to Dynamics CRM";
if (service.LastCrmError.Equals(UNABLE_TO_LOGIN_ERROR))
{
Console.WriteLine("Check the connection string values in cds/App.config.");
throw new Exception(service.LastCrmError);
}
else
{
throw service.LastCrmException;
}
}
}
#endregion Sample Code
catch (Exception ex)
{
SampleHelpers.HandleException(ex);
}
finally
{
if (service != null)
{
service.Dispose();
}
Console.WriteLine("Press <Enter> to exit.");
Console.ReadLine();
}
}
/// <summary>
/// This method first creates a series of Accounts to query over, a user query
/// that retrieves the names of all Accounts with a name of 'Coho Winery' and
/// a system query that retrieves all Account names. Then it validates the system
/// query, executes the system query and displays the results, and finally
/// executes the user query and displays the results.
/// </summary>
/// <param name="serverConfig">Contains server connection information.</param>
/// <param name="promptforDelete">When True, the user will be prompted to delete all
/// created entities.</param>
public void Run(ServerConnection.Configuration serverConfig, bool promptforDelete)
{
try
{
//<snippetUserQueryAndSavedQuery1>
// Connect to the Organization service.
// The using statement assures that the service proxy will be properly disposed.
using (_serviceProxy = new OrganizationServiceProxy(serverConfig.OrganizationUri, serverConfig.HomeRealmUri, serverConfig.Credentials, serverConfig.DeviceCredentials))
{
// This statement is required to enable early-bound type support.
_serviceProxy.EnableProxyTypes();
CreateRequiredRecords();
#region Validate saved query
// Create the request
ValidateSavedQueryRequest validateRequest = new ValidateSavedQueryRequest()
{
FetchXml = _savedQuery.FetchXml,
QueryType = _savedQuery.QueryType.Value
};
// Send the request
Console.WriteLine(" Validating Saved Query");
try
{
// executing the request will throw an exception if the fetch xml is invalid
var validateResponse = (ValidateSavedQueryResponse)_serviceProxy.Execute(validateRequest);
Console.WriteLine(" Saved Query validated successfully");
}
catch (Exception)
{
Console.WriteLine(" Invalid Saved Query");
throw;
}
#endregion
#region Execute saved query
// Create the request
ExecuteByIdSavedQueryRequest executeSavedQueryRequest = new ExecuteByIdSavedQueryRequest()
{
EntityId = _savedQuery.Id
};
// Execute the request
Console.WriteLine(" Executing Saved Query");
ExecuteByIdSavedQueryResponse executeSavedQueryResponse =
(ExecuteByIdSavedQueryResponse)_serviceProxy.Execute(executeSavedQueryRequest);
// Check results
if (String.IsNullOrEmpty(executeSavedQueryResponse.String))
{
throw new Exception("Saved Query did not return any results");
}
PrintResults(executeSavedQueryResponse.String);
#endregion
#region Execute user query
// Create the request
ExecuteByIdUserQueryRequest executeUserQuery = new ExecuteByIdUserQueryRequest()
{
EntityId = _userQuery.ToEntityReference()
};
// Send the request
Console.WriteLine(" Executing User Query");
ExecuteByIdUserQueryResponse executeUserQueryResponse =
(ExecuteByIdUserQueryResponse)_serviceProxy.Execute(executeUserQuery);
if (String.IsNullOrEmpty(executeUserQueryResponse.String))
{
throw new Exception("User Query did not return any results");
}
// validate results
PrintResults(executeUserQueryResponse.String);
#endregion
DeleteRequiredRecords(promptforDelete);
}
//</snippetUserQueryAndSavedQuery1>
}
// Catch any service fault exceptions that Microsoft Dynamics CRM throws.
catch (FaultException <Microsoft.Xrm.Sdk.OrganizationServiceFault> )
{
// You can handle an exception here or pass it back to the calling method.
throw;
}
}
/// <summary>
/// This method first creates a series of Accounts to query over, a user query
/// that retrieves the names of all Accounts with a name of 'Coho Winery' and
/// a system query that retrieves all Account names. Then it validates the system
/// query, executes the system query and displays the results, and finally
/// executes the user query and displays the results.
/// </summary>
/// <param name="serverConfig">Contains server connection information.</param>
/// <param name="promptforDelete">When True, the user will be prompted to delete all
/// created entities.</param>
public void Run(ServerConnection.Configuration serverConfig, bool promptforDelete)
{
try
{
//<snippetUserQueryAndSavedQuery1>
// Connect to the Organization service.
// The using statement assures that the service proxy will be properly disposed.
using (_serviceProxy = new OrganizationServiceProxy(serverConfig.OrganizationUri, serverConfig.HomeRealmUri,serverConfig.Credentials, serverConfig.DeviceCredentials))
{
// This statement is required to enable early-bound type support.
_serviceProxy.EnableProxyTypes();
CreateRequiredRecords();
#region Validate saved query
// Create the request
ValidateSavedQueryRequest validateRequest = new ValidateSavedQueryRequest()
{
FetchXml = _savedQuery.FetchXml,
QueryType = _savedQuery.QueryType.Value
};
// Send the request
Console.WriteLine(" Validating Saved Query");
try
{
// executing the request will throw an exception if the fetch xml is invalid
var validateResponse = (ValidateSavedQueryResponse)_serviceProxy.Execute(validateRequest);
Console.WriteLine(" Saved Query validated successfully");
}
catch (Exception)
{
Console.WriteLine(" Invalid Saved Query");
throw;
}
#endregion
#region Execute saved query
// Create the request
ExecuteByIdSavedQueryRequest executeSavedQueryRequest = new ExecuteByIdSavedQueryRequest()
{
EntityId = _savedQuery.Id
};
// Execute the request
Console.WriteLine(" Executing Saved Query");
ExecuteByIdSavedQueryResponse executeSavedQueryResponse =
(ExecuteByIdSavedQueryResponse)_serviceProxy.Execute(executeSavedQueryRequest);
// Check results
if (String.IsNullOrEmpty(executeSavedQueryResponse.String))
throw new Exception("Saved Query did not return any results");
PrintResults(executeSavedQueryResponse.String);
#endregion
#region Execute user query
// Create the request
ExecuteByIdUserQueryRequest executeUserQuery = new ExecuteByIdUserQueryRequest()
{
EntityId = _userQuery.ToEntityReference()
};
// Send the request
Console.WriteLine(" Executing User Query");
ExecuteByIdUserQueryResponse executeUserQueryResponse =
(ExecuteByIdUserQueryResponse)_serviceProxy.Execute(executeUserQuery);
if (String.IsNullOrEmpty(executeUserQueryResponse.String))
throw new Exception("User Query did not return any results");
// validate results
PrintResults(executeUserQueryResponse.String);
#endregion
DeleteRequiredRecords(promptforDelete);
}
//</snippetUserQueryAndSavedQuery1>
}
// Catch any service fault exceptions that Microsoft Dynamics CRM throws.
catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault>)
{
// You can handle an exception here or pass it back to the calling method.
throw;
}
}