Grid will refesh on Add but not on Update

Question

Hi,I am doing an Add and Updates to the database, but the grid will only refresh on the Add event, not on the Update event. The grid is inside a dialog box. Have tried Grid Refresh, StateHasChanged and even remove the grid and showed it again. The data gets to the database. I have more than 30 similar forms, and all of them have the same problem.I tried to attach a file, but it won't let me, so here is my code:---------------------------------

Cancel

@if (showGrid) {

} @code { [Parameter] public EventCallback OnSubClose { get; set; } [Parameter] public bool bitRateShow { get; set; } = true; [Parameter] public string strUser { get; set; } = ""; [Parameter] public int intID { get; set; } = 0; //DATABSE VARIABLES private tbModifierRate[] tblData; private tbModifierRate[] tblEdit; private tbModifierRate mod = new tbModifierRate(); SfGrid gridObj; //CANCEL VARIABLES private int intEditID = 0; private bool blCancel = true; private string strAddUpdate = "Add"; bool showGrid { get; set; } = true; protected override void OnInitialized() { fnGetData(); fnInit(); } private void fnInit() { mod.ModifierRateEffDate = DateTime.Today; mod.ModifierRateStatus = true; mod.ModifierRatePercent = 0; mod.ModifierRateAmountMinimum = 0; blCancel = true; strAddUpdate = "Add"; showGrid = false; showGrid = true; StateHasChanged(); } protected async Task fnGetData() { tblData = await @Service.ModifierRatesGetAsync(intID); } private async Task fnOnAdd() { int intResult = 0; if (fnFieldCheck() == 1) { return; } switch (blCancel) { case true: //ADD intResult = await Service.ModifierRatesCheckAsync(intID, mod); if (intResult == 0) { await Service.ModifierRatesAddAsync(intID, mod, strUser); fnInit(); } else { //CODE } break; case false: //UPDATE intResult = await Service.ModifierRatesUpdateAsync(intEditID, mod); if (intResult == 0) { //CODE } else { fnInit(); } break; } await fnGetData(); } private int fnFieldCheck() { // VERIFICA QUE LOS CAMPOS NECESARIOS NO ESTEN EN BLANCO int intCheck = 0; return intCheck; } private void fnOnCancel() { fnInit(); } public async Task OnCommandClicked(CommandClickEventArgs args) { // Get the selected Help Desk Ticket if (args.CommandColumn.Type == CommandButtonType.Edit) { //Open teh Edit dialog intEditID = args.RowData.ModifierRateID; tblEdit = await @Service.ModifierRatesEditAsync(intEditID); mod.ModifierRateAmountMinimum = tblEdit[0].ModifierRateAmountMinimum; mod.ModifierRatePercent = tblEdit[0].ModifierRatePercent; mod.ModifierRateEffDate = tblEdit[0].ModifierRateEffDate; mod.ModifierRateStatus = tblEdit[0].ModifierRateStatus; blCancel = false; strAddUpdate = "Update"; } } private async Task fnOnSubClose() { bitRateShow = false; await OnSubClose.InvokeAsync(); }}----------------------------

Renjith Singh Rajendran · Answer

Hi Jorge, 

Greetings from Syncfusion support. 

We have analyzed the shared codes, and we could see that you have not used the Grid’s inbuilt editing feature. We could see that you have manually handled the updates in db, so we suspect that there might be some db related problems occurred when updating your db which might have caused failure. 

SO we need the following details to further proceed on this and provide you a suggestion as early as possible. Kindly get back to us with the following details to proceed further. 


Share the complete details of any exception occurred in browser console when updating a record.
Share the complete code definition of ModifierRatesUpdateAsync. We need to check how you are updating to db.
Bind OnActionFailure event to grid, and share the details you get in the args of this event handler.
Share with us a video showing the replication of the problem you are facing.
If possible share with us a simple issue reproducing sample for us to validate based on your scenario.

Regards, 
Renjith R

Jorge Tirado · Answer

Thanks for the reply, here is the info asked:

There is no exception
Code for ModifierRatesUpdateAsync:

public async Task<int> ModifierRatesUpdateAsync(int intID, tbModifierRate mod)

{

string sqlstr = "";

int intOut = 0;

SqlParameter param1 = new SqlParameter("@intTask", 4);

SqlParameter param2 = new SqlParameter("@intID", intID);

SqlParameter param3 = new SqlParameter("@dtEffDate", mod.ModifierRateEffDate);

SqlParameter param4 = new SqlParameter("@numPercent", mod.ModifierRatePercent);

SqlParameter param5 = new SqlParameter("@numAmount", mod.ModifierRateAmountMinimum);

SqlParameter param6 = new SqlParameter("@bitStatus", mod.ModifierRateStatus);

SqlParameter paramOut = new SqlParameter("@intOut", intOut);

paramOut.Direction = System.Data.ParameterDirection.Output;

sqlstr = "EXECUTE @intOut = [spModifiersRatesTasks] @intTask, @intID, @dtEffDate, @numPercent, @numAmount, @bitStatus";

await _context.Database.ExecuteSqlRawAsync(sqlstr, param1, param2, param3, param4, param5, param6, paramOut);

intOut = Convert.ToInt32(Convert.ToString(paramOut.Value));

return intOut;

}

3. Used the OnActionFailure, but did not produce any detail since it never entered the function.

4. The video is attached.

5. WIll work on the code.

Attachment: Update_Video_b3d94297.zip

Jorge Tirado · Answer

As you can see on the previously attached video, the update on the database works fine, but it will only show when the whole page is refreshed. Running SQL Server 2019 Std Edition.Jorge

Renjith Singh Rajendran · Answer

Hi Jorge, 

We have analyzed your shared codes and video. We tried reproducing the reported scenario, by creating a sample based on your scenario and shared codes and updating Grid data. But we could not reproduce this reported behavior with the sample created from our side. We are attaching the sample which we have tried for your reference, 

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/EFGrid-33827997 
Note : A local MDF file is used in the above sample to assign and process the data. So before running the sample, please make sure the connection for this file is established and the correct connection string(local path of the MDF file in your machine) is provided in OrderContext.cs file in the application. 
 
We are suspecting that, after clicking Update button, fnGetData method is not properly fetching the updated data from your db. And as not updated data is available in tblData inside fnGetData method is causing the reported behavior from your side. 

So we suggest you to check this scenario based on the above case from your side. And if you are still facing difficulties kindly get back to us with a simple reproducing sample or if possible reproduce the behavior with the above attached sample and share with us for further analysis. 

Regards, 
Renjith R

Jorge Tirado · Answer

Just to let you know that the problem fixed with the latest update,Thanks.

Renjith Singh Rajendran · Answer

Hi Jorge, 
 
Thanks for your update. Please get back to us if you need further assistance. 
 
Regards, 
Renjith R