I have a grid that is using a data source with a foreign key (department column). When I try to edit the last record (Name4) the values change to the first record in the grid and even if I change the values nothing gets updated. The drop down option when editing the record is working, but the selection is not being saved.
My Razor code for the grid is:
@model IEnumerable<XXXCore.Models.Employee>
@{
ViewData["Title"] = "Index";
}
<h2>Index</h2>
<p>
<a asp-action="Create">Create New</a>
</p>
<ej-grid id="FlatGrid" allow-sorting="true" allow-paging="true" allow-reordering="true" datasource="ViewBag.DataSource1">
<e-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true" edit-mode="@(EditMode.Normal)"></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="Name" header-text="Name" text-align="Left" width="70"></e-column>
<e-column field="LastName" header-text="Last Name" text-align="Left" width="80"></e-column>
<e-column field="DOB" header-text="Birth Date" text-align="Left" width="80" format="{0:dd/MM/yyyy}"></e-column>
<e-column field="DepartmentID" datasource="(IEnumerable<object>)ViewBag.DataSource2"
header-text="Department" foreign-key-field="ID" foreign-key-value="Name" text-align="Left"
width="80" edit-type="@(EditingType.Dropdown)"></e-column>
</e-columns>
</ej-grid>
The controller code is:
// GET: Employees
public async Task<IActionResult> Index()
{
ViewBag.DataSource1 = await _context.Employees.ToListAsync();
ViewBag.DataSource2 = await _context.Departments.ToListAsync();
return View();
}
What am I missing ? thanks in advance.
