Retrieve data from sugarcrm using c# api with conditional query

Retrieve data from sugarcrm using c# api with conditional query


Before going through this module i strongly recommend to go through my previous post abt this topic as i'm writing as a continuation its difficult to get in track for new readers. Previous Post

create an instance of the dll

  SugarCRMCL.SugarSOAP.sugarsoap client = new SugarCRMCL.SugarSOAP.sugarsoap();

To reterive data

NB: While using query keep in mind that its key sensitive 

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Login Using Sugar API in asp.net c#

Hi *.*,

Before going through this module i strongly recommend to go through my previous post abt this topic as i'm writing as a continuation its difficult to get in track for new readers. Previous Post

Create an instance of the dll we refereed.

  SugarCRMCL.SugarSOAP.sugarsoap client = new SugarCRMCL.SugarSOAP.sugarsoap();

Login Module

Your password should be encrypted before sending to the crm. Sample encryption method below

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

sugar crm api using c# (Consuming soap service)

Hi *.*,
From last one month i was on air.fully after sugar crm api.my job was to create UI on .NET by consuming there api.As i get into the api i realized there no working sample or anything they providing for .net.Using custom class output for service some really stupid stuff.Now i remember a comment abt this crm in sourceforge.net

 very little support & stability has been present in the open source version - very disappointing

Its really unfortunate!!!!! but my client need that. :( Anyway i completed the project with lot of effort and pain. Even in my first project i didn't have this much mental load.Here i'm posting some of the basic steps.

Create a class library project [sample name i used sugarCRMCL]. build the solution first.
Right click on project file and click on add service reference >> Click on advanced

>> add web reference  

Add the service url at the text-box and hit enter key 

Click on add reference. Build your solution once and get the dll file from bin >>debug folder.

Now create new asp.net project environment. add that dll as reference to the bin folder.

On next day lets go with Login module  :)

Print Google Maps

Print Google Maps 


To print google maps you have to use the Google Static Maps API if you want printer friendly maps.

It should be pretty easy to build the Static Maps API URL request string from the LatLng or your markers. One caveat is that the URL is limited to 2048 characters including any character escapes, this will limit how many markers you can have on the map at one time.

In the Javascript API, markers have the class 'gmnoprint', which disables them from showing up on the printed rendering. You can iterate through the markers and remove this class, which should allow them to be printed on the page. As far as I know, this will not work for the direction lines.

Google Maps JavaScript API v3 Example: Drawing Tools Library :: Sample

Google Maps JavaScript API v3 Example: Drawing Tools Library :: Sample

Modified info window in google maps :)

 Modified info window in Google maps :)

Find the center of map depending on markers position in google maps

find the center of map depending on markers position in Google maps