How to set "ParentId" property on batch edit in ASPNET CORE
5 Replies
Hi Danilo,
According to your query you need to set the value for the PrimaryKey column on the server side when a new record is added to the grid. We have achieved your requirement in the below code example.
In the below code example, we have generated a random number and assigned that value to the PrimaryKey Column (OrderID) in server side during the insert operation.
|
[index.cshtml]
@{Html.EJ().Grid<object>("Grid")
.Locale("pt-BR")
.Datasource(ds => ds.Json((IEnumerable<object>)ViewBag.datasource).BatchURL("/Home/BatchUpdate").Adaptor(AdaptorType.RemoteSaveAdaptor))
.EditSettings(edit => { edit.AllowAdding().AllowDeleting().AllowEditing().RowPosition(RowPosition.Bottom).
EditMode(EditMode.Batch).ShowConfirmDialog(false); })
…...
.Columns(col =>
{
col.Field("OrderID").HeaderText("OrderID").IsPrimaryKey(true).Visible(false).Add();
…...
})
.Render();
}
[controller.cs]
public IActionResult BatchUpdate([FromBody]List<Order> changed, [FromBody]List<Order> added, [FromBody]List<Order> deleted)
{
if (changed != null && changed.Count > 0)
{
foreach (var temp in myObject.Changed)
{
var ord = temp;
Orders val = orddata.Where(or => or.OrderID == ord.OrderID).FirstOrDefault();
val.OrderID = ord.OrderID;
val.EmployeeID = ord.EmployeeID;
val.CustomerID = ord.CustomerID;
val.OrderDate = ord.OrderDate;
val.ShipCity = ord.ShipCity;
}
}
if (myObject.Added != null && myObject.Added.Count > 0)
{
Random ran = new Random();
foreach (var temp in myObject.Added)
{
temp.OrderID = ran.Next();
orddata.Insert(0, temp);
}
} if (deleted != null && deleted.Count > 0)
{
foreach (var temp in deleted)
{
orddata.Remove(orddata.Where(or => or.OrderID == temp.OrderID).FirstOrDefault());
}
}
var data = orddata;
return Json(new { added = added, changed = changed, deleted = deleted });
} |
Refer the below screenshot.
For your convenience, we have prepared a sample which can be downloaded from the below location.
If you need any further assistance please get back to us.
Regards,
Sathyanarayanamoorthy
Hi Danilo,
According to your query we suspect that you need to update the Id column in the Client side. We have achieved this requirement using the beforeBatchSave event in the below code example.
If you want to update the Id column in the server side then we suggest you to follow the solution provided in our previous update.
|
@{Html.EJ().Grid<object>("Grid")
.Datasource(ds => ds.Json((IEnumerable<object>)ViewBag.datasource).BatchURL("/Home/BatchUpdate").Adaptor(AdaptorType.RemoteSaveAdaptor))
…...
.ClientSideEvents(eve => eve.BeforeBatchSave("Save"))
.Columns(col=> {
col.Field("OrderID").HeaderText("OrderID").IsPrimaryKey(true).Visible(false).Add();
col.Field("EmployeeID").HeaderText("EmployeeID").Add();
col.Field("CustomerID").HeaderText("CustomerID").Add();
col.Field("ShipCity").HeaderText("ShipCity").Add();
})
.Render();
}
<script type="text/javascript">
function Save(args) {
args.batchChanges.added[0].OrderID = 12345;
}
</script> |
Refer the below screenshot.
Please refer the below documentation for details of beforeBatchSave event.
We have prepared a sample for your reference which can be downloaded from the below location.
If you need any further assistance please get back to us.
Regards,
Sathyanarayanamoorthy
SIGN IN To post a reply.
