Code snippets


Calling JavaScript function from different file.

 

if (typeof (TK) == "undefined")
{ TK = { __namespace: true }; }

TK.CRM = { __namespace: true };

TK.CRM.GetConfiguration = function (key) { 
 return key;

};

 
TK =
 {
 IHDURL: TK.CRM.GetConfiguration("Enya"),

 GetConfig : function () { 
 
 alert("Enigma and " + TK.IHDURL);
 }
 }

<input id=”Button1″ type=”button” value=”button”  onclick =”TK.GetConfig(‘Testing’);”/>

string userId = “i:0#.f|membership|geek@favs.onmicrosoft.com”;

var g= userId.Substring(userId.LastIndexOf(“|”) + 1);

SPMetal /web:http://hydvlscmvm20:5000  /code:C:\LSS\InvoiceForms\SPContext.cs

Gettting value from Soap Response

var resultXml = xmlHttpRequest.responseXML;
alert(resultXml.xml);

var entityNodes =
resultXml.selectNodes(“//RetrieveResponse/RetrieveResult/a:Attributes”);
var billetId=entityNodes[0].childNodes[1].childNodes[1].childNodes[0].nodeTypedValue;

Quick reference of stsadm commads related to solution

  • stsadm -o upgradesolution -name inoutcontactwebpart.wsp -filename “C:\inoutcontactwebpart.wsp” -immediate -allowgacdeployment
  • stsadm -o execadmsvcjobs
  • stsadm -o deletesolution -name inoutcontactwebpart.wsp -override
    stsadm -o addsolution -filename  “C:\inoutcontactwebpart.wsp”
  • stsadm -o deploysolution -name inoutcontactwebpart.wsp -allcontenturls -immediate -allowgacdeployment -force

Using Case when null in t-sql query

SELECT
CASE
WHEN  caseorigincodename IS NUll
THEN  ‘NA’
ElSE  caseorigincodename
END as CaseOrigin
FROM         FilteredIncident
WHERE     (statecode = 0)

Showing hyperlink in GridView.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

/*

http://crm/ACES/main.aspx?etn=contact&etc=2&id={33201199-28EE-DF11-8F27-00155D326904}&pagetype=entityrecord

*/

if (e.Row.RowType == DataControlRowType.DataRow)

{

e.Row.Cells[1].Text = “<a href=’http://crm/ACES/main.aspx?etn=contact&extraqs=_gridType=2&etc=2&id={“ + e.Row.Cells[0].Text + “}&pagetype=entityrecord’>” + e.Row.Cells[1].Text + “</a>”;

e.Row.Cells[0].Visible = false;

}

if (e.Row.RowType == DataControlRowType.Header)

{

e.Row.Cells[0].Visible = false;

}

}

window.open(url, ”, ‘width=400,height=300,toolbar=0,resizable=0’);

ImageFieldUrl

<asp:ImageField DataImageUrlField=”ImageFile” DataImageUrlFormatString=”~/Images/Products/{0}” >
<asp:ImageButton ID=”ImageButton1″ runat=”server”

ImageUrl='<%# Eval(“ImageFile”, “~/Images/Products/{0}”) %>’ PostBackUrl='<%# Eval(“ProductID”,”~/ProductDetail.aspx?id={0}”) %>’ />

Code for update using Dynamic Entity

CrmService service = new CrmService();

service.Credentials = System.Net.CredentialCache.DefaultCredentials;

service.CrmAuthenticationTokenValue = new CrmAuthenticationToken();

service.CrmAuthenticationTokenValue.AuthenticationType = 0;

service.CrmAuthenticationTokenValue.OrganizationName = “orgName”;

DynamicEntity myDE = new DynamicEntity();

myDE.Name = EntityName.contact.ToString();

KeyProperty keyProp = new KeyProperty();

keyProp.Name = “contactid”;

keyProp.Value = new Key();

keyProp.Value.Value = new Guid(“entityGuid”);

StringProperty strProp = new StringProperty();

strProp.Name = “lastname”;

strProp.Value = “myLastName”;

Property[] propColl = new Property[2];

propColl[0] = keyProp;

propColl[1] = strProp;

myDE.Properties = propColl;

service.Update(myDE);


Expression for a field in report

It would check whether a field is null or not. If null that it would add six months to current date or else keep the same value. It would also remove the time part from it.

= iif(
IsNothing(new_mydate.Value),
Format(DateAdd(DateInterval.Month,6,Now()),”M\/d\/yyyy”),
Format(Fields!new_mydate.Value,”M\/d\/yyyy”)
)

= iif(

IsNothing(new_mydate.Value),

Format(DateAdd(DateInterval.Month,6,Now()),”M\/d\/yyyy”),

Format(Fields!new_mydate.Value,”M\/d\/yyyy”)

)

Dynamically showing progress bar in the left navigation pane of the entity form.

document.getElementById(‘navAsyncOperations’).innerHTML = “<table align=’center’><tr><td><div id=’showbar’ style=’font-size:8pt;padding:2px;border:solid black 2px;’><span id=’p1′>            </span>  <span id=’p2′>            </span>  <span id=’p3′>            </span></div><span id=’info’></span></td></tr></table>”;

