Exemplo n.º 1
0
        /// <summary>
        /// This function use to Getting the Transaction Grid
        /// </summary>
        private void BindTransactionGrid(int bankId)
        {
            DataTable dtBankAccId = new DataTable();

            //if (bankId == 0)
            //{
            //int i;
            //dtBankAccId = (DataTable)Session["BankAccId"];
            //if (dtBankAccId.Rows.Count > 0)
            //{
            //    for (i = 0; i < dtBankAccId.Rows.Count; i++)
            //    {
            //       custBankAccId = Convert.ToInt32(dtBankAccId.Rows[i]["CB_CustBankAccId"].ToString());
            //    }
            //}
            //(Session["BankAccId"]);
            // custBankAccId = Convert.ToInt32(ViewState["BankId"]);
            //    TransactionList = customerAccountBo.GetCustomerBankTransaction(custBankAccId);
            //}
            //else
            // {
            TransactionList = customerAccountBo.GetCustomerBankTransaction(bankId, customerVo.CustomerId);
            // }
            DataTable dtTransaction = new DataTable();

            dtTransaction.Columns.Add("WERPBM_BankCode");
            dtTransaction.Columns.Add("WERPBDTM_BankName");
            dtTransaction.Columns.Add("CB_AccountNum");
            dtTransaction.Columns.Add("CCST_TransactionId");
            dtTransaction.Columns.Add("CCST_ExternalTransactionId");
            dtTransaction.Columns.Add("CCST_Transactiondate", typeof(DateTime));
            dtTransaction.Columns.Add("CCST_Desc");
            dtTransaction.Columns.Add("CCST_ChequeNo");
            dtTransaction.Columns.Add("CCST_IsWithdrwal");
            dtTransaction.Columns.Add("WERP_CFCCode");
            dtTransaction.Columns.Add("WERP_CFCName");
            dtTransaction.Columns.Add("CCST_Amount");
            dtTransaction.Columns.Add("CB_HoldingAmount");
            DataRow drTransaction;

            for (int i = 0; i < TransactionList.Count; i++)
            {
                drTransaction     = dtTransaction.NewRow();
                customeraccountVo = new CustomerAccountsVo();
                customeraccountVo = TransactionList[i];
                drTransaction["CCST_TransactionId"] = customeraccountVo.TransactionId.ToString();
                if (!string.IsNullOrEmpty(customeraccountVo.BankName))
                {
                    drTransaction["WERPBM_BankCode"] = customeraccountVo.BankName.ToString();
                }
                if (!string.IsNullOrEmpty(customeraccountVo.WERPBMBankName))
                {
                    drTransaction["WERPBDTM_BankName"] = customeraccountVo.WERPBMBankName.ToString();
                }
                if (!string.IsNullOrEmpty(customeraccountVo.BankName))
                {
                    drTransaction["CB_AccountNum"] = customeraccountVo.BankAccountNum.ToString();
                }

                if (customeraccountVo.ExternalTransactionId == null)
                {
                    drTransaction["CCST_ExternalTransactionId"] = "N/A";
                }
                else
                {
                    drTransaction["CCST_ExternalTransactionId"] = customeraccountVo.ExternalTransactionId.ToString();
                }
                drTransaction["CCST_Transactiondate"] = customeraccountVo.Transactiondate.ToString();
                if (customeraccountVo.CCST_Desc == null)
                {
                    drTransaction["CCST_Desc"] = "N/A";
                }
                else
                {
                    drTransaction["CCST_Desc"] = customeraccountVo.CCST_Desc.ToString().Trim();
                }
                if (customeraccountVo.ChequeNo == null)
                {
                    drTransaction["CCST_ChequeNo"] = "N/A";
                }
                else
                {
                    drTransaction["CCST_ChequeNo"] = customeraccountVo.ChequeNo.ToString().Trim();
                }
                if (customeraccountVo.IsWithdrwal == 0)
                {
                    drTransaction["CCST_IsWithdrwal"] = "CR";
                }
                else
                {
                    drTransaction["CCST_IsWithdrwal"] = "DR";
                }
                if (customeraccountVo.CFCCategoryCode == null)
                {
                    drTransaction["WERP_CFCCode"] = "N/A";
                }
                else
                {
                    drTransaction["WERP_CFCCode"] = customeraccountVo.CFCCategoryCode.ToString();
                }
                drTransaction["WERP_CFCName"] = customeraccountVo.CFCCategoryName.ToString();
                drTransaction["CCST_Amount"]  = double.Parse(customeraccountVo.Amount.ToString());
                dtTransaction.Rows.Add(drTransaction);
            }
            if (TransactionList.Count > 0)
            {
                if (Cache["gvCashSavingTransaction" + customerVo.CustomerId] == null)
                {
                    Cache.Insert("gvCashSavingTransaction" + customerVo.CustomerId, dtTransaction);
                }
                else
                {
                    Cache.Remove("gvCashSavingTransaction" + customerVo.CustomerId);
                    Cache.Insert("gvCashSavingTransaction" + customerVo.CustomerId, dtTransaction);
                }
                gvCashSavingTransaction.DataSource = dtTransaction;
                gvCashSavingTransaction.DataBind();
                gvCashSavingTransaction.Visible = true;
                imgBtnrgHoldings.Visible        = true;
                // BindDDLBankDetails();
            }
            else
            {
                gvCashSavingTransaction.DataSource = dtTransaction;
                gvCashSavingTransaction.DataBind();
                gvCashSavingTransaction.Visible = true;
                imgBtnrgHoldings.Visible        = false;
            }
        }