Subversion Repositories SmartDukaan

Rev

Rev 5286 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5286 Rev 16244
Line 7... Line 7...
7 
    <id property="id" column="id"/>
 7 
    <id property="id" column="id"/>
8 
  </resultMap>
 8 
  </resultMap>
9 
 
 9 
 
10 
	<insert id="insertAgent" parameterType="agent" useGeneratedKeys="true" keyProperty="id">
 10 
	<insert id="insertAgent" parameterType="agent" useGeneratedKeys="true" keyProperty="id">
11 
    INSERT INTO agent
 11 
    INSERT INTO agent
12 
      ( name, emailId, password, managerId, is_active)
 12 
      ( name, emailId, password, managerId, is_active, is_pmCrmUser, is_allAssignable)
13 
    VALUES
 13 
    VALUES
14 
      (#{name}, #{emailId},  #{password}, #{managerId}, #{is_active})
 14 
      (#{name}, #{emailId},  #{password}, #{managerId}, #{is_active}, #{is_pmCrmUser}, #{is_allAssignable})
15 
  </insert>
 15 
  </insert>
16 
 
 16 
 
17 
	<insert id="insertAgentRole" parameterType="map">
 17 
	<insert id="insertAgentRole" parameterType="map">
18 
	INSERT INTO user_roles
 18 
	INSERT INTO user_roles
19 
		(agentId, role_name)
 19 
		(agentId, role_name)