IT Corner

Home » All posts

CRM 2011

How to disable view picker in filtered view CRM 2011 Javascript

5:16 AM

CRM 2015

How to solve undifined or null reference in javascript CRM

1:55 AM

CRM 2015

How to get lookup value CRM 2015 using javascript

1:27 AM

CRM 2015

Step by Step How To Install Ribbon CRM 2015

5:03 AM

A Simple Way How to Create CRUD Operation in Dynamic CRM 2011

6:16 PM

CRUD Dynamic CRM 2011

When you start with your fisrt project or you first time use with Dynamic CRM, the first think should you have learn is CRUD operation. CRUD is acronym fro Create, Read, Update and Delete. Now I will show you a simple way to understand CRUD operation in Dynamic CRM 2011. here we go!

Config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

 <appSettings>
  <add key="CRMUrlOrg" value="http://192.168.21.28:5555/yourorganization/XRMServices/2011/Organization.svc" />
  <add key="CRMOrganization" value="yourorganization" />
  <add key="CRMDomain" value="yourdomain" />
  <add key="CRMUsername" value="yourusername" />
  <add key="CRMPassword" value="yourpassword" />
 </appSettings>
 
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
</configuration>

1. Create Operation

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using System.Configuration;
using System.ServiceModel.Description;

namespace DemoCRM
{
    class Program
    {
        static void Main(string[] args)
        {         
            //create service crm
            Uri urlcrm = new Uri(ConfigurationManager.AppSettings["CRMUrlOrg"]);
            string username = ConfigurationManager.AppSettings["CRMUsername"];
            string password = ConfigurationManager.AppSettings["CRMPassword"];

            ClientCredentials credentials = new ClientCredentials();
            credentials.Windows.ClientCredential.UserName = username;
            credentials.Windows.ClientCredential.Password = password;
            OrganizationServiceProxy serviceproxy = new OrganizationServiceProxy(urlcrm, null, credentials, null);
            IOrganizationService service;
            service = (IOrganizationService)serviceproxy;

            //First tutorial CRUD Crm 2011
            // 1. Create
            // insert into entity contact 

            Entity _contact = new Entity("contact");
            _contact.Attributes["firstname"] = "Jhon";
            _contact.Attributes["lastname"] = "Corner";
            _contact.Attributes["emailaddress1"] = "jhon@mial.com";

            Guid contactID = service.Create(_contact);

            Console.WriteLine("INSERT CONTACT SUCCESS WITH THE GUID : " + contactID);
            Console.ReadKey();

            //finish
            //lets run the program
        }
    }
}

2. Read Operation

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using System.Configuration;
using System.ServiceModel.Description;

namespace DemoCRM
{
    class Program
    {
        static void Main(string[] args)
        {         
            //create service crm
            Uri urlcrm = new Uri(ConfigurationManager.AppSettings["CRMUrlOrg"]);
            string username = ConfigurationManager.AppSettings["CRMUsername"];
            string password = ConfigurationManager.AppSettings["CRMPassword"];

            ClientCredentials credentials = new ClientCredentials();
            credentials.Windows.ClientCredential.UserName = username;
            credentials.Windows.ClientCredential.Password = password;
            OrganizationServiceProxy serviceproxy = new OrganizationServiceProxy(urlcrm, null, credentials, null);
            IOrganizationService service;
            service = (IOrganizationService)serviceproxy;

            // read from entity contact
            QueryByAttribute q_readcontact = new QueryByAttribute("contact");
            q_readcontact.ColumnSet = new ColumnSet(new string[] { "firstname", "lastname", "emailaddress1" });
            q_readcontact.Attributes.Add("firstname");
            q_readcontact.Values.Add("jhon");

            //similar to 
            //select firstname, lastname, emailaddress1 from contact where emailaddress1='jhon@mial.com'

            EntityCollection read_contacts = service.RetrieveMultiple(q_readcontact);
            
            // it return collection of entity
            // so, we use looping entity
            if (read_contacts.Entities.Count > 0) 
            {
                foreach (Entity _contact in read_contacts.Entities) 
                {
                    string fname = _contact.Attributes["firstname"].ToString();
                    string lname = _contact.Attributes["lastname"].ToString();
                    string email = _contact.Attributes["emailaddress1"].ToString();

                    Console.WriteLine("read from entity contact :");
                    Console.WriteLine("first name : " + fname);
                    Console.WriteLine("last name : " + lname);
                    Console.WriteLine("email : " + email);
                    Console.WriteLine("-------------------------------------------");
                    Console.WriteLine("press enter to continue");
                    Console.ReadKey();

                    //lets run the program
                }
            }
        }
    }
}

