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 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 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 btn_reconcile_Click(object sender, EventArgs e) { checkPastRecon(); string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; if (Page.IsValid) { ClaimsRecon cObj = new ClaimsRecon(); try { string _monthList = AnthRecon.CheckReconOrder(yrmo, "Non-CA"); if (_monthList.Equals("")) { if (RptsImported()) { //AnthRecon.matchDFCl(yrmo); cObj.rfdfFirstVerification(yrmo); cObj.CompareFRD_DFClaims(yrmo); ShowResult(); auditRecon(yrmo); } } else { lbl_error.Text = "Reconciliation for " + _monthList + " not completed!"; } } catch (Exception ex) { cObj.DeleteNCAReconData(yrmo); lbl_error.Text = "Error in reconciling<br />" + ex.Message; } } }
protected void btn_reconAgn_Click(object sender, EventArgs e) { CAClaimsDAL cobj = new CAClaimsDAL(); string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; try { cobj.DeleteReconData(yrmo); if (RptsImported()) { AnthRecon.CAClaimsRecon(yrmo); cobj.retainForcedAdj(yrmo); ViewResult(); auditRecon(yrmo); } } catch (Exception ex) { MultiView1.SetActiveView(view_main); cobj.DeleteReconData(yrmo); lbl_error.Text = "Error in re-reconciliation.<br />" + ex.Message; } }
protected void btn_reconcile_Click(object sender, EventArgs e) { checkPastRecon(); CAClaimsDAL cobj = new CAClaimsDAL(); string yrmo = ddlYrmo.SelectedItem.Text; if (Page.IsValid) { lbl_error.Text = ""; try { string _monthList = AnthRecon.CheckReconOrder(yrmo, "CA"); if (_monthList.Equals("")) { if (RptsImported()) { AnthRecon.CAClaimsRecon(yrmo); ViewResult(); auditRecon(yrmo); } } else { lbl_error.Text = "Reconciliation for " + _monthList + " not completed!"; } } catch (Exception ex) { MultiView1.SetActiveView(view_main); cobj.DeleteReconData(yrmo); lbl_error.Text = "Error - " + ex.Message; } } }