protected void rgRecordTypes_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) { GridDataItem item = e.Item as GridDataItem; RadHtmlChart progressChart = item["ProgressChartColumn"].FindControl("rhcProgress") as RadHtmlChart; int record_type_id = Convert.ToInt32(item.GetDataKeyValue("record_type_id")); DateTime date15MonthsAgo = DateTime.Now.AddMonths(-15); RecordProgressItem rpi = new RecordProgressItem(); var countsByRecordType = db.SP_RMS_Audit_Progress_by_recordtype(record_type_id, date15MonthsAgo).FirstOrDefault(); //Progress Chart Data rpi.TotalRecords = (int)countsByRecordType.total_sites; rpi.Audited = (int)countsByRecordType.audited; rpi.PercentAudited = rpi.TotalRecords > 0 ? Decimal.Divide((decimal)rpi.Audited, (decimal)rpi.TotalRecords) * 100 : 0; rpi.PercentAuditedString = rpi.TotalRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.Audited, (decimal)rpi.TotalRecords) * 100) : "0%"; List <RecordProgressItem> chartData = new List <RecordProgressItem>(); chartData.Add(rpi); progressChart.DataSource = chartData; progressChart.DataBind(); } }
protected void rgOffice_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) { GridDataItem item = e.Item as GridDataItem; RadHtmlChart allProgressChart = item["AllRecordsProgressChartColumn"].FindControl("rhcAllProgress") as RadHtmlChart; RadHtmlChart tsProgressChart = item["TSRecordsProgressChartColumn"].FindControl("rhcTSProgress") as RadHtmlChart; RadHtmlChart ntsProgressChart = item["NTSRecordsProgressChartColumn"].FindControl("rhcNTSProgress") as RadHtmlChart; int office_id = Convert.ToInt32(item.GetDataKeyValue("office_id")); RecordProgressItem rpi = new RecordProgressItem(); var allProgressChartData = db.SP_RMS_Progress_Report_by_office_id(office_id, rdpEndDt.SelectedDate, false, "no").FirstOrDefault(); var tsProgressChartData = db.SP_RMS_Progress_Report_by_office_id(office_id, rdpEndDt.SelectedDate, true, "yes").FirstOrDefault(); var ntsProgressChartData = db.SP_RMS_Progress_Report_by_office_id(office_id, rdpEndDt.SelectedDate, false, "yes").FirstOrDefault(); //All Records Progress Chart Data rpi.AllRecords = (int)allProgressChartData.TotalSites; rpi.AllAnalyzed = (int)allProgressChartData.Analyzed; rpi.AllApproved = (int)allProgressChartData.Approved; rpi.PercentAllAnalyzed = rpi.AllRecords > 0 ? Decimal.Divide((decimal)rpi.AllAnalyzed, (decimal)rpi.AllRecords) * 100 : 100; rpi.PercentAllApproved = rpi.AllRecords > 0 ? Decimal.Divide((decimal)rpi.AllApproved, (decimal)rpi.AllRecords) * 100 : 100; rpi.PercentAllAnalyzedString = rpi.AllRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.AllAnalyzed, (decimal)rpi.AllRecords) * 100) : "100%"; rpi.PercentAllApprovedString = rpi.AllRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.AllApproved, (decimal)rpi.AllRecords) * 100) : "100%"; //Time-Series Records Progress Chart Data rpi.TSRecords = (int)tsProgressChartData.TotalSites; rpi.TSAnalyzed = (int)tsProgressChartData.Analyzed; rpi.TSApproved = (int)tsProgressChartData.Approved; rpi.PercentTSAnalyzed = rpi.TSRecords > 0 ? Decimal.Divide((decimal)rpi.TSAnalyzed, (decimal)rpi.TSRecords) * 100 : 100; rpi.PercentTSApproved = rpi.TSRecords > 0 ? Decimal.Divide((decimal)rpi.TSApproved, (decimal)rpi.TSRecords) * 100 : 100; rpi.PercentTSAnalyzedString = rpi.TSRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TSAnalyzed, (decimal)rpi.TSRecords) * 100) : "100%"; rpi.PercentTSApprovedString = rpi.TSRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TSApproved, (decimal)rpi.TSRecords) * 100) : "100%"; //Non-Time-Series Records Progress Chart Data rpi.NTSRecords = (int)ntsProgressChartData.TotalSites; rpi.NTSAnalyzed = (int)ntsProgressChartData.Analyzed; rpi.NTSApproved = (int)ntsProgressChartData.Approved; rpi.PercentNTSAnalyzed = rpi.NTSRecords > 0 ? Decimal.Divide((decimal)rpi.NTSAnalyzed, (decimal)rpi.NTSRecords) * 100 : 100; rpi.PercentNTSApproved = rpi.NTSRecords > 0 ? Decimal.Divide((decimal)rpi.NTSApproved, (decimal)rpi.NTSRecords) * 100 : 100; rpi.PercentNTSAnalyzedString = rpi.NTSRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.NTSAnalyzed, (decimal)rpi.NTSRecords) * 100) : "100%"; rpi.PercentNTSApprovedString = rpi.NTSRecords > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.NTSApproved, (decimal)rpi.NTSRecords) * 100) : "100%"; List <RecordProgressItem> chartData = new List <RecordProgressItem>(); chartData.Add(rpi); allProgressChart.DataSource = chartData; allProgressChart.DataBind(); tsProgressChart.DataSource = chartData; tsProgressChart.DataBind(); ntsProgressChart.DataSource = chartData; ntsProgressChart.DataBind(); } }
protected void rgEmployees_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) { GridDataItem item = e.Item as GridDataItem; RadHtmlChart totalProgressChart = item["TotalProgressChartColumn"].FindControl("rhcTotalProgress") as RadHtmlChart; RadHtmlChart assignedProgressChart = item["AssignedProgressChartColumn"].FindControl("rhcAssignedProgress") as RadHtmlChart; RadHtmlChart assignedForAnalyzingChart = item["AssignedForAnalyzingChartColumn"].FindControl("rhcAssignedForAnalyzing") as RadHtmlChart; RadHtmlChart assignedForApprovingChart = item["AssignedForApprovingChartColumn"].FindControl("rhcAssignedForApproving") as RadHtmlChart; string user_id = item.GetDataKeyValue("user_id").ToString(); RecordProgressItem rpi = new RecordProgressItem(); var totalCountsForAnalyzer = db.SP_RMS_Progress_Counts_for_analyzer(user_id, rdpEndDt.SelectedDate, "total").FirstOrDefault(); var totalCountsForApprover = db.SP_RMS_Progress_Counts_for_approver(user_id, rdpEndDt.SelectedDate, "total").FirstOrDefault(); var assignedCountsForAnalyzer = db.SP_RMS_Progress_Counts_for_analyzer(user_id, rdpEndDt.SelectedDate, "assigned").FirstOrDefault(); var assignedCountsForApprover = db.SP_RMS_Progress_Counts_for_approver(user_id, rdpEndDt.SelectedDate, "assigned").FirstOrDefault(); //Total Progress Chart Data rpi.TotalRecordsAssignedToAnalyze = (int)totalCountsForAnalyzer.total_sites; rpi.TotalRecordsAssignedToApprove = (int)totalCountsForApprover.total_sites; rpi.TotalActuallyAnalyzed = (int)totalCountsForAnalyzer.analyzed; rpi.TotalActuallyApproved = (int)totalCountsForApprover.approved; rpi.PercentActuallyAnalyzed = rpi.TotalRecordsAssignedToAnalyze > 0 ? Decimal.Divide((decimal)rpi.TotalActuallyAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100 : 0; rpi.PercentActuallyApproved = rpi.TotalRecordsAssignedToApprove > 0 ? Decimal.Divide((decimal)rpi.TotalActuallyApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100 : 0; rpi.PercentActuallyAnalyzedString = rpi.TotalRecordsAssignedToAnalyze > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TotalActuallyAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100) : "0%"; rpi.PercentActuallyApprovedString = rpi.TotalRecordsAssignedToApprove > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TotalActuallyApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100) : "0%"; //Assigned Progress Chart Data rpi.TotalAssignedAnalyzed = (int)assignedCountsForAnalyzer.analyzed; rpi.TotalAssignedApproved = (int)assignedCountsForApprover.approved; rpi.PercentAssignedAnalyzed = rpi.TotalRecordsAssignedToAnalyze > 0 ? Decimal.Divide((decimal)rpi.TotalAssignedAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100 : 0; rpi.PercentAssignedApproved = rpi.TotalRecordsAssignedToApprove > 0 ? Decimal.Divide((decimal)rpi.TotalAssignedApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100 : 0; rpi.PercentAssignedAnalyzedString = rpi.TotalRecordsAssignedToAnalyze > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TotalAssignedAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100) : "0%"; rpi.PercentAssignedApprovedString = rpi.TotalRecordsAssignedToApprove > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.TotalAssignedApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100) : "0%"; //Records Assigned For Analyzing Chart Data rpi.RecordsAssignedToAnalyzeAnalyzed = (int)assignedCountsForAnalyzer.analyzed; rpi.RecordsAssignedToAnalyzeApproved = (int)assignedCountsForAnalyzer.approved; rpi.PercentRecordsAssignedToAnalyzeAnalyzed = rpi.TotalRecordsAssignedToAnalyze > 0 ? Decimal.Divide((decimal)rpi.RecordsAssignedToAnalyzeAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100 : 0; rpi.PercentRecordsAssignedToAnalyzeApproved = rpi.TotalRecordsAssignedToAnalyze > 0 ? Decimal.Divide((decimal)rpi.RecordsAssignedToAnalyzeApproved, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100 : 0; rpi.PercentRecordsAssignedToAnalyzeAnalyzedString = rpi.TotalRecordsAssignedToAnalyze > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.RecordsAssignedToAnalyzeAnalyzed, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100) : "0%"; rpi.PercentRecordsAssignedToAnalyzeApprovedString = rpi.TotalRecordsAssignedToAnalyze > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.RecordsAssignedToAnalyzeApproved, (decimal)rpi.TotalRecordsAssignedToAnalyze) * 100) : "0%"; //Records Assigned For Approving Chart Data rpi.RecordsAssignedToApproveAnalyzed = (int)assignedCountsForApprover.analyzed; rpi.RecordsAssignedToApproveApproved = (int)assignedCountsForApprover.approved; rpi.PercentRecordsAssignedToApproveAnalyzed = rpi.TotalRecordsAssignedToApprove > 0 ? Decimal.Divide((decimal)rpi.RecordsAssignedToApproveAnalyzed, (decimal)rpi.TotalRecordsAssignedToApprove) * 100 : 0; rpi.PercentRecordsAssignedToApproveApproved = rpi.TotalRecordsAssignedToApprove > 0 ? Decimal.Divide((decimal)rpi.RecordsAssignedToApproveApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100 : 0; rpi.PercentRecordsAssignedToApproveAnalyzedString = rpi.TotalRecordsAssignedToApprove > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.RecordsAssignedToApproveAnalyzed, (decimal)rpi.TotalRecordsAssignedToApprove) * 100) : "0%"; rpi.PercentRecordsAssignedToApproveApprovedString = rpi.TotalRecordsAssignedToApprove > 0 ? String.Format("{0:###.##}%", Decimal.Divide((decimal)rpi.RecordsAssignedToApproveApproved, (decimal)rpi.TotalRecordsAssignedToApprove) * 100) : "0%"; List <RecordProgressItem> chartData = new List <RecordProgressItem>(); chartData.Add(rpi); totalProgressChart.DataSource = chartData; totalProgressChart.DataBind(); assignedProgressChart.DataSource = chartData; assignedProgressChart.DataBind(); assignedForAnalyzingChart.DataSource = chartData; assignedForAnalyzingChart.DataBind(); assignedForApprovingChart.DataSource = chartData; assignedForApprovingChart.DataBind(); } }