DB_Script/Deployment/29651-Menu-for-Inward-Remittance/proc_dropDownListsInboundApi.sql

��USE [FastMoneyPro_Remit]
GO
/****** Object:  StoredProcedure [dbo].[proc_dropDownListsInboundApi]    Script Date: 5/6/2024 9:04:42 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  
ALTER PROC [dbo].[proc_dropDownListsInboundApi]  
     @flag   VARCHAR(200)  
    ,@param   VARCHAR(200)  = NULL  
    ,@param1  VARCHAR(200)  = NULL  
    ,@user   VARCHAR(30)   = NULL  
    ,@branchId  INT     = NULL  
    ,@country  VARCHAR(50)   = NULL  
    ,@agentId  VARCHAR(50)   = NULL  
    ,@countryId  INT     = NULL  
    ,@countryName   VARCHAR(100)  = NULL  
    ,@userType  VARCHAR(20)   = NULL  
    ,@groupId  INT     = NULL  
	--,@parentId INT = NULL
AS  
SET NOCOUNT ON;    

IF @flag = 'a-countryPay'  
BEGIN  
 SELECT  
  countryId,  
  UPPER(countryName) countryName  
 FROM countryMaster   
 WHERE ISNULL(isOperativeCountry,'') = 'Y'  
 AND ISNULL(operationType,'B') IN ('B','R')   
 ORDER BY countryName ASC   
 RETURN  
END  

IF @flag = 'a-countrySend'  
BEGIN  
 SELECT  
  countryId,  
  UPPER(countryName) countryName  
 FROM countryMaster   
 WHERE ISNULL(isOperativeCountry,'') = 'Y'  
 AND ISNULL(operationType,'B') IN ('B','S')   
 --AND countryName='UNITED KINGDOM'      -- new added as send country is always korea other remove this condition: sugg by (Prahlad Sir)  
 ORDER BY countryName ASC   
 RETURN;  
END  

IF @flag = 'agentSend'  
BEGIN  
 SELECT  
  agentId,  
  agentName agentName  
 FROM agentMaster am WITH(NOLOCK)   
 WHERE ISNULL(am.agentrole,'B') IN ('B','S')   
 AND agentCountryId = @param  
 AND isSettlingAgent = 'Y'  
 AND ISNULL(am.isActive,'Y') ='Y'  
 AND ISNULL(am.isDeleted,'N') = 'N'  
 ORDER BY agentName ASC   
 RETURN  
END 

ELSE IF @flag = 'branch'        -- Select branchName List According to CountryName and AgentName  
BEGIN  
 SELECT  
  agentId,  
  agentName   
 FROM agentMaster am WITH(NOLOCK)  
 WHERE ISNULL(am.isDeleted, 'N') <> 'Y'  
 AND am.agentType = '2904' AND isActive = 'Y'  
 AND am.agentCountryId = ISNULL(@country,am.agentCountryId) AND  am.parentId = ISNULL(@agentId,am.parentId)   
 ORDER BY agentName ASC  
 RETURN   
END