Update TotalPrice value in edit dialog based on other field's value

[Andrias Abadi]

Hi, I'm using the mvc grid to create invoice tables but I need the edit dialog to show the total price by multiplying the qty and unitprice when the value changes.

I can get the totalprice value displayed just fine using jsrender template after confirming insert dialog but not while in the dialog. I read some posts saying about LiveUpdate but I cant seem to find this one

Attachment: Syncfusion_Help_78ed95c9.rar

[Venkatesh Ayothi Raman]

Hi Andrias, 

Thanks for contacting Syncfusion support. 

We have achieved your requirement using Dialog template editing. In that, we have rendered the dialog template edit form with expression column (total field) value while we change the data quantity and price Numeric text box then we must change the expression column value like as follows, 

Code example: 

@Grid 

 

@(Html.EJ().Grid<object>("DetailTemplate") 

        . . . 

    .EditSettings(edit => { edit.AllowAdding().AllowDeleting().AllowEditing().EditMode(EditMode.DialogTemplate).DialogEditorTemplateID("#template"); }) 

            .Columns(col => 

            { 

                col.Field("SNO").HeaderText("SNO").IsPrimaryKey(true).TextAlign(TextAlign.Right).Width(90).Add(); 

                col.Field("quantity").HeaderText("quantity").Width(90).Add(); 

                col.Field("Price").HeaderText("Price").TextAlign(TextAlign.Right).Width(75).Add(); 

                col.HeaderText("total").Template("{{:quantity * Price}}").Width(85).Add();        

            }) 

 

                .ClientSideEvents(e => e.ActionComplete("actionComplete")) 

             

    ) 

 

@action complete 

  function actionComplete(args) { 

                //here we can bound the Numeric textbox control for qunatity and price column as well as define the change event for both 

                if ((args.requestType == "beginedit" || args.requestType == "add") && args.model.editSettings.editMode == "dialogtemplate") { 

 

                    $("#quantity").ejNumericTextbox({ value: $("#quantity").val(), change: "quantityChange" }); 

                     

                    $("#Price").ejNumericTextbox({ value: $("#Price").val(), change: "PriceChange" }); 

                } 

            } 

 

@quanity change event 

            function quantityChange(args) { 

                var price = +($("#Price").val()); // get the current value from input field 

                var quantity = +(args.value); 

                var total = price * quantity; 

                $("#Total").val(total); 

            } 

@price change event 

            function PriceChange(args) { 

                 

                var price = +(args.value); // get the current value from input field 

                var quantity = +($("#quantity").val()); 

                var total = price * quantity; 

                $("#Total").val(total); 

            } 

             

Screenshot: 

 

We have also prepared a sample for your convenience which can be download from following link. Please refer to the sample and Help documentation for your reference, 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/ExpressionColumn-1527011111 

Help documentation: 

1)      https://help.syncfusion.com/aspnetmvc/grid/columns#expression-column 

2)      https://help.syncfusion.com/aspnetmvc/grid/editing#edit-modes 

Regards, 

Venkatesh Ayothiraman. 

[Andrias Abadi]

Thanks, that solves the problem!

[Venkatesh Ayothi Raman]

Hi Andrias, 

Thanks for the feedback. 

We are very happy to hear that your requirement is achieved. 

Regards, 

Venkatesh Ayothiraman.