public GenericSchoolData(string code, int count)
{
this.Code = code;
this.count = count;
this.Percent = 0.0F;
this.sPercent = "0.0";
this.sCount = NumberFormatHelper.FormatNumber(count, 0, "n/a").ToString();
this.color = "#000000";
}
protected GenericData GetPupilsAges(List <PupilsDataHubObj> listpupils, int age)
{
GenericData data = new GenericData();
data.Code = "Pupils" + age;
data.count = listpupils.Where(x => x.Age == age).ToList().Count;
data.sum = listpupils.Count();
data.Percent = data.sum != 0 ? data.count * 100.0F / data.sum : 0.0f;
data.sPercent = double.IsNaN(data.count * 100.0F / data.sum)? "n/a" : NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.scount = data.sPercent.Equals("n/a") ? "n/a" : data.count.ToString();
return(data);
}
protected GenericData GetMovedOutwithScotland(List <PupilsDataHubObj> listpupils)
{
GenericData data = new GenericData();
data.Code = "MovedOutwithScotland";
data.count = listpupils.Where(x => (x.Current_Status != null && x.Current_Status.ToLower().Equals("moved outwith scotland"))).ToList().Count;
data.sum = listpupils.Count();
data.Percent = data.sum != 0 ? data.count * 100.0F / data.sum : 0.0f;
//data.sPercent = NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.sPercent = double.IsNaN(data.count * 100.0F / data.sum) ? "n/a" : NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.scount = data.sPercent.Equals("n/a") ? "n/a" : data.count.ToString();
return(data);
}
protected GenericData GetGender(List <PupilsDataHubObj> listpupils, string gender)
{
GenericData data = new GenericData();
data.Code = gender;
data.count = listpupils.Where(x => x.Gender.Equals(gender)).ToList().Count();
data.sum = listpupils.Count();
data.Percent = data.sum != 0 ? data.count * 100.0F / data.sum : 0.0f;
//data.sPercent = NumberFormatHelper.FormatNumber(data.Percent, 1, "n/a").ToString();
data.sPercent = double.IsNaN(data.count * 100.0F / data.sum) ? "n/a" : NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.scount = data.sPercent.Equals("n/a") ? "n/a" : data.count.ToString();
return(data);
}
protected GenericData GetUnknown(List <PupilsDataHubObj> listpupils)
{
List <PupilsDataHubObj> pupilsmoveoutScotland = listpupils.Where(x => x.status_code.Equals("000")).ToList();
listpupils = listpupils.Except(pupilsmoveoutScotland).ToList();
GenericData data = new GenericData();
data.Code = "Unknown";
data.count = listpupils.Where(x => x.status_code.Equals("999")).ToList().Count;
data.sum = listpupils.Count();
data.Percent = data.sum != 0? data.count * 100.0F / data.sum : 0.0f;
//data.sPercent = NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.sPercent = double.IsNaN(data.count * 100.0F / data.sum) ? "n/a" : NumberFormatHelper.FormatNumber(data.Percent, 1).ToString();
data.scount = data.sPercent.Equals("n/a") ? "n/a" : data.count.ToString();
return(data);
}
public string GetStringPercent()
{
return(NumberFormatHelper.FormatNumber(this.Percent, 1, "n/a").ToString());
}
public JsonResult GetData([System.Web.Http.FromUri] string sClientID, [System.Web.Http.FromUri] string sCategoryID, [System.Web.Http.FromUri] string sServiceType) // get selected list of school's id
{
try
{
object oResult = null;
var ListCategory = new[] { new { Code = "OOA", Name = "Out of Authority" }, new { Code = "CO", Name = "Commissioned" }, new { Code = "CD", Name = "Disability" }, new { Code = "SP", Name = "Special Parenting" } }.ToList();
var ListServiceType = new[] { new { Code = "SC", Name = "Secure Care" }, new { Code = "CH", Name = "Children's Home" }, new { Code = "RS", Name = "Residential School" }, new { Code = "CS", Name = "Crisis Support/Crisis Care" }, new { Code = "TBC", Name = "To Be Confirmed" } }.ToList();
Dictionary <string, string> DictSDataset = GetDatasets();
IList <ChildPlacements> listChild_id = GetListChildId(rpGeneric2nd);
var listChildAgreements = GetChildAgreementByClientID(rpGeneric2nd, sClientID);
var listChildPlacements = GetChildPlacementByClientID(rpGeneric2nd, sClientID);
oResult = new
{
ListClientID = listChild_id.Select(x => new
{
Client_Id = x.client_id,
PlacementCategory = x.placement_category,
ServiceType = x.service_type,
}).OrderBy(x => x.Client_Id),
ClientSelected = listChild_id.Where(x => x.client_id.Equals(sClientID)).Select(x => new
{
Client_Id = x.client_id,
PlacementCategory = x.placement_category,
ServiceType = x.service_type,
}).First(),
ListCategory = ListCategory,
ListCategorySelected = ListCategory.Where(x => x.Code.Equals(sCategoryID)).First(),
ListServiceType = ListServiceType,
ListServiceTypeSelected = ListServiceType.Where(x => x.Code.Equals(sServiceType)).First(),
listChildAgreements = listChildAgreements.Select(x => new
{
Client_Id = x.client_id,
Agreement_Id = x.agreement_id,
Agreement_Started = x.agreement_started.ToShortDateString(),
Agreement_Ended = x.agreement_ended.ToShortDateString(),
Active_Cost = NumberFormatHelper.FormatNumber(x.active_weeks_cost, 2).ToString(),
Actual_Cost = NumberFormatHelper.FormatNumber(x.actual_cost, 2).ToString(),
NumberofDays = x.numberofdays,
Supplier_Name = x.supplier_name,
Payattention = x.payattension,
DatasetDate = DictSDataset[x.dataset]
}).OrderBy(x => x.Agreement_Id).ThenBy(x => x.Agreement_Started),
listChildPlacements = listChildPlacements.Select(x => new
{
Client_Id = x.client_id,
DateOfBirth = x.dob.ToShortDateString(),
Gender = x.gender,
Age = GetAge(x.dob),
Placement_Id = x.placement_id,
Palcement_Started = x.placement_started.ToShortDateString(),
Palcement_Ended = x.placement_ended.ToShortDateString(),
Placement_Name = x.placement_name,
Payattention = x.payattension,
DatasetDate = DictSDataset[x.dataset]
}).OrderBy(x => x.Placement_Id).ThenBy(x => x.Palcement_Started),
Cost_OOA = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("OOA") && x.payattension.Equals("")).Sum(x => x.actual_cost), 2).ToString(),
Cost_D = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("CD") && x.payattension.Equals("")).Sum(x => x.actual_cost), 2).ToString(),
Cost_CO = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("CO") && x.payattension.Equals("")).Sum(x => x.actual_cost), 2).ToString(),
Cost_SP = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("SP") && x.payattension.Equals("")).Sum(x => x.actual_cost), 2).ToString(),
Cost_total = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.payattension.Equals("")).Sum(x => x.actual_cost), 2).ToString(),
Active_Cost_OOA = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("OOA") && x.payattension.Equals("**")).Sum(x => x.actual_cost), 2).ToString(),
Active_Cost_D = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("CD") && x.payattension.Equals("**")).Sum(x => x.actual_cost), 2).ToString(),
Active_Cost_CO = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("CO") && x.payattension.Equals("**")).Sum(x => x.actual_cost), 2).ToString(),
Active_Cost_SP = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.Placement_Category.Equals("SP") && x.payattension.Equals("**")).Sum(x => x.actual_cost), 2).ToString(),
Active_Cost_total = NumberFormatHelper.FormatNumber(listChildAgreements.Where(x => x.payattension.Equals("**")).Sum(x => x.actual_cost), 2).ToString(),
listCostbySupplier = listChildAgreements.GroupBy(x => x.supplier_code).Select(r => new
{
Supplier_name = r.First().supplier_name,
Count = r.Count().ToString(),
Cost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("")).Sum(xl => xl.actual_cost), 2).ToString(),
OngoingCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("**")).Sum(xl => xl.actual_cost), 2).ToString(),
}).ToList(),
ChartCostbyAuthority = GetChartCostByAuthorities(listChildAgreements),
ChartCostbySupplier = GetChartCostBySupplier(listChildAgreements),
};
return(Json(oResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(ThrowJsonError(ex));
}
}
public JsonResult GetData([System.Web.Http.FromUri] string sReportID) // get selected list of school's id
{
try
{
var ListReports = new[] { new { Code = "1", Name = "Cost Breakdown By Child" }, new { Code = "2", Name = "Cost Breakdown By Supplier" }, new { Code = "3", Name = "Cost Breakdown By Placement Category" }, new { Code = "4", Name = "Cost Breakdown By Service Type" } }.ToList();
Dictionary <string, string> DictPlacementCategory = GetDictPlacementCategory();
Dictionary <string, string> DictServiceType = GetDictServiceType();
var listChildAgreements = GetChildAgreement(rpGeneric2nd);
var listResults = new { };
object oResult = null;
// Cost Breakdown By Child
if (sReportID.Equals("1"))
{
oResult = new
{
ListReports = ListReports,
ListReportSelected = ListReports.Where(x => x.Code.Equals(sReportID)).First(),
listResults = listChildAgreements.GroupBy(x => x.client_id).Select(r => new
{
Client_id = r.First().client_id,
Count = r.Count().ToString(),
CountClosed = r.Where(x => x.payattension.Equals("")).Count().ToString(),
CountOngoing = r.Where(x => x.payattension.Equals("**")).Count().ToString(),
CountChild = r.Count().ToString(),
TotalCost = NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 2).ToString(),
ClosedCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("")).Sum(xl => xl.actual_cost), 2).ToString(),
OngoingCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("**")).Sum(xl => xl.actual_cost), 2).ToString()
}).OrderByDescending(x => x.TotalCost).ToList(),
ShowCountChild = false
};
}
else if (sReportID.Equals("2"))
{
oResult = new
{
ListReports = ListReports,
ListReportSelected = ListReports.Where(x => x.Code.Equals(sReportID)).First(),
listResults = listChildAgreements.GroupBy(x => x.supplier_code).Select(r => new
{
Client_id = r.First().supplier_name,
Count = r.Count().ToString(),
CountClosed = r.Where(x => x.payattension.Equals("")).Count().ToString(),
CountOngoing = r.Where(x => x.payattension.Equals("**")).Count().ToString(),
CountChild = r.Select(x => x.client_id).Distinct().Count().ToString(), //grp.Select(x => x.SomeField).Distinct().Count()
TotalCost = NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 2).ToString(),
ClosedCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("")).Sum(xl => xl.actual_cost), 2).ToString(),
OngoingCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("**")).Sum(xl => xl.actual_cost), 2).ToString()
}).OrderByDescending(x => x.TotalCost).ToList(),
ShowCountChild = true
};
}
else if (sReportID.Equals("3"))
{
oResult = new
{
ListReports = ListReports,
ListReportSelected = ListReports.Where(x => x.Code.Equals(sReportID)).First(),
listResults = listChildAgreements.GroupBy(x => x.Placement_Category).Select(r => new
{
Client_id = DictPlacementCategory[r.First().Placement_Category],
Count = r.Count().ToString(),
CountChild = r.Select(x => x.client_id).Distinct().Count().ToString(),
CountClosed = r.Where(x => x.payattension.Equals("")).Count().ToString(),
CountOngoing = r.Where(x => x.payattension.Equals("**")).Count().ToString(),
TotalCost = NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 2).ToString(),
ClosedCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("")).Sum(xl => xl.actual_cost), 2).ToString(),
OngoingCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("**")).Sum(xl => xl.actual_cost), 2).ToString()
// NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 1).ToString()
}).OrderByDescending(x => x.TotalCost).ToList(),
ShowCountChild = true,
PieChartCost = GetPieChartCostByPlacementCategory(listChildAgreements),
PieChartAgreements = GetPieChartNoAgreementByPlacementCategory(listChildAgreements),
BarChartCost = GetChartCostByPlacementCategory(listChildAgreements),
BarChartNoAgreement = GetChartNoAgreementsByPlacementCategory(listChildAgreements)
};
}
else
{
oResult = new
{
ListReports = ListReports,
ListReportSelected = ListReports.Where(x => x.Code.Equals(sReportID)).First(),
listResults = listChildAgreements.GroupBy(x => x.Service_Type).Select(r => new
{
Client_id = DictServiceType[r.First().Service_Type],
Count = r.Count().ToString(),
CountChild = r.Select(x => x.client_id).Distinct().Count().ToString(),
CountClosed = r.Where(x => x.payattension.Equals("")).Count().ToString(),
CountOngoing = r.Where(x => x.payattension.Equals("**")).Count().ToString(),
TotalCost = NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 2).ToString(),
ClosedCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("")).Sum(xl => xl.actual_cost), 2).ToString(),
OngoingCost = NumberFormatHelper.FormatNumber(r.Where(x => x.payattension.Equals("**")).Sum(xl => xl.actual_cost), 2).ToString()
// Cost = NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 1).ToString()
// NumberFormatHelper.FormatNumber(r.Sum(xl => xl.actual_cost), 1).ToString()
}).OrderByDescending(x => x.TotalCost).ToList(),
ShowCountChild = true,
PieChartCost = GetPieChartCostByServiceType(listChildAgreements),
PieChartAgreements = GetPieChartNoAgreementByServiceType(listChildAgreements),
BarChartCost = GetChartCostByServiceType(listChildAgreements),
BarChartNoAgreement = GetChartNoAgreementsByServiceType(listChildAgreements)
};
}
return(Json(oResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(ThrowJsonError(ex));
}
}
public double getcheckSumPercentage()
{
return(Convert.ToDouble(NumberFormatHelper.FormatNumber(this.listdata.Select(x => Convert.ToDouble(x.Percent)).Sum(), 1)));
}
protected List <GenericData> GetDestination(string seedcode, List <PupilsDataHubObj> listpupils, IList <Status> destinations)
{
List <PupilsDataHubObj> pupilsmoveoutScotland = listpupils.Where(x => x.Current_Status.ToLower().Equals("moved outwith scotland")).ToList();
listpupils = listpupils.Except(pupilsmoveoutScotland).ToList();
List <GenericData> listdata = new List <GenericData>();
GenericData tempobj = new GenericData();
foreach (Status item in destinations)
{
tempobj = new GenericData();
tempobj.Code = item.code;
tempobj.Name = item.name;
tempobj.count = listpupils.Where(x => (x.Current_Status != null && x.status_code.Equals(item.code))).ToList().Count;
tempobj.sum = listpupils.Count();
tempobj.Percent = tempobj.sum != 0 ? tempobj.count * 100.0F / tempobj.sum : 0.0f;;
tempobj.sPercent = double.IsNaN(tempobj.count * 100.0F / tempobj.sum) ? "n/a" : NumberFormatHelper.FormatNumber(tempobj.Percent, 1).ToString();
tempobj.scount = tempobj.sPercent.Equals("n/a") ? "n/a" : tempobj.count.ToString();
//tempobj.sPercent = NumberFormatHelper.FormatNumber(tempobj.Percent, 1).ToString();
listdata.Add(tempobj);
}
return(listdata);
}