Batch editing in EJ 1 ASP.NET Core Grid
7 Replies
Hi Petra,
Thanks for contacting Syncfusion Support.
Query#:- But, at your suggestion, I've even tried to pass data in ViewBag, so my view looked like: but that doesn't work - action BatchUpdate is never called.
So my question is - how to save changes to database when "update" is clicked?
We have checked your query by preparing sample(using ViewBag dataSource) with batchMode and update the records into the database at server end using batch-url property of e-datamanager.
Refer to the code below:-
|
GridFeatures.cshtml
<ej-grid id="FlatGrid" allow-paging="true">
<e-datamanager json="(IEnumerable<object>)ViewBag.datasource" batch-url="/Grid/BatchUpdate" adaptor="remoteSaveAdaptor" />
<e-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true" edit-mode="@(EditMode.Batch)"></e-edit-settings>
<e-toolbar-settings show-toolbar="true" toolbar-items="@(new List<string>() {"add","edit","delete","update","cancel" })"></e-toolbar-settings>
<e-columns>
<e-column field="OrderID" header-text="Order ID" is-primary-key="true" validation-rules='new Dictionary<string, object>() { {"required",true}, {"number",true} }' text-align="Right" width="75"></e-column>
. . .
</e-columns>
</ej-grid>
GridController:-
public ActionResult BatchUpdate([FromBody] submitvalue myObject)
{
if (myObject.Changed != null && myObject.Changed.Count > 0)
{
foreach (var temp in myObject.Changed)
{
var ord = temp;
Order val = orddata.Where(or => or.OrderID == ord.OrderID).FirstOrDefault();
val.OrderID = ord.OrderID;
val.EmployeeID = ord.EmployeeID;
val.CustomerID = ord.CustomerID;
val.Freight = ord.Freight;
val.OrderDate = ord.OrderDate;
val.ShipCity = ord.ShipCity;
}
}
if (myObject.Added != null && myObject.Added.Count > 0)
{
foreach (var temp in myObject.Added)
{
orddata.Insert(0, temp);
}
}
if (myObject.Deleted != null && myObject.Deleted.Count > 0)
{
foreach (var temp in myObject.Deleted)
{
orddata.Remove(orddata.Where(or => or.OrderID == temp.OrderID).FirstOrDefault());
}
}
var data = orddata;
return Json(data);
}
public class submitvalue
{
public List<Order> Added { get; set; }
public List<Order> Changed { get; set; }
public List<Order> Deleted { get; set; }
public object Key { get; set; }
} |
Screenshot:-
After following the above suggestion still faced issue share us the following details.
- Complete Grid code example(server end).
- Screenshot of network Tab details.(as like above)
- Check whether batch-url method has been called at server end.(Share video demo).
- If possible replicate it in the above sample and revert us back.
- Share detailed explanation of your requirement.
- Screenshot of the script error (if any)
Regards,
Farveen sulthana T
Hi Petra,
Thanks for the update.
Query : what should I return from that BatchUpdate action? Because now (for test) I've put just return Json("[]");, and it seems to work like that. What is variable "orddata" in your example?
In our sample, “orddata” is the list of data bound to the Grid. (You can check the same in the sample link provided by us in our previous update)
We suggest you return the object containing the batch changes after updating them at server end. We have already discussed same in our UG documentation. Kindly check the Batch Update code example in the below help documentation,
Screenshot:
Kindly get back to us for further assistance.
Regards,
Padmavathy Kamalanathan
What does it mean that you suggest me to return the batch changes? Does it mean that if I returned something else, it could still work? According to your answer, it seems that anything colud be returned, that it doesn't even matter...
I have another problem now - on initial grid load (after button click on my main view, grid is returned in partial view and placed on the page), I got some errors in console - first I got:
and then, on second load, I got:
First time when I tried to save batch changes (on 
click), changes weren't saved (grid looked just like before I edited some cells). On every other load, changes were saved.
click), changes weren't saved (grid looked just like before I edited some cells). On every other load, changes were saved.It seems like it happend only when that first error showed up. But now I can't replicate it :( That second error still happens from time to time and I can't figure out the pattern, but obviously there are some problems.
Do you know what causes those errors and what should I do to fix it?
SIGN IN To post a reply.
