protected void bindDfnoRfAdj(string prymo, string _dcn, string _ssn, string _pDate)
{
lblDupDetDFnoRF.Visible = false;
grdvDupDetails.Visible = false;
lblNote1.Visible = false;
ClaimsRecon detObj = new ClaimsRecon();
string _yrmo = detObj.latestReconYrmo();
DataSet ds1 = new DataSet();
ds1.Clear();
ds1 = detObj.DFnoRFAging(_yrmo, _dcn);
if (ds1.Tables[0].Rows.Count > 0)
{
lblDupDetDFnoRF.Visible = true;
grdvDupDetails.Visible = true;
lblNote1.Visible = true;
grdvDupDetails.DataSource = ds1;
grdvDupDetails.DataBind();
}
else
{
lblDupDetDFnoRF.Visible = false;
grdvDupDetails.Visible = false;
lblNote1.Visible = false;
}
DataSet ds2 = new DataSet(); ds2 = detObj.DFnoRFAging(prymo, _ssn, _dcn, _pDate);
if (ds2.Tables[0].Rows.Count == 1)
{
dtvDFnoRF.DataSource = ds2;
dtvDFnoRF.DataBind();
}
}
private void SortGridView(string sortExpression, string direction, string source)
{
ClaimsRecon repObj = new ClaimsRecon();
DataTable dt;
DataView dv;
string yrmo = repObj.latestReconYrmo();
switch (source)
{
case "DFAging":
dt = repObj.DFnoRFAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDFnoRF.DataSource = dv;
grdvDFnoRF.DataBind();
break;
case "DFRFAging":
dt = repObj.DFRFAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDFRF.DataSource = dv;
grdvDFRF.DataBind();
break;
case "DFRFmismatchAging":
//dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0];
dt = repObj.getMismatchCF(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvmismatchDFRF.DataSource = dv;
grdvmismatchDFRF.DataBind();
break;
}
}
protected void btn_xlDFAging_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
string _prevYrmo = AnthRecon.prevYRMO(yrmo);
string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo);
ClaimsRecon repObj1 = new ClaimsRecon();
DataSet ds = new DataSet();
ds.Clear();
DataSet dsSummary = new DataSet();
dsSummary.Clear();
string filename = "DF_no_RF_Aging_" + yrmo;
string[][] cols = { new string[] { "YRMO", "SSN", "Claim #", "Name", "Service From Dt", "Service Thru Dt", "Paid date", "Claim Type", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" } };
string[] sheetnames = { "DF_no_RF_Aging" };
string[] titles = { "Aging Report of Open DFs not on Anthem's DF no RF report for " + yrmo };
string[] sumTitles = { "Summary Statistics for Aging Report", "Detail Aging Report" };
string[][] sumColsFormat = { new string[] { "string", "number", "number", "decimal", "decimal" } };
try
{
ds = repObj1.DFnoRFAging(yrmo);
dsSummary = repObj1.getSummary(yrmo, "DFnoRF");
ExcelReport.ExcelXMLRpt(ds, filename, sheetnames, titles, cols, colsFormat, dsSummary, sumTitles, sumColsFormat);
}
catch (Exception ex)
{
MultiView1.SetActiveView(view_main);
lbl_error.Text = "Error in generating excel report" + ex.Message;
}
}
protected void bindDFAging()
{
string yrmo = ddlYrmo.SelectedItem.Text;
DataSet ds = new DataSet();
ClaimsRecon bobj = new ClaimsRecon();
ds = bobj.DFnoRFAging(yrmo);
if (ds.Tables[0].Rows.Count > 0)
{
grdvDFAging.DataSource = ds;
grdvDFAging.DataBind();
}
}
protected void bindDFAging()
{
DataSet ds = new DataSet();
ClaimsRecon bobj = new ClaimsRecon();
string yrmo = bobj.latestReconYrmo();
if (!yrmo.Equals("-1"))
{
ds = bobj.DFnoRFAging(yrmo);
//if (ds.Tables[0].Rows.Count > 0)
//{
grdvDFnoRF.DataSource = ds;
grdvDFnoRF.DataBind();
//}
}
}
private void SortGridView(string sortExpression, string direction, string source)
{
ClaimsRecon repObj = new ClaimsRecon();
DataTable dt;
DataView dv;
string yrmo = ddlYrmo.SelectedItem.Text;
switch (source)
{
case "recon":
dt = repObj.DF_DFRFClaimsRecon(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvResult.DataSource = dv;
grdvResult.DataBind();
break;
case "DFAging":
//dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0];
dt = repObj.DFnoRFAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDFAging.DataSource = dv;
grdvDFAging.DataBind();
break;
case "DFRFAging":
//dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0];
dt = repObj.DFRFAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDFRFAging.DataSource = dv;
grdvDFRFAging.DataBind();
break;
case "DFRFmismatchAging":
//dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0];
dt = repObj.getMismatchCF(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDFRFmismatchAging.DataSource = dv;
grdvDFRFmismatchAging.DataBind();
break;
case "recon_matched":
dt = ReconDAL.getMatchedDCNAmnt(yrmo, "Matched").Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvMatched.DataSource = dv;
grdvMatched.DataBind();
break;
case "recon_mismatched":
dt = ReconDAL.getMatchedDCNAmnt(yrmo, "UnMatched").Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvMatched.DataSource = dv;
grdvMatched.DataBind();
break;
case "recon_unmatchDFRF":
dt = ReconDAL.getRFDFUM(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvUnmatchedDFRF.DataSource = dv;
grdvUnmatchedDFRF.DataBind();
break;
case "recon_unmatchAnth":
dt = ReconDAL.getClaimsUM(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvUnmatchedAnth.DataSource = dv;
grdvUnmatchedAnth.DataBind();
break;
}
}