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();
}
}
