call C# dll using Javascript ActiveX Object

call C# dll using Javascript ActiveX Object

I got a chance to work with siebel crm . The Version they were using is working with ActiveX Object. My objective is we had a dll which has been created in .net class library output.I need to call that library using javascript and do some functionality. Here i'm sharing how i communicate dll with ActiveX using javascript.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

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 :)

Passing store procedure result to another store procedure as parameter

Passing store procedure result to another store procedure as parameter

-- First Stored ProcedureCREATE PROCEDURE SquareSP@MyFirstParam INT
AS
DECLARE @MyFirstParamSquare INT
SELECT @MyFirstParamSquare = @MyFirstParam*@MyFirstParam-- Additional CodeRETURN (@MyFirstParamSquare)GO

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  :)