Aspnet_roles_getallroles // aspnet_roles_roleexists

Aspnet_roles_getallrolesalter procedure DBO. aspnet_roles_getallroles ---- get all roles
(
@ Applicationname nvarchar (256 ))
As
Begin
Declare @ applicationid uniqueidentifier
Select @ applicationid = NULL
Select @ applicationid = applicationid from aspnet_applications where lower (@ applicationname) = loweredapplicationname
If (@ applicationid is null)
Return
Select rolename
From DBO. aspnet_roles where applicationid = @ applicationid
Order by rolename
/** // * It seems like the simplest one. sort by rolename */
End

Aspnet_roles_roleexistsalter procedure DBO. aspnet_roles_roleexists
@ Applicationname nvarchar (256 ),
@ Rolename nvarchar (256)
As
Begin
Declare @ applicationid uniqueidentifier
Select @ applicationid = NULL
Select @ applicationid = applicationid from aspnet_applications where lower (@ applicationname) = loweredapplicationname
If (@ applicationid is null)
Return (0)
/** // * Return a section of @ applicationid. I am tired of this Code. I have to come here. It's really hard to write them, of course not me */
If (exists (select rolename from DBO. aspnet_roles where lower (@ rolename) = loweredrolename and applicationid = @ applicationid ))
/** // * If this role exists, 1 is returned, and 0 is returned if it does not exist. This seems very simple */
Return (1)
Else
Return (0)
End