public bool ProbarConexionCRM()
{
Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy _serviceProxy;
Microsoft.Xrm.Sdk.IOrganizationService _service;
Microsoft.Crm.Sdk.Samples.ServerConnection.Configuration serverConfig;
try
{
Microsoft.Crm.Sdk.Samples.ServerConnection serverConnect = new Microsoft.Crm.Sdk.Samples.ServerConnection();
serverConfig = serverConnect.GetServerConfiguration();
// Connect to the CRM web service using a connection string.
using (_serviceProxy = new Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy(serverConfig.OrganizationUri, serverConfig.HomeRealmUri, serverConfig.Credentials, serverConfig.DeviceCredentials))
{
_service = (Microsoft.Xrm.Sdk.IOrganizationService)_serviceProxy;
return(true);
}
}
// 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;
}
catch (Exception)
{
return(false);
}
}
private static void ConexionCRM()
{
Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy _serviceProxy;
Microsoft.Xrm.Sdk.IOrganizationService _service;
Microsoft.Crm.Sdk.Samples.ServerConnection.Configuration serverConfig;
try
{
Microsoft.Crm.Sdk.Samples.ServerConnection serverConnect = new Microsoft.Crm.Sdk.Samples.ServerConnection();
serverConfig = serverConnect.GetServerConfiguration();
CrmServiceClient crmSvc = new CrmServiceClient(new System.Net.NetworkCredential("<UserName>", "<Password>", “ <Domain> ”), AuthenticationType.AD, "<Server>", "<Port>", "<OrgName>", useUniqueInstance: false, useSsl: false, <orgDetail>);
// Connect to the CRM web service using a connection string.
using (_serviceProxy = new Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy(serverConfig.OrganizationUri, serverConfig.HomeRealmUri, serverConfig.Credentials, serverConfig.DeviceCredentials))
{
_service = (Microsoft.Xrm.Sdk.IOrganizationService)_serviceProxy;
var i = 0;
}
}
// 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;
}
catch (Exception)
{
}
}
static async Task Main(string[] args)
{
try
{
var _crmUrl = "https://crm.test.ru/";
var _organizationName = "Org";
var config = Microsoft.Xrm.Sdk.Client.ServiceConfigurationFactory
.CreateConfiguration <Microsoft.Xrm.Sdk.IOrganizationService>(
new Uri($"{_crmUrl}{_organizationName}/XRMServices/2011/Organization.svc"));
var clientCredentials = new System.ServiceModel.Description.ClientCredentials();
clientCredentials.Windows.ClientCredential.UserName = "******";
clientCredentials.Windows.ClientCredential.Password = "******";
var client = new Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy(config, clientCredentials);
//client.CallerId = new Guid("5c073647-da06-e611-80f9-005056971789");
var q = new Microsoft.Xrm.Sdk.Query.QueryExpression("role")
{
ColumnSet = { Columns = { "name", "businessunitid", "roleid" } },
Orders =
{
new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending)
},
LinkEntities =
{
new Microsoft.Xrm.Sdk.Query.LinkEntity("role", "systemuserroles", "roleid", "roleid",
Microsoft.Xrm.Sdk.Query.JoinOperator.Inner)
{
LinkEntities =
{
new Microsoft.Xrm.Sdk.Query.LinkEntity("systemuserroles", "systemuser", "systemuserid",
"systemuserid", Microsoft.Xrm.Sdk.Query.JoinOperator.Inner)
{
LinkCriteria =
{
Filters =
{
new Microsoft.Xrm.Sdk.Query.FilterExpression(Microsoft.Xrm.Sdk.Query
.LogicalOperator.And)
{
Conditions =
{
new Microsoft.Xrm.Sdk.Query.ConditionExpression("systemuserid",
Microsoft.Xrm.Sdk.Query.ConditionOperator.EqualUserId)
}
}
}
}
}
}
}
}
};
var rq = new Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest()
{
Query = q
};
/*var n = new Microsoft.Crm.Sdk.Messages.SetStateRequest
* {
* EntityMoniker =
* new Microsoft.Xrm.Sdk.EntityReference("lead", new Guid("c5dc1b6f-1712-e811-8229-005056977311")),
* State = new Microsoft.Xrm.Sdk.OptionSetValue(0),
* Status = new Microsoft.Xrm.Sdk.OptionSetValue(100000003)
* };
*
* var r = client.Execute(n);*/
var result = await client.RetrieveMultiple(q);
//return result.Entities.Select(i => i.GetAttributeValue<string>("name"));
foreach (var role in result.Entities)
{
Console.WriteLine(role.GetAttributeValue <string>("name"));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine();
Console.WriteLine("Press key");
Console.ReadKey();
}
