Tuesday, September 22, 2015

asp.net fire button click in javascript function pass parameters

1) Javascript function

 function SetDocumentEditorSrc(WrkID) {
                __doPostBack('<%= btnSetRadEditorContent.UniqueID %>', WrkID);
            }

2)  Button Click Event

        protected void btnSetRadEditorContent_Click(object sender, EventArgs e)
        {
            String fileId = Request["__EVENTARGUMENT"]; // parameter
            if (!String.IsNullOrEmpty(fileId))
            {
                String convertedContent = "";

                RxOffice.BLL.Document document = new RxOffice.BLL.Document();
                document.SetRadEditorContent(Convert.ToInt32(fileId));
                if (!String.IsNullOrEmpty(convertedContent))
                {
                    RadEditor1.Content = convertedContent;
                }
            }

            //string filePath = Server.MapPath("~/SampleInitialContent.docx");
            //byte[] fileBinaryData = File.ReadAllBytes(filePath);
            //string convertedContent = Functions.ConvertDocxToHtml(fileBinaryData);

        }

asp.net update panel

1) Update Panel

<asp:UpdatePanel runat="server">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="btnSetRadEditorContent" EventName="Click" />
</Triggers>
<ContentTemplate>
<div style="float: left; width: 59%; margin-left: 10px; border: 1px solid #e2e6eb;">
<%--<iframe id="ifrmWrkDocViewer" src="#" style="height: 430px !important; width: 100%; margin-left: 5px;"></iframe>--%>
<telerik:RadEditor ID="RadEditor1" runat="server" ContentFilters="DefaultFilters, PdfExportFilter">
<ExportSettings FileName="RadEditorExport" OpenInNewWindow="true"></ExportSettings>
</telerik:RadEditor>
<asp:Button ID="btnSetRadEditorContent" runat="server" OnClick="btnSetRadEditorContent_Click" Style="display: none;" />
</div>
</ContentTemplate>
</asp:UpdatePanel>


2) Button click

protected void btnSetRadEditorContent_Click(object sender, EventArgs e)
{
string filePath = Server.MapPath("~/SampleInitialContent.docx");
byte[] fileBinaryData = File.ReadAllBytes(filePath);
string convertedContent = Functions.ConvertDocxToHtml(fileBinaryData);

RadEditor1.Content = convertedContent;
}


3) Javascript Function

 function SetDocumentEditorSrc(WrkID) {
                __doPostBack('<%= btnSetRadEditorContent.UniqueID %>');
            }


asp.net fire button click in javascript function

<asp:Button ID="btnSetRadEditorContent" runat="server" OnClick="btnSetRadEditorContent_Click" Style="display: none;" />


 function SetDocumentEditorSrc(WrkID) {
                __doPostBack('<%= btnSetRadEditorContent.UniqueID %>');
            }


  protected void btnSetRadEditorContent_Click(object sender, EventArgs e)
        {
            string filePath = Server.MapPath("~/SampleInitialContent.docx");
            byte[] fileBinaryData = File.ReadAllBytes(filePath);
            string convertedContent = Functions.ConvertDocxToHtml(fileBinaryData);

            RadEditor1.Content = convertedContent;
        }

Thursday, September 10, 2015

sql conditional insert,update,delete with merge command



declare @target table
(
id int,
lead_id int
)
insert into @target(id,lead_id) values(1,521),(2,521),(1,13),(2,13)
--select * from @target

declare @source table
(
id int,
lead_id int
)

insert into @source(id,lead_id) values(2,521),(3,521),(4,521)
--select * from @source

merge into @target as ttable
using @source as stable
on stable.lead_id = ttable.lead_id and stable.id = ttable.id
when NOT MATCHED then
INSERT (id,lead_id)
VALUES(stable.id,stable.lead_id)
WHEN NOT MATCHED BY SOURCE
AND ttable.lead_id IN(521) THEN
        DELETE;

select * from @target

Tuesday, September 1, 2015

telerik kendo grid refresh after create,update,delete event

 var dataSourceBudgetStatus = new kendo.data.DataSource({
            transport: {
                read: {
                    url: APIbaseUrl + "/Workflow/GetBudgetStatus",
                    dataType: "json",
                    type: "POST",
                    data: budgetStatusInfo
                },
                update: {
                    url: APIbaseUrl + "/Workflow/AddUpdateBudgetStatus",
                    dataType: "json",
                    type: "POST",
                    data: budgetStatusInfo
                },
                destroy: {
                    url: APIbaseUrl + "/Workflow/GetBudgetStatus",
                    dataType: "json",
                    type: "POST",
                    data: budgetStatusInfo
                },
                create: {
                    url: APIbaseUrl + "/Workflow/AddUpdateBudgetStatus",
                    dataType: "json",
                    type: "POST",
                    data: budgetStatusInfo,
                },
                parameterMap: function (options, operation) {

                    if (operation !== "read" && options.models[0]) {
                        options.models[0].ExpenseWorkflowId = 4;//parseInt($('input[id$=hdnExpenseId]').val());
                        return options.models[0];
                    }
                    else if (operation == "read" && options.models) {
                        return options.models;
                    }

                }
            },
            requestEnd: function (e) {
                var type = e.type;
                if (type != "read") {
                    $('#budgetstatusgrid').data('kendoGrid').dataSource.read();
                }
            },
            batch: true,
            pageSize: 5,
            schema: {
                model: {
                    id: "BudgetStatusId",
                    fields: {
                        BudgetStatusId: { editable: false, nullable: true },
                        ExpenseWorkflowId: { editable: false, nullable: true },
                        ExpenseHead: { validation: { required: true } },
                        TotalBudget: { validation: { required: true } },
                        TotalExpenseIncurredTillDate: { validation: { required: true } },
                        CurrentExpenses: { validation: { required: true } },
                        RemainingBudget: { validation: { required: true } }
                    }
                }
            }
        });