Update grid record

[Pratheep]

Hi

It's possible When  add new record check that product code already exists or not in the grid..if exist that product code than update the records (example update Qty) ..if not exists than add new records.

Thanks
Pratheep

Attachment: WebApplication1_bf16754b.rar

[Venkatesh Ayothi Raman]

Hi Pratheep, 

Thanks for contacting Syncfusion support. 

We were analyzed your project that you have shared for us and we have achieved your requirement using EndAdd client side event in Grid. In this event, we can make sure the if the added product code is unique or same, if the product code is same then added function will be performing otherwise update action will perform in Grid.  

We have also modified your sample for your convenience. Please refer to the sample and cod example, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WebApplication1-1774889564 

Code example: 

@Grid 

<asp:UpdatePanel ID="UpdatePanel1" runat="server"> 

            <ContentTemplate> 

 

                <ej:Grid ID="ProductGrid" ClientIDMode="Static" runat="server" AllowPaging="True" AllowFiltering="false" OnServerEditRow="EditEvents_ServerEditRow" 

                    OnServerAddRow="EditEvents_ServerAddRow" OnServerDeleteRow="EditEvents_ServerDeleteRow"> 

                  

                    <ClientSideEvents ActionComplete="complete" EndAdd="endAdd" EndDelete="endDelete" EndEdit="endEdit" /> 

                    <Columns> 

                        . . . 

                    </Columns> 

                    <EditSettings AllowEditing="True" AllowAdding="True" AllowDeleting="True" EditMode="DialogTemplate" DialogEditorTemplateID="#protemplate"></EditSettings> 

                    <ToolbarSettings ShowToolbar="True" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings> 

                </ej:Grid>            

 

@EndADD event 

function endAdd(args) { 

            var len = this.model.dataSource.length; 

            for (var i = 0; i < len; i++) { 

                if (i != 0 && args.data.Productcode === this.model.dataSource[i].Productcode) { 

                    this.model.dataSource.splice(0, 1); 

                    this.model.dataSource[i-1].Productname = args.data.Productname; 

                    this.model.dataSource[i-1].qty = args.data.qty; 

                    this.refreshContent(); 

                    return false; 

                } 

            } 

            

        } 

Help document: https://help.syncfusion.com/api/js/ejgrid#events:endadd 

Regards, 

Venkatesh Ayothiraman. 

[Pratheep]

Hi Venkatesh Ayothiraman

Thank you for your replay.  already exists product code (10003)  qty is 3  in the grid . than  if i enter same product code (10003)  2  qty ... Can I update qty 5 in the grid

Thanks
Pratheep

[Venkatesh Ayothi Raman]

Hi Pratheep, 

Thanks for the update. 

Yes, we can update the quantity value for already existing product code by using same endAdd event in Grid. We have also modified your project. Please refer to the sample and code example for your convenience, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WebApplication1-1052051527 

Code example: 

function endAdd(args) { 

            var len = this.model.dataSource.length; 

            for (var i = 0; i < len; i++) { 

                if (i != 0 && args.data.Productcode === this.model.dataSource[i].Productcode) { 

                    this.model.dataSource.splice(0, 1); 

                    this.model.dataSource[i - 1].Productname = args.data.Productname; 

                    this.model.dataSource[i - 1].qty = this.model.dataSource[i - 1].qty+args.data.qty; //here we can add the new qty value with existing one. 

                    this.refreshContent(); 

                    return false; 

                } 

            } 

 

        } 

Regards, 

Venkatesh Ayothiraman. 

[Pratheep]

Hi Venkatesh Ayothiraman.

Thank for your replay.working fine

Thanks
Pratheep

[Venkatesh Ayothi Raman]

Hi Pratheep, 

Thanks for the feedback. 

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

Regards, 

Venkatesh Ayothiraman.