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); }