/// <summary> /// Gets All the Details of a Bank Account beloging to a Customer /// </summary> /// <param name="customerId">CustomerId of the customer who holds the Bank Account</param> /// <param name="customerBankAccId">Bank Account Id of the Bank Account to be retrieved</param> /// <returns>Returns Object holding Bank Details</returns> public CustomerBankAccountVo GetCustomerBankAccount(int customerId, int customerBankAccId) { CustomerBankAccountVo customerBankAccountVo = new CustomerBankAccountVo(); CustomerBankAccountDao customerBankAccountDao = new CustomerBankAccountDao(); try { customerBankAccountVo = customerBankAccountDao.GetCusomerBankAccount(customerId, customerBankAccId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountBo.cs:GetCusomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = customerBankAccId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(customerBankAccountVo); }
/// <summary> /// Method to Edit the Bank Account Details /// </summary> /// <param name="customerBankAccountVo">Object holding all the details of the Bank Account to be created.</param> /// <param name="customerId">CustomerId of the customer whose Bank Account the method Edits</param> /// <returns>Returns a boolean Variable stating if the Method is successful</returns> public bool UpdateCustomerBankAccount(CustomerBankAccountVo customerBankAccountVo, int customerId) { bool bResult = false; CustomerBankAccountDao customerBankAccountDao = new CustomerBankAccountDao(); try { bResult = customerBankAccountDao.UpdateCustomerBankAccount(customerBankAccountVo, customerId); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountBo.cs:EditCustomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = customerBankAccountVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
public bool UpdateCustomerBankAccount(CustomerBankAccountVo customerBankAccountVo, int customerId) { bool bResult = false; Database db; DbCommand updateCustomerBankCmd; //string query = "update CustomerBankAccount set CB_CustBankAccId='" + customerBankAccountVo.CustBankAccId + "',CB_BankName='" + customerBankAccountVo.BankName + "',CB_AccountType='" + customerBankAccountVo.AccountType + "',CB_AccountNum='" + customerBankAccountVo.AccountNum + "',CB_ModeOfOperation='" + customerBankAccountVo.ModeOfOperation + "',CB_BranchName='" + customerBankAccountVo.BankName + "',CB_BranchAdrLine1='" + customerBankAccountVo.BranchAdrLine1 + "',CB_BranchAdrLine2='" + customerBankAccountVo.BranchAdrLine2 + "',CB_BranchAdrLine3='" + customerBankAccountVo.BranchAdrLine3 + "',CB_BranchAdrPinCode='" + customerBankAccountVo.BranchAdrPinCode + "',CB_BranchAdrCity='" + customerBankAccountVo.BranchAdrCity + "',CB_BranchAdrState='" + customerBankAccountVo.BranchAdrState + "',CB_BranchAdrCountry='" + customerBankAccountVo.BranchAdrCountry + "',CB_MICR='" + customerBankAccountVo.MICR + "',CB_IFSC='" + customerBankAccountVo.IFSC + "'where C_CustomerId='" + customerId + "'"; try { db = DatabaseFactory.CreateDatabase("wealtherp"); updateCustomerBankCmd = db.GetStoredProcCommand("SP_UpdateCustomerBankAccount"); db.AddInParameter(updateCustomerBankCmd, "@CB_CustBankAccId", DbType.Int32, customerBankAccountVo.CustBankAccId); db.AddInParameter(updateCustomerBankCmd, "@CB_BankName", DbType.String, customerBankAccountVo.BankName); db.AddInParameter(updateCustomerBankCmd, "@XBAT_BankAccountTypeCode", DbType.String, customerBankAccountVo.AccountType); db.AddInParameter(updateCustomerBankCmd, "@CB_AccountNum", DbType.String, customerBankAccountVo.AccountNum); db.AddInParameter(updateCustomerBankCmd, "@XMOH_ModeOfHoldingCode", DbType.String, customerBankAccountVo.ModeOfOperation); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchName", DbType.String, customerBankAccountVo.BankName); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine1", DbType.String, customerBankAccountVo.BranchAdrLine1); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine2", DbType.String, customerBankAccountVo.BranchAdrLine2); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine3", DbType.String, customerBankAccountVo.BranchAdrLine3); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrPinCode", DbType.String, customerBankAccountVo.BranchAdrPinCode); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrCity", DbType.String, customerBankAccountVo.BranchAdrCity); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrState", DbType.String, customerBankAccountVo.BranchAdrState); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrCountry", DbType.String, customerBankAccountVo.BranchAdrCountry); db.AddInParameter(updateCustomerBankCmd, "@CB_Balance", DbType.Decimal, customerBankAccountVo.Balance); db.AddInParameter(updateCustomerBankCmd, "@CB_MICR", DbType.Int64, customerBankAccountVo.MICR); db.AddInParameter(updateCustomerBankCmd, "@CB_IFSC", DbType.String, customerBankAccountVo.IFSC); db.AddInParameter(updateCustomerBankCmd, "@C_CustomerId", DbType.Int32, customerId); db.ExecuteNonQuery(updateCustomerBankCmd); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:UpdateCustomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = customerBankAccountVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); BindSatesToDP(path); } try { SessionBo.CheckSession(); customerVo = (CustomerVo)Session["customerVo"]; customerId = customerVo.CustomerId; customerBankAccId = int.Parse(Session["CustBankAccId"].ToString()); customerBankAccountVo = customerBankAccountBo.GetCustomerBankAccount(customerId, customerBankAccId); txtAccountNumber.Text = customerBankAccountVo.BankAccountNum.ToString(); ddlAccountType.SelectedValue = customerBankAccountVo.AccountType; if (customerBankAccountVo.ModeOfOperation != null && customerBankAccountVo.ModeOfOperation != "") { ddlModeOfOperation.SelectedValue = customerBankAccountVo.ModeOfOperation; } txtBankName.Text = customerBankAccountVo.BankName.ToString(); txtBranchName.Text = customerBankAccountVo.BranchName.ToString(); txtBankAdrLine1.Text = customerBankAccountVo.BranchAdrLine1.ToString(); txtBankAdrLine2.Text = customerBankAccountVo.BranchAdrLine2.ToString(); txtBankAdrLine3.Text = customerBankAccountVo.BranchAdrLine3.ToString(); txtBankAdrPinCode.Text = customerBankAccountVo.BranchAdrPinCode.ToString(); txtBankAdrCity.Text = customerBankAccountVo.BranchAdrCity.ToString(); txtIfsc.Text = customerBankAccountVo.IFSC.ToString(); txtMicr.Text = customerBankAccountVo.MICR.ToString(); if (customerBankAccountVo.BranchAdrState != null && customerBankAccountVo.BranchAdrState != "") { ddlBankAdrState.SelectedValue = customerBankAccountVo.BranchAdrState; } //ddlBankAdrState.SelectedValue = customerBankAccountVo.BranchAdrState; ddlBankAdrCountry.SelectedValue = customerBankAccountVo.BranchAdrCountry; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EditCustomerBankAccount.ascx:Page_Load()"); object[] objects = new object[3]; objects[0] = customerBankAccountVo; objects[1] = customerId; objects[2] = customerBankAccId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public CustomerBankAccountVo GetCusomerIndBankAccount(int customerBankAccId) { CustomerBankAccountDao customerBankAccountDao = new CustomerBankAccountDao(); CustomerBankAccountVo customerBankAccountVo = new CustomerBankAccountVo(); try { // userVo = userDao.Getselectlist(); customerBankAccountVo = customerBankAccountDao.GetCusomerIndBankAccount(customerBankAccId); } catch (BaseApplicationException Ex) { throw Ex; } return(customerBankAccountVo); }
protected void Page_Load(object sender, EventArgs e) { try { SessionBo.CheckSession(); customerId = int.Parse(Session["CustomerId"].ToString()); customerBankAccId = int.Parse(Session["CustBankAccId"].ToString()); customerBankAccountVo = customerBankAccountBo.GetCustomerBankAccount(customerId, customerBankAccId); txtAccountNumber.Text = customerBankAccountVo.AccountNum.ToString(); ddlAccountType.SelectedValue = customerBankAccountVo.AccountType; ddlModeOfOperation.SelectedValue = customerBankAccountVo.ModeOfOperation; txtBankName.Text = customerBankAccountVo.BankName.ToString(); txtBranchName.Text = customerBankAccountVo.BranchName.ToString(); txtBankAdrLine1.Text = customerBankAccountVo.BranchAdrLine1.ToString(); txtBankAdrLine2.Text = customerBankAccountVo.BranchAdrLine2.ToString(); txtBankAdrLine3.Text = customerBankAccountVo.BranchAdrLine3.ToString(); txtBankAdrPinCode.Text = customerBankAccountVo.BranchAdrPinCode.ToString(); txtBankAdrCity.Text = customerBankAccountVo.BranchAdrCity.ToString(); txtIfsc.Text = customerBankAccountVo.IFSC.ToString(); txtMicr.Text = customerBankAccountVo.MICR.ToString(); ddlBankAdrState.SelectedValue = customerBankAccountVo.BranchAdrState; ddlBankAdrCountry.SelectedValue = customerBankAccountVo.BranchAdrCountry; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewAllBankDetails.ascx:Page_Load()"); object[] objects = new object[3]; objects[0] = customerBankAccountVo; objects[1] = customerBankAccId; objects[2] = customerId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
/// <summary> /// Method for Creating a Bank Account for the Customer. /// </summary> /// <param name="customerBankAccountVo">Object holding all the details of the Bank Account to be created.</param> /// <param name="customerId">CustomerId of the customer whose Bank Account the method Creates</param> /// <param name="userId">UserId of the user who is creating the Bank Account for the Customer</param> /// <returns>Returns a boolean Variable stating if the Method is successful</returns> public int CreateCustomerBankAccount(CustomerBankAccountVo customerBankAccountVo, int customerId, int userId) { int accountId; CustomerBankAccountDao customerBankAccountDao = new CustomerBankAccountDao(); try { accountId = customerBankAccountDao.CreateCustomerBankAccount(customerBankAccountVo, customerId, userId); // bResult=true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountBo.cs:CreateCustomerBankAccount()"); object[] objects = new object[3]; objects[0] = customerBankAccountVo; objects[1] = customerId; objects[2] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(accountId); }
public List <CustomerBankAccountVo> GetCustomerBankAccounts(int customerId) { List <CustomerBankAccountVo> accountList = null; CustomerBankAccountVo customerBankAccountVo; Database db; DataSet getCustomerBankDs; DbCommand getCustomerBankCmd; //string query = "select * from CustomerBankAccount where C_CustomerId=" + customerId.ToString() + "and CB_CustBankAccId=" + customerBankAccId.ToString(); try { db = DatabaseFactory.CreateDatabase("wealtherp"); accountList = new List <CustomerBankAccountVo>(); getCustomerBankCmd = db.GetStoredProcCommand("SP_GetCustomerBankAccounts"); db.AddInParameter(getCustomerBankCmd, "@C_CustomerId", DbType.Int32, customerId); getCustomerBankDs = db.ExecuteDataSet(getCustomerBankCmd); if (getCustomerBankDs.Tables[0].Rows.Count > 0) { foreach (DataRow dr in getCustomerBankDs.Tables[0].Rows) { customerBankAccountVo = new CustomerBankAccountVo(); customerBankAccountVo.CustBankAccId = int.Parse(dr["CB_CustBankAccId"].ToString()); customerBankAccountVo.BankName = dr["CB_BankName"].ToString(); customerBankAccountVo.AccountType = dr["XBAT_BankAccountTye"].ToString(); customerBankAccountVo.AccountNum = dr["CB_AccountNum"].ToString(); customerBankAccountVo.ModeOfOperation = dr["XMOH_ModeOfHolding"].ToString(); customerBankAccountVo.BranchName = dr["CB_BranchName"].ToString(); ////customerBankAccountVo.BranchAdrLine1 = dr["CB_BranchAdrLine1"].ToString(); ////customerBankAccountVo.BranchAdrLine2 = dr["CB_BranchAdrLine2"].ToString(); ////customerBankAccountVo.BranchAdrLine3 = dr["CB_BranchAdrLine3"].ToString(); ////customerBankAccountVo.BranchAdrPinCode = int.Parse(dr["CB_BranchAdrPinCode"].ToString()); ////customerBankAccountVo.BranchAdrCity = dr["CB_BranchAdrCity"].ToString(); ////customerBankAccountVo.BranchAdrState = dr["CB_BranchAdrState"].ToString(); ////customerBankAccountVo.BranchAdrCountry = dr["CB_BranchAdrCountry"].ToString(); ////customerBankAccountVo.Balance = float.Parse(dr["CB_Balance"].ToString()); ////customerBankAccountVo.MICR = long.Parse(dr["CB_MICR"].ToString()); ////customerBankAccountVo.IFSC = dr["CB_IFSC"].ToString(); accountList.Add(customerBankAccountVo); } } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:GetCustomerBankAccounts()"); object[] objects = new object[1]; objects[0] = customerId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(accountList); }
/// <summary> /// Function to bind the Details to the Bank Grid /// </summary> public void BindBankDetails() { try { customerBankAccountList = customerBankAccountBo.GetCustomerBankAccounts(customerId); if (customerBankAccountList.Count != 0) { DataTable dtCustomerBankAccounts = new DataTable(); //dtCustomerBankAccounts.Columns.Add("CustBankAccId"); dtCustomerBankAccounts.Columns.Add("Bank Name"); //dtCustomerBankAccounts.Columns.Add("Branch Name"); dtCustomerBankAccounts.Columns.Add("Account Type"); //dtCustomerBankAccounts.Columns.Add("Mode Of Operation"); dtCustomerBankAccounts.Columns.Add("Account Number"); DataRow drCustomerBankAccount; for (int i = 0; i < customerBankAccountList.Count; i++) { drCustomerBankAccount = dtCustomerBankAccounts.NewRow(); customerBankAccountVo = new CustomerBankAccountVo(); customerBankAccountVo = customerBankAccountList[i]; //drCustomerBankAccount[0] = customerBankAccountVo.CustBankAccId.ToString(); drCustomerBankAccount[0] = customerBankAccountVo.BankName.ToString(); //drCustomerBankAccount[2] = customerBankAccountVo.BranchName.ToString(); drCustomerBankAccount[1] = customerBankAccountVo.AccountType.ToString(); //drCustomerBankAccount[4] = customerBankAccountVo.ModeOfOperation.ToString(); drCustomerBankAccount[2] = customerBankAccountVo.AccountNum.ToString(); dtCustomerBankAccounts.Rows.Add(drCustomerBankAccount); } gvBankDetails.DataSource = dtCustomerBankAccounts; gvBankDetails.DataBind(); gvBankDetails.Visible = true; } else { gvBankDetails.Visible = false; lblBankDetailsMsg.Visible = true; lnkMoreBankDetails.Visible = false; gvBankDetails.DataSource = null; gvBankDetails.DataBind(); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RMCustIndividualDashboard.ascx:BindBankDetails()"); object[] objects = new object[0]; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
protected void Page_Load(object sender, EventArgs e) { try { SessionBo.CheckSession(); path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); customerVo = (CustomerVo)Session["CustomerVo"]; customerId = customerVo.CustomerId; customerBankAccId = int.Parse(Session["CustBankAccId"].ToString()); customerBankAccountVo = customerBankAccountBo.GetCustomerBankAccount(customerId, customerBankAccId); lblAccNum.Text = customerBankAccountVo.BankAccountNum.ToString(); //lblAccType.Text = customerBankAccountVo.AccountType; if (customerBankAccountVo.AccountType == "CC") { lblAccType.Text = "C.C."; } if (customerBankAccountVo.AccountType == "CR") { lblAccType.Text = "Current"; } if (customerBankAccountVo.AccountType == "FR") { lblAccType.Text = "F.C.N.R."; } if (customerBankAccountVo.AccountType == "NE") { lblAccType.Text = "NRE"; } if (customerBankAccountVo.AccountType == "NO") { lblAccType.Text = "NRO"; } if (customerBankAccountVo.AccountType == "OD") { lblAccType.Text = "O.D."; } if (customerBankAccountVo.AccountType == "SV") { lblAccType.Text = "Savings"; } if (customerBankAccountVo.AccountType == "OT") { lblAccType.Text = "Other"; } if (customerBankAccountVo.AccountType == "TBC") { lblAccType.Text = "To Be Categorized"; } //lblAccType.Text = XMLBo.GetBankAccountTypes(path, customerBankAccountVo.AccountType); if (customerBankAccountVo.ModeOfOperation == "SO") { lblModeOfOperation.Text = "Self Only"; } if (customerBankAccountVo.ModeOfOperation == "SI") { lblModeOfOperation.Text = "Singly"; } if (customerBankAccountVo.ModeOfOperation == "SE") { lblModeOfOperation.Text = "Severaly"; } if (customerBankAccountVo.ModeOfOperation == "JO") { lblModeOfOperation.Text = "Jointly"; } if (customerBankAccountVo.ModeOfOperation == "AS") { lblModeOfOperation.Text = "Anyone or Survivor"; } if (customerBankAccountVo.ModeOfOperation == "BR") { lblModeOfOperation.Text = "As per Board Resolution"; } if (customerBankAccountVo.ModeOfOperation == "ES") { lblModeOfOperation.Text = "Either or Survivor"; } if (customerBankAccountVo.ModeOfOperation == "FS") { lblModeOfOperation.Text = "Former or Survivor"; } if (customerBankAccountVo.ModeOfOperation == "TBC") { lblModeOfOperation.Text = "To Be Categorized"; } //lblModeOfOperation.Text = customerBankAccountVo.ModeOfOperation; lblBankName.Text = customerBankAccountVo.BankName.ToString(); lblBranchName.Text = customerBankAccountVo.BranchName.ToString(); lblLine1.Text = customerBankAccountVo.BranchAdrLine1.ToString(); lblLine2.Text = customerBankAccountVo.BranchAdrLine2.ToString(); lblLine3.Text = customerBankAccountVo.BranchAdrLine3.ToString(); lblPinCode.Text = customerBankAccountVo.BranchAdrPinCode.ToString(); lblCity.Text = customerBankAccountVo.BranchAdrCity.ToString(); lblIfsc.Text = customerBankAccountVo.IFSC.ToString(); lblMicr.Text = customerBankAccountVo.MICR.ToString(); state = XMLBo.GetStateName(path, customerBankAccountVo.BranchAdrState); lblState.Text = state; lblCountry.Text = customerBankAccountVo.BranchAdrCountry; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewCustomerAllBankDetails.ascx:PageLoad()"); object[] objects = new object[3]; objects[0] = customerBankAccId; objects[1] = customerBankAccountVo; objects[2] = customerId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public CustomerBankAccountVo GetCusomerIndBankAccount(int customerBankAccId) { CustomerBankAccountVo customerBankAccountVo = null; Database db; DataSet getCustomerBankDs; DbCommand getCustomerBankAccCmd; DataRow dr; try { db = DatabaseFactory.CreateDatabase("wealtherp"); getCustomerBankAccCmd = db.GetStoredProcCommand("SP_GetCustomerIndividualBankAccounts"); db.AddInParameter(getCustomerBankAccCmd, "@CB_CustBankAccId", DbType.Int32, customerBankAccId); getCustomerBankDs = db.ExecuteDataSet(getCustomerBankAccCmd); if (getCustomerBankDs.Tables[0].Rows.Count > 0) { customerBankAccountVo = new CustomerBankAccountVo(); dr = getCustomerBankDs.Tables[0].Rows[0]; if (dr["CB_CustBankAccId"].ToString() != "") { customerBankAccountVo.CustBankAccId = int.Parse(dr["CB_CustBankAccId"].ToString()); } if (dr["CP_PortfolioId"].ToString() != "") { customerBankAccountVo.PortfolioId = int.Parse(dr["CP_PortfolioId"].ToString()); } //customerBankAccountVo.BankName = dr["WERPBM_BankCode"].ToString(); //if (dr["XBAT_BankAccountTypeCode"].ToString() == "SB") //{ // customerBankAccountVo.AccountType = "SV"; //} //else //customerBankAccountVo.AccountType = dr["PAIC_AssetInstrumentCategoryCode"].ToString(); //customerBankAccountVo.AccountTypeCode = dr["PAIC_AssetInstrumentCategoryCode"].ToString(); customerBankAccountVo.BankAccountNum = dr["CB_AccountNum"].ToString(); customerBankAccountVo.ModeOfOperation = dr["XMOH_ModeOfHoldingCode"].ToString(); customerBankAccountVo.ModeOfOperationCode = dr["XMOH_ModeOfHolding"].ToString(); customerBankAccountVo.BranchName = dr["CB_BranchName"].ToString(); customerBankAccountVo.BankCity = dr["CB_BankCity"].ToString(); if (dr["CB_IsHeldJointly"].ToString() != "") { customerBankAccountVo.IsJointHolding = int.Parse(dr["CB_IsHeldJointly"].ToString()); } customerBankAccountVo.BranchAdrLine1 = dr["CB_BranchAdrLine1"].ToString(); customerBankAccountVo.BranchAdrLine2 = dr["CB_BranchAdrLine2"].ToString(); customerBankAccountVo.BranchAdrLine3 = dr["CB_BranchAdrLine3"].ToString(); if (dr["CB_BranchAdrPinCode"].ToString() != "") { customerBankAccountVo.BranchAdrPinCode = int.Parse(dr["CB_BranchAdrPinCode"].ToString()); } customerBankAccountVo.RTGSCode = dr["CB_RTGS"].ToString(); customerBankAccountVo.NeftCode = dr["CB_NEFT"].ToString(); //customerBankAccountVo.BranchAdrCity = dr["CB_BranchAdrCity"].ToString(); //customerBankAccountVo.BranchAdrState = dr["CB_BranchAdrState"].ToString(); //customerBankAccountVo.BranchAdrCountry = dr["CB_BranchAdrCountry"].ToString(); if (dr["CB_Balance"].ToString() != "") { customerBankAccountVo.Balance = float.Parse(dr["CB_Balance"].ToString()); } //if (dr["CB_MICR"].ToString() != "") customerBankAccountVo.MICR = dr["CB_MICR"].ToString(); customerBankAccountVo.IFSC = dr["CB_IFSC"].ToString(); if (!string.IsNullOrEmpty(dr["WCMV_BankName"].ToString())) { customerBankAccountVo.BankName = dr["WCMV_BankName"].ToString(); } if (!string.IsNullOrEmpty(dr["WCMV_LookupId_BankId"].ToString())) { customerBankAccountVo.BankId = int.Parse(dr["WCMV_LookupId_BankId"].ToString()); } if (!string.IsNullOrEmpty(dr["WCMV_LookupId_AccType"].ToString())) { customerBankAccountVo.BankAccTypeId = int.Parse(dr["WCMV_LookupId_AccType"].ToString()); } if (!string.IsNullOrEmpty(dr["WCMV_Lookup_BranchAddCityId"].ToString())) { customerBankAccountVo.BranchAddCityId = int.Parse(dr["WCMV_Lookup_BranchAddCityId"].ToString()); } if (!string.IsNullOrEmpty(dr["WCMV_Lookup_BranchAddStateId"].ToString())) { customerBankAccountVo.BranchAddStateId = int.Parse(dr["WCMV_Lookup_BranchAddStateId"].ToString()); } if (!string.IsNullOrEmpty(dr["WCMV_Lookup_BranchAddCountryId"].ToString())) { customerBankAccountVo.BranchAddCountryId = int.Parse(dr["WCMV_Lookup_BranchAddCountryId"].ToString()); } if (!string.IsNullOrEmpty(dr["CB_BankBranchCode"].ToString())) { customerBankAccountVo.BankBranchCode = dr["CB_BankBranchCode"].ToString(); } if (!string.IsNullOrEmpty(dr["CB_IsCurrent"].ToString())) { customerBankAccountVo.IsCurrent = Convert.ToBoolean(dr["CB_IsCurrent"]); } } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:GetCusomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerBankAccId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(customerBankAccountVo); }
public bool UpdateCustomerBankAccount(CustomerBankAccountVo customerBankAccountVo, int customerId) { bool bResult = false; Database db; DbCommand updateCustomerBankCmd; //string query = "update CustomerBankAccount set CB_CustBankAccId='" + customerBankAccountVo.CustBankAccId + "',CB_BankName='" + customerBankAccountVo.BankName + "',CB_AccountType='" + customerBankAccountVo.AccountType + "',CB_AccountNum='" + customerBankAccountVo.AccountNum + "',CB_ModeOfOperation='" + customerBankAccountVo.ModeOfOperation + "',CB_BranchName='" + customerBankAccountVo.BankName + "',CB_BranchAdrLine1='" + customerBankAccountVo.BranchAdrLine1 + "',CB_BranchAdrLine2='" + customerBankAccountVo.BranchAdrLine2 + "',CB_BranchAdrLine3='" + customerBankAccountVo.BranchAdrLine3 + "',CB_BranchAdrPinCode='" + customerBankAccountVo.BranchAdrPinCode + "',CB_BranchAdrCity='" + customerBankAccountVo.BranchAdrCity + "',CB_BranchAdrState='" + customerBankAccountVo.BranchAdrState + "',CB_BranchAdrCountry='" + customerBankAccountVo.BranchAdrCountry + "',CB_MICR='" + customerBankAccountVo.MICR + "',CB_IFSC='" + customerBankAccountVo.IFSC + "'where C_CustomerId='" + customerId + "'"; try { db = DatabaseFactory.CreateDatabase("wealtherp"); updateCustomerBankCmd = db.GetStoredProcCommand("SP_UpdateCustomerBankAccount"); db.AddInParameter(updateCustomerBankCmd, "@CB_CustBankAccId", DbType.Int32, customerBankAccountVo.CustBankAccId); //db.AddInParameter(updateCustomerBankCmd, "@WERPBM_BankCode", DbType.String, customerBankAccountVo.BankName); //db.AddInParameter(updateCustomerBankCmd, "@PAIC_AssetInstrumentCategoryCode", DbType.String, customerBankAccountVo.AccountType); db.AddInParameter(updateCustomerBankCmd, "@CB_AccountNum", DbType.String, customerBankAccountVo.BankAccountNum); db.AddInParameter(updateCustomerBankCmd, "@CB_IsHeldJointly", DbType.Int32, customerBankAccountVo.IsJointHolding); db.AddInParameter(updateCustomerBankCmd, "@XMOH_ModeOfHoldingCode", DbType.String, customerBankAccountVo.ModeOfOperation); db.AddInParameter(updateCustomerBankCmd, "@CB_BankCity", DbType.String, customerBankAccountVo.BankCity); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchName", DbType.String, customerBankAccountVo.BranchName); //if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrLine1)) db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine1", DbType.String, customerBankAccountVo.BranchAdrLine1); // if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrLine2)) db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine2", DbType.String, customerBankAccountVo.BranchAdrLine2); // if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrLine3)) db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrLine3", DbType.String, customerBankAccountVo.BranchAdrLine3); db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrPinCode", DbType.Int64, customerBankAccountVo.BranchAdrPinCode); //if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrCity)) //db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrCity", DbType.String, customerBankAccountVo.BranchAdrCity); // if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrState)) //db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrState", DbType.String, customerBankAccountVo.BranchAdrState); //if (!string.IsNullOrEmpty(customerBankAccountVo.BranchAdrCountry)) //db.AddInParameter(updateCustomerBankCmd, "@CB_BranchAdrCountry", DbType.String, customerBankAccountVo.BranchAdrCountry); db.AddInParameter(updateCustomerBankCmd, "@CB_Balance", DbType.Decimal, customerBankAccountVo.Balance); db.AddInParameter(updateCustomerBankCmd, "@CB_MICR", DbType.String, customerBankAccountVo.MICR); // if (!string.IsNullOrEmpty(customerBankAccountVo.IFSC)) db.AddInParameter(updateCustomerBankCmd, "@CB_RTGS", DbType.String, customerBankAccountVo.RTGSCode); db.AddInParameter(updateCustomerBankCmd, "@CB_NEFT", DbType.String, customerBankAccountVo.NeftCode); db.AddInParameter(updateCustomerBankCmd, "@CB_IFSC", DbType.String, customerBankAccountVo.IFSC); db.AddInParameter(updateCustomerBankCmd, "@C_CustomerId", DbType.Int32, customerId); db.AddInParameter(updateCustomerBankCmd, "@WCMV_LookupId_BankId", DbType.Int32, customerBankAccountVo.BankId); db.AddInParameter(updateCustomerBankCmd, "@WCMV_LookupId_AccType", DbType.Int32, customerBankAccountVo.BankAccTypeId); if (customerBankAccountVo.BranchAddCityId != 0) { db.AddInParameter(updateCustomerBankCmd, "@WCMV_Lookup_BranchAddCityId", DbType.Int32, customerBankAccountVo.BranchAddCityId); } if (customerBankAccountVo.BranchAddStateId != 0) { db.AddInParameter(updateCustomerBankCmd, "@WCMV_Lookup_BranchAddStateId", DbType.Int32, customerBankAccountVo.BranchAddStateId); } if (customerBankAccountVo.BranchAddCountryId != 0) { db.AddInParameter(updateCustomerBankCmd, "@WCMV_Lookup_BranchAddCountryId", DbType.Int32, customerBankAccountVo.BranchAddCountryId); } db.AddInParameter(updateCustomerBankCmd, "@CB_IsCurrent", DbType.Int32, Convert.ToInt32(customerBankAccountVo.IsCurrent)); db.AddInParameter(updateCustomerBankCmd, "@CB_BankBranchCode", DbType.String, customerBankAccountVo.BankBranchCode); db.ExecuteNonQuery(updateCustomerBankCmd); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:UpdateCustomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = customerBankAccountVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
public CustomerBankAccountVo GetCusomerBankAccount(int customerId, int customerBankAccId) { CustomerBankAccountVo customerBankAccountVo = null; Database db; DataSet getCustomerBankDs; DbCommand getCustomerBankAccCmd; DataRow dr; string query = "select * from CustomerBank a INNER JOIN WERPBankDataTransalationMapping b ON a.WERPBM_BankCode = b.WERPBM_BankCode where C_CustomerId=" + customerId + "and CB_CustBankAccId=" + customerBankAccId; try { db = DatabaseFactory.CreateDatabase("wealtherp"); getCustomerBankAccCmd = db.GetSqlStringCommand(query); db.AddInParameter(getCustomerBankAccCmd, "@C_CustomerId", DbType.Int32, customerId); db.AddInParameter(getCustomerBankAccCmd, "@CB_CustBankAccId", DbType.Int32, customerBankAccId); getCustomerBankDs = db.ExecuteDataSet(getCustomerBankAccCmd); if (getCustomerBankDs.Tables[0].Rows.Count > 0) { customerBankAccountVo = new CustomerBankAccountVo(); dr = getCustomerBankDs.Tables[0].Rows[0]; if (dr["CB_CustBankAccId"].ToString() != "") { customerBankAccountVo.CustBankAccId = int.Parse(dr["CB_CustBankAccId"].ToString()); } customerBankAccountVo.BankName = dr["WERPBM_BankCode"].ToString(); if (dr["XBAT_BankAccountTypeCode"].ToString() == "SB") { customerBankAccountVo.AccountType = "SV"; } else { customerBankAccountVo.AccountType = dr["XBAT_BankAccountTye"].ToString(); } customerBankAccountVo.BankAccountNum = dr["CB_AccountNum"].ToString(); customerBankAccountVo.ModeOfOperation = dr["XMOH_ModeOfHolding"].ToString(); customerBankAccountVo.BranchName = dr["CB_BranchName"].ToString(); customerBankAccountVo.BranchAdrLine1 = dr["CB_BranchAdrLine1"].ToString(); customerBankAccountVo.BranchAdrLine2 = dr["CB_BranchAdrLine2"].ToString(); customerBankAccountVo.BranchAdrLine3 = dr["CB_BranchAdrLine3"].ToString(); if (dr["CB_BranchAdrPinCode"].ToString() != "") { customerBankAccountVo.BranchAdrPinCode = int.Parse(dr["CB_BranchAdrPinCode"].ToString()); } customerBankAccountVo.RTGSCode = dr["CB_RTGS"].ToString(); customerBankAccountVo.NeftCode = dr["CB_NEFT"].ToString(); customerBankAccountVo.BranchAdrCity = dr["CB_BranchAdrCity"].ToString(); customerBankAccountVo.BranchAdrState = dr["CB_BranchAdrState"].ToString(); customerBankAccountVo.BranchAdrCountry = dr["CB_BranchAdrCountry"].ToString(); if (dr["CB_Balance"].ToString() != "") { customerBankAccountVo.Balance = float.Parse(dr["CB_Balance"].ToString()); } //if (dr["CB_MICR"].ToString() != "") // customerBankAccountVo.MICR = long.Parse(dr["CB_MICR"].ToString()); customerBankAccountVo.MICR = dr["CB_MICR"].ToString(); customerBankAccountVo.IFSC = dr["CB_IFSC"].ToString(); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:GetCusomerBankAccount()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = customerBankAccId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(customerBankAccountVo); }
public int CreateCustomerBankAccount(CustomerBankAccountVo customerBankAccountVo, int customerId, int userId) { int accountId = 0; // bool bResult = false; Database db; DbCommand createCustomerBankCmd; try { db = DatabaseFactory.CreateDatabase("wealtherp"); createCustomerBankCmd = db.GetStoredProcCommand("SP_CreateCustomerBankAccount"); db.AddInParameter(createCustomerBankCmd, "@C_CustomerId", DbType.Int32, customerId); db.AddInParameter(createCustomerBankCmd, "@WERPBM_BankCode", DbType.String, customerBankAccountVo.BankName); db.AddInParameter(createCustomerBankCmd, "@CP_PortfolioId", DbType.Int32, customerBankAccountVo.PortfolioId); if (!string.IsNullOrEmpty("PAIC_AssetInstrumentCategoryCode".ToString())) { db.AddInParameter(createCustomerBankCmd, "@PAIC_AssetInstrumentCategoryCode", DbType.String, customerBankAccountVo.AccountType); } else { db.AddInParameter(createCustomerBankCmd, "@PAIC_AssetInstrumentCategoryCode", DbType.String, DBNull.Value); } db.AddInParameter(createCustomerBankCmd, "@CB_AccountNum", DbType.String, customerBankAccountVo.BankAccountNum); db.AddInParameter(createCustomerBankCmd, "@CB_IsHeldJointly", DbType.Int32, customerBankAccountVo.IsJointHolding); db.AddInParameter(createCustomerBankCmd, "@XMOH_ModeOfHoldingCode", DbType.String, customerBankAccountVo.ModeOfOperation); db.AddInParameter(createCustomerBankCmd, "@CB_BankCity", DbType.String, customerBankAccountVo.BankCity); db.AddInParameter(createCustomerBankCmd, "@CB_BranchName", DbType.String, customerBankAccountVo.BranchName); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrLine1", DbType.String, customerBankAccountVo.BranchAdrLine1); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrLine2", DbType.String, customerBankAccountVo.BranchAdrLine2); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrLine3", DbType.String, customerBankAccountVo.BranchAdrLine3); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrPinCode", DbType.Int32, customerBankAccountVo.BranchAdrPinCode); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrCity", DbType.String, customerBankAccountVo.BranchAdrCity); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrState", DbType.String, customerBankAccountVo.BranchAdrState); db.AddInParameter(createCustomerBankCmd, "@CB_BranchAdrCountry", DbType.String, customerBankAccountVo.BranchAdrCountry); db.AddInParameter(createCustomerBankCmd, "@CB_Balance", DbType.Decimal, customerBankAccountVo.Balance); if (!string.IsNullOrEmpty(customerBankAccountVo.MICR.ToString())) { db.AddInParameter(createCustomerBankCmd, "@CB_MICR", DbType.Int64, customerBankAccountVo.MICR); } else { db.AddInParameter(createCustomerBankCmd, "@CB_MICR", DbType.Int64, DBNull.Value); } if (!string.IsNullOrEmpty(customerBankAccountVo.RTGSCode.ToString())) { db.AddInParameter(createCustomerBankCmd, "@CB_RTGS", DbType.String, customerBankAccountVo.RTGSCode); } else { db.AddInParameter(createCustomerBankCmd, "@CB_RTGS", DbType.String, DBNull.Value); } if (!string.IsNullOrEmpty(customerBankAccountVo.NeftCode.ToString())) { db.AddInParameter(createCustomerBankCmd, "@CB_NEFT", DbType.String, customerBankAccountVo.NeftCode); } else { db.AddInParameter(createCustomerBankCmd, "@CB_NEFT", DbType.String, DBNull.Value); } if (!string.IsNullOrEmpty(customerBankAccountVo.IFSC.ToString())) { db.AddInParameter(createCustomerBankCmd, "@CB_IFSC", DbType.String, customerBankAccountVo.IFSC); } else { db.AddInParameter(createCustomerBankCmd, "@CB_IFSC", DbType.String, DBNull.Value); } db.AddInParameter(createCustomerBankCmd, "@CB_CreatedBy", DbType.Int32, userId); db.AddInParameter(createCustomerBankCmd, "@CB_ModifiedBy", DbType.Int32, userId); db.AddInParameter(createCustomerBankCmd, "@WCMV_LookupId_BankId", DbType.Int32, customerBankAccountVo.BankId); db.AddInParameter(createCustomerBankCmd, "@WCMV_LookupId_AccType", DbType.Int32, customerBankAccountVo.BankAccTypeId); if (customerBankAccountVo.BranchAddCityId != 0) { db.AddInParameter(createCustomerBankCmd, "@WCMV_Lookup_BranchAddCityId", DbType.Int32, customerBankAccountVo.BranchAddCityId); } if (customerBankAccountVo.BranchAddStateId != 0) { db.AddInParameter(createCustomerBankCmd, "@WCMV_Lookup_BranchAddStateId", DbType.Int32, customerBankAccountVo.BranchAddStateId); } if (customerBankAccountVo.BranchAddCountryId != 0) { db.AddInParameter(createCustomerBankCmd, "@WCMV_Lookup_BranchAddCountryId", DbType.Int32, customerBankAccountVo.BranchAddCountryId); } db.AddOutParameter(createCustomerBankCmd, "@CB_CustBankAccId", DbType.Int32, 10000); db.AddInParameter(createCustomerBankCmd, "@CB_IsCurrent", DbType.Int16, customerBankAccountVo.IsCurrent); if (!string.IsNullOrEmpty(customerBankAccountVo.BankBranchCode.ToString())) { db.AddInParameter(createCustomerBankCmd, "@CB_BankBranchCode", DbType.String, customerBankAccountVo.BankBranchCode); } else { db.AddInParameter(createCustomerBankCmd, "@CB_BankBranchCode", DbType.String, null); } // db.ExecuteNonQuery(createCustomerBankCmd); if (db.ExecuteNonQuery(createCustomerBankCmd) != 0) { accountId = int.Parse(db.GetParameterValue(createCustomerBankCmd, "CB_CustBankAccId").ToString()); } // bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerBankAccountDao.cs:CreateCustomerBankAccount()"); object[] objects = new object[3]; objects[0] = customerBankAccountVo; objects[1] = customerId; objects[2] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(accountId); }
//string customerId = Session["customerId"].ToString(); protected void Page_Load(object sender, EventArgs e) { try { SessionBo.CheckSession(); customerVo = (CustomerVo)Session["CustomerVo"]; customerId = customerVo.CustomerId; customerBankAccountList = customerBankAccountBo.GetCustomerBankAccounts(customerId); if (customerBankAccountList.Count != 0) { lblMsg.Visible = false; DataTable dtCustomerBankAccounts = new DataTable(); // dtAdvisorBranches.Columns.Add(Select"); dtCustomerBankAccounts.Columns.Add("CustBankAccId"); dtCustomerBankAccounts.Columns.Add("Bank Name"); dtCustomerBankAccounts.Columns.Add("Branch Name"); dtCustomerBankAccounts.Columns.Add("Account Type"); dtCustomerBankAccounts.Columns.Add("Mode Of Operation"); dtCustomerBankAccounts.Columns.Add("Account Number"); DataRow drCustomerBankAccount; for (int i = 0; i < customerBankAccountList.Count; i++) { drCustomerBankAccount = dtCustomerBankAccounts.NewRow(); customerBankAccountVo = new CustomerBankAccountVo(); customerBankAccountVo = customerBankAccountList[i]; drCustomerBankAccount[0] = customerBankAccountVo.CustBankAccId.ToString(); drCustomerBankAccount[1] = customerBankAccountVo.BankName.ToString(); drCustomerBankAccount[2] = customerBankAccountVo.BranchName.ToString(); drCustomerBankAccount[3] = customerBankAccountVo.AccountType.ToString(); drCustomerBankAccount[4] = customerBankAccountVo.ModeOfOperation.ToString(); drCustomerBankAccount[5] = customerBankAccountVo.AccountNum.ToString(); dtCustomerBankAccounts.Rows.Add(drCustomerBankAccount); } gvCustomerBankAccounts.DataSource = dtCustomerBankAccounts; gvCustomerBankAccounts.DataBind(); gvCustomerBankAccounts.Visible = true; } else { gvCustomerBankAccounts.DataSource = null; gvCustomerBankAccounts.DataBind(); lblMsg.Visible = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewBankDetails.ascx:Page_Load()"); object[] objects = new object[5]; objects[0] = customerVo; objects[2] = customerBankAccountVo; objects[3] = customerBankAccountList; objects[4] = custBankAccId; objects[5] = customerId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }