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