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