Update MemberItems and CouponMember table by using coupon.
"DupeYN" value is set "Y", multiple members can use this coupon. "DupeYN" value is set "N", only one member can use it. - set "DeleteYN" to "Y"
2016-03-15 added update GameInfo table by Coupon property.
To update GameInfo table by Coupon, set value to and pass the params. https://github.com/CloudBreadProject/CloudBread/issues/26.
More...
Update MemberItems and CouponMember table by using coupon.
"DupeYN" value is set "Y", multiple members can use this coupon. "DupeYN" value is set "N", only one member can use it. - set "DeleteYN" to "Y"
2016-03-15 added update GameInfo table by Coupon property.
To update GameInfo table by Coupon, set value to and pass the params. https://github.com/CloudBreadProject/CloudBread/issues/26.
- Author
- Dae Woo Kim
- Parameters
-
| string | InsertORUpdate - if itemid exists in memberitem inventory, then "UPDATE". if not, "INSERT". |
| MemberItems | object |
| CouponMember | object |
- Returns
- string "2" or "3" - affected rows. 2 or 3 is depend on "DupeYN" value.
- See also
- uspUdtCouponMember SP, BehaviorID : B15
- Todo:
- change SP to upsert auto method