예제 #1
0
        public DataSet GetHTHAnthemRpt(string yrmo, string plancode)
        {
            IPBA_DAL dobj = new IPBA_DAL();

            string[] programs = { "Active", "Active Pilot", "COBRA", "COBRA Pilot" };
            string[] tiercds  = { "E", "C", "S", "F" };
            DataSet  dsTemp   = new DataSet(); dsTemp.Clear();
            DataSet  dsDet    = new DataSet(); dsDet.Clear();

            DataRow[] rows;


            dsTemp = dobj.GetDetData(yrmo, plancode);
            dsDet  = dsTemp.Clone();

            foreach (string program in programs)
            {
                foreach (string tiercd in tiercds)
                {
                    rows = GetDetRows(program, tiercd, dsTemp); dsDet.Merge(rows);
                }
            }

            dsDet.Tables[0].Columns["Class"].ColumnName  = "progcd";
            dsDet.Tables[0].Columns["Type"].ColumnName   = "ptype";
            dsDet.Tables[0].Columns["SSN"].ColumnName    = "ssno";
            dsDet.Tables[0].Columns["Name"].ColumnName   = "name";
            dsDet.Tables[0].Columns["Tier"].ColumnName   = "tiercd";
            dsDet.Tables[0].Columns["Eff Dt"].ColumnName = "effdt";
            dsDet.Tables[0].Columns["Rate"].ColumnName   = "rate";

            return(dsDet);
        }
예제 #2
0
        public DataSet GetDetailRpt(string yrmo, string plancode)
        {
            IPBA_DAL dobj  = new IPBA_DAL();
            int      count = 0;

            string[]  programs = { "Active", "Active Pilot", "COBRA", "COBRA Pilot" };
            string[]  tiercds  = { "E", "C", "S", "F" };
            DataSet   dsTemp   = new DataSet(); dsTemp.Clear();
            DataSet   dsDet    = new DataSet(); dsDet.Clear();
            DataTable tblDet;
            DataRow   row;

            DataRow[] rows;


            dsTemp = dobj.GetDetData(yrmo, plancode);
            dsDet  = dsTemp.Clone(); tblDet = dsDet.Tables[0];

            foreach (string program in programs)
            {
                foreach (string tiercd in tiercds)
                {
                    rows  = GetDetRows(program, tiercd, dsTemp); dsDet.Merge(rows);
                    count = GetDetEmpCount(program, tiercd, dsTemp);

                    if (count != 0)
                    {
                        row         = tblDet.NewRow();
                        row["Name"] = "***";
                        row["Tier"] = count;
                        row["Rate"] = GetDetTotalAmt(program, tiercd, dsTemp);
                        tblDet.Rows.Add(row);
                    }
                }
                count = GetEmpCount(program, dsTemp);
                if (count != 0)
                {
                    row          = tblDet.NewRow();
                    row["Class"] = "*** SUB TOTAL:";
                    row["Tier"]  = count;
                    row["Rate"]  = GetTotalAmt(program, dsTemp);
                    tblDet.Rows.Add(row);
                }
            }
            if (tblDet.Rows.Count > 0)
            {
                row          = tblDet.NewRow();
                row["Class"] = "*** GRAND TOTAL:";
                row["Rate"]  = GetTotalAmt(dsTemp);
                tblDet.Rows.Add(row);
            }

            return(dsDet);
        }
