You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
101 lines
2.8 KiB
101 lines
2.8 KiB
EXEC proc_get_exRate_master @flag = 'False'
|
|
, @user = 'arjundhami554@gmail.com'
|
|
, @sCountryId = '113'
|
|
, @sAgent = '0'
|
|
, @sSuperAgent = '393877'
|
|
, @sBranch = '394395'
|
|
, @senderId = '0'
|
|
, @collCurr = 'GBP'
|
|
, @pCountryId = '151'
|
|
, @pCountry = 'Nepal'
|
|
, @pAgent = '0'
|
|
, @pCurr = 'NPR'
|
|
, @deliveryMethodId = '1'
|
|
, @cAmt = '0.0'
|
|
, @pAmt = '100000.0'
|
|
, @calBy = 'p'
|
|
, @couponCode = null
|
|
, @schemeId = null
|
|
, @payOutPartner = '0'
|
|
, @paymentType = null
|
|
, @cardOnline = null
|
|
, @TPexRate = null
|
|
, @isManualSc = 'N'
|
|
, @manualSc = '0.0'
|
|
, @ProcessFor = 'dashboard'
|
|
, @discountedFee = '0.0'
|
|
|
|
|
|
EXEC proc_get_exRate_master @flag = 'False'
|
|
,@user = 'saraadhikari45@gmail.com'
|
|
,@sCountryId = '113'
|
|
,@sAgent = '0'
|
|
,@sSuperAgent = '393877'
|
|
,@sBranch = '394395'
|
|
,@senderId = '0'
|
|
,@collCurr = 'JPY'
|
|
,@pCountryId = '203'
|
|
,@pCountry = 'Vietnam'
|
|
,@pAgent = '0'
|
|
,@pCurr = 'VND'
|
|
,@deliveryMethodId = '1'
|
|
,@cAmt = '0.0'
|
|
,@pAmt = '50000000.0'
|
|
,@calBy = 'p'
|
|
,@couponCode = NULL
|
|
,@schemeId = NULL
|
|
,@payOutPartner = '0'
|
|
,@paymentType = NULL
|
|
,@cardOnline = NULL
|
|
,@TPexRate = NULL
|
|
,@isManualSc = 'N'
|
|
,@manualSc = '0.0'
|
|
,@ProcessFor = 'dashboard'
|
|
,@discountedFee = '0.0'
|
|
|
|
|
|
|
|
/****** Script for SelectTopNRows command from SSMS ******/
|
|
SELECT tranType,pAgent,*
|
|
FROM [FastMoneyPro_Remit].[dbo].[exRateTreasury] where pCountry='151'
|
|
|
|
--UPDATE [exRateTreasury] set cAgent=NULL where pCountry='151'
|
|
--delete from [exRateTreasury] where exRateTreasuryId='3'
|
|
/****** Script for SelectTopNRows command from SSMS ******/
|
|
SELECT *
|
|
FROM [FastMoneyPro_Remit].[dbo].[defExRate]
|
|
|
|
SELECT pAgent,* FROM exRateTreasury WITH(NOLOCK) WHERE ISNULL(isActive, 'N') = 'Y'
|
|
AND cCurrency = 'GBP' AND pCurrency = 'NPR' AND cAgent = '394395' AND (pAgent=394398)
|
|
AND (pCountry = 151)
|
|
|
|
SELECT exRateTreasuryId,* FROM exRateTreasury WITH(NOLOCK) WHERE ISNULL(isActive, 'N') = 'Y'
|
|
AND cCurrency = 'GBP' AND pCurrency = 'NPR' AND cAgent = '394395' AND pAgent = '394398' AND tranType IS NULL
|
|
|
|
select * FROM agentmaster
|
|
select * FROM dbo.FNAGetExRateDetails(3)
|
|
|
|
SELECT *
|
|
FROM AGENTMASTER(NOLOCK)
|
|
WHERE PARENTID = 394452
|
|
AND ISNULL(ISSETTLINGAGENT, 'N') = 'Y';
|
|
UPDATE AGENTMASTER ISSETTLINGAGENT='N'
|
|
select * FROM dbo.FNAGetBranchFullDetails(394452)
|
|
select * FROM TblPartnerwiseCountry(NOLOCK) WHERE CountryId = '104'
|
|
|
|
select * FROM dbo.FNAGetExRate('233', '0', '394395', 'GBP', '151', '394398', 'NPR', 1)
|
|
|
|
|
|
select * FROM dbo.FNAGetExRate('233', '0', '394395', 'GBP', '151', '394398', 'NPR', 1)
|
|
|
|
SELECT * FROM dbo.FNAGetExRate(233,394395,'','GBP',104,'394452','INR',1)
|
|
SELECT *
|
|
FROM agentMaster(NOLOCK)
|
|
WHERE extCode = 'NP ANYWHERE'
|
|
|
|
SELECT *
|
|
FROM TblPartnerwiseCountry(NOLOCK)
|
|
WHERE CountryId = '151'
|
|
AND IsActive = 1
|
|
AND ISNULL(IsMobileEnabled, 0) = 1
|
|
AND ISNULL(PaymentMethod, @deliveryMethodId) = @deliveryMethodId
|