示例#1
0
    protected void bindDfnoRfAdj(string prymo, string _dcn, string _ssn, string _pDate)
    {
        lblDupDetDFnoRF.Visible = false;
        grdvDupDetails.Visible  = false;
        lblNote1.Visible        = false;

        ClaimsRecon detObj = new ClaimsRecon();
        string      _yrmo  = detObj.latestReconYrmo();
        DataSet     ds1    = new DataSet();

        ds1.Clear();
        ds1 = detObj.DFnoRFAging(_yrmo, _dcn);
        if (ds1.Tables[0].Rows.Count > 0)
        {
            lblDupDetDFnoRF.Visible   = true;
            grdvDupDetails.Visible    = true;
            lblNote1.Visible          = true;
            grdvDupDetails.DataSource = ds1;
            grdvDupDetails.DataBind();
        }
        else
        {
            lblDupDetDFnoRF.Visible = false;
            grdvDupDetails.Visible  = false;
            lblNote1.Visible        = false;
        }

        DataSet ds2 = new DataSet(); ds2 = detObj.DFnoRFAging(prymo, _ssn, _dcn, _pDate);

        if (ds2.Tables[0].Rows.Count == 1)
        {
            dtvDFnoRF.DataSource = ds2;
            dtvDFnoRF.DataBind();
        }
    }
示例#2
0
    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 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 bindDFAging()
    {
        string      yrmo = ddlYrmo.SelectedItem.Text;
        DataSet     ds   = new DataSet();
        ClaimsRecon bobj = new ClaimsRecon();

        ds = bobj.DFnoRFAging(yrmo);

        if (ds.Tables[0].Rows.Count > 0)
        {
            grdvDFAging.DataSource = ds;
            grdvDFAging.DataBind();
        }
    }
示例#5
0
    protected void bindDFAging()
    {
        DataSet     ds   = new DataSet();
        ClaimsRecon bobj = new ClaimsRecon();
        string      yrmo = bobj.latestReconYrmo();

        if (!yrmo.Equals("-1"))
        {
            ds = bobj.DFnoRFAging(yrmo);
            //if (ds.Tables[0].Rows.Count > 0)
            //{
            grdvDFnoRF.DataSource = ds;
            grdvDFnoRF.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;
        }
    }