protected void lnkAdjCF3_OnClick(object sender, EventArgs e)
{
lblErrRep.Text = "";
ClaimsRecon repObj3 = new ClaimsRecon();
DataSet ds = new DataSet();
ds.Clear();
string yrmo = repObj3.latestReconYrmo();
string _prevYrmo = AnthRecon.prevYRMO(yrmo);
string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo);
DataSet dsmismatchCF = new DataSet();
dsmismatchCF.Clear();
string filename = "DFRF_Amount_Mismatch_Aging_" + yrmo;
string[][] cols = { new string[] { "YRMO", "Claim ID", "Anthem DF Counter", "DFRF Counter", "Anthem DF Amount", "DFRF Amount", "Variance", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } };
string[][] colsFormat = { new string[] { "string", "string", "number", "number", "decimal", "decimal", "decimal", "decimal", "decimal", "decimal" } };
string[] sheetnames = { "Amount_mismatch_Aging" };
string[] titles = { "Aging Report of Amount mismatch Records for " + yrmo };
try
{
dsmismatchCF = repObj3.getMismatchCF(yrmo);
ExcelReport.ExcelXMLRpt(dsmismatchCF, filename, sheetnames, titles, cols, colsFormat);
}
catch (Exception ex)
{
lblErrRep.Text = "Error in generating excel report" + ex.Message;
}
}
protected void btn_xlDFRFmismatchAging_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
string _prevYrmo = AnthRecon.prevYRMO(yrmo);
string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo);
ClaimsRecon repObj3 = new ClaimsRecon();
DataSet dsmismatchCF = new DataSet();
dsmismatchCF.Clear();
string filename = "DFRF_Amount_Mismatch_Aging_" + yrmo;
string[][] cols = { new string[] { "YRMO", "Claim ID", "Anthem DF Counter", "DFRF Counter", "Anthem DF Amount", "DFRF Amount", "Variance", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } };
string[][] colsFormat = { new string[] { "string", "string", "number", "number", "decimal", "decimal", "decimal", "decimal", "decimal", "decimal" } };
string[] sheetnames = { "Amount_mismatch_Aging" };
string[] titles = { "Aging Report of Amount mismatch Records for " + yrmo };
try
{
dsmismatchCF = repObj3.getMismatchCF(yrmo);
ExcelReport.ExcelXMLRpt(dsmismatchCF, filename, sheetnames, titles, cols, colsFormat);
}
catch (Exception ex)
{
MultiView1.SetActiveView(view_main);
lbl_error.Text = "Error in generating excel report" + ex.Message;
}
}
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;
}
}
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;
}
}