Subversion Repositories SmartDukaan

Rev

Rev 4793 | Rev 5286 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4793 Rev 5168
Line 65... Line 65...
65 
  <update id="changeAgentStatus" parameterType="map">
 65 
  <update id="changeAgentStatus" parameterType="map">
66 
  	UPDATE agent
 66 
  	UPDATE agent
67 
  	SET is_active = #{status}
 67 
  	SET is_active = #{status}
68 
  	WHERE emailId = #{emailId}
 68 
  	WHERE emailId = #{emailId}
69 
  </update>
 69 
  </update>
- 
 
 70
- 
 
 71 
  <update id="removeAgentRoles" parameterType="long">
- 
 
 72 
  	DELETE FROM user_roles
- 
 
 73 
  	WHERE agentId = #{id}
- 
 
 74 
  </update>
70
75
71
76
72 
</mapper>
 77 
</mapper>
73 

            78