Samuele E. Locatelli
148 lines
6.4 KiB
Transact-SQL
148 lines
6.4 KiB
Transact-SQL
------------------------------------------------------------------------------------------------------
|
|
-- Utenti
|
|
------------------------------------------------------------------------------------------------------
|
|
carlo.viviani@gmail.com Viviani Carlo carlo.viviani@gmail.com BM5U64BBGG4ULA08NL6X 1001 True IT False
|
|
ceo@steamware.net CEO USER ceo@steamware.net BM5U64BBGG4ULA08NL6X 1001 True IT False
|
|
giancarlo@steamware.net Rottoli Giancarlo giancarlo@steamware.net BM5U64BBGG4ULA08NL6X 1001 True IT False
|
|
johnny.colleoni@cms.it Colleoni Johnny johnny.colleoni@cms.it 3QZA06RKIH5A0WT7SPYD 1001 True IT False
|
|
marco.labaria@cms.it Labaria Marco marco.labaria@cms.it B2A3IZXOES1S503C4H7L 1001 True IT False
|
|
mario.volpi@cms.it Volpi Mario mario.volpi@cms.it 1RZGII6IW2NJJF95KGN7 1001 True IT False
|
|
michele.zanchi@cms.it Zanchi Michele michele.zanchi@cms.it ES34RWTC5NZ0LYUVRKUL 1001 True IT False
|
|
piercarlo.moreschi@cms.it Moreschi Piercarlo piercarlo.moreschi@cms.it 9M7A7RRUC85EUFXYAJVP 1001 True IT False
|
|
samuele@steamware.net Locatelli Samuele samuele@steamware.net BM5U64BBGG4ULA08NL6X 1001 True IT False
|
|
santo.benintendi@cms.it Benintendi Santo santo.benintendi@cms.it 91OLLIZGKBUUPZL16ZRQ 1001 True IT False
|
|
simone.baroni@cms.it Baroni Simone simone.baroni@cms.it HLNOX02RAELTZKIGEZQE 1001 True IT False
|
|
valerio.benintendi@cms.it Benintendi Valerio valerio.benintendi@cms.it M0DIMN8SLHQ5AP3X48BT 1001 True IT False
|
|
vittorio.paninforni@cms.it Paninforni Vittorio vittorio.paninforni@cms.it 57SF2P1GF7O2E7SQW0C7 1001 True IT False
|
|
|
|
|
|
------------------------------------------------------------------------------------------------------
|
|
-- Diritti
|
|
------------------------------------------------------------------------------------------------------
|
|
carlo.viviani@gmail.com X999 CMS_SC CapoGruppo
|
|
carlo.viviani@gmail.com X999 CMS_SC CapoOfficina
|
|
carlo.viviani@gmail.com X999 CMS_SC SuperAdmin
|
|
carlo.viviani@gmail.com X999 CMS_SC User
|
|
ceo@steamware.net X999 CMS_SC User
|
|
giancarlo@steamware.net X999 CMS_SC CapoGruppo
|
|
giancarlo@steamware.net X999 CMS_SC CapoOfficina
|
|
giancarlo@steamware.net X999 CMS_SC SuperAdmin
|
|
giancarlo@steamware.net X999 CMS_SC User
|
|
johnny.colleoni@cms.it X999 CMS_SC User
|
|
marco.labaria@cms.it X999 CMS_SC User
|
|
mario.volpi@cms.it X999 CMS_SC CapoGruppo
|
|
mario.volpi@cms.it X999 CMS_SC CapoOfficina
|
|
mario.volpi@cms.it X999 CMS_SC CqSetSC
|
|
mario.volpi@cms.it X999 CMS_SC User
|
|
michele.zanchi@cms.it X999 CMS_SC User
|
|
piercarlo.moreschi@cms.it X999 CMS_SC User
|
|
samuele@steamware.net X999 CMS_SC CapoGruppo
|
|
samuele@steamware.net X999 CMS_SC CapoOfficina
|
|
samuele@steamware.net X999 CMS_SC CqSetSC
|
|
samuele@steamware.net X999 CMS_SC SuperAdmin
|
|
samuele@steamware.net X999 CMS_SC User
|
|
santo.benintendi@cms.it X999 CMS_SC User
|
|
simone.baroni@cms.it X999 CMS_SC User
|
|
valerio.benintendi@cms.it X999 CMS_SC CapoGruppo
|
|
valerio.benintendi@cms.it X999 CMS_SC CqSetSC
|
|
valerio.benintendi@cms.it X999 CMS_SC User
|
|
vittorio.paninforni@cms.it X999 CMS_SC User
|
|
|
|
------------------------------------------------------------------------------------------------------
|
|
-- Vocabolario
|
|
------------------------------------------------------------------------------------------------------
|
|
exec voc.stp_insNewLemma 'AuthUserBaseCollaudi','Accesso Utenti Collaudo'
|
|
exec voc.stp_insNewLemma 'AuthUserBaseTitle','Istruzioni'
|
|
exec voc.stp_insNewLemma 'AuthUserBaseInstr01','Inserendo Cognome e Nome gli utenti collaudatori registrati possono accedere alla funzionalità di inserimento dati di Collaudo'
|
|
exec voc.stp_insNewLemma 'btnAuthUserBase','Effettua Login'
|
|
exec voc.stp_insNewLemma 'ErrorEAK04','[ErrorEAK04] Attenzione: profilo utente non corretto per accesso Collaudatore'
|
|
exec voc.stp_insNewLemma 'ErrorEAK05','[ErrorEAK05] Attenzione: email non trovata, prego contattare amministratore!'
|
|
exec voc.stp_insNewLemma 'UserData','Dati Utente'
|
|
exec voc.stp_insNewLemma 'UserRights','Permessi Utente'
|
|
exec voc.stp_insNewLemma 'DevicesList','Elenco Devices Autorizzati'
|
|
exec voc.stp_insNewLemma 'UserAuthOk','User'
|
|
exec voc.stp_insNewLemma 'Logout','Logout'
|
|
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------------------------------
|
|
-- UserParam
|
|
------------------------------------------------------------------------------------------------------
|
|
/****** Object: Table [dbo].[UserParam] Script Date: 29/10/2015 17:24:29 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[UserParam](
|
|
[Email] [nvarchar](250) NOT NULL,
|
|
[ParName] [nvarchar](50) NOT NULL,
|
|
[ParValue] [nvarchar](max) NOT NULL,
|
|
CONSTRAINT [PK_UserParam] PRIMARY KEY CLUSTERED
|
|
(
|
|
[Email] ASC,
|
|
[ParName] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[UserParam] ADD CONSTRAINT [DF_Table_1_email] DEFAULT ('@') FOR [Email]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[UserParam] ADD CONSTRAINT [DF_UserParam_ParValue] DEFAULT ('') FOR [ParValue]
|
|
GO
|
|
|
|
|
|
------------------------------------------------------------------------------------------------------
|
|
-- stored!
|
|
------------------------------------------------------------------------------------------------------
|
|
-- =============================================
|
|
-- Author: S.E. Locatelli
|
|
-- Create date: 2015.10.29
|
|
-- Description: recupera parametro utente da key
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].stp_UsrPar_getByKey
|
|
(
|
|
@email nvarchar(250),
|
|
@ParName nvarchar(50)
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT Email, ParName, ParValue
|
|
FROM dbo.UserParam
|
|
WHERE Email = @email
|
|
AND ParName = @ParName
|
|
|
|
-- =============================================
|
|
-- Author: S.E. Locatelli
|
|
-- Create date: 2015.10.29
|
|
-- Description: upsert record parametro x utente
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[stp_UsrPar_upsert]
|
|
(
|
|
@Email NVARCHAR(250),
|
|
@ParName NVARCHAR(50),
|
|
@ParValue NVARCHAR(MAX)
|
|
)
|
|
AS
|
|
|
|
BEGIN tran
|
|
SET NOCOUNT OFF;
|
|
|
|
-- SE NON HO un record lo inserisco altrimenti update...
|
|
MERGE UserParam AS target
|
|
USING (SELECT @Email, @ParName, @ParValue) AS source (Email, ParName, ParValue)
|
|
ON (target.Email = source.Email AND target.ParName = source.ParName)
|
|
WHEN MATCHED THEN
|
|
UPDATE SET ParValue = source.ParValue
|
|
WHEN NOT MATCHED THEN
|
|
INSERT (Email, ParName, ParValue)
|
|
VALUES (source.Email, source.ParName, source.ParValue);
|
|
|
|
-- Rileggo..
|
|
SELECT Email, ParName, ParValue FROM UserParam WHERE (Email = @Email) AND (ParName = @ParName)
|
|
|
|
COMMIT tran |