public StringBuilder UpdateAgentBankDetailsDl(AgencyBankAccount agentInfo) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyID", agentInfo.TmpAgencyID), new SqlParameter("@AccountName", agentInfo.AccountName), new SqlParameter("@AccountNumber", agentInfo.AccountNo), new SqlParameter("@IFSCCode", agentInfo.IFSCCode), new SqlParameter("@CreatedBy", agentInfo.CreatedBy), }; var jsonResult = new StringBuilder(); jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.GetConnectionString, SPKeys.SPSetUpdateAgencyBankAccount, P); return(jsonResult); } catch { throw; } }
public StringBuilder SetAgencyBankAccountStep2(AgencyBankAccount agentBankInfo) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@TmpAgencyID", Convert.ToInt64(agentBankInfo.TmpAgencyID)), new SqlParameter("@AccountName", agentBankInfo.AccountName), new SqlParameter("@AccountNo", agentBankInfo.AccountNo), new SqlParameter("@IFSCCode", agentBankInfo.IFSCCode), new SqlParameter("@CreatedBy", Convert.ToInt64(agentBankInfo.CreatedBy)), }; var jsonResult = new StringBuilder(); jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetTmpAgencyBankAccount, P); return(jsonResult); } catch { throw; } }