BBBlog

How to easily create dependent Picklist(Option Set) in CRM 2011 ?

2011-09-15T01:02:00.001-07:00

http://blogs.msdn.com/b/paf/archive/2011/04/21/how-to-easily-create-dependent-picklist-in-crm-2011.aspx

Execute CRM workflow from C#

2011-09-15T01:00:00.001-07:00

ExecuteWorkflowRequest request = new ExecuteWorkflowRequest();

request.WorkflowId = WorkflowId;
request.EntityId = contact_guid
ExecuteWorkflowResponse response = (ExecuteWorkflowResponse)Service.Execute(request);

Create word document and populate fields using mail merge in C#

2011-09-15T00:59:00.000-07:00

Object oMissing = System.Reflection.Missing.Value;

Object oTrue = true;

Object oFalse = false;
Word.Application oWord = new Word.Application();
Word.Document oWordDoc = new Word.Document();
oWord.Visible = true;
Object oTemplatePath = System.Windows.Forms.Application.StartupPath+"\\Report.dot";
oWordDoc = oWord.Documents.Add(ref oTemplatePath, ref oMissing, ref oMissing, ref oMissing);
foreach (Word.Field myMergeField in oWordDoc.Fields)
{

iTotalFields++;

Word.Range rngFieldCode = myMergeField.Code;

String fieldText = rngFieldCode.Text;

if (fieldText.StartsWith(" MERGEFIELD"))

{

Int32 endMerge = fieldText.IndexOf("\\");

Int32 fieldNameLength = fieldText.Length - endMerge;

String fieldName = fieldText.Substring(11, endMerge - 11);

fieldName = fieldName.Trim();

if (fieldName == "Name")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_name.Text);

}

if (fieldName == "Address")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_address.Text);

}

if (fieldName == "Age")

{

myMergeField.Select();

oWord.Selection.TypeText(num_age.Text);

}

if (fieldName == "EAddress")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_email.Text);

}

if (fieldName == "Company")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_company.Text);

}

if (fieldName == "TelNo")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_tel.Text);

}

if (fieldName == "ODetails")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_odetails.Text);

}

Paper quilling basics

2011-09-15T00:56:00.001-07:00

Paper quilling instructions - Rolling your first coil

So take your piece of paper and gently put the end into the slot in the tool. Make sure that only the tiniest bit of paper protrudes through to the other side of the slot.

Then, holding the tool in your dominant hand and the paper between your other thumb and index finger, slowly turn the quilling tool so that the paper winds evenly around the tip.

Try to keep the edges of the paper lined up. Keep some tension on the paper as you are turning the tool, but don't tug too hard or you may tear it!

When your quarter length strip is all wound around the tool hold it in place for a moment so that the paper can "remember" its position. Then let go and turn the tool upside down, allowing the quilled coil to fall off onto the table. The paper will begin to uncoil a little, don't panic, it is supposed to do that. Leave it to "relax" a little and then when it stops uncoiling use a toothpick with a tiny dot of tacky glue on the end to stick the end of the paper in place. Hold the paper together for a moment or two until the glue dries.

As we are practicing, pick another color of paper and make another coil. Make perhaps a dozen before we move onto the next stage.

Paper quilling instructions - Shaping your coils

Sometimes you will want to leave your coils as circles, but often you will squeeze and manipulate them into different shapes to build up your picture. We will start with the easiest shape.

The teardrop
Pick up your coil and with the thumb and index finger pinch it together forming a shape with a point at one end and leaving the other end rounded. This is a useful shape for flower petals.

The petal
Taking your teardrop shape, gently press your pointed end to one side to curve it over.

The marquise or eye shape
Take another coil and this time hold it between the thumb and index fingers of both hands. Pinch tightly with both hands to form points at each end. The marquise is one of the most useful shapes in quilling.

The leaf
Make another marquise but this time after pinching the ends move them in opposite directions creating a twist in the shape.

The half moon or crescent
You will need your quilling tool again for this shape. Take one of your coils and push the handle of the tool into the circle, squeezing the two ends to form points.

The triangle
A slightly tricky one this time. Holding the circle between your index fingers of each hand, push the bottom of the circle up with your thumbs to create a triangle. Pinch the three corners to sharpen them up.

The tulip
Start by making the teardrop shape but before letting go of the pinched end push it back into the main part of the circle to form an indentation. Sharpen up the two outside points if required but they can be left rounded.

Bunny ear or shield
Similar in appearance to the crescent, this shape is made without using the quilling tool as a former. Holding the coil in one hand use the index finger on the other hand to push an indentation into the circle. Then pinch the two resulting points to sharpen up the shape and make the ears.

The arrow
First make a teardrop by pinching one end. Then, holding the pinched end, use your finger to push the other end towards your other hand forming an indentation. Pinch the points to sharpen up the shape.

