Grid not showing added line item when View is in a MVC Area.

[Mahindra Morar]

Hi,

Adding a new item line to a Grid control works okay when the view is in root folder structure of a MVC project. However if I use the Grid control inside a view that is in an Area it does not show the newly inserted row unless I refresh the whole page.

Any help in resolving this issue would be greatly appreciated.

[Farveen Sulthana Thameeztheen Basha]

Hi Mahindra,  

Thanks for contacting Syncfusion Support. 

We have checked your query and prepared sample according to your requirement with CRUD operations. Please refer to the Sample Link:- 

http://www.syncfusion.com/downloads/support/directtrac/193119/SAMPLE~4143970389.ZIP 

We need some additional information to find the cause of the issue. Please share us the following details. 

1. Share us the Grid code example (both in server and client side). 

2.If possible provide an issue reproducing sample or hosted link or reproduce the issue in the above sample and revert us back. 

3. Exact scenario you have faced the issue. 

4.  Screenshot/Video demo to replicate the issue. 

The provided details will helps us to analyze and provide you solution as early as possible.    

 

Regards,  

 

Farveen sulthana T  

[Mahindra Morar]

Hi Farveen,

I have attached the source code for a sample project I am working on with the issue of the data grid not updating when placed in a View which is inside a MVC Area.

The issue can be replicated by compiling the application and clicking on the Pricing menu and Price Types. Updating and deleting lines work without any issues, its only when adding a new item it does not appear in the grid unless I refresh the web page or click on the column header to reorder.

Thanks for your help.

Attachment: Webcore.Usertronics.ECommerceManagement_8219ab56.zip

[Farveen Sulthana Thameeztheen Basha]

Hi Mahindra, 

We suspect that your reported problem will occur when we doesn’t return the proper value of the added record on the database. While deleting and updating the record, you have updated the values in the database. So we suggest you to return the value.Value in the JSON result. 

Please refer to the code example:- 

public ActionResult NormalInsert([FromBody]CRUDModel<Order> value) 

        { 

            if (value.Value.OrderID > 10000) 

                throw new Exception("OrderID must be above 1000"); 

            orddata.Insert(orddata.Count, value.Value); 

            return Json(value.Value); 

        } 

After following the above solution, still facing the problem please get back to us with further details. 

Regards, 

Farveen sulthana T 

[Mahindra Morar]

Hi Faveen,

I have tried what you have suggested and still can't see the inserted row after saving unless I either sort by one of the grid columns or refresh the page.

Below is the code for the Crud actions.

        public async Task<ActionResult> Crud([FromBody]CRUDModel<mdPriceType> value, string action)

        {

            var crudMsg = new mdCrudMessage();

            if (value.Action == Constants.CrudOperations.LIT_INSERT)

            {

                var response = await PostWSObjectAsync<mdPriceType, mdPriceTypeResponse>(value.Value, URI_RESOURCE);

                crudMsg = MessageFormatter.FormatCrudResultsHtml(response.CrudResults);               

            }

            if (value.Action == Constants.CrudOperations.LIT_UPDATE)

            {

                var url = string.Format("{0}/{1}/{2}", URI_RESOURCE, value.Key, value.Value.Lockstamp);

                var response = await PutWSObjectAsync<mdPriceType,mdPriceTypeResponse>(value.Value, url);

                crudMsg = MessageFormatter.FormatCrudResultsHtml(response.CrudResults);

            }

            if (value.Action == Constants.CrudOperations.LIT_DELETE)

            {

                string lockstamp = Request.Headers["x-lockstamp"];

                var response = await DeleteWSObjectAsync(Convert.ToInt32(value.Key), lockstamp, URI_RESOURCE);

                if (response != HttpStatusCode.OK)

                {

                    crudMsg.IsFault = true;

                    crudMsg.HtmMessage = Constants.LIT_ERROR_HTML_MSG;

                }

            }

      

            if (crudMsg.IsFault)

                return new BadRequestObjectResult(crudMsg.HtmMessage);

            return  Json(value.Value);

        }

Do you have any other suggestions?

Mahindra

[Manivannan Padmanaban]

Hi Mahindra,  

 

 

Sorry for the inconvenience caused. 

 

 

We can reproduce the issue at our end and we suspected that <field="PriceTypeId”> value is null while saving the newly added row and if you are using the CRUD operation in server side then you need to return the value for the field which you have mentioned as <is-identity="true">. 

 

 

Please refer to the code example: -  

 

 

 

public async Task<ActionResult> Crud([FromBody]CRUDModel<mdPriceType> value, string action) 

        { 

            var crudMsg = new mdCrudMessage(); 

 

            if (value.Action == Constants.CrudOperations.LIT_INSERT) 

            { 

              ... 

                 

 

            crudMsg = MessageFormatter.FormatCrudResultsHtml(response.CrudResults); 

             

            return Json(response); 

         

    } 

} 

 

 

We have done the same in the sample also, which you have updated earlier that can be downloadable from the below location. 

 

http://www.syncfusion.com/downloads/support/forum/134717/ze/Webcore.Usertronics.ECommerceManagement_8219ab56-1582850673  

  

Please let us know if you need further assistance 

 

 

Regards,  

 

 

Manivannan Padmanaban 

[Mahindra Morar]

Thanks for all your help. Works a treat now.

[Farveen Sulthana Thameeztheen Basha]

Hi Mahindra, 

Thanks for your update. We are glad to know that your reported problem has been resolved. Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T