Telerik Rad Editor Example With Mail Merge and Custom Dropdown

Telerik Rad Editor Example With Mail Merge

Custom radeditor dropdown  binding from code behind

Step 1 :- Rad Editor Design

<telerik:RadEditor runat="server" ID="RadEditorMailMerge" SkinID="DefaultSetOfTools"

EnableResize="true" Visible="false" ContentFilters="MakeUrlsAbsolute,FixEnclosingP"

EditModes="Design" Height="250px" Width="750px" ContentAreaMode="Iframe"

AutoResizeHeight="false" Font-Size="Smaller" OnClientCommandExecuting="OnClientCommandExecuting">

<ExportSettings OpenInNewWindow="true">

  </ExportSettings>

     <Tools>

        <telerik:EditorToolGroup>

            <telerik:EditorTool Name="Bold" />

            <telerik:EditorTool Name="Italic" />

            <telerik:EditorTool Name="Underline" />

            <telerik:EditorTool Name="Cut" />

            <telerik:EditorTool Name="Copy" />

            <telerik:EditorTool Name="Paste" />

            <telerik:EditorTool Name="FontName" />

            <telerik:EditorTool Name="FontSize" />

            <telerik:EditorTool Name="ForeColor" />

            <telerik:EditorTool Name="BackColor" />

            <telerik:EditorTool Name="JustifyLeft" />

            <telerik:EditorTool Name="JustifyFull" />

            <telerik:EditorTool Name="JustifyCenter" />

             <telerik:EditorTool Name="JustifyRight" />

           </telerik:EditorToolGroup>

         </Tools>

<ImageManager ViewPaths="~/InteractionImages,~/InteractionImages"

 UploadPaths="~/InteractionImages,~/InteractionImages"

DeletePaths="~/InteractionImages,~/InteractionImages"

EnableAsyncUpload="true"></ImageManager>

<TrackChangesSettings CanAcceptTrackChanges="False" />

</telerik:RadEditor>

Step 2:- For Step 2 Write the code for

OnClientCommandExecuting="OnClientCommandExecuting" this event

function OnClientCommandExecuting(editor, args) {

            debugger;

            ////alert('LOKESH');

            var name = args.get_name();

            var val = args.get_value();

            if (name == "General") {

                editor.pasteHtml(val);

                args.set_cancel(true);

            }

            else if (name == "Partner/Lead") {

                editor.pasteHtml(val);

                args.set_cancel(true);

            }

            else if (name == "Pledge") {

                editor.pasteHtml(val);

                args.set_cancel(true);

            } else if (name == "Payment") {

                editor.pasteHtml(val);

                args.set_cancel(true);

            }

            debugger;

        }

For above image to load the dropdowns use the below code

private void ConfigureMailMergeTools()

        {

            EditorToolGroup mailMergeTools = new EditorToolGroup();

            EditorDropDown addFieldToolGeneral = new EditorDropDown("General");

            addFieldToolGeneral.Text = "General";

            addFieldToolGeneral.ShowText = true;

            addFieldToolGeneral.ShowIcon = false;

            PopulateFieldsTool(addFieldToolGeneral, Constants.InteractionGeneral);

            mailMergeTools.Tools.Add(addFieldToolGeneral);

            EditorDropDown addFieldToolPartnerOrLead = new EditorDropDown("Partner/Lead");

            addFieldToolPartnerOrLead.Text = "Partner/Lead";

            addFieldToolPartnerOrLead.ShowText = true;

            addFieldToolPartnerOrLead.ShowIcon = false;

            PopulateFieldsTool(addFieldToolPartnerOrLead, Constants.InteractionLead);

            mailMergeTools.Tools.Add(addFieldToolPartnerOrLead);

            EditorDropDown addFieldToolPledge = new EditorDropDown("Pledge");

            addFieldToolPledge.Text = "Pledge";

            addFieldToolPledge.ShowText = true;

            addFieldToolPledge.ShowIcon = false;

            PopulateFieldsTool(addFieldToolPledge, Constants.InteractionPledge);

            mailMergeTools.Tools.Add(addFieldToolPledge);

            EditorDropDown addFieldToolPayment = new EditorDropDown("Payment");

            addFieldToolPayment.Text = "Payment";

            addFieldToolPayment.ShowText = true;

            addFieldToolPayment.ShowIcon = false;

            PopulateFieldsTool(addFieldToolPayment, Constants.InteractionPayment);

            mailMergeTools.Tools.Add(addFieldToolPayment);

            radtxtInteractionEmailMessage.Tools.Add(mailMergeTools);

            RadEditorMailMerge.Tools.Add(mailMergeTools);

        }

        private void PopulateFieldsTool(EditorDropDown addFieldTool, Dictionary<int, string> InteractionLead)

        {

            string start = "{";

            string end = "}";

            foreach (var Dataitem in InteractionLead)

            {

                EditorDropDownItem item = new EditorDropDownItem();

                item.Name = Dataitem.Value;

                item.Value = start + Dataitem.Value + end;

                addFieldTool.Items.Add(item);

            }

        }

