/// <summary>
    /// Loads  the record of the selected application
    /// </summary>
    public void loadInvSummary()
    {
        try
        {
            mainDSTableAdapters.GetClientInfoTableAdapter client = new mainDSTableAdapters.GetClientInfoTableAdapter();
            mainDS.GetClientInfoDataTable tblClient = client.GetClientInfo(MySessionManager.ClientID);
            if (tblClient.Rows.Count > 0)
            {
                if (tblClient[0].IsdatClientNameNull() == false)
                {
                    lblClientName.InnerText = tblClient[0].datClientName.ToString();
                }
                if (tblClient[0].IsdatClientNumberNull() == false)
                {
                    lblClientNo.InnerText = tblClient[0].datClientNumber.ToString();
                }
                if (tblClient[0].IsdatMobileNumber1Null() == false)
                {
                    lblMobile1.InnerText = tblClient[0].datMobileNumber1.ToString();
                }
            }

            InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
            InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);

            if (tblInvApp.Rows.Count > 0)
            {
                if (tblInvApp[0].IsdatInvestmentNameNull() == false)
                {
                    this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString();
                }
                if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false)
                {
                    this.lblRatePerAnnum.InnerText = tblInvApp[0].datInterestRatePerAnnum.ToString("c").Replace("$", "");
                }
                if (tblInvApp[0].IsdatInvestmentTypeNull() == false)
                {
                    this.lblType.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString());
                }
                if (tblInvApp[0].IsdatTermsNull() == false)
                {
                    this.lblTerms.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days";
                }
                if (tblInvApp[0].IsdatInvestmentNameNull() == false)
                {
                    this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString();
                }
                if (tblInvApp[0].IsdatModeOfRepaymentNull() == false)
                {
                    this.lblModeOfInv.InnerText = util.displayValue("opt_payment_modes", tblInvApp[0].datModeOfRepayment.ToString());
                }
                if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false)
                {
                    this.lblFreqPayment.InnerText = util.displayValue("opt_frequencies_investments", tblInvApp[0].datFrequencyOfInterestPayment.ToString());
                }
                if (tblInvApp[0].IsdatInvestmentAmountNull() == false)
                {
                    this.lblAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", "");
                }
                if (tblInvApp[0].IsdatValueDateNull() == false)
                {
                    this.txtValue.Text = tblInvApp[0].datValueDate.ToString("dd-MM-yyyy");
                }
            }
        }
        catch (Exception ex) { }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (MySessionManager.AppID > 0)
        {
            this.itemLoanApp.Visible     = true;
            this.ItemLoanAccount.Visible = false;
            LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
            MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID));

            try
            {
                mainDSTableAdapters.GetApplicationInfoTableAdapter appinfo = new mainDSTableAdapters.GetApplicationInfoTableAdapter();
                mainDS.GetApplicationInfoDataTable tblAppInfo = appinfo.GetApplicationInfo(MySessionManager.AppID);
                if (tblAppInfo.Rows.Count > 0)
                {
                    this.btnEditApp.HRef        = setUrls(MySessionManager.AppID);
                    this.btnViewAppTracker.HRef = "~/pages/applicationtracker.aspx?id=" + MyEncryption.Encrypt(MySessionManager.AppID.ToString(), "12345678910");
                    if (tblAppInfo[0].IsdatLoanAmountNull() == false)
                    {
                        this.lnAmt.InnerText = tblAppInfo[0].datLoanAmount.ToString("c").Replace("$", "");
                    }
                    if (tblAppInfo[0].IsdatLoanTypeNull() == false)
                    {
                        this.lnType.InnerText = tblAppInfo[0].datLoanType.ToString();
                    }
                    if (tblAppInfo[0].IsdatApplicationStatusNull() == false)
                    {
                        this.lnAppStatus.InnerText = tblAppInfo[0].datApplicationStatus.ToString();
                    }
                    if (tblAppInfo[0].IsdatDurationNull() == false)
                    {
                        this.lnDuration.InnerText = tblAppInfo[0].datDuration.ToString() + " month(s)";
                    }
                    if (tblAppInfo[0].IsdatBranchNull() == false)
                    {
                        this.lnAppBranch.InnerText = tblAppInfo[0].datBranch.ToString();
                    }
                    if (tblAppInfo[0].IsdatApplicationDateNull() == false)
                    {
                        this.lnAppDate.InnerText = tblAppInfo[0].datApplicationDate.ToLongDateString();
                    }
                }
            }
            catch (Exception ex) { }
        }
        else if (MySessionManager.AccountID > 0)
        {
            this.ItemLoanAccount.Visible = true;
            this.itemLoanApp.Visible     = false;
            LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
            MySessionManager.ClientID = Convert.ToInt32(loanAcc.GetClientIDFromAcc(Convert.ToInt32(MySessionManager.AccountID)));

            try
            {
                mainDSTableAdapters.GetLoanAccountInfoTableAdapter accinfo = new mainDSTableAdapters.GetLoanAccountInfoTableAdapter();
                mainDS.GetLoanAccountInfoDataTable tblAccInfo = accinfo.GetLoanAccountInfo(Convert.ToInt32(MySessionManager.AccountID));
                if (tblAccInfo.Rows.Count > 0)
                {
                    if (tblAccInfo[0].IsdatOutstandingAmountNull() == false)
                    {
                        this.lnOutstanding.InnerText = tblAccInfo[0].datOutstandingAmount.ToString("c").Replace("$", "");
                    }
                    if (tblAccInfo[0].IsdatStartDateNull() == false)
                    {
                        this.lnStartDate.InnerText = tblAccInfo[0].datStartDate.ToLongDateString();
                    }
                    if (tblAccInfo[0].IsdatEndDateNull() == false)
                    {
                        this.lnEndDate.InnerText = tblAccInfo[0].datEndDate.ToLongDateString();
                    }
                    if (tblAccInfo[0].IsdatBranchNull() == false)
                    {
                        this.lnAccBranch.InnerText = tblAccInfo[0].datBranch.ToString();
                    }
                    this.btnTransactions.HRef   = "~/pages/transactions.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=entry";
                    this.btnViewStatement.HRef  = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=2";
                    this.btnMonitorAccount.HRef = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=1";
                }
            }
            catch (Exception ex) { }
        }

        try
        {
            mainDSTableAdapters.GetClientInfoTableAdapter clientInfo = new mainDSTableAdapters.GetClientInfoTableAdapter();
            mainDS.GetClientInfoDataTable tblClientInfo = clientInfo.GetClientInfo(MySessionManager.ClientID);
            if (tblClientInfo.Rows.Count > 0)
            {
                if (tblClientInfo[0].IsdatClientNameNull() == false)
                {
                    clientname.InnerText = tblClientInfo[0].datClientName.ToString();
                }
                if (tblClientInfo[0].IsdatClientNumberNull() == false)
                {
                    clientNo.InnerText = tblClientInfo[0].datClientNumber.ToString();
                }
                if (tblClientInfo[0].IsdatMobileNumber1Null() == false)
                {
                    clMobile.InnerText = tblClientInfo[0].datMobileNumber1.ToString();
                }
            }
        }
        catch (Exception ex) { }
    }