public JsonResult RegionalData(int regionID) { var requests = _regionalRequestService.FindBy(t => t.RegionID == regionID); var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionID); var totalRequests = requests.Count(); var draft = (from r in requests where r.Status == 1 select r).Count(); var approved = (from r in requests where r.Status == 2 select r).Count(); var closed = (from r in requests where r.Status == 3 select r).Count(); var federalApp = (from r in requests where r.Status >= 4 select r).Count(); var reqApp = (from r in requisitions where r.Status == 2 select r).Count(); var reqDraft = (from r in requisitions where r.Status == 1 select r).Count(); var reqHub = (from r in requisitions where r.Status >= 3 select r).Count(); var d = new DashboardData() { ApprovedRequests = (decimal)approved*100/totalRequests, PendingRequests = (decimal)(draft * 100) / totalRequests, HubAssignedRequests = (decimal)(closed * 100) / totalRequests, FederalApproved = (decimal)(federalApp * 100) / totalRequests, ApprovedRequisitions = ((decimal)(reqApp * 100) / requisitions.Count()), HubAssignedRequisitions = ((decimal)(reqHub * 100) / requisitions.Count()), PendingRequisitions = ((decimal)(reqDraft * 100) / requisitions.Count()), Above18 = 45, Bet5And8 = 26, Below5 = 29, Female = 24152, Male = 21451, IncomingCommodity = 25131, IncomingDispatches = 2142 }; return Json(d, JsonRequestBehavior.AllowGet); }
public JsonResult RegionalData(int regionID) { var requests = _regionalRequestService.FindBy(t => t.RegionID == regionID); var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionID); var totalRequests = requests.Count(); var currentPlan = _hrdService.FindBy(t => t.Status == 3).FirstOrDefault().PlanID; var utilizations = _utilization.FindBy(t => t.PlanID == currentPlan); var sum18 = 0; var sum518 = 0; var sum5 = 0; var female = 0; var male = 0; if(utilizations!=null){ foreach (var i in utilizations) { sum18 = +(i.FemaleAbove18Years+i.MaleAbove18Years); sum5 = +(i.FemaleLessThan5Years + i.MaleLessThan5Years); sum518 = +(i.FemaleBetween5And18Years + i.MaleBetween5And18Years); female = +(i.FemaleAbove18Years + i.FemaleBetween5And18Years + i.FemaleLessThan5Years); male = +(i.MaleAbove18Years + i.MaleBetween5And18Years + i.MaleLessThan5Years); }} var draft = (from r in requests where r.Status == 1 select r).Count(); var approved = (from r in requests where r.Status == 2 select r).Count(); var closed = (from r in requests where r.Status == 3 select r).Count(); var federalApp = (from r in requests where r.Status >= 4 select r).Count(); var reqApp = (from r in requisitions where r.Status == 2 select r).Count(); var reqDraft = (from r in requisitions where r.Status == 1 select r).Count(); var reqHub = (from r in requisitions where r.Status >= 3 select r).Count(); var d = new DashboardData(); if (totalRequests != 0) { d.ApprovedRequests = (decimal)approved; d.PendingRequests = (decimal)(draft); d.HubAssignedRequests = (decimal)(closed); d.FederalApproved = (decimal)(federalApp); } if (requisitions.Count() != 0) { d.ApprovedRequisitions = ((decimal)(reqApp)); d.HubAssignedRequisitions = ((decimal)(reqHub)); d.PendingRequisitions = ((decimal)(reqDraft)); } d.Above18 = sum18; d.Bet5And8 = sum518; d.Below5 = sum5; d.Female = female; d.Male = male; d.IncomingCommodity = 25131; d.IncomingDispatches = 2142; return Json(d, JsonRequestBehavior.AllowGet); }