public async Task <IActionResult> GetChartsData(DashboardSearchDto searchModel)
{
DashboardChartstDto model = new DashboardChartstDto();
model.bcp = beneficiaryRepositor.BeneficiaryByBCPList(searchModel);
return(Ok(model));
}
//public void ReturneeByBCPList(DashboardSearchDto model)
public Ng2Charts BeneficiaryByBCPList(DashboardSearchDto model)
{
var data = (from b in db.Beneficiaries
where b.IsActive == true && b.ScreeningDate >= model.FromDate && b.ScreeningDate <= model.ToDate
group b by b.BorderPoint into ByBCP
select new {
BCPName = db.BorderCrossingPoints.Where(bp => bp.BCPCode == ByBCP.Key).Select(bp => bp.EnName).FirstOrDefault(),
DEP = ByBCP.Where(b => b.ReturnStatus == "DEP").Count(),
DC = ByBCP.Where(b => b.ReturnStatus == "DC").Count(),
SR = ByBCP.Where(b => b.ReturnStatus == "SR").Count()
}
).ToList();
Ng2Charts bybcp = new Ng2Charts
{
categories = data.Select(x => x.BCPName).ToArray(),
series = new Series[]
{
new Series
{
label = "Deported",
data = data.Select(x => x.DEP).ToArray()
},
new Series
{
label = "Document claimant",
data = data.Select(x => x.DC).ToArray()
},
new Series
{
label = "Spontaneous returnee",
data = data.Select(x => x.SR).ToArray()
},
}
};
return(bybcp);
}
