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.
83 lines
4.8 KiB
83 lines
4.8 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_online_dropDownList] Script Date: 7/4/2019 11:35:48 AM ******/
|
|
DROP PROCEDURE [dbo].[proc_online_dropDownList]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_online_dropDownList] Script Date: 7/4/2019 11:35:48 AM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE PROC [dbo].[proc_online_dropDownList]
|
|
@Flag VARCHAR(50),
|
|
@Extra VARCHAR(50) = NULL,
|
|
@customerId INT = NULL
|
|
AS
|
|
SET NOCOUNT ON;
|
|
|
|
IF @Flag ='onlineCountrylist'
|
|
BEGIN
|
|
SELECT countryId, countryName
|
|
FROM countryMaster WITH (NOLOCK)
|
|
WHERE ISNULL(allowOnlineCustomer,'N') = 'Y'
|
|
AND countryName = 'South Korea'
|
|
END
|
|
|
|
ELSE IF @Flag ='allCountrylist'
|
|
BEGIN
|
|
select countryId,countryName = UPPER(countryName)
|
|
FROM dbo.countryMaster (nolock)
|
|
order by ISNULL(isOperativeCountry,'N') DESC,countryName
|
|
END
|
|
|
|
ELSE IF @flag='occupationList'
|
|
BEGIN
|
|
SELECT valueId,detailTitle
|
|
FROM staticdatavalue WITH (NOLOCK)
|
|
WHERE typeid=2000 AND ISNULL(ISActive,'N')='Y'
|
|
END
|
|
|
|
ELSE IF @flag='countryStates'
|
|
BEGIN
|
|
SELECT stateId as valueId,stateName as detailTitle
|
|
FROM countryStateMaster WITH (NOLOCK)
|
|
WHERE countryId=@Extra AND ISNULL(isDeleted,'N')<>'Y'
|
|
END
|
|
|
|
ELSE IF @flag='RecieverList'
|
|
BEGIN
|
|
SELECT receiverid, firstName+isnull(' '+ middleName,' ')+isnull(' '+lastName1,'') +isnull(' ' +lastName2,'') [receiverName]
|
|
from receiverInformation (nolock)
|
|
where customerId=@customerId
|
|
AND country = @Extra
|
|
END
|
|
|
|
ELSE IF @flag='OccupationList'
|
|
BEGIN
|
|
SELECT valueId,detailTitle from staticdatavalue(nolock) where typeid=2000 AND ISNULL(ISActive,'Y')='Y'
|
|
END
|
|
|
|
ELSE IF @flag='GenderList'
|
|
BEGIN
|
|
SELECT valueId,detailTitle from staticdatavalue(nolock) where typeid=4 AND ISNULL(ISActive,'Y')='Y'
|
|
END
|
|
|
|
ELSE IF @flag='IdType'
|
|
BEGIN
|
|
SELECT valueId,detailTitle from staticdatavalue(nolock) where typeid = 1300 AND valueId IN (8008,1302,10997) AND ISNULL(ISActive,'Y')='Y' ORDER BY valueId desc
|
|
END
|
|
ELSE IF @flag='city'
|
|
BEGIN
|
|
--IF NOT EXISTS(SELECT TOP 1 'x' FROM dbo.CityMaster(NOLOCK) WHERE cityName LIKE ''+@Extra+'%')
|
|
--BEGIN
|
|
-- SELECT @Extra AS valueId, @Extra AS detailTitle
|
|
--END
|
|
--ELSE
|
|
BEGIN
|
|
SELECT cityName valueId,cityName detailTitle
|
|
FROM dbo.CityMaster(NOLOCK)
|
|
order by cityName
|
|
END
|
|
END
|
|
GO
|