public JsonResult GetGeography() { var Fdps = _fdpService.FindBy(g => g.Latitude != null && g.Longitude != null); var geography = (from fdp in Fdps select new { fdp.Name, fdp.Latitude, fdp.Longitude } ); return(Json(geography, JsonRequestBehavior.AllowGet)); }
private bool CheckIfDFPExists(int woredaId, string name) { try { if (_fdpService.FindBy(f => f.Name == name && f.AdminUnitID == woredaId).Any()) { return(false); } else { return(true); } } catch (Exception) { return(true); } }
public JsonResult ImportantNumbers(int regionID) { var requests = _regionalRequestService.FindBy(t => t.RegionID == regionID); var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionID); var fdps = _fdpService.FindBy(t => t.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID == regionID); var currentHRD = _hrdService.FindBy(t => t.Status == 3).FirstOrDefault(); var bene = currentHRD.HRDDetails.Where(t => t.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID == regionID).Sum( e => e.NumberOfBeneficiaries); var d = new ImportantNumbers() { TotalCommodity = 4502, TotalFDPS = fdps.Count, TotalPeople = bene, TotalRequests = requests.Count, TotalRequistions = requisitions.Count }; return(Json(d, JsonRequestBehavior.AllowGet)); }