Ejemplo n.º 1
0
        public static A2ZTRNLOGICDTO GetFixedDepositAmt(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.AccOrgAmt = Converter.GetDecimal(dt.Rows[0]["AccOrgAmt"]);

                if (p.AccOrgAmt != 0)
                {
                    p.NoMsg    = Converter.GetSmallInteger(1);
                    p.NoRecord = Converter.GetSmallInteger(1);
                    return(p);
                }
                else
                {
                    p.NoRecord    = Converter.GetSmallInteger(1);
                    p.LogicAmount = Converter.GetDouble(dt.Rows[0]["AccFixedAmt"]);
                    p.NoMsg       = 0;
                    return(p);
                }
            }
            else
            {
                p.NoRecord = 0;
                p.NoMsg    = 0;
            }

            return(p);
        }
Ejemplo n.º 2
0
        public static A2ZTRNLOGICDTO GetNetEncashmentBenefitMSplus(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");

            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.BalInterest = Converter.GetDouble(dt.Rows[0]["AccProvBalance"]);
                p.CalInterest = Converter.GetDouble(dt.Rows[0]["CalInterest"]);


                if (p.CalInterest > 0)
                {
                    p.LogicAmount = Converter.GetDouble(p.CalInterest);
                    p.NoRecord    = Converter.GetSmallInteger(1);
                    return(p);
                }
                else
                {
                    p.LogicAmount = 0;
                    p.NoRecord    = Converter.GetSmallInteger(1);
                    return(p);
                }
            }
            else
            {
                p.NoRecord = 0;
            }

            return(p);
        }
Ejemplo n.º 3
0
        public static A2ZTRNLOGICDTO GetIntWithdrawal(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.AccPrincipal = Converter.GetDecimal(dt.Rows[0]["AccPrincipal"]);
                p.AccRenwlAmt  = Converter.GetDecimal(dt.Rows[0]["AccRenwlAmt"]);
                p.BalAmount    = Converter.GetDecimal(dt.Rows[0]["AccBalance"]);
                p.AccLienAmt   = Converter.GetDecimal(dt.Rows[0]["AccLienAmt"]);

                var rr = Convert.ToString(dt.Rows[0]["AccRenwlDate"]);

                if (rr != "")
                {
                    DataTable dt1 = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCSPARAM WHERE AccType = '" + AccType + "'", "A2ZACGMS");
                    if (dt.Rows.Count > 0)
                    {
                        p.IntWithdrDays = Converter.GetSmallInteger(dt1.Rows[0]["PrmIntWithdrDays"]);

                        A2ZCSPARAMETERDTO dto   = A2ZCSPARAMETERDTO.GetParameterValue();
                        DateTime          tDate = Converter.GetDateTime(dto.ProcessDate);
                        DateTime          fDate = Converter.GetDateTime(rr);
                        int Days = Convert.ToInt32(tDate.Subtract(fDate).TotalDays);

                        if (Days <= p.IntWithdrDays)
                        {
                            if (p.AccLienAmt > p.AccPrincipal)
                            {
                                p.LogicAmount = Converter.GetDouble(p.BalAmount - p.AccLienAmt);
                            }
                            else
                            {
                                p.LogicAmount = Converter.GetDouble(p.BalAmount - p.AccPrincipal);
                            }
                        }
                        else
                        {
                            p.NoMsg = 1;
                        }
                    }
                }

                p.NoRecord = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }

            return(p);
        }
