internal static DMPieChartParentModel GetDataForPieChartEmployee(List <VAT_DailyAttendance> AttList, DMPieChartParentModel vm) { if (AttList.Count > 0) { vm.HeaderRight = "Employees for " + AttList.FirstOrDefault().OUName; vm.HeaderDescription = "Click on below employee to view its details"; List <DMParentModel> dmList = new List <DMParentModel>(); foreach (var id in AttList.Select(aa => aa.EmpID).Distinct().ToList()) { if (AttList.Where(aa => aa.EmpID == id).Count() > 0) { DMParentModel dmObj = new DMParentModel(); dmObj.ID = (int)id; dmObj.NameWithDetail = AttList.Where(aa => aa.EmpID == id).First().EmployeeName + " (" + AttList.Where(aa => aa.EmpID == id).First().JobTitleName + ")"; dmObj.Name = AttList.Where(aa => aa.EmpID == id).First().EmployeeName; dmObj.Count = AttList.Where(aa => aa.EmpID == id).Count(); dmList.Add(dmObj); } } vm.ChildList = dmList.OrderByDescending(aa => aa.Count).ToList(); } return(vm); }
internal static DMPieChartParentModel GetDataForPieChartCommonOU(List <VAT_DailyAttendance> AttList, DMPieChartParentModel vm) { if (AttList.Count > 0) { vm.HeaderRight = "Common Organizational Units"; vm.HeaderDescription = "Click on below common organizational unit to view its details"; List <DMParentModel> dmList = new List <DMParentModel>(); foreach (var id in AttList.Select(aa => aa.OUCommonID).Distinct().ToList()) { if (AttList.Where(aa => aa.OUCommonID == id).Count() > 0 && id != null) { DMParentModel dmObj = new DMParentModel(); dmObj.ID = (int)id; dmObj.Name = AttList.Where(aa => aa.OUCommonID == id).First().OUCommonName; dmObj.NameWithDetail = AttList.Where(aa => aa.OUCommonID == id).First().OUCommonName; dmObj.Count = AttList.Where(aa => aa.OUCommonID == id).Count(); dmList.Add(dmObj); } } vm.ChildList = dmList.OrderByDescending(aa => aa.Count).ToList(); } return(vm); }