Dear Team,
I try debugging many time but find no solution for this.
Here is my logging:
[14:18:06 INF] HTTP POST /Chart/GetAllTask responded 200 in 206.3315 ms
[14:18:06 INF] HTTP POST /Chart/GetAllTask responded 200 in 233.4024 ms
[14:18:06 INF] HTTP POST /Chart/GetAllTask responded 200 in 269.3434 ms
[14:18:07 INF] HTTP POST /Chart/GetAllTask responded 200 in 285.3059 ms
It call my API one time per series but Data is the same.
I already read this thread but It is not working for me.
https://www.syncfusion.com/forums/151830/charts-with-webapi-adapter-will-fire-request-multiple-times
Here is my chart partial view:
@model HLVERPCORE.Models.Chart.ChartInitModel
<div class="control-section" align="center">
<ejs-chart id="@Model.ChartId" title="@Model.ChartTitle" height="400">
<e-data-manager url="Chart/GetAllTask" adaptor="UrlAdaptor" crossDomain="true"></e-data-manager>
<e-chart-primaryxaxis labelIntersectAction="@Syncfusion.EJ2.Charts.LabelIntersectAction.Rotate45" interval="1" valueType="@Syncfusion.EJ2.Charts.ValueType.Category">
<e-majorgridlines width="0"></e-majorgridlines>
<e-minorgridlines width="0"></e-minorgridlines>
<e-majorticklines width="0"></e-majorticklines>
<e-minorticklines width="0"></e-minorticklines>
<e-linestyle width="0"></e-linestyle>
</e-chart-primaryxaxis>
<e-chart-primaryyaxis title="Giờ">
<e-majorticklines width="0"></e-majorticklines>
<e-minorticklines width="0"></e-minorticklines>
<e-minorgridlines width="1"></e-minorgridlines>
<e-linestyle width="0"></e-linestyle>
</e-chart-primaryyaxis>
<e-series-collection>
<e-series xName="Category" yName="GN" name="Chung" width="2" columnWidth="0.5" type="@Syncfusion.EJ2.Charts.ChartSeriesType.StackingColumn" fill="#FFCC00">
<e-series-border width="1" color="#ffffff" ></e-series-border>
</e-series>
<e-series xName="Category" yName="NV" name="Nghiệp vụ" width="2" columnWidth="0.5" type="@Syncfusion.EJ2.Charts.ChartSeriesType.StackingColumn" fill="#6633CC">
<e-series-border width="1" color="#ffffff"></e-series-border>
</e-series>
<e-series xName="Category" yName="QL" name="Quản lý" width="2" columnWidth="0.5" type="@Syncfusion.EJ2.Charts.ChartSeriesType.StackingColumn" fill="#20C997">
<e-series-border width="1" color="#ffffff"></e-series-border>
</e-series>
<e-series xName="Category" yName="KN" name="Kiêm nhiệm" width="2" columnWidth="0.5" type="@Syncfusion.EJ2.Charts.ChartSeriesType.StackingColumn" fill="#FF6B6B">
<e-series-border width="1" color="#ffffff"></e-series-border>
</e-series>
</e-series-collection>
<e-chart-tooltipsettings enable="true"></e-chart-tooltipsettings>
<e-chart-legendsettings visible="true" enableHighlight="true"></e-chart-legendsettings>
<e-chart-chartarea>
<e-chartarea-border width="0"></e-chartarea-border>
</e-chart-chartarea>
</ejs-chart>
</div>
My Chart controller:
public async Task<JsonResult> GetAllTask()
{
var result = await _commonService.GetAllDataAsync<TaskViewModel>(EndPointConstants.GET_ALL_TASKS, _token);
if (result.Success)
{
var groupedData = result.Data
.GroupBy(r => new { r.CreateUser, r.TaskGroupId })
.Select(g => new
{
CreateUser = g.Key.CreateUser,
TaskGroupId = g.Key.TaskGroupId,
TimeSpent = g.Sum(task => task.TimeSpent)
})
.ToArray();
var stackedChartData = groupedData
.GroupBy(t => t.CreateUser)
.Select(g => new ChartModel()
{
Category = g.Key,
NV = g.FirstOrDefault(x => x.TaskGroupId == "NV")?.TimeSpent ?? 0,
GN = g.FirstOrDefault(x => x.TaskGroupId == "GN")?.TimeSpent ?? 0,
QL = g.FirstOrDefault(x => x.TaskGroupId == "QL")?.TimeSpent ?? 0,
KN = g.FirstOrDefault(x => x.TaskGroupId == "KN")?.TimeSpent ?? 0
}).ToArray();
return Json(new { result = stackedChartData, count = stackedChartData.Count() });
}
return Json(new { result = "", count = 0 });
//return RedirectToAction(nameof(Error), result);
}
My report view:
@model List<HLVERPCORE.Models.Chart.ChartInitModel>
<ejs-tab id="ej2Tab">
<e-tab-tabitems>
<e-tab-tabitem>
<e-content-template>
<div>
<div class="e-tab-header">
<div>a</div>
<div>b</div>
<div>c</div>
</div>
<div class="e-content">
@foreach (var chartViewModel in Model)
{
<div>
@await Html.PartialAsync(chartViewModel.ChartTemplate, chartViewModel)
</div>
}
<div>
<ejs-grid id="ej2grid" height="330px" allowPaging="true">
<e-data-manager url="https://services.odata.org/V4/Northwind/Northwind.svc/Products" crossdomain="true" adaptor="ODataV4Adaptor"></e-data-manager>
<e-grid-columns>
<e-grid-column field="ProductID" headerText="Product ID" textAlign="Right" width="120"></e-grid-column>
<e-grid-column field="ProductName" headerText="Product Name" width="150"></e-grid-column>
<e-grid-column field="UnitPrice" headerText="Supplier ID" textAlign="Right" width="130"></e-grid-column>
<e-grid-column field="UnitsInStock" headerText="QuantityPerUnit" format="C2" textAlign="Right" width="120"></e-grid-column>
<e-grid-column field="Discontinued" headerText="Discontinued" width="140" textAlign="Center" type="boolean" displayAsCheckBox="true"></e-grid-column>
</e-grid-columns>
</ejs-grid>
</div>
</div>
</div>
</e-content-template>
</e-tab-tabitem>
</e-tab-tabitems>
</ejs-tab>
Any solution for this ?
API: asp.net core API
FE: asp.net core mvc
Thanks,
Khang Thai
