Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [Facturas]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE PROCEDURE [dbo].[PROC_AgregarUsuario] @Email VARCHAR(100), @SALT VARCHAR(100), @PASS VARCHAR(100), @PASSWORDECRYPT VARCHAR(100), @Nuevo INT
- AS
- BEGIN
- DECLARE @USERID UNIQUEIDENTIFIER,
- @MensajeRegreso VARCHAR(8000),
- @CantidadContactosEmpresa INT,
- @EmpresaRFC char(13)
- SET @USERID = (SELECT [UserId] FROM [dbo].[aspnet_Users] WHERE [UserName] = @Email)
- IF @Nuevo IN (1, 2)
- BEGIN
- SET @CantidadContactosEmpresa = (SELECT COUNT(*) FROM [dbo].[EmpresaUser] WHERE [EmpresaUser_Empresa] IN (SELECT [EmpresaUser_Empresa] FROM [dbo].[EmpresaUser] WHERE [EmpresaUser_Email] = @Email))
- IF @USERID IS NULL
- BEGIN
- INSERT INTO dbo.aspnet_Users
- ( ApplicationId ,
- UserId ,
- UserName ,
- LoweredUserName ,
- MobileAlias ,
- IsAnonymous ,
- LastActivityDate
- )
- SELECT TOP 1 ApplicationId , -- ApplicationId - uniqueidentifier
- NEWID() , -- UserId - uniqueidentifier
- @Email , -- UserName - nvarchar(256)
- LOWER(@Email) , -- LoweredUserName - nvarchar(256)
- NULL , -- MobileAlias - nvarchar(16)
- 0 , -- IsAnonymous - bit
- GETDATE() -- LastActivityDate - datetime
- FROM dbo.aspnet_Applications
- SET @USERID = (SELECT UserId FROM dbo.aspnet_Users WHERE UserName = @Email)
- INSERT INTO dbo.aspnet_Membership
- ( ApplicationId ,
- UserId ,
- Password ,
- PasswordFormat ,
- PasswordSalt ,
- MobilePIN ,
- Email ,
- LoweredEmail ,
- PasswordQuestion ,
- PasswordAnswer ,
- IsApproved ,
- IsLockedOut ,
- CreateDate ,
- LastLoginDate ,
- LastPasswordChangedDate ,
- LastLockoutDate ,
- FailedPasswordAttemptCount ,
- FailedPasswordAttemptWindowStart ,
- FailedPasswordAnswerAttemptCount ,
- FailedPasswordAnswerAttemptWindowStart ,
- Comment
- )
- SELECT ApplicationId , -- ApplicationId - uniqueidentifier
- @USERID , -- UserId - uniqueidentifier
- @PASSWORDECRYPT , -- Password - nvarchar(128)
- 1 , -- PasswordFormat - int
- @SALT , -- PasswordSalt - nvarchar(128)
- NULL , -- MobilePIN - nvarchar(16)
- @Email , -- Email - nvarchar(256)
- LOWER(@Email) , -- LoweredEmail - nvarchar(256)
- 'Pregunta' , -- PasswordQuestion - nvarchar(256)
- @PASSWORDECRYPT , -- PasswordAnswer - nvarchar(128)
- 1 , -- IsApproved - bit
- 0 , -- IsLockedOut - bit
- GETDATE() , -- CreateDate - datetime
- GETDATE() , -- LastLoginDate - datetime
- GETDATE() , -- LastPasswordChangedDate - datetime
- '18990101' , -- LastLockoutDate - datetime
- 0 , -- FailedPasswordAttemptCount - int
- '18990101' , -- FailedPasswordAttemptWindowStart - datetime
- 0 , -- FailedPasswordAnswerAttemptCount - int
- '18990101', -- FailedPasswordAnswerAttemptWindowStart - datetime
- @PASS -- Comment - ntext
- FROM dbo.[aspnet_Applications]
- /*Rol Empresa*/
- INSERT INTO dbo.aspnet_UsersInRoles
- ( UserId, RoleId )
- SELECT @USERID, -- UserId - uniqueidentifier
- RoleId -- RoleId - uniqueidentifier
- FROM dbo.aspnet_Roles WHERE RoleName IN ('Empresas')
- IF EXISTS (SELECT NULL FROM [dbo].[Empresa] WHERE [EMP_RFC] IN (SELECT [EmpresaUser_Empresa] FROM [dbo].[EmpresaUser] WHERE [EmpresaUser_Email] = @Email))
- BEGIN
- INSERT INTO dbo.aspnet_UsersInRoles
- ( UserId, RoleId )
- SELECT @USERID, -- UserId - uniqueidentifier
- RoleId -- RoleId - uniqueidentifier
- FROM dbo.aspnet_Roles WHERE RoleName IN ('Empresas')
- END
- IF @CantidadContactosEmpresa = 1
- BEGIN
- INSERT INTO dbo.aspnet_UsersInRoles
- ( UserId, RoleId )
- SELECT @USERID, -- UserId - uniqueidentifier
- RoleId -- RoleId - uniqueidentifier
- FROM dbo.aspnet_Roles WHERE RoleName IN ('Empresas')
- END
- SET @MensajeRegreso = 'Creo que funcionó ...'
- END
- ELSE
- BEGIN
- INSERT INTO dbo.aspnet_Users
- ( ApplicationId ,
- UserId ,
- UserName ,
- LoweredUserName ,
- MobileAlias ,
- IsAnonymous ,
- LastActivityDate
- )
- SELECT TOP 1 ApplicationId , -- ApplicationId - uniqueidentifier
- NEWID() , -- UserId - uniqueidentifier
- @Email , -- UserName - nvarchar(256)
- LOWER(@Email) , -- LoweredUserName - nvarchar(256)
- NULL , -- MobileAlias - nvarchar(16)
- 0 , -- IsAnonymous - bit
- GETDATE() -- LastActivityDate - datetime
- FROM dbo.aspnet_Applications
- SET @USERID = (SELECT UserId FROM dbo.aspnet_Users WHERE UserName = @Email)
- INSERT INTO dbo.aspnet_Membership
- ( ApplicationId ,
- UserId ,
- Password ,
- PasswordFormat ,
- PasswordSalt ,
- MobilePIN ,
- Email ,
- LoweredEmail ,
- PasswordQuestion ,
- PasswordAnswer ,
- IsApproved ,
- IsLockedOut ,
- CreateDate ,
- LastLoginDate ,
- LastPasswordChangedDate ,
- LastLockoutDate ,
- FailedPasswordAttemptCount ,
- FailedPasswordAttemptWindowStart ,
- FailedPasswordAnswerAttemptCount ,
- FailedPasswordAnswerAttemptWindowStart ,
- Comment
- )
- SELECT ApplicationId , -- ApplicationId - uniqueidentifier
- @USERID , -- UserId - uniqueidentifier
- @PASSWORDECRYPT , -- Password - nvarchar(128)
- 1 , -- PasswordFormat - int
- @SALT , -- PasswordSalt - nvarchar(128)
- NULL , -- MobilePIN - nvarchar(16)
- @Email , -- Email - nvarchar(256)
- LOWER(@Email) , -- LoweredEmail - nvarchar(256)
- 'Pregunta' , -- PasswordQuestion - nvarchar(256)
- @PASSWORDECRYPT , -- PasswordAnswer - nvarchar(128)
- 1 , -- IsApproved - bit
- 0 , -- IsLockedOut - bit
- GETDATE() , -- CreateDate - datetime
- GETDATE() , -- LastLoginDate - datetime
- GETDATE() , -- LastPasswordChangedDate - datetime
- '18990101' , -- LastLockoutDate - datetime
- 0 , -- FailedPasswordAttemptCount - int
- '18990101' , -- FailedPasswordAttemptWindowStart - datetime
- 0 , -- FailedPasswordAnswerAttemptCount - int
- '18990101', -- FailedPasswordAnswerAttemptWindowStart - datetime
- @PASS -- Comment - ntext
- FROM dbo.[aspnet_Applications]
- /*Rol Empresa*/
- INSERT INTO dbo.aspnet_UsersInRoles
- ( UserId, RoleId )
- SELECT @USERID, -- UserId - uniqueidentifier
- RoleId -- RoleId - uniqueidentifier
- FROM dbo.aspnet_Roles WHERE RoleName IN ('Empresas')
- IF EXISTS (SELECT NULL FROM [dbo].[Empresa] WHERE [EMP_RFC] IN (SELECT [EmpresaUser_Empresa] FROM [dbo].[EmpresaUser] WHERE [EmpresaUser_Email] = @Email))
- BEGIN
- INSERT INTO dbo.aspnet_UsersInRoles
- ( UserId, RoleId )
- SELECT @USERID, -- UserId - uniqueidentifier
- RoleId -- RoleId - uniqueidentifier
- FROM dbo.aspnet_Roles WHERE RoleName IN ('Empresas')
- END
- SET @PASS = (SELECT TOP 1 [EmpresaUser_Password] FROM [dbo].[EmpresaUser] WHERE [EmpresaUser_Email] = @Email ORDER BY [EmpresaUser_Email])
- UPDATE [dbo].[EmpresaUser] SET [EmpresaUser_Password] = @PASS WHERE [EmpresaUser_Email] = @Email
- SET @MensajeRegreso = 'No creo que funcione ...'
- END
- END
- IF @Nuevo IN (0, 1)
- BEGIN
- SELECT @MensajeRegreso AS Mensaje
- END
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement