public StringBuilder UpdateAgencyDetailsDal(AgencyRegistraction agencyInfo) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyID", agencyInfo.AgencyID), new SqlParameter("@AgencyTypeID", agencyInfo.AgencyTypeID), new SqlParameter("@AgencyName", agencyInfo.AgencyName), new SqlParameter("@Address1", agencyInfo.Address1), new SqlParameter("@Address2", agencyInfo.Address2), new SqlParameter("@Pincode", agencyInfo.Pincode), new SqlParameter("@StateID", agencyInfo.stateID), new SqlParameter("@cityID", agencyInfo.CityID), new SqlParameter("@ProfileImage", agencyInfo.ProfileImage), }; var jsonResult = new StringBuilder(); jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetAgencyUpdate, P); return(jsonResult); } catch { throw; } }
public StringBuilder SetAgentRegistrationStep1(AgencyRegistraction agentInfo) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyId", agentInfo.AgencyID), new SqlParameter("@AgencyTypeID", agentInfo.AgencyTypeID), new SqlParameter("@AgencyName", agentInfo.AgencyName), new SqlParameter("@Address1", agentInfo.Address1), new SqlParameter("@Address2", agentInfo.Address2), new SqlParameter("@stateID", agentInfo.stateID), new SqlParameter("@CityID", agentInfo.CityID), new SqlParameter("@Pincode", agentInfo.Pincode), new SqlParameter("@ProfileImage", agentInfo.ProfileImage), new SqlParameter("@CreatedBy", agentInfo.CreatedBy), }; var jsonResult = new StringBuilder(); jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetTmpAgencyRegStep1, P); return(jsonResult); } catch { throw; } }