 |
| Creación del recurso compartido |
 |
| Recurso compartido |
 |
| Funciones compartidas en la librería |
 |
| Publicando los cambios |
 |
| Añadir la librería en Cuentas |
 |
| Selección del recurso compartido |
 |
| Añadirlo en OnLoad |
 |
| Creación del Option set |
 |
| Definir los valores de los Países |
 |
| Publicar el Option Set |
 |
| Utilización del Option Set en otras entidades (Cuenta) |
 |
| Este tipo de Picklist, puede ser definido que no pueda ser modificado |
 |
| Creación del proceso |
 |
| Proceso del díalogo |
 |
| XRM Virtual User Group |
 |
| CRM 2011 - Personalización de entidades |
// Prompt user to install/uninstall sample data.
Console.WriteLine("Would you like to:");
Console.WriteLine("1) Install sample data for Microsoft Dynamics CRM?");
Console.WriteLine("2) Uninstall sample data for Microsoft Dynamics CRM?");
Console.Write("Press [1] to Install, [2] to Uninstall: ");
String answer = Console.ReadLine();
// Update the sample data based on the user's response.
switch (answer)
{
case "1":
Console.WriteLine("Installing sample data...");
InstallSampleDataRequest request =new InstallSampleDataRequest();
InstallSampleDataResponse response =(InstallSampleDataResponse)_serviceProxy.Execute(request);
Console.WriteLine("Sample data successfully installed.");
break;
case "2":
Console.WriteLine("Uninstalling sample data...");
UninstallSampleDataRequest request2 = new UninstallSampleDataRequest();
UninstallSampleDataResponse response2 = (UninstallSampleDataResponse)_serviceProxy.Execute(request2);
Console.WriteLine("Sample data successfully uninstalled.");
break;
default:
Console.WriteLine("Neither option was selected. No changes have been made to your records.");
break;
}
 |