예제 #3
0
        Decimal GetManAdjAmtCHG(int i, string yrmo, string exprCHG, string programcd, string plancode, string tier, string priortier)
        {
            Decimal  amt = 0;
            Decimal  amtprev, amtprev1, amtprev2, amtcur;
            string   adjyrmo;
            IPBA_DAL dobj = new IPBA_DAL();

            switch (exprCHG)
            {
            case "-1":
                amt = dobj.GetRate(yrmo, programcd, plancode, priortier);
                break;

            case "1":
                amt = dobj.GetRate(yrmo, programcd, plancode, tier);
                break;

            case "1-":
                adjyrmo = GetYRMO(yrmo, (-1));
                amt     = dobj.GetRate(yrmo, programcd, plancode, tier);
                break;

            case "A+1":
                adjyrmo = GetYRMO(yrmo, (-1));
                amtcur  = dobj.GetRate(yrmo, programcd, plancode, tier);
                amtprev = dobj.GetRate(adjyrmo, programcd, plancode, priortier);

                if (i == 1)
                {
                    amt = dobj.GetRate(yrmo, programcd, plancode, tier);
                }
                else
                {
                    amt = (amtcur - amtprev);
                }

                break;

            case "2A+1":
                adjyrmo  = GetYRMO(yrmo, (-1));
                amtcur   = dobj.GetRate(yrmo, programcd, plancode, tier);
                amtprev  = dobj.GetRate(adjyrmo, programcd, plancode, priortier);
                adjyrmo  = GetYRMO(yrmo, (-2));
                amtprev1 = dobj.GetRate(adjyrmo, programcd, plancode, priortier);

                if (i == 1)
                {
                    amt = dobj.GetRate(yrmo, programcd, plancode, tier);
                }
                else if (i == 2)
                {
                    amt = amtcur - amtprev;
                }
                else
                {
                    amt = amtcur - amtprev1;
                }

                break;

            case "3A+1":
                adjyrmo  = GetYRMO(yrmo, (-1));
                amtcur   = dobj.GetRate(yrmo, programcd, plancode, tier);
                amtprev  = dobj.GetRate(adjyrmo, programcd, plancode, priortier);
                adjyrmo  = GetYRMO(yrmo, (-2));
                amtprev1 = dobj.GetRate(adjyrmo, programcd, plancode, priortier);
                adjyrmo  = GetYRMO(yrmo, (-3));
                amtprev2 = dobj.GetRate(adjyrmo, programcd, plancode, priortier);

                if (i == 1)
                {
                    amt = dobj.GetRate(yrmo, programcd, plancode, tier);
                }
                else if (i == 2)
                {
                    amt = amtcur - amtprev;
                }
                else if (i == 3)
                {
                    amt = amtcur - amtprev1;
                }
                else
                {
                    amt = amtcur - amtprev2;
                }

                break;
            }

            return(amt);
        }