3.Update Operation

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using System.Configuration;
using System.ServiceModel.Description;

namespace DemoCRM
{
    class Program
    {
        static void Main(string[] args)
        {         
            //create service crm
            Uri urlcrm = new Uri(ConfigurationManager.AppSettings["CRMUrlOrg"]);
            string username = ConfigurationManager.AppSettings["CRMUsername"];
            string password = ConfigurationManager.AppSettings["CRMPassword"];

            ClientCredentials credentials = new ClientCredentials();
            credentials.Windows.ClientCredential.UserName = username;
            credentials.Windows.ClientCredential.Password = password;
            OrganizationServiceProxy serviceproxy = new OrganizationServiceProxy(urlcrm, null, credentials, null);
            IOrganizationService service;
            service = (IOrganizationService)serviceproxy;

            //update entity crm

            //first, define which entity to update
            //update contact with email address='jhon@mial.com';

            QueryByAttribute q_updatecontact = new QueryByAttribute("contact");
            q_updatecontact.ColumnSet = new ColumnSet(new string[] { "firstname", "lastname", "emailaddress1" });
            q_updatecontact.Attributes.Add("emailaddress1");
            q_updatecontact.Values.Add("jhon@mial.com");

            EntityCollection _updatecontacts = service.RetrieveMultiple(q_updatecontact);
            if (_updatecontacts.Entities.Count > 0) 
            {
                foreach (Entity _updatecontact in _updatecontacts.Entities) 
                {
                    _updatecontact.Attributes["firstname"] = "Indiana";
                    _updatecontact.Attributes["lastname"] = "Jhones";

                    service.Update(_updatecontact);

                    Console.WriteLine("Update contact success!");
                    Console.ReadKey();
                    //it similar to UPDATE contact SET firstname='Indiana', lastname='Jhones' WHERE emailaddress1='jhon@mial.com'

                    //lets run the program

                }
            }   
  
        }
    }
}

4. Delete Operation

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using System.Configuration;
using System.ServiceModel.Description;

namespace DemoCRM
{
    class Program
    {
        static void Main(string[] args)
        {         
            //create service crm
            Uri urlcrm = new Uri(ConfigurationManager.AppSettings["CRMUrlOrg"]);
            string username = ConfigurationManager.AppSettings["CRMUsername"];
            string password = ConfigurationManager.AppSettings["CRMPassword"];

            ClientCredentials credentials = new ClientCredentials();
            credentials.Windows.ClientCredential.UserName = username;
            credentials.Windows.ClientCredential.Password = password;
            OrganizationServiceProxy serviceproxy = new OrganizationServiceProxy(urlcrm, null, credentials, null);
            IOrganizationService service;
            service = (IOrganizationService)serviceproxy;

     //DELETE from entity crm
            QueryByAttribute q_deletecontact = new QueryByAttribute("contact");
            q_deletecontact.ColumnSet = new ColumnSet(new string[] { "firstname", "lastname", "emailaddress1" });
            q_deletecontact.Attributes.Add("emailaddress1");
            q_deletecontact.Values.Add("jhon@mial.com");

            EntityCollection deletecontacts = service.RetrieveMultiple(q_deletecontact);

            if (deletecontacts.Entities.Count > 0) 
            {
                foreach (Entity _deletecontact in deletecontacts.Entities) 
                {
                    service.Delete(_deletecontact.LogicalName, _deletecontact.Id);

                    Console.WriteLine("delete contact success!");
                    Console.ReadKey();
                    //finish
                    //lets run the program
                }
            }
            

            //thanks for wathing
            //see you in the next tutorial
            //happy coding :)   
  
        }
    }
}

Thanks For visiting my web, happy coding

crm 4.0