Ejemplo n.º 4
0
        public static A2ZTRNLOGICDTO GetInterestAmtFDR(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            var prm = new object[5];

            prm[0] = BranchNo;
            prm[1] = MemType;
            prm[2] = MemberNo;
            prm[3] = AccType;
            prm[4] = AccountNo;
            int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCalculateEncashmentFDR", prm, "A2ZACGMS"));

            if (result == 0)
            {
                DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' AccType = '" + AccType + "' and AccNo = '" +
                                                                              AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");

                var p = new A2ZTRNLOGICDTO();
                if (dt.Rows.Count > 0)
                {
                    p.CalNofDays     = Converter.GetSmallInteger(dt.Rows[0]["CalNofDays"]);
                    p.CalIntRate     = Converter.GetDecimal(dt.Rows[0]["CalIntRate"]);
                    p.CalFDAmount    = Converter.GetDouble(dt.Rows[0]["CalFDAmount"]);
                    p.CalOrgInterest = Converter.GetDouble(dt.Rows[0]["CalOrgInterest"]);
                    p.CalInterest    = Converter.GetDouble(dt.Rows[0]["CalInterest"]);
                    p.CalProvAdjCr   = Converter.GetDouble(dt.Rows[0]["CalProvAdjCr"]);
                    p.CalProvAdjDr   = Converter.GetDouble(dt.Rows[0]["CalProvAdjDr"]);
                    p.CalFDate       = Converter.GetDateTime(dt.Rows[0]["CalFDate"]);
                    p.CalPeriod      = Converter.GetSmallInteger(dt.Rows[0]["CalPeriod"]);


                    if (p.CalInterest > 0)
                    {
                        p.LogicAmount = Converter.GetDouble(p.CalInterest);
                        p.NoRecord    = Converter.GetSmallInteger(1);
                        return(p);
                    }
                    else
                    {
                        p.LogicAmount = 0;
                        p.NoRecord    = Converter.GetSmallInteger(1);
                        return(p);
                    }
                }
                else
                {
                    p.NoRecord = 0;
                }

                return(p);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 5
0
        public static A2ZTRNLOGICDTO GetODInterestAmt(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo, string TrnDate)
        {
            var prm = new object[6];

            prm[0] = BranchNo;
            prm[1] = MemType;
            prm[2] = MemberNo;
            prm[3] = AccType;
            prm[4] = AccountNo;
            prm[5] = TrnDate;
            int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCalculateODInterest", prm, "A2ZACGMS"));

            if (result == 0)
            {
                DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                              AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");

                var p = new A2ZTRNLOGICDTO();
                if (dt.Rows.Count > 0)
                {
                    p.CalInterest   = Converter.GetDouble(dt.Rows[0]["CalInterest"]);
                    p.AccDueIntAmt  = Converter.GetDouble(dt.Rows[0]["AccDueIntAmt"]);
                    p.AccHoldIntAmt = Converter.GetDouble(dt.Rows[0]["AccHoldIntAmt"]);

                    if (p.AccDueIntAmt < 0)
                    {
                        p.AccDueIntAmt = 0;
                    }

                    //if (p.CalInterest < 0)
                    //{
                    p.AccCurrIntAmt = Converter.GetDouble(Math.Abs(p.CalInterest + p.AccHoldIntAmt));
                    p.LogicAmount   = Converter.GetDouble(Math.Abs(p.CalInterest) + p.AccDueIntAmt + p.AccHoldIntAmt);
                    p.NoRecord      = Converter.GetSmallInteger(1);
                    return(p);
                    //}
                    //else
                    //{
                    //    p.LogicAmount = 0;
                    //    p.NoRecord = Converter.GetSmallInteger(1);
                    //    return p;
                    //}
                }
                else
                {
                    p.NoRecord = 0;
                }

                return(p);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 6
0
        public static A2ZTRNLOGICDTO GetNetLoanAmtReceived(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.BalAmount    = Converter.GetDecimal(dt.Rows[0]["AccBalance"]);
                p.InterestRate = Converter.GetDecimal(dt.Rows[0]["AccIntRate"]);

                p.LogicAmount = Converter.GetDouble(p.BalAmount * p.InterestRate) / 1200;

                DataTable dt1 = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCSPARAM WHERE AccType = '" + AccType + "'", "A2ZACGMS");
                if (dt1.Rows.Count > 0)
                {
                    p.RoundFlag = Converter.GetSmallInteger(dt1.Rows[0]["PrmRoundFlag"]);

                    if (p.RoundFlag == 1)
                    {
                        p.LogicAmount = Math.Round(p.LogicAmount);
                    }

                    if (p.RoundFlag == 2)
                    {
                        p.LogicAmount = Math.Ceiling(p.LogicAmount);
                    }
                    if (p.RoundFlag == 3)
                    {
                        p.LogicAmount = (p.LogicAmount);
                    }

                    double Balance  = Converter.GetDouble(p.BalAmount);
                    double Interest = Converter.GetDouble(p.LogicAmount);

                    // p.LogicAmount = Converter.GetDouble(Balance + Interest);
                    p.LogicAmount = Converter.GetDouble(Balance);
                }

                p.NoRecord = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }

            return(p);
        }
Ejemplo n.º 7
0
        public static A2ZTRNLOGICDTO GetBenefitWithdrawalA(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            var prm = new object[1];

            prm[0] = AccountNo;

            int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSGetMonthlyBenefit", prm, "A2ZACGMS"));

            if (result == 0)
            {
                DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                              AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


                var p = new A2ZTRNLOGICDTO();
                if (dt.Rows.Count > 0)
                {
                    p.AccFixedAmt    = Converter.GetDecimal(dt.Rows[0]["AccFixedAmt"]);
                    p.AccFixedMthInt = Converter.GetDecimal(dt.Rows[0]["AccFixedMthInt"]);
                    p.BalAmount      = Converter.GetDecimal(dt.Rows[0]["AccProvBalance"]);
                    p.CalProvDate    = Converter.GetDateTime(dt.Rows[0]["AccProvCalDate"]);
                    p.AdjBalAmount   = Converter.GetDecimal(dt.Rows[0]["AccAdjProvBalance"]);
                    p.BenefitDate    = Converter.GetDateTime(dt.Rows[0]["AccBenefitDate"]);

                    p.AccProvBalance = Converter.GetDecimal(dt.Rows[0]["AccProvBalance"]);


                    p.LogicAmount = Converter.GetDouble(p.BalAmount + p.AdjBalAmount);


                    p.NoMonths = Converter.GetDecimal((p.BalAmount + p.AdjBalAmount) / p.AccFixedMthInt);

                    p.NoRecord = Converter.GetSmallInteger(1);
                    return(p);
                }
                else
                {
                    p.NoRecord = 0;
                }

                return(p);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 8
0
        public static A2ZTRNLOGICDTO GetShareMinAmt(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            var p = new A2ZTRNLOGICDTO();

            var prm = new object[5];

            prm[0] = BranchNo;
            prm[1] = MemType;
            prm[2] = MemberNo;
            prm[3] = AccType;
            prm[4] = AccountNo;
            int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCalculateSharePenalAmt", prm, "A2ZACGMS"));

            if (result == 0)
            {
                DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                              AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");

                if (dt.Rows.Count > 0)
                {
                    p.CalPeriod = Converter.GetSmallInteger(dt.Rows[0]["CalPeriod"]);

                    DataTable dt1 = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCSPARAM WHERE AccType = '" + AccType + "'", "A2ZACGMS");

                    if (dt1.Rows.Count > 0)
                    {
                        p.LogicAmount = Converter.GetDouble(dt1.Rows[0]["PrmMinDeposit"]);
                    }

                    if (p.CalPeriod != 0)
                    {
                        p.LogicAmount = Converter.GetDouble(p.LogicAmount * p.CalPeriod);
                    }
                    p.NoRecord = Converter.GetSmallInteger(1);
                    return(p);
                }
                else
                {
                    p.NoRecord = 0;
                }
            }
            return(p);
        }
Ejemplo n.º 9
0
        public static A2ZTRNLOGICDTO GetLoanReturnAmt(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.BalAmount          = Converter.GetDecimal(dt.Rows[0]["AccBalance"]);
                p.InstlAmt           = Converter.GetDecimal(dt.Rows[0]["AccLoanInstlAmt"]);
                p.InterestRate       = Converter.GetDecimal(dt.Rows[0]["AccIntRate"]);
                p.AccDuePrincAmt     = Converter.GetDouble(dt.Rows[0]["AccDuePrincAmt"]);
                p.AccDueIntAmt       = Converter.GetDouble(dt.Rows[0]["AccDueIntAmt"]);
                p.AccDuePenalAmt     = Converter.GetDouble(dt.Rows[0]["AccDuePenalAmt"]);
                p.AccLastDuePrincAmt = Converter.GetDouble(dt.Rows[0]["AccLastDuePrincAmt"]);

                p.LogicAmount = p.AccDuePrincAmt;

                //p.LogicAmount = Converter.GetDouble(p.BalAmount + p.InstlAmt);

                //if (p.LogicAmount > 0)
                //{
                //    p.LogicAmount = Converter.GetDouble(Math.Abs(p.BalAmount));
                //}
                //else
                //{
                //    p.LogicAmount = Converter.GetDouble(p.InstlAmt);
                //}

                p.NoRecord = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }


            return(p);
        }
Ejemplo n.º 10
0
        public static A2ZTRNLOGICDTO GetClosingFees(int AccType)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCSPARAM WHERE AccType = '" + AccType + "'", "A2ZACGMS");


            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.LogicAmount = Converter.GetDouble(dt.Rows[0]["PrmAccClosingFees"]);
                p.NoRecord    = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }


            return(p);
        }
Ejemplo n.º 11
0
        public static A2ZTRNLOGICDTO GetSharePenalAmt(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            //var prm = new object[5];

            //prm[0] = BranchNo;
            //prm[1] = MemType;
            //prm[2] = MemberNo;
            //prm[3] = AccType;
            //prm[4] = AccountNo;
            //int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCalculateSharePenalAmt", prm, "A2ZACGMS"));
            //if (result == 0)
            //{

            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");

            var p = new A2ZTRNLOGICDTO();

            if (dt.Rows.Count > 0)
            {
                p.CalPenalAmt = Converter.GetDouble(dt.Rows[0]["CalPenalAmt"]);

                p.LogicAmount = Converter.GetDouble(Math.Abs(p.CalPenalAmt));
                p.NoRecord    = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }

            return(p);

            //}
            ////else
            ////{
            ////    return null;
            ////}
        }
Ejemplo n.º 12
0
        public static A2ZTRNLOGICDTO GetBenefitAmtMSplus(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo)
        {
            var p = new A2ZTRNLOGICDTO();


            var prm = new object[5];

            prm[0] = BranchNo;
            prm[1] = MemType;
            prm[2] = MemberNo;
            prm[3] = AccType;
            prm[4] = AccountNo;
            int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCalculateEncashmentMSplus", prm, "A2ZACGMS"));

            if (result == 0)
            {
                DataTable dt0 = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCTYPE WHERE AccTypeCode = '" + AccType + "'", "A2ZACGMS");
                if (dt0.Rows.Count > 0)
                {
                    p.ProvSw = Converter.GetInteger(dt0.Rows[0]["AccProvisionMode"]);

                    DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                                  AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


                    if (dt.Rows.Count > 0)
                    {
                        p.BalInterest     = Converter.GetDouble(dt.Rows[0]["AccProvBalance"]);
                        p.CalOrgInterest  = Converter.GetDouble(dt.Rows[0]["CalOrgInterest"]);
                        p.CalPaidInterest = Converter.GetDouble(dt.Rows[0]["AccTotIntWdrawn"]);
                        p.CalInterest     = Converter.GetDouble(dt.Rows[0]["CalInterest"]);

                        p.CalEncashment = Converter.GetDecimal(dt.Rows[0]["CalEncashment"]);

                        if (p.ProvSw == 1)
                        {
                            p.RestInterest = Converter.GetDouble(p.BalInterest - p.CalInterest);
                        }
                        else
                        {
                            p.RestInterest = p.CalInterest;
                        }


                        if (p.CalInterest > 0 && p.RestInterest < 0)
                        {
                            p.LogicAmount = Converter.GetDouble(p.RestInterest);
                            p.NoRecord    = Converter.GetSmallInteger(1);
                            return(p);
                        }
                        else
                        {
                            p.LogicAmount = 0;
                            p.NoRecord    = Converter.GetSmallInteger(1);
                            return(p);
                        }
                    }
                    else
                    {
                        p.NoRecord = 0;
                    }
                }

                return(p);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 13
0
        public static A2ZTRNLOGICDTO GetNetEncashmentPension(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo, DateTime TrnDate)
        {
            var p = new A2ZTRNLOGICDTO();

            A2ZCSPARAMETERDTO dto  = A2ZCSPARAMETERDTO.GetParameterValue();
            DateTime          dt1  = Converter.GetDateTime(dto.ProcessDate);
            string            date = dt1.ToString("dd/MM/yyyy");

            A2ZPENSIONDEFAULTERDTO getDTO = (A2ZPENSIONDEFAULTERDTO.GetPensionDepInformation(BranchNo, TrnDate, MemType, MemberNo, AccType, AccountNo));

            if (getDTO.MemType > 0)
            {
                p.UptoMonth = Converter.GetString(getDTO.UptoMonth);
                p.UptoYear  = Converter.GetInteger(getDTO.UptoYear);

                p.UptoPaidDate  = Converter.GetDateTime(getDTO.UptoPaidDate);
                p.UptoPaidNo    = Converter.GetDecimal(getDTO.UptoPaidNo);
                p.DueDepositAmt = Converter.GetDecimal(getDTO.DueDepositAmt);
            }


            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
                                                                          AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");


            if (dt.Rows.Count > 0)
            {
                p.CalEncashment = Converter.GetDecimal(dt.Rows[0]["CalEncashment"]);
                p.LogicAmount   = Converter.GetDouble(p.CalEncashment);

                p.AccPeriod   = Converter.GetInteger(dt.Rows[0]["AccPeriod"]);
                p.MthDeposit  = Converter.GetDouble(dt.Rows[0]["AccMonthlyDeposit"]);
                p.TotalDepAmt = Converter.GetDouble(dt.Rows[0]["AccTotalDep"]);
                p.OpenDate    = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]);

                //p.NoMonths = Converter.GetDecimal(p.TotalDepAmt / p.MthDeposit);

                //if (p.NoMonths == 0)
                //{
                //    p.UptoDate = "";
                //}
                //else
                //{
                //    p.NoMonths = p.NoMonths - 1;
                //    if (p.NoMonths < 1)
                //    {
                //        p.NoMonths = 0;
                //    }
                //    DateTime Depdate = new DateTime();
                //    Depdate = p.OpenDate.AddMonths(Converter.GetSmallInteger(p.NoMonths));
                //    p.UptoDate = String.Format("{0:Y}", Depdate);
                //}

                p.NoRecord = Converter.GetSmallInteger(1);
                return(p);
            }
            else
            {
                p.NoRecord = 0;
            }

            return(p);
        }