public ltrTopTenAmtByHospital(DataSet ds) { // // Required for telerik Reporting designer support // InitializeComponent(); DataTable dt = null; DataTable dt2 = null; if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { dt = ds.Tables[0]; dt2 = ds.Tables[1]; dt.TableName = "ReportByAmtVisits"; table1.DataSource = dt; if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "ABH") { txtReport.Value = "Report Claim Analysis By Top Ten Amount By Hospital/Clinic"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Amount By Hospital/Clinic"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "A_Percentage", "Hospital"); } else if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "VBH") { txtReport.Value = "Report Claim Analysis By Top Ten Visits By Hospital/Clinic"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Visits By Hospital/Clinic"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "V_Percentage", "Hospital"); } else if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "ABD") { txtReport.Value = "Report Claim Analysis By Top Ten Amount By Disease"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Amount By Disease"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "A_Percentage", "DISEASE"); } else if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "VBD") { txtReport.Value = "Report Claim Analysis By Top Ten Visits By Disease"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Visits By Disease"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "V_Percentage", "DISEASE"); } else if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "ABM") { txtReport.Value = "Report Claim Analysis By Top Ten Amount By Member"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Amount By Member"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "A_Percentage", "Name"); } else if (dt.Rows.Count > 0 && dt.Rows[0]["ReportType"].ToString() == "VBM") { txtReport.Value = "Report Claim Analysis By Top Ten Visits By Member"; _PieChartAmount.ChartTitle.TextBlock.Text = "Top Ten Visits By Member"; ReportsUtility.GeneratePieChart(dt2, _PieChartAmount, "V_Percentage", "Name"); } if (dt.Rows.Count > 0 && dt.Columns[0].ToString() == "HOSPITAL") { txtSortBy.Value = "Hospital / Clinic Name"; txtSortValue.Value = "=HOSPITAL"; } else if (dt.Rows.Count > 0 && dt.Columns[0].ToString() == "DISEASE") { txtSortBy.Value = "Disease"; txtSortValue.Value = "=DISEASE"; } else if (dt.Rows.Count > 0 && dt.Columns[0].ToString() == "Name") { txtSortBy.Value = "Member"; txtSortValue.Value = "=Name"; } } // // TODO: Add any constructor code after InitializeComponent call // }
public ltrClaimTop10HospitalBenefit(DataSet ds) { // // Required for telerik Reporting designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // DataTable dt = null; if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { dt = ds.Tables[0]; tblNormal.DataSource = dt; if (dt.Rows.Count > 0 && dt.Columns[1].ToString() == "HOSPITAL") { // tblNormal.ColumnGroups.RemoveAt(1); // tblNormal.Body.Columns.Remove(tblNormal.Body.Columns[1]); tblNormal.Visible = false; tblMember.Visible = true; tblMember.DataSource = dt; tblMember.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Pixel(0), Telerik.Reporting.Drawing.Unit.Pixel(250)); txtReport.Value = "Report Claim Analysis By Top Ten Amount Of Hospital / Clinic All Benefit"; txtsortByMember.Value = "Hospital / Clinic Name"; txtsortValueMember.Value = "=HOSPITAL"; //txtSortBy.Value = "Hospital / Clinic Name"; // txtSortByThai.Value = "Hospital / Clinic Name"; //txtSortValue.Value = "=HOSPITAL"; // txtSortValueThai.Value = "=HOSPITAL"; _PieChartAmount.ChartTitle.TextBlock.Text = "Claim Cost Amount"; _pieChartFrequency.ChartTitle.TextBlock.Text = "Claim Frequency of Visits"; ReportsUtility.GeneratePieChart(dt, _PieChartAmount, "A_Percentage", "Hospital"); ReportsUtility.GeneratePieChart(dt, _pieChartFrequency, "F_Percentage", "Hospital"); } else if (dt.Rows.Count > 0 && dt.Columns[1].ToString() == "DISEASE") { txtReport.Value = "Report Claim Analysis By Top Ten Amount Of Disease All Benefit"; txtSortBy.Value = "Disease"; txtSortByThai.Value = "Disease Thai"; txtSortValue.Value = "=DISEASE"; txtSortValueThai.Value = "=DISEASE_THAI"; tblNormal.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Pixel(0), Telerik.Reporting.Drawing.Unit.Pixel(250)); _PieChartAmount.ChartTitle.TextBlock.Text = "Claim Cost Amount"; _pieChartFrequency.ChartTitle.TextBlock.Text = "Claim Frequency of Visits"; ReportsUtility.GeneratePieChart(dt, _PieChartAmount, "A_Percentage", "DISEASE"); ReportsUtility.GeneratePieChart(dt, _pieChartFrequency, "F_Percentage", "DISEASE"); } else if (dt.Rows.Count > 0 && dt.Columns[1].ToString() == "Name") { tblNormal.Visible = false; tblMember.Visible = true; tblMember.DataSource = dt; tblMember.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Pixel(0), Telerik.Reporting.Drawing.Unit.Pixel(250)); txtReport.Value = "Report Claim Analysis By Top Ten Amount Of Member All Benefit"; txtsortByMember.Value = "Member Name"; txtsortValueMember.Value = "=Name"; _PieChartAmount.ChartTitle.TextBlock.Text = "Claim Cost Amount"; _pieChartFrequency.ChartTitle.TextBlock.Text = "Claim Frequency of Visits"; ReportsUtility.GeneratePieChart(dt, _PieChartAmount, "A_Percentage", "Name"); ReportsUtility.GeneratePieChart(dt, _pieChartFrequency, "F_Percentage", "Name"); } } }