public static Dictionary<int, string> InteractionGeneral = new Dictionary<int, string>()

        {

          {1,"Today's Date"},

          {2,"Signature Image"},

          {3,"Signature Name"},

          {4,"Signature Designation"},

        };

public static Dictionary<int, string> InteractionLead = new Dictionary<int, string>()

        {

          {1,"Partner ID"},{2,"Lead ID"},{3,"First Name"},{4,"Last Name"},{5,"Salutation"},             {6,"Mailing Address"},{8,"Address 1"},

          {9,"Address 2"},{10,"Address 3"},{11,"City"},{12,"State"},{13,"Postal Code"},                 {14,"Country"},{15,"Job Title"},{16,"Phone No"},

          {17,"Mobile"},{18,"Email"},{19,"PAN Number"},

        };

After this write your code for replacing the merge fields with your code .

Example {Today's Date} to -- {date}

Read More »

How to Kill all Active Connections to the SQL Server Database

How to Kill all Active Connections to the SQL Server Database

use master

DECLARE @dbname sysname

SET @dbname = 'Your DB Name'

DECLARE @spid int

SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname)

WHILE @spid IS NOT NULL

BEGIN

EXECUTE ('KILL ' + @spid)

SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid > @spid

END

Read More »

How to use the simple Dynamic pivot in SQL Server (Dynamic Columns)

How to use the simple Dynamic pivot in SQL Server (Dynamic Columns)

Declare @SampleTable as table (Sno int,Names nvarchar(50),Subjects nvarchar(50),

Marks int,Location nvarchar(50));

insert into @SampleTable VALUES(1,'Lokesh','Maths',95,'Hyderabad');

insert into @SampleTable VALUES(2,'Lokesh','Science',25,'Hyderabad');

insert into @SampleTable VALUES(3,'Krishna','Maths',59,'Chennai');

insert into @SampleTable VALUES(4,'Krishna','Science',56,'Chennai');

insert into @SampleTable VALUES(5,'Google','Maths',25,'UnNone');

insert into @SampleTable VALUES(6,'Google','Science',80,'UnNone');

DECLARE @cols AS NVARCHAR(MAX);

DECLARE @queryExecution AS NVARCHAR(MAX);

select @cols =SUBSTRING(( select distinct ',['+CONVERT(VARCHAR(50),convert(VARCHAR(19),Subjects,105))+']'

from @SampleTable for xml path('')),2,8000)

set @queryExecution='

Declare @SampleTable as table (Sno int,Names nvarchar(50),Subjects nvarchar(50),

Marks int,Location nvarchar(50));

insert into @SampleTable VALUES(1,''Lokesh'',''Maths'',95,''Hyderabad'');

insert into @SampleTable VALUES(2,''Lokesh'',''Science'',25,''Hyderabad'');

insert into @SampleTable VALUES(3,''Krishna'',''Maths'',59,''Chennai'');

insert into @SampleTable VALUES(4,''Krishna'',''Science'',56,''Chennai'');

insert into @SampleTable VALUES(5,''Google'',''Maths'',25,''UnNone'');

insert into @SampleTable VALUES(6,''Google'',''Science'',80,''UnNone'');

SELECT * FROM @SampleTable;

with CTE

as

(

      SELECT Names,Location,'+@cols+' from @SampleTable

      PIVOT

      (

            SUM(Marks) FOR Subjects IN ('+@cols+')  

      ) as pivottable

)

--This is PIVOT table result

SELECT Names,Location,SUM(Maths) Maths,SUM(Science)Science from CTE group by  Names,Location'

PRINT @queryExecution

execute(@queryExecution);

Read More »