Child Grid parameters
Hello,
I applied exactly what you detailed. When clicking to open Child Grid, the following message appears in the console:
"Undefined"
When I check on the controller the same message also appears:
Here is the full code:
public IActionResult GridSubGerencial_Read([FromBody] DataManagerRequest dm, string Proposta_id)
{
TempData.Keep("datainicial");
TempData.Keep("datafinal");
IEnumerable DataSource = ObterDadosSubGerencial();
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast<MovimentacaoFinanceira>().Count();
if (dm.Skip != 0)
{
DataSource = operation.PerformSkip(DataSource, dm.Skip); //Paging
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource);
}
public IActionResult GridGerencial_Read([FromBody] DataManagerRequest dm)
{
TempData.Keep("datainicial");
TempData.Keep("datafinal");
IEnumerable DataSource = ObterDadosGerencial();
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast<ViewRelatorioProposta>().Count();
if (dm.Skip != 0)
{
DataSource = operation.PerformSkip(DataSource, dm.Skip); //Paging
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource);
}
public List<MovimentacaoFinanceira> ObterDadosSubGerencial()
{
List<MovimentacaoFinanceira> model = new List<MovimentacaoFinanceira>();
var lista = (from a in _context.MovimentacaoFinanceira
select a).ToList();
foreach (var c in lista)
{
model.Add(new MovimentacaoFinanceira
{
Id = c.Id,
Proposta_id = c.Proposta_id,
Valor_final = c.Valor_final,
Propostastr = c.Propostastr
});
}
return model;
}
public List<ViewRelatorioProposta> ObterDadosGerencial()
{
DateTime? datainicio = Convert.ToDateTime("01/" + System.DateTime.Now.Month + "/" + System.DateTime.Now.Year);
DateTime? datafim = Convert.ToDateTime("01/" + System.DateTime.Now.Month + "/" + System.DateTime.Now.Year).AddMonths(1).AddDays(-1);
List<ViewRelatorioProposta> model = new List<ViewRelatorioProposta>();
var lista = (from a in _context.ViewRelatorioProposta
where a.Data_criacao >= datainicio
&& a.Data_criacao <= datafim
select a).ToList();
foreach (var c in lista)
{
model.Add(new ViewRelatorioProposta
{
Id = c.Id,
Nome = c.Nome,
Codigo = c.Codigo,
Proposta_id = c.Id
});
}
return model;
}
@{
var ChildGrid = new Syncfusion.EJ2.Grids.Grid()
{
QueryString = "Proposta_id",
Columns = new List<Syncfusion.EJ2.Grids.GridColumn> {
new Syncfusion.EJ2.Grids.GridColumn(){ Field="Proposta_id", IsPrimaryKey=true, HeaderText="ID", Width="150" },
new Syncfusion.EJ2.Grids.GridColumn(){ Field="Valor_final", HeaderText="Valor", Width="150" },
}};
}
<ejs-grid id="GridRelatorioGerencial" childGrid="ChildGrid" detailDataBound="detailDataBound" locale="pt" allowfiltering="true" height="273" allowPaging="true" toolbar="@(new List<string>() { "Search"})">
<e-data-manager url="@Url.Action("GridGerencial_Read","Relatorios")"
adaptor="UrlAdaptor" crossDomain="true"></e-data-manager>
<e-grid-filterSettings type="Excel"></e-grid-filterSettings>
<e-grid-columns>
<e-grid-column field="Proposta_id" headerText="ID" type="string" width="200"></e-grid-column>
<e-grid-column field="Codigo" headerText="Proposta" type="string" width="200"></e-grid-column>
</e-grid-columns>
</ejs-grid>
<script>
function detailDataBound(args) {
console.log(args.childGrid.parentDetails.parentKeyFieldValue);
args.childGrid.dataSource = new ej.data.DataManager({
url: "/Relatorios/GridSubGerencial_Read/" + args.childGrid.parentDetails.parentKeyFieldValue,
adaptor: new ej.data.UrlAdaptor()
});
}
</script>
Thanks
Fernando,
We have tried to reproduce the issue but the “parentKeyFieldValue” can be accesses inside the “detailDataBound” event. Please refer to the below screenshot and the attached sample for more information.
|
|
If you are still facing the issue, please share an issue reproducible sample or try to reproduce the issue in the above sample which will be helpful for us to validate further.
Attachment: ChildGrid_a0d73c.zip
Fernando,
Thanks for sharing the sample.
By analyzing your sample, we could see that the issue was raised because of the SerializerSettings. While returning the response return from the server, the field name was not in the proper format. Please refer to the below screenshot for more information.
|
@{ var ChildGrid = new Syncfusion.EJ2.Grids.Grid() { QueryString = "MoradorId", . . . } }; } |
So, we suggest you add the below code to your program.cs file to overcome the problem. Refer to the below documentation for more information.
If the ASP.NET CORE version is 3.X and above then add the below code in program.cs file
|
[program.cs]
using Newtonsoft.Json.Serialization;
var builder = WebApplication.CreateBuilder(args);
builder.Services.AddMvc().AddNewtonsoftJson(options => { options.SerializerSettings.ContractResolver = new DefaultContractResolver(); });
|
To use AddNewtonsoftJson in your project we need to include Microsoft.AspNetCore.Mvc.NewtonsoftJson assembly,
|
|
