Пример #1
0
    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;
        }
    }
Пример #3
0
    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;
        }
    }