The star
Make a marquise as before, then turn the shape 90 degrees and repeat, pinching two more points to make a star. Press hard at each point to sharpen up the shape.

The square
This one needs both thumbs and both index fingers! Hold the circle between all four digits and gently press into a square shape. Squeeze each corner to transform your circle into a square.

The holly leaf
A pair of pointed craft tweezers are useful when making this shape which is, of course, great for quilled Christmas cards.

Squeeze your circle together in the center using your tweezers. Using your fingers pinch one end and push it towards the center, repeat at other end to form a holly leaf shape.

Paper quilling instructions - Making a tight coil and variations

We missed out the first illustration in the photo above. The tight coil is the easiest of all to make. Wrap the paper around the quilling needle as before but before taking it off the tool glue the end in place. Hold it for a few seconds to allow the glue to dry before gently releasing it from the tool.

Fringed flowers
Using the same technique as above for the tight coil but with wider paper we can make a fringed flower or pompom. Start by cutting small snips into one edge of the paper at regular intervals all the way along its length. Then roll a tight coil and glue the unsnipped section. Gently spread the snipped section to produce a fluffy effect.

Fringed flowers with centers
To create a flower with a different colored center take a 3mm wide strip in yellow or a suitable color and glue a snipped wider length of paper in the flower colour of your choice to the end. Start rolling from the narrow end and continue rolling when you reach the snipped paper. Glue as before and then spread open the snipped flower leaving a nice tight center.

Paper quilling instructions - Open coil

Open coils or scrollwork can add a delicate touch to a quilled item. This time we do not glue the end of the paper strip once it is coiled.

Open circle
Easy one! Just coil as normal but after leaving it to relax do not glue the end.Open coils or scroll work can add a delicate touch to a quilled item. This time we do not glue the end of the paper strip once it is coiled.

Open circle
Easy one! Just coil as normal but after leaving it to relax do not glue the end.

Open heart
Take your length of quilling paper and fold it in half. Roll from one end in towards the fold line until a small section of paper is left preceding the fold. Do the same for the other end. Try to leave the same amount of free paper on each side of the heart so that it lines up nicely when finished.

Open V
Worked in the same manner as the heart above, but roll away from the fold line creating the coils on the outside so that the finished result looks like a letter V with outward facing curls on the open ends.

There are other open coils you can make, but this page is getting rather long so I'll leave them for a separate page.

Download file from the C#.net

2011-09-15T00:55:00.001-07:00

private void DownloadFile( string fname, bool forceDownload )
{
string path = MapPath( fname );
string name = Path.GetFileName( path );
string ext = Path.GetExtension( path );
string type = "";
// set known types based on file extension
if ( ext != null )
{
switch( ext.ToLower() )
{
case ".htm":
case ".html":
type = "text/HTML";
break;

case ".txt":
type = "text/plain";
break;

case ".doc":
case ".rtf":
type = "Application/msword";
break;
}
}
if ( forceDownload )
{
Response.AppendHeader( "content-disposition",
"attachment; filename=" + name );
}
if ( type != "" )
Response.ContentType = type;
Response.WriteFile( path );
Response.End();
}

CRM: update statecode and statuscode

2010-04-19T04:25:00.000-07:00

You can not update the state/status of an entity using service.update method.

Each entity, including new customized ones have a "setstate" request class.
for example, if you want to set the state of account:
----------------------------------------------------
CrmService service = new CrmService();
SetStateAccountRequest setacc = new SetStateAccountRequest();
setacc.EntityID = new Guid("");
setacc.AccountState = new AccountState();
setacc.AccountState = AccountState.Inactive;
service.Execute(setacc);
----------------------------------------------------

e-bday cake to gift to your nearer and dearer

2008-09-17T23:21:00.001-07:00

Hi all,
This is the link thru which you can show your skills to decorate cake and send it to your friends and family member.
http://www.theoworlds.com/birthday/
I hope you like this.
Thanks.

C# Alphanumeric sorting

2008-09-17T23:21:00.000-07:00

Hi all,
In my previous project the requirement is to sort alphanumeric order.
Normally its treated as String so in string "20" is less than "19" and that was an issue.
But then after a long searching i find the very good solution in the C# only and its very easy also.
C# has the interfaces that you can implement in your classes and then create custom methods for that.
This is the solution:
--------------------
1) Implement IComparer interface in your class and use its Compare() to generalize your code for the sorting.
2) if you want to see sample compare() method and here is the link:
http://dotnetperls.com/Content/Alphanumeric-Sorting.aspx
If you have any suggestion then you can post it.
Thanks.

2008-01-23T00:59:00.000-08:00

Hi this is first post on my own blog. I have just created blog for trial.