protected void bindDfRfAdj(string prymo, string _dcn, string _ssn, string _uDate)
{
lblDupDetDFRF.Visible = false;
grdvDupDetailsDFRF.Visible = false;
lblNote2.Visible = false;
ClaimsRecon detObj1 = new ClaimsRecon();
string _yrmo = detObj1.latestReconYrmo();
DataSet ds1DFRF = new DataSet();
ds1DFRF.Clear();
ds1DFRF = detObj1.DFRFAging(_yrmo, _dcn);
if (ds1DFRF.Tables[0].Rows.Count > 0)
{
lblDupDetDFRF.Visible = true;
grdvDupDetailsDFRF.Visible = true;
lblNote2.Visible = true;
grdvDupDetailsDFRF.DataSource = ds1DFRF;
grdvDupDetailsDFRF.DataBind();
}
else
{
lblDupDetDFRF.Visible = false;
grdvDupDetailsDFRF.Visible = false;
lblNote2.Visible = false;
}
DataSet ds2DFRF = new DataSet(); ds2DFRF = detObj1.DFRFAging(prymo, _ssn, _dcn, _uDate);
if (ds2DFRF.Tables[0].Rows.Count == 1)
{
dtvDFRF.DataSource = ds2DFRF;
dtvDFRF.DataBind();
}
}
protected void lnkAdjCF2_OnClick(object sender, EventArgs e)
{
lblErrRep.Text = "";
ClaimsRecon repObj2 = new ClaimsRecon();
DataSet ds = new DataSet();
ds.Clear();
string yrmo = repObj2.latestReconYrmo();
string _prevYrmo = AnthRecon.prevYRMO(yrmo);
string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo);
DataSet dsSummary = new DataSet();
dsSummary.Clear();
string filename = "DF_RF_Aging_" + yrmo;
string[][] cols = { new string[] { "YRMO", "Member ID", "DCN", "Last Update", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "decimal", "decimal", "decimal", "decimal" } };
string[] sheetnames = { "DF_RF_Aging" };
string[] titles = { "Aging Report of records cleared from DF no RF, not cleared in DF/RF for " + yrmo };
string[] sumTitles = { "Summary Statistics for Aging Report", "Detail Aging Report" };
string[][] sumColsFormat = { new string[] { "string", "number", "number", "decimal", "decimal" } };
try
{
ds = repObj2.DFRFAging(yrmo);
dsSummary = repObj2.getSummary(yrmo, "DFRF");
ExcelReport.ExcelXMLRpt(ds, filename, sheetnames, titles, cols, colsFormat, dsSummary, sumTitles, sumColsFormat);
}
catch (Exception ex)
{
lblErrRep.Text = "Error in generating excel report" + ex.Message;
}
}
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 bindDFRFAging()
{
string yrmo = ddlYrmo.SelectedItem.Text;
DataSet ds = new DataSet();
ClaimsRecon bobj1 = new ClaimsRecon();
ds = bobj1.DFRFAging(yrmo);
if (ds.Tables[0].Rows.Count > 0)
{
grdvDFRFAging.DataSource = ds;
grdvDFRFAging.DataBind();
}
}
protected void bindDFRFAging()
{
DataSet ds = new DataSet();
ClaimsRecon bobj1 = new ClaimsRecon();
string yrmo = bobj1.latestReconYrmo();
if (!yrmo.Equals("-1"))
{
ds = bobj1.DFRFAging(yrmo);
//if (ds.Tables[0].Rows.Count > 0)
//{
grdvDFRF.DataSource = ds;
grdvDFRF.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;
}
}