예제 #4
0
        public DataSet GetSummaryRpt(string yrmo, string plancode)
        {
            IPBA_DAL dobj = new IPBA_DAL();
            string   tierexp;
            int      count = 0;

            string[] typecds  = { "STD", "CHG", "RETRO", "MANCHG", "MANRETRO" };
            string[] programs = { "Active", "Active Pilot", "COBRA", "COBRA Pilot", "Retiree", "Retiree Pilot" };
            string[] tiercds  = { "E", "C", "S", "F" };
            DataSet  dsTemp   = new DataSet(); dsTemp.Clear();
            DataSet  dsTemp1  = new DataSet(); dsTemp1.Clear();
            DataSet  dsSum    = new DataSet(); dsSum.Clear();

            System.Type typeDecimal = System.Type.GetType("System.Decimal");
            System.Type typeInt     = System.Type.GetType("System.Int32");
            DataTable   tblSum      = dsSum.Tables.Add("Summary");
            DataRow     row;
            DataColumn  col;

            col = new DataColumn("PlanYr"); tblSum.Columns.Add(col);
            col = new DataColumn("Classification"); tblSum.Columns.Add(col);
            col = new DataColumn("Coverage Tier"); tblSum.Columns.Add(col);
            col = new DataColumn("Emps", typeInt); tblSum.Columns.Add(col);
            col = new DataColumn("Rate", typeDecimal); tblSum.Columns.Add(col);
            col = new DataColumn("Total", typeDecimal); tblSum.Columns.Add(col);

            dsTemp  = dobj.GetDetData(yrmo, plancode);
            dsTemp1 = dobj.GetAdjData(yrmo, plancode); dsTemp.Merge(dsTemp1); dsTemp1.Clear();
            dsTemp1 = GetCobraAdjustments(yrmo, plancode); dsTemp.Merge(dsTemp1); dsTemp1.Clear();
            dsTemp1 = GetManualAdjustments(yrmo, plancode); dsTemp.Merge(dsTemp1); dsTemp1.Clear();

            foreach (string typecd in typecds)
            {
                foreach (string program in programs)
                {
                    foreach (string tiercd in tiercds)
                    {
                        tierexp = GetTierExp(tiercd, program);
                        count   = GetEmpCount(typecd, program, tiercd, dsTemp);
                        if (count != 0)
                        {
                            row                   = tblSum.NewRow();
                            row["PlanYr"]         = yrmo.Substring(0, 4);
                            row["Classification"] = GetClassification(typecd, program);
                            row["Coverage Tier"]  = tierexp;
                            row["Emps"]           = count;
                            row["Rate"]           = dobj.GetRate(yrmo, program, plancode, tiercd);
                            if (typecd.Equals("CHG") || typecd.Equals("MANCHG"))
                            {
                                row["Total"] = count * dobj.GetRate(yrmo, program, plancode, tiercd);
                            }
                            else
                            {
                                row["Total"] = GetTotalAmt(typecd, program, tiercd, dsTemp);
                            }
                            tblSum.Rows.Add(row);
                        }
                        if (typecd.Equals("CHG") || typecd.Equals("MANCHG"))
                        {
                            tierexp = GetTierExp(tiercd, program);
                            count   = GetEmpCountPriorCHG(typecd, program, tiercd, dsTemp);
                            if (count != 0)
                            {
                                row                   = tblSum.NewRow();
                                row["PlanYr"]         = yrmo.Substring(0, 4);
                                row["Classification"] = GetClassification(typecd, program);
                                row["Coverage Tier"]  = tierexp;
                                row["Emps"]           = (-1) * count;
                                row["Rate"]           = dobj.GetRate(yrmo, program, plancode, tiercd);
                                row["Total"]          = (-1) * count * dobj.GetRate(yrmo, program, plancode, tiercd);
                                tblSum.Rows.Add(row);
                            }
                        }
                    }
                    count = GetEmpCount(typecd, program, dsTemp);
                    if (count != 0)
                    {
                        row = tblSum.NewRow();
                        row["Classification"] = "***";
                        row["Coverage Tier"]  = "SUB TOTAL:";
                        row["Emps"]           = GetSumEmpCount(GetClassification(typecd, program), dsSum);
                        row["Total"]          = GetTotalAmt(typecd, program, dsTemp);
                        tblSum.Rows.Add(row);
                    }
                }
            }
            if (tblSum.Rows.Count > 0)
            {
                row = tblSum.NewRow();
                row["Classification"] = "*****";
                row["Coverage Tier"]  = "GRAND TOTAL:";
                row["Emps"]           = GetSumEmpCount(dsSum);
                row["Total"]          = GetTotalAmt(dsTemp);
                tblSum.Rows.Add(row);
            }

            return(dsSum);
        }
