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; }
}