| Type Mapping Between Versions |
//CRM 2011 Entity entity = new Entity(Account.EntityLogicalName); entity["accountid"] = Guid.NewGuid(); // CRM 4.0 DynamicEntity entity = new DynamicEntity(); entity.Name = EntityName.account.ToString(); entity["accountid"] = new Key(Guid.NewGuid());
SELECT * FROM dbo.fn_GetFormatStrings()Esta función esta documentada en la SDK y se puede llamar de forma soportada. Para mas información acerca de esta función ir a: http://msdn.microsoft.com/en-us/library/bb955087.aspx
DateTime dtfecha = new DateTime(2010, 1, 1); double dblNumero = 587125635.66; Console.WriteLine(dtfecha.ToString(@"dd\/MM\/yyyy")); Console.WriteLine(dblNumero.ToString(@"###,###,###,##0;-###,###,###,##0;0")); Console.WriteLine(dblNumero.ToString(@"""£""###,###,###,##0.00;-""£""###,###,###,##0.00;""£""0.00"));Esto nos devuelve:
CrmAuthenticationToken token = new CrmAuthenticationToken();
token.OrganizationName = "AdventureWorks";
token.AuthenticationType = 0;
MetadataService metadataService = new MetadataService();
metadataService.Url = "http://192.168.1.22:5555/MSCRMServices/2007/MetadataService.asmx";
metadataService.CrmAuthenticationTokenValue = token;
metadataService.Credentials = new System.Net.NetworkCredential("usuario", "contraseña", "CRM");
RetrieveAllEntitiesRequest allEntitiesRequest = new RetrieveAllEntitiesRequest();
allEntitiesRequest.RetrieveAsIfPublished = false;
allEntitiesRequest.MetadataItems = MetadataItems.EntitiesOnly;
DateTime dtinicioall = DateTime.Now;
RetrieveAllEntitiesResponse allEntitiesResponse = (RetrieveAllEntitiesResponse)metadataService.Execute(allEntitiesRequest);
TimeSpan dtall = DateTime.Now.Subtract(dtinicioall);
Console.WriteLine("Tiempo en ejecutar RetrieveAllEntitiesResponse:" dtall.TotalMilliseconds.ToString());
RetrieveEntityRequest entityRequest = new RetrieveEntityRequest();
entityRequest.RetrieveAsIfPublished = false;
entityRequest.LogicalName = "contact";
entityRequest.EntityItems = EntityItems.All;
DateTime dtiniciocontact = DateTime.Now;
RetrieveEntityResponse entityResponse = (RetrieveEntityResponse)metadataService.Execute(entityRequest);
TimeSpan dtcontact = DateTime.Now.Subtract(dtiniciocontact);
Console.WriteLine("Tiempo en ejecutar RetrieveEntityResponse de contact:" dtcontact.TotalMilliseconds.ToString());
DateTime dtinicioaccount = DateTime.Now;
entityResponse = (RetrieveEntityResponse)metadataService.Execute(entityRequest);
TimeSpan dtaccount = DateTime.Now.Subtract(dtinicioaccount);
Console.WriteLine("Tiempo en ejecutar RetrieveEntityResponse de account:" dtaccount.TotalMilliseconds.ToString());
RetrieveAttributeRequest attributeRequest = new RetrieveAttributeRequest();
attributeRequest.EntityLogicalName = "contact";
attributeRequest.LogicalName = "firstname";
attributeRequest.RetrieveAsIfPublished = false;
DateTime dtiniciofirstname = DateTime.Now;
RetrieveAttributeResponse attributeResponse = (RetrieveAttributeResponse)metadataService.Execute(attributeRequest);
TimeSpan dtfirstname = DateTime.Now.Subtract(dtiniciofirstname);
Console.WriteLine("Tiempo en ejecutar RetrieveAttributeResponse de firstname de contact:" dtfirstname.TotalMilliseconds.ToString());
attributeRequest = new RetrieveAttributeRequest();
attributeRequest.EntityLogicalName = "account";
attributeRequest.LogicalName = "name";
attributeRequest.RetrieveAsIfPublished = false;
DateTime dtinicioname = DateTime.Now;
attributeResponse = (RetrieveAttributeResponse)metadataService.Execute(attributeRequest);
TimeSpan dtname = DateTime.Now.Subtract(dtinicioname);
Console.WriteLine("Tiempo en ejecutar RetrieveAttributeResponse de name de account:" dtname.TotalMilliseconds.ToString());
Console.ReadLine();
SELECT * FROM IncidentExtensionBase
SELECT incidentid,New_Categoria,New_Categorianame FROM FilteredIncident
DELETE new_paisExtensionBase
DELETE new_paisBase
SELECT Subscription.MachineName, SystemUserBase.FullName
FROM Subscription
INNER JOIN SystemUserBase
ON Subscription.SystemUserId = SystemUserBase.SystemUserId
select asyncoperationid, name,statecodename,statuscodename, createdon
from FilteredAsyncOperation
WHERE messagename='ExecuteWorkflow'
order by createdon desc
select stepname,activityname,description, completedon,statusname
from FilteredWorkflowLog
where asyncoperationid='8C6D813F-0C73-DF11-955A-000C299E8D82' --(aqui poner un "id" recogido de la consulta anterior)
var crm = new Xrm.XrmDataContext("Crm");
var namedContacts =
from contact in crm.contacts
where contact.emailaddress1 == "[email protected]"
select contact;
foreach (var c in namedContacts)
{
System.Console.WriteLine(c.fullname);
}
var contacts4 =
from contact in crm.GetEntities("contact")
where contact.GetPropertyValue("emailaddress1") == "[email protected]"
select contact.GetPropertyValue("fullname");
foreach (var c in contacts4)
{
Console.Write("{0}, ", c);
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace TestXrm
{
class Program
{
static void Main(string[] args)
{
CrearContacto();
}
static void CrearContacto()
{
var crm = new Xrm.XrmDataContext("Crm");
var contact = crm.CreateEntity("contact");
contact.SetPropertyValue("firstname", "Demian Adolfo");
contact.SetPropertyValue("lastname", "Raschkovan");
contact.SetPropertyValue("emailaddress1", "[email protected]");
var id = Guid.NewGuid();
contact.SetPropertyValue("contactid", id);
crm.AddObject("contact", contact);
crm.SaveChanges();
var id2 = contact.GetPropertyValue("contactid");
}
}
}
Suscribirse al RSS