예제 #5
0
        DataSet GetCobraAdjustments(string yrmo, string plancode)
        {
            IPBA_DAL dobj = new IPBA_DAL();

            System.Type typeDecimal = System.Type.GetType("System.Decimal");
            DataSet     dsTemp      = new DataSet(); dsTemp.Clear();
            DataSet     dsCobAdj    = new DataSet(); dsCobAdj.Clear();
            DataTable   tblCobAdj   = dsCobAdj.Tables.Add("Table");
            DataRow     row1;
            DataColumn  col;
            Decimal     amt, amt1, rate, adjamt;
            String      prevyrmo, comments, recordYrmo;
            Boolean     found;
            int         months;

            col = new DataColumn("Py"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Class"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Type"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("SSN"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Name"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("YRMO"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Tier"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Comments"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Months"); tblCobAdj.Columns.Add(col);
            col = new DataColumn("Rate", typeDecimal); tblCobAdj.Columns.Add(col);
            col = new DataColumn("typecd"); tblCobAdj.Columns.Add(col);

            dsTemp = dobj.GetCobraAdjData(yrmo, plancode);
            foreach (DataRow row in dsTemp.Tables[0].Rows)
            {
                amt = Decimal.Parse(row["Rate"].ToString());

                if (amt == 0)
                {
                    continue;
                }

                adjamt     = amt;
                recordYrmo = row["CoveragePeriod"].ToString();
                found      = false;
                months     = 1;

                for (int i = 1; i < 12; i++)
                {
                    amt1     = (System.Math.Abs(amt)) / i;
                    prevyrmo = IPBAImport.getPrevYRMO(i - 1, recordYrmo);
                    rate     = dobj.GetRate(prevyrmo, row["Class"].ToString(), plancode, row["Tier"].ToString());

                    if (rate.Equals(amt1))
                    {
                        adjamt     = (amt) / i;
                        months     = i;
                        recordYrmo = prevyrmo;
                        found      = true;
                        break;
                    }
                }
                if (found)
                {
                    if (amt > 0)
                    {
                        comments = "COBRA RETRO PAYMENT - EFF DT: " + row["Eff Dt"].ToString();
                    }
                    else
                    {
                        comments = "COBRA RETRO CREDIT - EFF DT: " + row["Eff Dt"].ToString();
                    }
                }
                else
                {
                    comments = "COBRA ADJUSTMENT - EFF DT: " + row["Eff Dt"].ToString();
                }

                for (int j = 0; j < months; j++)
                {
                    row1             = tblCobAdj.NewRow();
                    row1["Py"]       = yrmo.Substring(0, 4);
                    row1["Class"]    = row["Class"];
                    row1["Type"]     = row["Type"];
                    row1["SSN"]      = row["SSN"];
                    row1["Name"]     = row["Name"];
                    row1["YRMO"]     = recordYrmo;
                    row1["Tier"]     = row["Tier"];
                    row1["Comments"] = comments;
                    if (amt > 0)
                    {
                        row1["Months"] = 1;
                    }
                    else
                    {
                        row1["Months"] = -1;
                    }
                    row1["Rate"]   = adjamt;
                    row1["typecd"] = "RETRO";
                    tblCobAdj.Rows.Add(row1);
                }
            }
            dsTemp.Clear();
            return(dsCobAdj);
        }
예제 #6
0
        DataSet GetManualAdjustments(string yrmo, string plancode)
        {
            IPBA_DAL   dobj      = new IPBA_DAL();
            WashRules  wobj      = new WashRules();
            DataSet    dsTemp    = new DataSet(); dsTemp.Clear();
            DataSet    dsManAdj  = new DataSet(); dsManAdj.Clear();
            DataTable  tblManAdj = dsManAdj.Tables.Add("Table");
            DataRow    row1;
            DataColumn col;

            System.Type typeDecimal = System.Type.GetType("System.Decimal");
            col = new DataColumn("Py"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Class"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Type"); tblManAdj.Columns.Add(col);
            col = new DataColumn("SSN"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Name"); tblManAdj.Columns.Add(col);
            col = new DataColumn("YRMO"); tblManAdj.Columns.Add(col);
            col = new DataColumn("PriorTier"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Tier"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Comments"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Months"); tblManAdj.Columns.Add(col);
            col = new DataColumn("Rate", typeDecimal); tblManAdj.Columns.Add(col);
            col = new DataColumn("typecd"); tblManAdj.Columns.Add(col);
            col = new DataColumn("flag"); tblManAdj.Columns.Add(col);

            DateTime effdt;
            string   exprCHG, yrmocalc;
            int      months;
            string   _flag = "";

            dsTemp = dobj.GetManAdjData(yrmo, plancode, "NEW");
            foreach (DataRow row in dsTemp.Tables[0].Rows)
            {
                effdt  = Convert.ToDateTime(row["Eff Dt"]);
                months = wobj.washRuleADD(effdt, yrmo, plancode);

                _flag = "";
                if (MaxMonExceeded(plancode, "NEW", yrmo, effdt))
                {
                    _flag = "*";
                }

                if (months != 0)
                {
                    for (int i = 1; i <= months; i++)
                    {
                        row1          = tblManAdj.NewRow();
                        row1["Py"]    = yrmo.Substring(0, 4);
                        row1["Class"] = row["Class"];
                        row1["Type"]  = row["Type"];
                        row1["SSN"]   = row["SSN"];
                        row1["Name"]  = row["Name"];
                        row1["YRMO"]  = GetYRMO(yrmo, (i - 1));
                        row1["Tier"]  = row["Tier"];
                        if (row["Class"].ToString().Equals("COBRA") || row["Class"].ToString().Equals("COBRA Pilot"))
                        {
                            if (row["Comments"].ToString().Contains("NEW ENROLLEE EFF: "))
                            {
                                row1["Comments"] = row["Comments"].ToString().Replace("NEW ENROLLEE EFF: ", "COBRA RETRO PAYMENT - EFF DT: ");
                            }
                            else
                            {
                                row1["Comments"] = row["Comments"].ToString().Replace("RETRO CVG EFF: ", "COBRA RETRO PAYMENT - EFF DT: ");
                            }
                        }
                        else
                        {
                            row1["Comments"] = row["Comments"];
                        }
                        row1["Months"] = 1;
                        row1["Rate"]   = dobj.GetRate(GetYRMO(yrmo, (i - 1)), row["Class"].ToString(), plancode, row["Tier"].ToString());
                        row1["typecd"] = row["typecd"];
                        row1["flag"]   = _flag;
                        tblManAdj.Rows.Add(row1);
                    }
                }
            }
            dsTemp.Clear();
            dsTemp = dobj.GetManAdjData(yrmo, plancode, "TERM");
            foreach (DataRow row in dsTemp.Tables[0].Rows)
            {
                effdt  = Convert.ToDateTime(row["Eff Dt"]);
                months = wobj.washRuleTERM(effdt, yrmo, plancode);

                _flag = "";
                if (MaxMonExceeded(plancode, "TERM", yrmo, effdt))
                {
                    _flag = "*";
                }

                if (months != 0)
                {
                    for (int i = 1; i <= System.Math.Abs(months); i++)
                    {
                        if (months < 0)
                        {
                            yrmocalc = GetYRMO(yrmo, i);
                        }
                        else
                        {
                            yrmocalc = yrmo;
                        }

                        row1          = tblManAdj.NewRow();
                        row1["Py"]    = yrmo.Substring(0, 4);
                        row1["Class"] = row["Class"];
                        row1["Type"]  = row["Type"];
                        row1["SSN"]   = row["SSN"];
                        row1["Name"]  = row["Name"];
                        row1["YRMO"]  = yrmocalc;
                        row1["Tier"]  = row["Tier"];
                        if (row["Class"].ToString().Equals("COBRA") || row["Class"].ToString().Equals("COBRA Pilot"))
                        {
                            if (months < 0)
                            {
                                row1["Comments"] = row["Comments"].ToString().Replace("TERMINATED CVG EFF: ", "COBRA RETRO CREDIT - EFF DT: ");
                            }
                            else
                            {
                                row1["Comments"] = row["Comments"].ToString().Replace("TERMINATED CVG EFF: ", "COBRA RETRO PAYMENT - EFF DT: ");
                            }
                        }
                        else
                        {
                            row1["Comments"] = row["Comments"];
                        }
                        if (months < 0)
                        {
                            row1["Months"] = -1;
                            row1["Rate"]   = (-1) * dobj.GetRate(yrmocalc, row["Class"].ToString(), plancode, row["Tier"].ToString());
                        }
                        else
                        {
                            row1["Months"] = 1;
                            row1["Rate"]   = dobj.GetRate(yrmocalc, row["Class"].ToString(), plancode, row["Tier"].ToString());
                        }
                        row1["typecd"] = row["typecd"];
                        row1["flag"]   = _flag;
                        tblManAdj.Rows.Add(row1);
                    }
                }
            }
            dsTemp.Clear();
            dsTemp = dobj.GetManAdjData(yrmo, plancode, "CHG");
            foreach (DataRow row in dsTemp.Tables[0].Rows)
            {
                effdt   = Convert.ToDateTime(row["Eff Dt"]);
                exprCHG = wobj.washRuleCHG(effdt, yrmo, plancode);
                months  = GetMonthsManAdjCHG(exprCHG);

                _flag = "";
                if (MaxMonExceeded(plancode, "CHG", yrmo, effdt))
                {
                    _flag = "*";
                }

                for (int i = 1; i <= months; i++)
                {
                    row1              = tblManAdj.NewRow();
                    row1["Py"]        = yrmo.Substring(0, 4);
                    row1["Class"]     = row["Class"];
                    row1["Type"]      = row["Type"];
                    row1["SSN"]       = row["SSN"];
                    row1["Name"]      = row["Name"];
                    row1["YRMO"]      = GetYRMO(yrmo, (i - 1));
                    row1["PriorTier"] = row["PriorTier"];
                    row1["Tier"]      = row["Tier"];
                    row1["Comments"]  = row["Comments"];
                    row1["Months"]    = 1;
                    row1["Rate"]      = GetManAdjAmtCHG(i, yrmo, exprCHG, row["Class"].ToString(), plancode, row["Tier"].ToString(), row["PriorTier"].ToString());
                    row1["typecd"]    = row["typecd"];
                    row1["flag"]      = _flag;
                    tblManAdj.Rows.Add(row1);
                    if (exprCHG.Equals("1-"))
                    {
                        continue;
                    }
                }
            }
            dsTemp.Clear();
            return(dsManAdj);
        }
예제 #7
0
        public DataSet GetAdjustmentRpt(string yrmo, string plancode)
        {
            IPBA_DAL dobj  = new IPBA_DAL();
            int      count = 0;

            string[]  typecds  = { "CHG", "RETRO" };
            string[]  programs = { "Active", "Active Pilot", "COBRA", "COBRA Pilot", "Retiree", "Retiree Pilot" };
            DataSet   dsTemp   = new DataSet(); dsTemp.Clear();
            DataSet   dsAdj    = new DataSet(); dsAdj.Clear();
            DataTable tblAdj   = dsAdj.Tables.Add("Adjustments");

            System.Type typeDecimal = System.Type.GetType("System.Decimal");
            DataRow[]   rows;
            DataRow     row;
            DataColumn  col;

            col = new DataColumn("Py"); tblAdj.Columns.Add(col);
            col = new DataColumn("Class"); tblAdj.Columns.Add(col);
            col = new DataColumn("Type"); tblAdj.Columns.Add(col);
            col = new DataColumn("SSN"); tblAdj.Columns.Add(col);
            col = new DataColumn("Name"); tblAdj.Columns.Add(col);
            col = new DataColumn("YRMO"); tblAdj.Columns.Add(col);
            col = new DataColumn("Comments"); tblAdj.Columns.Add(col);
            col = new DataColumn("Months"); tblAdj.Columns.Add(col);
            col = new DataColumn("Amount", typeDecimal); tblAdj.Columns.Add(col);
            col = new DataColumn("Flag"); tblAdj.Columns.Add(col);

            dsTemp = dobj.GetAdjData(yrmo, plancode);
            dsTemp.Merge(GetCobraAdjustments(yrmo, plancode));
            dsTemp.Merge(GetManualAdjustments(yrmo, plancode));

            foreach (string program in programs)
            {
                foreach (string typecd in typecds)
                {
                    rows = GetAdjRows(typecd, program, dsTemp);
                    foreach (DataRow row1 in rows)
                    {
                        row             = tblAdj.NewRow();
                        row["Py"]       = row1["Py"];
                        row["Class"]    = program;
                        row["Type"]     = row1["Type"];
                        row["SSN"]      = row1["SSN"];
                        row["Name"]     = row1["Name"];
                        row["YRMO"]     = row1["YRMO"];
                        row["Comments"] = row1["Comments"];
                        row["Months"]   = row1["Months"];
                        row["Amount"]   = row1["Rate"];
                        row["Flag"]     = row1["flag"];
                        tblAdj.Rows.Add(row);
                    }
                    count = GetAdjEmpCount(typecd, program, dsTemp);
                    if (count != 0)
                    {
                        row             = tblAdj.NewRow();
                        row["Comments"] = "***";
                        row["Amount"]   = GetAdjTotalAmt(typecd, program, dsTemp);
                        tblAdj.Rows.Add(row);
                    }
                }
                count = GetEmpCount(program, dsTemp);
                if (count != 0)
                {
                    row           = tblAdj.NewRow();
                    row["Class"]  = "*** SUB TOTAL:";
                    row["Amount"] = GetTotalAmt(program, dsTemp);
                    tblAdj.Rows.Add(row);
                }
            }
            if (tblAdj.Rows.Count > 0)
            {
                row           = tblAdj.NewRow();
                row["Class"]  = "*** GRAND TOTAL:";
                row["Amount"] = GetTotalAmt(dsTemp);
                tblAdj.Rows.Add(row);
            }

            return(dsAdj);
        }