OAT » TPI Admin

Categoría:

BEGIN TRANSACTION
    DECLARE @CurrentDate DATETIME = GETDATE() 
    DECLARE @AdminID UNIQUEIDENTIFIER
        SELECT @AdminID = UserId 
        FROM SUMACUserDetail 
        WHERE UserName = 'ADMINISTRADOR'
		INSERT INTO SUMACCatalogValue (
			Code
			,DescriptionES
			,CatalogTypeCode
			,IsLocked
			,CreatedDate
			,CreatedBy
			,ModifiedDate
			,ModifiedBy
		)
		VALUES (
			56
			,'Búsqueda de Aranceles'
			,1
			,1
			,@CurrentDate
			,@AdminID
			,@CurrentDate
			,@AdminID
		)
COMMIT;

Privilegio (lectura):

BEGIN TRANSACTION
    DECLARE @CurrentDate DATETIME = GETDATE() 
    DECLARE @AdminID UNIQUEIDENTIFIER
        SELECT @AdminID = UserId 
        FROM SUMACUserDetail 
        WHERE UserName = 'ADMINISTRADOR'
		INSERT INTO SUMACPrivilege (
			PrivilegeCode
			,CategoryCode
			,ActionCode
			,CreatedDate
			,CreatedBy
			,ModifiedDate
			,ModifiedBy
		)
		VALUES (
			62
			,56
			,1
			,@CurrentDate
			,@AdminID
			,@CurrentDate
			,@AdminID
		)
COMMIT;