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