protected void bindResult(string _src)
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
string yrmo = ddlYrmo.SelectedItem.Text;
switch (_src)
{
case "ACT":
ds = ReconDAL.GetDomReconData(yrmo, "ACT");
grdvActResult.DataSource = ds;
grdvActResult.DataBind();
break;
case "RET":
ds = ReconDAL.GetDomReconData(yrmo, "RET");
grdvRetResult.DataSource = ds;
grdvRetResult.DataBind();
break;
case "COB":
ds = ReconDAL.GetDomReconData(yrmo, "COB");
grdvCobResult.DataSource = ds;
grdvCobResult.DataBind();
break;
}
}
private void SortGridView(string sortExpression, string direction, string source)
{
// You can cache the DataTable for improving performance
string yrmo = ddlYrmo.SelectedItem.Text;
DataTable dt = ReconDAL.GetDomReconData(yrmo, source).Tables[0];
DataView dv = new DataView(dt);
dv.Sort = sortExpression + direction;
switch (source)
{
case "ACT":
grdvActResult.DataSource = dv;
grdvActResult.DataBind();
break;
case "RET":
grdvRetResult.DataSource = dv;
grdvRetResult.DataBind();
break;
case "COB":
grdvCobResult.DataSource = dv;
grdvCobResult.DataBind();
break;
}
}
protected void btn_genRpt_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
DataSet ds = new DataSet();
DataSet dsFinal = new DataSet();
dsFinal.Clear();
string[][] cols = { new string[] { "Reconciliation Type", "EBA Count", "EBA Amount", "Anthem Count", "Anthem Amount", "EBA Count Variance" },
new string[] { "YRMO", "Anthem Group Suffix", "Anthem Covg. Code", "EBA Count", "EBA Amount", "Anthem Count", "Anthem Amount", "EBA Count Variance", "EBA vs Anthem % Count Variance", "Threshold", "Threshold Level"},
new string[] { "YRMO", "Anthem Group Suffix", "Anthem Covg. Code", "EBA Count", "EBA Amount", "Anthem Count", "Anthem Amount", "EBA Count Variance", "EBA vs Anthem % Count Variance", "Threshold", "Threshold Level"},
new string[] { "YRMO", "Anthem Group Suffix", "Anthem Covg. Code", "EBA Count", "EBA Amount", "Anthem Count", "Anthem Amount", "EBA Count Variance", "EBA vs Anthem % Count Variance", "Threshold", "Threshold Level"} };
string[][] colsFormat = { new string[] { "string", "number", "decimal", "number", "decimal", "number" },
new string[] { "string", "string", "string", "number", "decimal", "number", "decimal", "number", "decimal", "decimal", "string"},
new string[] { "string", "string", "string", "number", "decimal", "number", "decimal", "number", "decimal", "decimal", "string"},
new string[] { "string", "string", "string", "number", "decimal", "number", "decimal", "number", "decimal", "decimal", "string"} };
string[] sheetnames = { "Summary", "Active", "Retiree", "Cobra" };
string[] titles = { "Domestic Billing Reconciliation Summary for YRMO - " + yrmo, "Active Billing Reconciliation for YRMO - " + yrmo, "Retiree Billing Reconciliation for YRMO - " + yrmo, "Cobra Billing Reconciliation for YRMO - " + yrmo };
try
{
ds = ReconDAL.GetDomSummary(yrmo);
ds.Tables[0].TableName = "sumTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[0].TableName = "sumTableF";
ds.Clear();
ds = ReconDAL.GetDomReconData(yrmo, "ACT");
ds.Tables[0].TableName = "actTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[1].TableName = "actTableF";
ds.Clear();
ds = ReconDAL.GetDomReconData(yrmo, "RET");
ds.Tables[0].TableName = "retTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[2].TableName = "retTableF";
ds.Clear();
ds = ReconDAL.GetDomReconData(yrmo, "COB");
ds.Tables[0].TableName = "cobTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[3].TableName = "cobTableF";
ds.Clear();
ExcelReport.ExcelXMLRpt(dsFinal, "DomesticRecon_" + yrmo, sheetnames, titles, cols, colsFormat);
}
catch (Exception ex)
{
MultiView1.SetActiveView(view_main);
lbl_error.Text = "Error in generating excel report" + ex.Message;
}
}