コード例 #1
0
        public DataSet GetCustomerRTDetails(int CustomerID)
        {
            DataSet dsGetCustomerRTDetails = new DataSet();
            CustomerGoalSetupDao RTDetails = new CustomerGoalSetupDao();

            try
            {
                dsGetCustomerRTDetails = RTDetails.GetCustomerRTDetails(CustomerID);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();

                FunctionInfo.Add("Method", "CustomerGoalSetupBo.cs:GetCustomerRTDetails()");

                object[] objects = new object[0];
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(dsGetCustomerRTDetails);
        }
コード例 #2
0
        /// <summary>
        /// It retuns Customer Retirement Goal description paragrapgh
        /// </summary>
        /// <param name="CustomerID"></param>
        /// <returns></returns>
        public string RTGoalDescriptionText(int CustomerID)
        {
            string  GoalDescription        = "";
            DataSet dsGetCustomerRTDetails = new DataSet();
            CustomerGoalSetupDao RTDetails = new CustomerGoalSetupDao();

            try
            {
                string futureValueOncurrentInvestment  = null;
                string futureValueOncurrentInvestment2 = null;
                string yearlySavingRequired            = null;
                string gapvalues = null;
                dsGetCustomerRTDetails = RTDetails.GetCustomerRTDetails(CustomerID);
                if (dsGetCustomerRTDetails.Tables[0].Rows.Count > 0)
                {
                    if (string.IsNullOrEmpty(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_FutureValueOnCurrentInvest"].ToString()))
                    {
                        futureValueOncurrentInvestment = "0";
                    }
                    else
                    {
                        futureValueOncurrentInvestment = Math.Round(double.Parse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_FutureValueOnCurrentInvest"].ToString()), 2).ToString();
                    }

                    if (string.IsNullOrEmpty(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_LumpsumInvestmentRequired"].ToString()))
                    {
                        futureValueOncurrentInvestment2 = "0";
                    }
                    else
                    {
                        futureValueOncurrentInvestment2 = Math.Round(double.Parse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_LumpsumInvestmentRequired"].ToString()), 2).ToString();
                    }


                    if (string.IsNullOrEmpty(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_YearlySavingsRequired"].ToString()))
                    {
                        yearlySavingRequired = "0";
                    }
                    else
                    {
                        yearlySavingRequired = Math.Round(double.Parse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_YearlySavingsRequired"].ToString()), 2).ToString();
                    }


                    if (string.IsNullOrEmpty(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_GapValues"].ToString()))
                    {
                        gapvalues = "0";
                    }
                    else
                    {
                        gapvalues = Math.Round(double.Parse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_GapValues"].ToString()), 2).ToString();
                    }


                    if (dsGetCustomerRTDetails.Tables[0].Rows.Count > 0)
                    {
                        double fvCostOfToday          = 0;
                        double currentInvestment      = 0;
                        double roiEarned              = 0;
                        double monthlySavingsRequired = 0;
                        double.TryParse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_FVofCostToday"].ToString(), out fvCostOfToday);
                        double.TryParse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_CurrentInvestment"].ToString(), out currentInvestment);
                        double.TryParse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_ROIEarned"].ToString(), out roiEarned);
                        double.TryParse(dsGetCustomerRTDetails.Tables[0].Rows[0]["CG_MonthlySavingsRequired"].ToString(), out monthlySavingsRequired);

                        string StrRT1 = "We have done an extensive analysis of your" +
                                        " retirement goal needs and savings required per month to meet those " +
                                        "needs.Based on the inputs provided by you we have calculated that at " +
                                        "the time of your retirement you'll need a corpus of Rs." + Math.Round(fvCostOfToday, 2).ToString() +
                                        " to lead a financialy stable retired life.";

                        string StrRT2 = "To meet the retirement goal you have already invested Rs." + Math.Round(currentInvestment, 2).ToString() +
                                        " which will grow at " + Math.Round(roiEarned, 2).ToString() + " % " +
                                        " and it's value at the time of your retirement will be Rs." + futureValueOncurrentInvestment + ".";

                        string StrRT3 = "You have no investmensts attached to your retirement.";

                        string StrRT4 = "For the gap of Rs." + gapvalues +
                                        " for your retirement goal, you need to start planning soon." +
                                        "You can opt for any of the following saving options to meet your retirement goal." +
                                        " Monthly savings required to meet the goal is Rs." + Math.Round(monthlySavingsRequired, 2).ToString() +
                                        ".Yearly savings required to meet the goal is Rs." + yearlySavingRequired + ".Lumpsum investment required is Rs." + futureValueOncurrentInvestment2 +
                                        ".We recommend you to start saving as per the retirement plan provided by us.";



                        if (currentInvestment == 0)
                        {
                            GoalDescription = StrRT1 + StrRT3 + StrRT4;
                        }
                        else
                        {
                            GoalDescription = StrRT1 + StrRT2 + StrRT4;
                        }
                    }
                    else
                    {
                        GoalDescription = "";
                    }
                }
                else
                {
                    GoalDescription = "";
                }
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();

                FunctionInfo.Add("Method", "CustomerGoalSetupBo.cs:GetCustomerRTDetails()");

                object[] objects = new object[0];
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }



            return(GoalDescription);
        }