var percentComplete;
GetPercentComplete=function()
{

// hard code the the value for total number of field
var totalField=3;

// set total no of blank field as 0
var totalBlankField=0;

// check for all the required fields and increment the value
if(crmForm.all.new_name.DataValue==null)
{
totalBlankField++;
}

if(crmForm.all.new_firstname.DataValue==null)
{
totalBlankField++;
}

if(crmForm.all.new_lastname.DataValue==null)
{
totalBlankField++;
}

// total no. of fields would be total field minus total blank field

var totalFilledField=totalField-totalBlankField;

// if total filled field is zero that 0 % complete

if(totalFilledField==0)
{

percentComplete=0;
}
else
{

// calculate the percentage
percentComplete=(totalFilledField/totalField)*100;

}

Code for refreshing parent Crm Form from an asp.net page code

private void ReloadWindow()
{
StringBuilder builder = new StringBuilder();
builder.Append(“<script language=JavaScript>”);
builder.Append(“\r\n”);
builder.Append(“if (“);
builder.Append(“(window.opener != null) &&”);
builder.Append(“(window.opener.parent != null) &&”);
builder.Append(“(window.opener.parent.document != null) &&”);
builder.Append(“(window.opener.parent.document.crmForm != null)) {“);
builder.Append(“\r\n”);
builder.Append(“var parentForm = window.opener.parent.document.crmForm;”);
builder.Append(“\r\n”);
builder.Append(“parentForm.Save();”);
builder.Append(“\r\n”);
builder.Append(“window.opener.document.location.replace(window.opener.location);”);
builder.Append(“\r\n”);
builder.Append(“}”);
builder.Append(“\r\n”);
builder.Append(“self.focus();”);
builder.Append(“</script>”);
this.Response.Write(builder.ToString());
}

Just a simple JavaScript to change the status of the form

var statusContent=”’test content’

document.getElementById(‘EntityStatusText’).innerHTML=statusContent;

Preventing user from changing url in browser javascript

<body onBlur=”self.focus();”>

For getting value from crm’s form to iframe page

var AccountName = parent.document.forms[0].all.name.DataValue;
alert(‘Order Name=’+AccountName);

For getting values from Iframe’s page

// test is the name of the iframe
// textbox1,image1 are the control inside the page within iframe

var to=window.frames[‘test’].document.getElementById(‘TextBox1’).value;
var to1=window.frames[‘test’].document.getElementById(‘Image1’).src;
For changing Button value using javascript

script type=”text/javascript”>

function SetReadOnly()
{

var x=document.getElementsByTagName(“input”);
for (var i=0;i<x.length;i++)
{
if (x.item(i).type==”button”&&x.item(i).value==”OK”)
{
x.item(i).value=”Save”
};
}
}
_spBodyOnLoadFunctionNames.push(“SetReadOnly()”);

</script>
For writing log in a text file

TextWriter log = TextWriter.Synchronized(File.AppendText(@”C:\g.txt”));
log.WriteLine(“MyMessage”);
log.Close();

For converting mm/dd/yyyy format to dd/mm/yyyy

public string ConvertTOSqlServerFormat(string DateToConvert)
{
int day, month, year;
String[] myDelim = DateToConvert.Split(new Char[] { ‘/’ });

day = Convert.ToInt32(myDelim[0]);
month = Convert.ToInt32(myDelim[1]);
year = Convert.ToInt32(myDelim[2]);

string myConvertedDate = new DateTime(year, month, day).ToShortDateString();
return myConvertedDate;
}

For giving double quotes

string myInfo=”Hello”;
string myMsg = @”This is my message”””+myInfo+ @”””to you”;
MessageBox.Show(myMsg);

–> This is my message “Hello” to you

For finding the days difference in javascript and setting a particular date 28 days before

<!–[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <![endif]–><!–[if gte mso 9]> <![endif]–> <!–[endif]–>

function GetDiff(form1)

{

date1 = new Date(form1.firstdate.value);

date2 = new Date(form1.seconddate.value);

diff = new Date();

//date.getTime() –>Returns the number of milliseconds since midnight Jan 1, 1970

//Math.abs() –>Returns the absolute value of a number

//Math.floor –>Returns the value of a number rounded downwards to the nearest integer

diff=diff.setTime(Math.abs(date1.getTime() – date2.getTime()));

days = Math.floor(diff / (1000 * 60 * 60 * 24));

// if days greater than 28

// than set the first date 28 days less than the second date

if(days>28)

{

alert(‘Greater than 28 ‘);

// setting the second date 28 days less

date2.setDate(date2.getDate()-28);

// converting to string to find the length and if 1 than adding a 0

// i.e 1 to 01

var month=((date2.getMonth())+1).toString();

if(month.length==1)

{

month=“0”+month;

}

var date=date2.getDate().toString();

if(date.length==1)

{

date=“0”+date;

}

form1.firstdate.value=month+“/”+date+“/”+date2.getYear();

}

}


30 thoughts on “Code snippets”

  1. Hi folks,
    I am new to Dynamics CRM, I want to integrate CRM such that when even some operations/changes performed on Accounts and Leads, I need to post them to a HTTP endpoint.
    please help me.

    Like

  2. I’m curious to find out what blog platform you are utilizing?
    I’m experiencing some small security issues with my latest website and I would like to find something more risk-free.
    Do you have any solutions?

    Like

  3. Heya just wanted to give you a quick heads up and let
    you know a few of the pictures aren’t loading correctly. I’m not sure
    why but I think its a linking issue. I’ve tried it in two different browsers
    and both show the same results.

    Like

  4. Wow, marvelous blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your website is wonderful, as well as the content!. Thanks For Your article about Code snippets | Nishant Rana& .

    Like

  5. Wow, fantastic blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, let alone the content!. Thanks For Your article about Code snippets | Nishant Rana& .

    Like

  6. Wow, awesome blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is magnificent, as well as the content!. Thanks For Your article about Code snippets | Nishant Rana& .

    Like

  7. Wow, amazing blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is fantastic, let alone the content!. Thanks For Your article about Code snippets | Nishant Rana& .

    Like

  8. you are in reality a good webmaster. The site loading velocity is amazing.
    It kind of feels that you’re doing any unique trick. In addition, The contents are masterpiece. you have done a great process on this matter!

    Like

  9. Thanks for another informative web site. Where else could I get that type of info written in such an ideal way? I’ve a project that I’m just now working on, and I have been on the look out for such information.

    Like

  10. I have created a webservice to Add a contact, account etc.. So my client application will be to create a contact thro webservice.

    Right now, my client application database has tables for contact and account, but the primary key is of int data type. If i import all the contacts from the existing database to crm, all the contactid will be in GUID type.

    how will I identify which contact id(int) is for which guid?..

    how will I retrieve a imported contact from crm if I pass the contactid (int) to the webservice? ..

    should I create a custom attribute in crm as an identifier?

    Your help is greatly appreciated!

    Thanks
    karthik

    Like

  11. I have created a webservice to Add a contact, account etc.. So my client application will be to create a contact thro webservice.

    Right now, my client application database has tables for contact and account, but the primary key is of int data type. If i import all the contacts from the existing database to crm, all the contactid will be in GUID type.

    how will I identify which contact id(int) is for which guid?..

    how will I retrieve a imported contact from crm if I pass the contactid (int) to the webservice? ..

    should I create a custom attribute in crm as an identifier?

    Your help is greatly appreciated!

    Like

  12. Hi Nishanth ,
    I am working on the MS CRM webservice on java . i couldn’t find much examples in the Java .can you please help on this . I am trying to store the value into the Salesorder entity . but i am getting exception. And Same thing is hpning while retrieving the data with query condition.
    . Please help me .

    org.apache.axis2.AxisFault:
    com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character ‘S’
    (code 83) in prolog; expected ‘<'
    at [row,col {unknown-source}]: [1,1]
    at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
    at
    org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:118)
    at
    org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:67)
    at
    org.apache.axis2.description.OutInAxisOperationClient.handleResponse(OutInAxisOperation.java:354)

    Like

  13. hi nishanth im trying to invoke a Siebel web service from .net(im using c#).im querying contacts.but im getting null response..can you please tell me how to do it properly..thanks in advance

    Like

  14. Hey Nishat, are you up for a SharePoint development project? reply a follow up comment here to let me know. This is for a company in California. Thanks.

    Like

  15. Hi Nishat,

    I need to call a custom webservice and pass a value on some event through javasript in CRM entity page.
    Can you please help me in this regard, giving some sample code?

    Like

  16. Hi Nishant,

    I am trying to update attributes of entities programmatically for CRM 4.0 using metadatawebservice. can you please help me with snippet on how to do it.

    Like

    1. Hi,

      Nishant I am facing some problem while calling webservice from client machine. Below code is working fine on local machine(window 2003 server). When i call application from user machine (window XP) than permission denied error raise. Please help. Thanx in advance.

      function XmlhttpCall(objXML,serviceName)
      {
      try
      {
      var xmlHttp = new ActiveXObject(“Microsoft.XMLHTTP”);
      var xmlHttpGo = xmlHttp;

      var str = “http://192.168.0.1/MyWebService/HelloWebService.asmx” + serviceName;
      //Service name is webmethod define in Webservice
      //192.168.0.1 is ip address of my server (Window 2003 Server)
      xmlHttpGo.open(“POST”, str, false);
      xmlHttpGo.SetRequestHeader(“Content-type”,”application/x-www-form-urlencoded”);
      xmlHttpGo.send(‘xmlLogin=’ + objXML.xml);

      var xmlString1 = xmlHttpGo.responseXML.text;

      return xmlString1;
      }
      catch(e)
      {
      return (e.Message + “–> XmlhttpCall”);
      }
      }

      Like

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s