SQL SP GetUserData for api

USE [Nobolo]

GO

/****** Object:  StoredProcedure [dbo].[SpGetUserData]    Script Date: 7/8/2020 1:22:10 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SpGetUserData] 

@UserID bigint = 0,

@IsNewUser int = 0,

@ReturnMessage varchar(200) = null output ,

@ReturnValue bigint = 0

AS

BEGIN

select top 1 UsersID,

IsNull(A.Name,'') as Name,

IsNULL(A.Email,'') as Email,

A.PhoneNumber ,

A.ThumbnailURL,

A.RecordStatus,

A.CreatedDate,

A.ModifiedDate,

A.DeviceModel,

A.DeviceOSVersion,

A.[TimeZoneMinutes],

A.AppVersion,

A.DeviceType,

A.DeviceUTCOffset,

A.DeviceToken,

A.DeviceLat,

A.DeviceLong,

A.[IsEntertainingRequestForCustomer],

A.[IsEntertainingRequestForPhotographer],

--SignUpRole,

A.[VerificationCode],

A.AppCurrentView,

--((A.[Credit]*( select [PhotographersPercentage] from [dbo].[tblSystemConfiguration]))/100) as Credit,

A.[Credit],

A.Token,

C.[IsUserCreditFirst] as UseCreditFirst,

ISNULL(C.[RequestNotificationsToCustomer],0) as RequestNotificationsToCustomer,

IsNull(A.ThiryPartyType,'') as ThirdPartyType,

A.[IsTermsAccepted],

(select top 1 TermUrl from tblTerms order by [TermsID] desc) as TermsAndCondition,

'' as PrivacyURL ,

'' as AppStoreURL,

'' as RateAppURL,

IsNull(A.StripeCustomerID,'') as StripeCustomerID,

Case When (A.[IsEntertainingRequestForCustomer]=0 and A.[IsEntertainingRequestForPhotographer]=0) Then '' Else  IsNull(B.ID,'') end as RequestID,

Case When (A.[IsEntertainingRequestForCustomer]=0 and A.[IsEntertainingRequestForPhotographer]=0) Then '' Else IsNull(B.RequestStatus,'') end as RequestStatus,

A.SpokenLanguages,

A.[ReferralCode],

IsNull(A.IsLoggedIn,'') as IsLoggedIn,

IsNull(C.SettingValue,'') as IsNotificationOn,

[IsPhoneNoChanged],

--(Select [LanguageName] from [dbo].[tblLanguages] F where F.[LanguagesID]=C.[UserLanguageID]) as UserLanguage,

--IsNull(UserName,'') as UserName,

--IsNull(FirstName,'') as FirstName,

--IsNull(LastName,'') as LastName,

@IsNewUser as IsNewUser

--Case 

-- When @IsNewUser = 0 Then 0

-- Else 1

--End as IsNewUser

from tblUsers A

LEFT join tblrequestInfos B

on (A.UsersID = B.UserID OR A.UsersID = B.PhotographerID) and B.RecordStatus = 'Active' and (B.RequestStatus <> 'PhotoUploaded' and B.RequestStatus <> 'Completed' and B.RequestStatus <> 'Declined') 

LEFT join tblUserSettings C

on A.UsersID = C.UserID and C.RecordStatus = 'Active' 

Where A.UsersID = @UserID  

--and (A.RecordStatus = 'Active' OR @IsNewUser=1)

ORDER BY ISNULL(B.ID,A.UsersID) desc

END