How to enable the Grid data CRUD function.
Hello,
As the title suggests, i am curious about how to solve it.
First, I bring the data to be imported into Grid to Ajax based on the data selected from the Dropdown list.
At this time, the imported data is received only as a DataSource From Grid.
So, if you modify the data and use Toolbar, it does not go to the controller to update to the DB.
i Want to use CRUD function in the same situation as above.
Please give me a solution on How to use it?
Below is the code i wrote. Please keep in mind
//////////HTML///////////////////
//////////////////////////
//////////Dropdownlist Change (Script)////////////
function ProjectChange(args) {
var ProjectGrid = document.getElementById("ProjectGrid").ej2_instances[0];
var RoomGrid = document.getElementById("RoomGrid").ej2_instances[0];
//ExportBtn to be Able
document.getElementById("exportBtn").disabled = false;
$.ajax({
url: "/ProjectData/ViewUpdate",
data: { "sProjectNo": args.itemData.value },
type: "POST",
success: function (data) {
ProjectGrid.dataSource = ej.data.DataUtil.parse.parseJson(data[0]);
RoomGrid.dataSource = ej.data.DataUtil.parse.parseJson(data[1]);
},
error: function () {
alert("Error")
}
});
}
//////////////////////
///////Controller//////////////
public IActionResult UrlRoom([FromBody] DataManagerRequest dm)
{
List
//ViewBag.Room = listRoom;
IEnumerable
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
roomDatas = operation.PerformSearching(roomDatas, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
roomDatas = operation.PerformSorting(roomDatas, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
roomDatas = operation.PerformFiltering(roomDatas, dm.Where, dm.Where[0].Operator);
}
int count = listRoom.Cast
if (dm.Skip != 0)
{
roomDatas = operation.PerformSkip(roomDatas, dm.Skip); //Paging
}
if (dm.Take != 0)
{
roomDatas = operation.PerformTake(roomDatas, dm.Take);
}
return dm.RequiresCounts ? Json(new { result = listRoom, count = count }) : Json(listRoom);
//return Content("");
}
public ActionResult CrudUpdate([FromBody] CRUDModel
{
string d = action;
foreach (RoomData changeData in batchmodel.Changed)
{
RoomData After = changeData;
RoomData Before = RoomData.GetList().Where(or => or.Key == After.Key).FirstOrDefault();
RoomData.Update(Before, After);
}
foreach (RoomData deleteData in batchmodel.Deleted)
{
RoomData.Delete(deleteData);
}
foreach (RoomData InsertData in batchmodel.Added)
{
RoomData.Insert(InsertData);
}
var data = RoomData.GetList().ToList();
return Json(data);
}
////////////////////////////////////////////////////
