public JsonResult GetDataDetails([System.Web.Http.FromUri] string seedcode, [System.Web.Http.FromUri] string centretype, [System.Web.Http.FromUri] string dataname, [System.Web.Http.FromUri] string sYear) { try { ACCDataStore.Entity.Users temp = Session["SessionUser"] as ACCDataStore.Entity.Users; object oResult = null; List <DataHubData> listSchoolData = new List <DataHubData>(); var listSchool = GetListSchoolname(); listSchool.Add(new DatahubCentre("1002", "Aberdeen City", "1")); var listdatasetdate = GetListDataSetDate(); var listNeighbourhoodName = GetListNeighbourhoodsname(rpGeneric2nd); listNeighbourhoodName.Add(new DatahubCentre("1002", "Aberdeen City", "1")); DatahubCentre selectedcentre = null; var selecteddatacatagory = new { Code = "Positive Destination", Name = "Positive Destination" }; var layers = new[] { new { Code = "S01", Name = "Neighbourhood Zones" }, new { Code = "S02", Name = "School Locations" } }.ToList(); var datacatagories = new[] { new { Code = "Positive Destination", Name = "Positive Destination" }, new { Code = "Non-Positive Destination", Name = "Non-Positive Destination" }, new { Code = "Unknown Destination", Name = "Unknown Destination" } }.ToList(); if (centretype.Equals("32")) { List <DatahubCentre> ListNeighbourSelected = seedcode != null?listNeighbourhoodName.Where(x => x.seedcode.Equals(seedcode)).ToList() : null; selectedcentre = listNeighbourhoodName.Where(x => x.seedcode.Equals(seedcode)).FirstOrDefault(); selecteddatacatagory = datacatagories.Where(x => x.Code.Equals(dataname)).FirstOrDefault(); if (ListNeighbourSelected != null && ListNeighbourSelected.Count > 0) { listSchoolData = GetDataHubNeighbourhoodDatabyStatuses(ListNeighbourSelected, sYear); } } else { List <DatahubCentre> ListSchoolSelected = seedcode != null?listSchool.Where(x => x.seedcode.Equals(seedcode)).ToList() : null; selectedcentre = listSchool.Where(x => x.seedcode.Equals(seedcode)).FirstOrDefault(); selecteddatacatagory = datacatagories.Where(x => x.Code.Equals(dataname)).FirstOrDefault(); if (ListSchoolSelected != null && ListSchoolSelected.Count > 0) { listSchoolData = GetDataHubSchoolDatabyStatuses(ListSchoolSelected, sYear); } } oResult = new { selectedcentre = selectedcentre, datasets = listdatasetdate.Select(x => x.GetJson()), selectedDataset = listdatasetdate.Where(x => x.code.Equals(sYear)).Select(x => x.GetJson()).First(), selecteddatacatagory = selecteddatacatagory, listSchoolData = listSchoolData }; return(Json(oResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(ThrowJsonError(ex)); } }
public JsonResult GetData([System.Web.Http.FromUri] string layertype, string datacatagory, string seedcode, string dataset) { try { object oResult = null; List <DataHubData> listSchoolData = new List <DataHubData>(); var listSchool = GetListSchoolname(); var listdatasetdate = GetListDataSetDate(); var listNeighbourhoodName = GetListNeighbourhoodsname(rpGeneric2nd); DatahubCentre selectedcentre = null; var selecteddatacatagory = new { Code = "Participating Destination", Name = "Participating Destination" }; var layers = new [] { new { Code = "S01", Name = "Neighbourhood Zones" }, new { Code = "S02", Name = "School Locations" } }.ToList(); var datacatagories = new[] { new { Code = "Participating Destination", Name = "Participating Destination" }, new { Code = "Non-Participating Destination", Name = "Non-Participating Destination" }, new { Code = "Unknown Destination", Name = "Unknown Destination" } }.ToList(); if (layertype.Equals("S01")) { List <DatahubCentre> ListNeighbourSelected = seedcode != null?listNeighbourhoodName.Where(x => x.seedcode.Equals(seedcode)).ToList() : null; selectedcentre = listNeighbourhoodName.Where(x => x.seedcode.Equals(seedcode)).FirstOrDefault(); selecteddatacatagory = datacatagories.Where(x => x.Code.Equals(datacatagory)).FirstOrDefault(); if (ListNeighbourSelected != null && ListNeighbourSelected.Count > 0) { listSchoolData = GetDataHubNeighbourhoodDatabyStatuses(ListNeighbourSelected, dataset); } } else { List <DatahubCentre> ListSchoolSelected = seedcode != null?listSchool.Where(x => x.seedcode.Equals(seedcode)).ToList() : null; selectedcentre = listSchool.Where(x => x.seedcode.Equals(seedcode)).FirstOrDefault(); selecteddatacatagory = datacatagories.Where(x => x.Code.Equals(datacatagory)).FirstOrDefault(); if (ListSchoolSelected != null && ListSchoolSelected.Count > 0) { listSchoolData = GetDataHubSchoolDatabyStatuses(ListSchoolSelected, dataset); } } //Load datahub summary for creating heatmap List <SummaryDHdata> heatmapdata = GetHeatMapdata(dataset); oResult = new { selectedcentre = selectedcentre, layers = layers, selectedLayer = layers.Where(x => x.Code.Contains(layertype)).FirstOrDefault(), datasets = listdatasetdate.Select(x => x.GetJson()), selectedDataset = listdatasetdate.Where(x => x.code.Equals(dataset)).Select(x => x.GetJson()).First(), datacatagories = datacatagories, selecteddatacatagory = selecteddatacatagory, heatmapdata = heatmapdata, ChartData = GetChartData(listSchoolData) }; return(Json(oResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(ThrowJsonError(ex)); } }
public JsonResult GetListPupils([System.Web.Http.FromUri] string seedcode, [System.Web.Http.FromUri] string centretype, [System.Web.Http.FromUri] string dataname, [System.Web.Http.FromUri] string sYear) { try { Users temp = Session["SessionUser"] as Users; List <PupilsDataHubObj> templistpupils = new List <PupilsDataHubObj>(); List <PupilsDataHubObj> listpupils = new List <PupilsDataHubObj>(); DatahubCentre centreName = new DatahubCentre(); if (centretype.Equals("1")) { //get list all pupils data by school if (seedcode.Equals("1002")) { templistpupils = Getlistpupil(rpGeneric2nd, sYear); centreName = new DatahubCentre("1002", "Aberdeen City", "1"); } else { templistpupils = Getlistpupil(rpGeneric2nd, sYear).Where(x => (x.SEED_Code != null && x.SEED_Code.Equals(seedcode))).ToList();; centreName = GetListSchoolname().Where(x => x.seedcode.Equals(seedcode)).First(); } } else if (centretype.Equals("2")) { //get list pupils data by neighbourhood if (seedcode.Equals("1002")) { templistpupils = Getlistpupil(rpGeneric2nd, sYear); centreName = new DatahubCentre("1002", "Aberdeen City", "2"); } else { templistpupils = GetDatahubdatabyNeighbourhoods(rpGeneric2nd, seedcode, sYear); centreName = GetListNeighbourhoodsname(rpGeneric2nd).Where(x => x.seedcode.Equals(seedcode)).First(); } } switch (dataname.ToLower()) { case "allclients": listpupils = (from a in templistpupils where !a.SDS_Client_Ref.Equals("n/a") select a).ToList(); break; case "male": listpupils = (from a in templistpupils where a.Gender.ToLower().Equals("male") select a).ToList(); break; case "female": listpupils = (from a in templistpupils where a.Gender.ToLower().Equals("female") select a).ToList(); break; case "pupils16": listpupils = (from a in templistpupils where a.Age == 16 select a).ToList(); break; case "pupils17": listpupils = (from a in templistpupils where a.Age == 17 select a).ToList(); break; case "pupils18": listpupils = (from a in templistpupils where a.Age == 18 select a).ToList(); break; case "pupils19": listpupils = (from a in templistpupils where a.Age == 19 select a).ToList(); break; case "movedoutwithscotland": listpupils = (from a in templistpupils where a.status_code.ToLower().Equals("000") select a).ToList(); break; default: listpupils = (from a in templistpupils where a.status_code.ToLower().Equals(dataname.ToLower()) select a).ToList(); break; } var listdatasetdate = GetListDataSetDate(); object oResult = null; oResult = new { ListPupils = listpupils.Select(x => new { Forename = x.Forename, Surname = x.Surname, Age = x.Age, Gender = x.Gender, CSS_Address = x.CSS_Address, CSS_Postcode = x.CSS_Postcode, Telephone = x.Telephone_Number, }).OrderBy(x => x.Age).ThenBy(x => x.Forename), DatasetSelected = listdatasetdate.Where(x => x.code.Equals(sYear)).Select(x => x.GetJson()).First(), DataTitle = dataname, CentreName = centreName }; return(Json(oResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(ThrowJsonError(ex)); } }