Beispiel #1
0
    protected void bindDfRfAdj(string prymo, string _dcn, string _ssn, string _uDate)
    {
        lblDupDetDFRF.Visible      = false;
        grdvDupDetailsDFRF.Visible = false;
        lblNote2.Visible           = false;

        ClaimsRecon detObj1 = new ClaimsRecon();
        string      _yrmo   = detObj1.latestReconYrmo();
        DataSet     ds1DFRF = new DataSet();

        ds1DFRF.Clear();
        ds1DFRF = detObj1.DFRFAging(_yrmo, _dcn);
        if (ds1DFRF.Tables[0].Rows.Count > 0)
        {
            lblDupDetDFRF.Visible         = true;
            grdvDupDetailsDFRF.Visible    = true;
            lblNote2.Visible              = true;
            grdvDupDetailsDFRF.DataSource = ds1DFRF;
            grdvDupDetailsDFRF.DataBind();
        }
        else
        {
            lblDupDetDFRF.Visible      = false;
            grdvDupDetailsDFRF.Visible = false;
            lblNote2.Visible           = false;
        }

        DataSet ds2DFRF = new DataSet(); ds2DFRF = detObj1.DFRFAging(prymo, _ssn, _dcn, _uDate);

        if (ds2DFRF.Tables[0].Rows.Count == 1)
        {
            dtvDFRF.DataSource = ds2DFRF;
            dtvDFRF.DataBind();
        }
    }
Beispiel #2
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;
        }
    }
Beispiel #3
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 bindDFRFAging()
    {
        string      yrmo  = ddlYrmo.SelectedItem.Text;
        DataSet     ds    = new DataSet();
        ClaimsRecon bobj1 = new ClaimsRecon();

        ds = bobj1.DFRFAging(yrmo);

        if (ds.Tables[0].Rows.Count > 0)
        {
            grdvDFRFAging.DataSource = ds;
            grdvDFRFAging.DataBind();
        }
    }
Beispiel #5
0
    protected void bindDFRFAging()
    {
        DataSet     ds    = new DataSet();
        ClaimsRecon bobj1 = new ClaimsRecon();
        string      yrmo  = bobj1.latestReconYrmo();

        if (!yrmo.Equals("-1"))
        {
            ds = bobj1.DFRFAging(yrmo);

            //if (ds.Tables[0].Rows.Count > 0)
            //{
            grdvDFRF.DataSource = ds;
            grdvDFRF.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;
        }
    }