select lawsoncardno,txnpin, membershipid, mobileverifieddate,agreeYn, HasDeclare, idNumber, idExpiryDate, idIssueCountry, idIssueDate, fullname, * FROM customermaster where username='luffy@yopmail.com' select ADDITIONALADDRESS, membershipid, mobileverifieddate,agreeYn, HasDeclare, isemailverified, * FROM customermastertemp where username='luffy@yopmail.com' select * FROM TBL_MOBILE_OTP_REQUEST where user_id='stha@yopmail.com' delete FROM customermaster where username='hide@yopmail.com' delete FROM CustomerMasterTemp where username='hide@yopmail.com' delete FROM mobile_userRegistration where username='hide@yopmail.com' delete FROM TBL_MOBILE_OTP_REQUEST where user_id='hide@yopmail.com' delete from customerDocument where cdid='132' select * from customerDocument where customerid='48' --11440 select * FROM mobile_userRegistration where username='luffy@yopmail.com' update customermaster set mobileverifieddate=null , mobileapprovedDate=null, HasDeclare=0, agreeYn=0, lawsoncardno='', txnpin=123456,isForcedPwdChange=0 where username='luffy@yopmail.com' select idNumber, idtype, ADDITIONALADDRESS,verificationCode, nativeCountry,* FROM CustomerMastertemp where username='hide@yopmail.com' select idNumber, idtype, ADDITIONALADDRESS, verificationCode,* FROM CustomerMaster where username='hide@yopmail.com' update CustomerMaster set verificationCode=null,ADDITIONALADDRESS='s' where username='hide@yopmail.com' update CustomerMaster set idIssueCountry='' where username='hide@yopmail.com' update CustomerMasterTemp set idtype=null where username='hide@yopmail.com' update customermaster set lawsoncardno='KYC_LATER' where username='hide@yopmail.com' SELECT name FROM sys.procedures WHERE Object_definition(object_id) LIKE '%PROCESSING%' update customermaster set verificationCode='' where username='hide1@yopmail.com' select * FROM TBL_MOBILE_OTP_REQUEST where user_id='luffy@yopmail.com' select * FROM staticDataValue where typeid='8103' UPDATE TBL_MOBILE_OTP_REQUEST set IS_SUCCESS=0 , REQUESTED_DATE=GETDATE(), IS_EXPIRED=0 where user_id='luffy@yopmail.com' update customermaster set lawsoncardno='KYC_NOW' where username='puranpanthi429@gmail.com' update CustomerMasterTemp set isEmailVerified='1' where username='luffy1@yopmail.com' update customermastertemp set isemailverified=1 where username='stha@yopmail.com' EXEC GetUserInfo @flag='basic-reg', @emailId='luffy@yopmail.com' update mobile_userRegistration set isForcePinChange=0 ,isForcePassChange=0 where username='stha@yopmail.com' --CustomerInfoAgree select * FROM staticdatavalue where valueid= '11394' select * FROM staticdatavalue where typeid= '8103' Exec proc_customerDocumentType @flag='getDocByCustomerId' ,@customerId='48' EXEC JsonRx_Proc_UserRegistration @flag='agree' , @username = 'luffy@yopmail.com' EXEC JsonRx_Proc_UserRegistration @flag='save-kyc-option', @username = 'stha@yopmail.com', @registrationType = 'MKYC', @clientId = 'KYC_LATER' EXEC mobile_proc_customerMaster @flag='refresh-customer-info', @userName='stha@yopmail.com',@appVersion='22', @phoneBrand = 'Samsung SM-S908E',@phoneOS= '13',@fcmId = null,@osVersion='33' EXEC proc_InsertRewardPoints @Flag = 'REGISTER', @CustomerId=48,@ReferralId='23' EXEC JsonRx_Proc_UserRegistration_V2 @flag = 'sign-up-v2-new-cust' ,@idNumber = NULL ,@nativeCountry = 'ID' ,@referralCode = 'mob000043' ,@username = 'luffy1@yopmail.com' ,@password = 'P@ssw0rd' ,@clientId = ':2487:aff:fe2c:d631%dummy0' ,@uuid = 'a25982f555d5a7d6' ,@appVersion = '22' ,@phoneBrand = 'Samsung SM-S908E' ,@phoneOs = '13' ,@fcmId = 'fdDb5nE0R9GEoEPNBjKi41:APA91bHCnM3SHP2BdUQj4bluKgz9GBqCRjClz_oggpONZSrVP8_hLTkCyJVa_0065I7LaVlDHDRkXbJzwTA4ondwzen9ZCLrI89ALQs6nBklBnq9s_KEOeqOtG0N6dJdRWWRE3N2duTV' ,@osVersion = '33' ,@fullName = 'Monkey D. Luffy' ,@dob = '12/05/1988' ,@mobile = '9841760699' ,@postalCode = 'l18jq' ,@address1 = 'Eurochange, 11 Wall Street' ,@address2 = 'Nepal' ,@city = 'Liverpool' ,@gender = '98' ,@FirstName = 'Monkey' ,@MiddleName = 'D.' ,@LastName = 'Luffy' EXEC proc_mobile_StaticData @flag='kycV3', @customerId='luffy@yopmail.com' EXEC mobile_proc_customerMaster @flag='refresh-customer-info', @userName = 'atm@yopmail.com', @appVersion = '2.5',@phoneBrand = 'samsung', @phoneOS = 'Quince Tart', @fcmId = 'fsN8yCRWRhWHK2SMzNADr2:APA91bHQZYgZRcdNtcyysnhhqSFC1J8BHW-GpJGS7P6tgXk8JXvHQseq853bETZ_mjvHvR6zSgUSkhcJ8AR0Zb0glj-m3IJyeY8ZF5gKw6sXr-59aKMGGvclXA5L9-nPs2McVME3-WO2', @osVersion = '10' EXEC mobile_proc_customerMaster_V2 @flag='i', @username = 'stha@yopmail.com', @type = '0', @employeerName = null, @monthlyIncome = null, @businessType = null, @mobile = null, @additionalAddress = Nnull, @idType = '10997', @additionalIdType = '11316', @idFront = null, @idBack = null, @idSide = null, @additionalId = null, @additionalIdBack = null, @facePicture = null, @occupation = null, @purposeOfRegistration = null, @otherIdType = null, @otherOccupation = null, @rType = null, @trustDocId = null EXEC proc_SendTransaction @flag ='send', @User = 'stha@yopmail.com' , @SenderId = '21' , @sIpAddress = null , @ReceiverId = '12' , @rFirstName = null , @rMiddleName = null , @rLastName = null , @rIdType = null , @rIdNo = null , @rIdIssue = null , @rIdExpiry = null , @rDob = null , @rMobileNo = null , @rNativeCountry = null , @rStateId = '0' , @rDistrictId = '0' , @rAddress = null , @rCity = null , @rEmail = null , @rAccountNo = null , @sCountryId = '0' , @pCountryId = '0' , @deliveryMethodId = '1' , @pBranchId = '0' , @pBankId = '0' , @collCurr = 'GBP' , @payoutCurr = 'NPR' , @collAmt = '100' , @payoutAmt = '10546.0000' , @transferAmt = '100.0000' , @exRate = '105.4688' , @calBy = 'c' , @tpExRate = '105.4688' , @payOutPartnerId = '394397' , @forexSessionId = '50A0F07E-056A-4800-9341-FD58696D1BEB' , @paymentType = 'wallet' , @PurposeOfRemittance = '11411' , @PurposeOfRemittanceOther = null , @SourceOfFund = '11416' , @SourceOfFundOther = null , @RelWithSender = '11331' , @SourceType = null , @scDiscount = null , @ProcessId = '50A0F07E056A48009341FD58696D1BEB:394397:sendTxn' , @schemeId = null , @goodsOrigin = null , @goodsType = null , @portOfShipment = null , @discountedFee = null select * FROM receiverInformation where receiverid='12' EXEC proc_SendTransaction @flag ='send', @User = 'stha@yopmail.com' , @SenderId = '21' , @sIpAddress = null , @ReceiverId = '12' , @rFirstName = null , @rMiddleName = null , @rLastName = null , @rIdType = null , @rIdNo = null , @rIdIssue = null , @rIdExpiry = null , @rDob = null , @rMobileNo = null , @rNativeCountry = null , @rStateId = '0' , @rDistrictId = '0' , @rAddress = null , @rCity = null , @rEmail = null , @rAccountNo = null , @sCountryId = '0' , @pCountryId = '0' , @deliveryMethodId = '1' , @pBranchId = '0' , @pBankId = '0' , @collCurr = 'GBP' , @payoutCurr = 'NPR' , @collAmt = '100' , @payoutAmt = '10546.0000' , @transferAmt = '100.0000' , @exRate = '105.4688' , @calBy = 'c' , @tpExRate = '105.4688' , @payOutPartnerId = '394397' , @forexSessionId = '50A0F07E-056A-4800-9341-FD58696D1BEB' , @paymentType = 'wallet' , @PurposeOfRemittance = '11411' , @PurposeOfRemittanceOther = null , @SourceOfFund = '11416' , @SourceOfFundOther = null , @RelWithSender = '11331' , @SourceType = null , @scDiscount = null , @ProcessId = '50A0F07E056A48009341FD58696D1BEB:394397:sendTxn' , @schemeId = null , @goodsOrigin = null , @goodsType = null , @portOfShipment = null , @discountedFee = null