How To Retrieve Data From CRM 4.0

5:32 PM

Dynamic crm - how to retrirve data from crm 4.0

CRM 4.0 - Retrieve data crm

After we created Connection for CRM 4.0 , now we will try in a simple way how to retrieve data from CRM 4.0. It is very simple. there is two way how to retrieve data from crm, first, use query by attribute, it like like select in sql with the only one condition. second, use query expression, it like selet in sql with multy condition. and now we are going to try using query expression.
Step 1.
we make new class with the name crmclass or whatever else and begin make capacity for recover information crm

using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
using Microsoft.Crm.SdkTypeProxy;
using Microsoft.Crm.Sdk.Metadata;
using Microsoft.Crm.SdkTypeProxy.Metadata;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;


namespace CRMTutorial
{
    class CRMClass
    {
        public BusinessEntityCollection getallrecod_byexpression(CrmService _crmservice, string _entityname, string[] _columnset) 
        {
            QueryExpression q_expression = new QueryExpression(_entityname);
            q_expression.ColumnSet = new ColumnSet(_columnset);

            RetrieveMultipleRequest request = new RetrieveMultipleRequest();
            request.Query = q_expression;
            request.ReturnDynamicEntities = true;
            RetrieveMultipleResponse response = (RetrieveMultipleResponse)_crmservice.Execute(request);
            BusinessEntityCollection returnentities = response.BusinessEntityCollection;

            return returnentities;

        }
    }
}

Step 2.
just call the function in main program

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
using Microsoft.Crm.SdkTypeProxy;
using Microsoft.Crm.Sdk.Metadata;
using Microsoft.Crm.SdkTypeProxy.Metadata;
using System.IO;

namespace CRMTutorial
{
    class Program
    {
        static void Main(string[] args)
        {

                //create object from crm class

                CRMClass mycrmclass = new CRMClass();

                BusinessEntityCollection entities = mycrmclass.getallrecod_byexpression(service, "your entity name", new string[] { "your attribute name" });

  if (entities.BusinessEntities.Count > 0)
  {
   foreach (DynamicEntity entityname in entities.BusinessEntities)
   {
       string attributetoshow= entityname.Properties["your attribute name"].ToString();

   }
  }
            
        }
    }
}

finish :)
thanks for reading

crm 4.0

How To Connect Crm 2007 c#

9:51 PM

CRM is a business arrangement that helps organizations enhance promoting, deals, administration and responsibility to its clients to build the productivity of the association, while enhancing the client experience. Presently I need to share a tad bit involvement being developed crm. Acctualy I am Microsoft Dynamic CRM 2011, however for some anticipate still utilize crm 2007. so I need to relocate my code from element crm 2011 to dynamic crm 2007. It's exceptionally defferent code

config

Main Program

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
using Microsoft.Crm.SdkTypeProxy;
using Microsoft.Crm.Sdk.Metadata;
using Microsoft.Crm.SdkTypeProxy.Metadata;
using System.IO;
using System.Xml.Linq;
using System.Xml;
using System.Configuration;


namespace CRMTutorial
{
    class Program
    {
        static void Main(string[] args)
        {
        
 string _crmserviceurl = ConfigurationManager.AppSettings["CRMServerURL"];
        string _organization = ConfigurationManager.AppSettings["CRMOrganization"];
        string _username = ConfigurationManager.AppSettings["CRMUsername"];
        string _password = ConfigurationManager.AppSettings["CRMPassword"];
        string _domain = ConfigurationManager.AppSettings["CRMDomain"];
      
        CrmAuthenticationToken mytoken = new CrmAuthenticationToken();
        mytoken.AuthenticationType = 0;
        mytoken.OrganizationName = this._organization;

        NetworkCredential mycredential = new NetworkCredential();
        mycredential.UserName = this._username;
        mycredential.Password = this._password;
        mycredential.Domain = this._domain;

        CrmService service = new CrmService();
        service.Url = _crmserviceurl;
        service.UseDefaultCredentials = false;
        service.CrmAuthenticationTokenValue = mytoken;
        service.Credentials = mycredential; 
   
  /*Your code here
  call the service crm
  */ 
  
        }
    }
}