public JsonResult GetEarlyWarningRequiredNumbers()
{
var currentHrd = GetCurrentHrd();
var nationalBenficiaryNo = currentHrd.HRDDetails.Sum(m => m.NumberOfBeneficiaries);
var requests = _eWDashboardService.FindByRequest(m => m.PlanID == currentHrd.PlanID);
var requistions = _eWDashboardService.GetAllReliefRequisition();
var hrdAndRequestViewModel = new HrdAndRequestViewModel
{
TotalHrdBeneficaryNumber = nationalBenficiaryNo,
HrdTotalCommodity = currentHrd.Ration.RationDetails.Sum(m => m.Amount)*(nationalBenficiaryNo),
TotalRequest = requests.Count,
TotalRequisitionNumber = (from requistion in requistions
from request in requests
where requistion.RegionalRequestID==request.RegionalRequestID
select new
{
requistion.RequisitionID
}).Count()
//RequestedTotalBeneficaryNumber = requests.RegionalRequestDetails.Sum(m=>m.Beneficiaries)
};
return Json(hrdAndRequestViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult GetEarlyWarningRequiredNumbers()
{
var currentHrd = GetCurrentHrd();
var nationalBenficiaryNo = currentHrd.HRDDetails.Sum(m => m.NumberOfBeneficiaries);
var requests = _eWDashboardService.FindByRequest(m => m.PlanID == currentHrd.PlanID);
var requistions = _eWDashboardService.GetAllReliefRequisition();
//var totalCommodity = currentHrd.Ration.RationDetails.Sum(m => m.Amount);
var regions = (from item in currentHrd.HRDDetails
select new { item.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID }
).Distinct().ToList();
decimal total = 0;
foreach (var region in regions)
{
foreach (var ration in GetCurrentHrd().Ration.RationDetails)
{
var rationAmount = ration.Amount/1000; //todisplay in MT
var regionSum = currentHrd.HRDDetails.Where(t => t.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID == region.AdminUnitID).Sum(t => t.NumberOfBeneficiaries * t.DurationOfAssistance * rationAmount);
total += regionSum;
}
}
var hrdAndRequestViewModel = new HrdAndRequestViewModel
{
TotalHrdBeneficaryNumber = nationalBenficiaryNo,
HrdTotalCommodity = total,
TotalRequest = requests.Count,
TotalRequisitionNumber = (from requistion in requistions
from request in requests
where requistion.RegionalRequestID==request.RegionalRequestID
select new
{
requistion.RequisitionID
}).Count()
//RequestedTotalBeneficaryNumber = requests.RegionalRequestDetails.Sum(m=>m.Beneficiaries)
};
return Json(hrdAndRequestViewModel, JsonRequestBehavior.AllowGet);
}
