예제 #1
0
    protected void lnk_genDtlRpt_OnClick(object sender, EventArgs e)
    {
        string      yrmo    = ddlYrmo.SelectedItem.Text;
        CAExcelRpt  xlobj   = new CAExcelRpt();
        CAClaimsDAL caobj   = new CAClaimsDAL();
        DataSet     dsFinal = new DataSet();

        dsFinal.Clear();
        DataSet ds = new DataSet();

        ds.Clear();
        string filename = "CA_Claims_Recon_detail_" + yrmo;

        string[]   sheetnames = { "matched_Check&Amt", "mismatched_Amounts", "unmatchedCheck_Anthem", "unmatchedCheck_BOA", "duplicate_checks" };
        string[]   titles     = { "California Claims Reconciliation Matched Records by Check# and Amount for " + yrmo,
                                  "California Claims Reconciliation Mismatched Amount Records for " + yrmo,
                                  "California Claims Reconciliation Un-Matched Check Records from Anthem for " + yrmo,
                                  "California Claims Reconciliation Un-Matched Check Records from BOA for " + yrmo,
                                  "California Claims Reconciliation Duplicate Check Record Details for " + yrmo };
        string[][] colsFormat = { new string[] { "string",   "string",   "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string",  "decimal", "decimal" },
                                  new string[] { "string",   "string",   "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string",  "decimal", "decimal" },
                                  new string[] { "checknum", "string",   "string",   "string", "string", "string", "string", "string", "decimal" },
                                  new string[] { "checknum", "string",   "string",   "decimal" },
                                  new string[] { "string",   "checknum", "string",   "string", "string", "string", "string", "string", "string",  "string", "decimal", "decimal", "string"  } };

        try
        {
            ds = caobj.GetMatchedChecknAmtRecords(yrmo);
            ds.Tables[0].TableName = "matchedTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[0].TableName = "matchedTableF";
            ds.Clear();
            ds = caobj.GetAmtMismatchCheckRecords(yrmo);
            ds.Tables[0].TableName = "mismatchAmtTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[1].TableName = "mismatchAmtTableF";
            ds.Clear();
            ds = caobj.GetAnthMismatch(yrmo);
            ds.Tables[0].TableName = "AnthUnmatchedTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[2].TableName = "AnthUnmatchedTableF";
            ds.Clear();
            ds = caobj.GetBOAMismatch(yrmo);
            ds.Tables[0].TableName = "BOAUnmatchedTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[3].TableName = "BOAUnmatchedTableF";
            ds.Clear();
            ds = caobj.GetDupChecksDetails(yrmo);
            ds.Tables[0].TableName = "DupDtlTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[4].TableName = "DupDtlTableF";
            ds.Clear();
            xlobj.ExcelXMLRpt(dsFinal, filename, sheetnames, titles, colsFormat);
        }
        catch (Exception ex)
        {
            lbl_error.Text = "Error in generating CA Claims Report of matched and mismatched records for YRMO - " + yrmo + "<br />" + ex.Message;
        }
    }
예제 #2
0
    protected void lnk_genDtlRptA2_OnClick(object sender, EventArgs e)
    {
        string filename = "Planhier_Rate_Audit";

        string[]   sheetnames = { "rate_audit" };
        string[]   titles     = { "Audit Information for Planhier Rates" };
        string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string", "string", "string" } };
        CAExcelRpt xlobj      = new CAExcelRpt();
        DataSet    dsrptA2    = new DataSet();

        dsrptA2 = BenhierDAL.getRateAuditReport();
        xlobj.ExcelXMLRpt(dsrptA2, filename, sheetnames, titles, colsFormat);
    }
예제 #3
0
    protected void lnk_genDtlRptA1_OnClick(object sender, EventArgs e)
    {
        string filename = "Benefit_Hierarchy_Audit";

        string[]   sheetnames = { "ben_audit" };
        string[]   titles     = { "Audit Information for Benefit Hierarchy" };
        string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string" } };
        CAExcelRpt xlobj      = new CAExcelRpt();
        DataSet    dsrptA1    = new DataSet();

        dsrptA1 = BenhierDAL.getPlanhierAuditReport();
        xlobj.ExcelXMLRpt(dsrptA1, filename, sheetnames, titles, colsFormat);
    }
    protected void lnkAdjCF_OnClick(object sender, EventArgs e)
    {
        lblErrRep.Text = "";
        CAClaimsDAL caobj   = new CAClaimsDAL();
        CAExcelRpt  xlobj   = new CAExcelRpt();
        DataSet     dsFinal = new DataSet();

        dsFinal.Clear();
        DataSet ds = new DataSet();

        ds.Clear();

        string yrmo     = caobj.getLatestYRMOAdj();
        string filename = "CA_Claims_CFAging_" + yrmo;

        string[]   sheetnames = { "mismatched_amounts_CF", "unmatched_Anthem_CF", "unmatched_BOA_CF", "duplicate_checks_CF" };
        string[]   titles     = { "Mismatched Amount Carry Forwards with Aging for YRMO : " + yrmo, "Un-Matched Carry Forwards from Anthem with Aging for YRMO : " + yrmo, "Un-Matched Carry Forwards from BOA with Aging for YRMO : " + yrmo, "Duplicate Check Carry Forwards with Aging for YRMO : " + yrmo };
        string[][] colsFormat = { new string[] { "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string", "decimal", "decimal", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "checknum", "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" } };

        try
        {
            ds = caobj.GetAmtMismatchAging(yrmo);
            ds.Tables[0].TableName = "matchTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[0].TableName = "matchTableF";
            ds.Clear();
            ds = caobj.GetAnthMismatchAging(yrmo);
            ds.Tables[0].TableName = "AnthUnmatchTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[1].TableName = "AnthUnmatchTableF";
            ds.Clear();
            ds = caobj.GetBOAMismatchAging(yrmo);
            ds.Tables[0].TableName = "BOAUnmatchTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[2].TableName = "BOAUnmatchTableF";
            ds.Clear();
            ds = caobj.GetDupsAging(yrmo);
            ds.Tables[0].TableName = "DupTable";
            dsFinal.Tables.Add(ds.Tables[0].Copy());
            dsFinal.Tables[2].TableName = "DupTableF";
            ds.Clear();
            xlobj.ExcelXMLRpt(dsFinal, filename, sheetnames, titles, colsFormat);
        }
        catch (Exception ex)
        {
            lblErrRep.Text = "Error in generating Carry Forward report with aging for YRMO - " + yrmo + "<br />" + ex.Message;
        }
    }