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