public void SetDownloadFileCommandAction(string guid, DateTime date, string dest, string source)
{
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(@"
DECLARE @guid varchar(50);
DECLARE @date datetime;
DECLARE @dest varchar(50);
DECLARE @source varchar(50);
SET @guid='" + guid + @"';
SET @date='" + date.ToString("yyyyMMdd") + @"';
SET @dest='" + dest + @"';
SET @source='" + source + @"';
UPDATE [CtrlPc].[dbo].[FILE_UPLOAD]
SET [UPLOADED]=1, [DATE_UPLOADED]=@date
FROM [CtrlPc].[dbo].[FILE_UPLOAD]
INNER JOIN [CtrlPc].[dbo].[GUID]
ON [FILE_UPLOAD].ID_GUID=[GUID].[ID_GUID]
WHERE [GUID].[GUID]=@guid
AND [FILE_UPLOAD].[DATE_UPLOAD]<=CAST(@date as date)
AND [FILE_UPLOAD].[UPLOADED]=0
AND [FILE_UPLOAD].[DESTINATION]=@dest
AND [FILE_UPLOAD].[SOURCE]=@source
");
}
public SetExecProgramCommand(int idexec, DateTime date)
{
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(@"
UPDATE [CtrlPc].[dbo].[EXEC_PROGRAM] SET DATE_DERNIERE_EXECUTION=CONVERT(DATETIME,'" + date.ToString("yyyy-MM-dd HH:mm:ss") + @"') WHERE ID_EXEC=" + idexec + @"
");
}
public SetResetPresenceCommand(string guid)
{
if (OnlyHexInString(guid))
{
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(@"
UPDATE CtrlPc.dbo.FILE_MANAGER SET PRESENCE=0 WHERE ID_GUID=(SELECT ID_GUID FROM CtrlPc.dbo.GUID WHERE GUID='" + @guid + @"')
");
}
}
public void CreateGuidAction(string hostname, string guid, string identifiant, string version)
{
string requete = @"
DECLARE @GUID varchar(50);
DECLARE @VERSION varchar(10);
DECLARE @HOSTNAME varchar(500);
DECLARE @IDENTIFIANT varchar(500);
SET @GUID='" + guid + @"';
SET @VERSION='" + version + @"';
SET @HOSTNAME='" + hostname + @"';
SET @IDENTIFIANT='" + identifiant + @"';
IF EXISTS (SELECT * FROM [CtrlPc].[dbo].[GUID] WHERE [GUID]=@GUID)
BEGIN
UPDATE [CtrlPc].[dbo].[GUID]
SET [VERSION]=@VERSION, [DATE_MODIFICATION]=GETDATE()
WHERE [GUID]=@GUID
END
ELSE
BEGIN
INSERT INTO [CtrlPc].[dbo].[GUID]
([ID_USER]
,[GUID]
,[HOTSNAME]
,[VERSION])
VALUES
((SELECT ID_USER FROM [CtrlPc].[dbo].[USER] WHERE EMAIL=@IDENTIFIANT)
,@GUID
,@HOSTNAME
,@VERSION)
END
";
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(requete);
}
public void TraceLogAction(string guid, DateTime dateTraitement, string codeappli, int codeerreur, string description)
{
if (description.Contains("'"))
{
description = description.Replace("'", "''");
}
string requete = @"
DECLARE @GUID varchar(50);
DECLARE @DATETRAITEMENT varchar(50);
DECLARE @CODEAPPLI varchar(50);
DECLARE @CODEERREUR int;
DECLARE @DESCRIPTION varchar(max);
SET @GUID='" + guid + @"';
SET @DATETRAITEMENT='" + dateTraitement.ToString("yyyy-MM-dd HH:mm:ss.FF") + @"';
SET @CODEAPPLI='" + codeappli + @"';
SET @CODEERREUR=" + codeerreur + @";
SET @DESCRIPTION='" + description + @"';
INSERT INTO [CtrlPc].[dbo].[JOURNAL]
([ID_GUID]
,[DATE_TRAITEMENT]
,[CODE_APPLI]
,[CODE_ERREUR]
,[DESCRITION])
VALUES
((SELECT ID_GUID FROM [CtrlPc].[dbo].[GUID] WHERE [GUID]=@GUID)
,@DATETRAITEMENT
,(SELECT ID_APPLI FROM [CtrlPc].[dbo].[APPLICATION] WHERE [LIBELLE]=@CODEAPPLI)
,@CODEERREUR
,@DESCRIPTION)
";
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(requete);
}
public SetIncrementeRelicaCommand(string guid)
{
ExecReqSqlNoQuery MyExecReqSqlNoQuery = new ExecReqSqlNoQuery();
MyExecReqSqlNoQuery.ExecuteReq(@"EXEC CtrlPc.dbo.PS_ControleInsert '" + guid + "'");//cela va juste incrémenter le relica
}
