public string GetHeartbeatCommandAction(string guid, DateTime date)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
SELECT CtrlPc.dbo.VerifArret('" + guid + "',CONVERT(DATETIME,'" + date.ToString("yyyy-MM-dd HH:mm:ss") + @"',120))
");
return(MyExecReqSqlReader.result);
}
public string GetPlageHoraireCommandAction(string guid, DateTime dateheure)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
select CtrlPc.dbo.CtrlPlageHoraire('" + guid + "',CONVERT(DATETIME,'" + dateheure.ToString("yyyy-MM-dd HH:mm:ss") + @"',120))
");
return(MyExecReqSqlReader.result);
}
public SetDateDerniereConnexion(string guid)
{
if (OnlyHexInString(guid))
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
UPDATE [CtrlPc].[dbo].[GUID]
SET [DATE_DERNIERE_CONNEXION]=getdate()
WHERE [GUID]='" + guid + @"'
");
}
}
public string GetArretCommandAction(string guid)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
SELECT ARRET
FROM CtrlPc.dbo.FORCE_ARRET
INNER JOIN CtrlPc.dbo.GUID
ON FORCE_ARRET.ID_GUID=GUID.ID_GUID
WHERE GUID.GUID='" + guid + @"'
");
return(MyExecReqSqlReader.result);
}
public string GetRemLogInfoCommandAction(string guid)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
DECLARE @string varchar(5);
DECLARE @status int;
DECLARE @statusparam int;
DECLARE @type int;
DECLARE @IdGuid int;
SELECT @IdGuid=[ID_GUID]
FROM [CtrlPc].[dbo].[GUID]
WHERE [GUID]='" + guid + @"'
SELECT
@status=[PARAM_HISTO_JOURNAL].[ID_STATUS],
@statusparam=[PARAM_HISTO_JOURNAL].[ID_STATUS_PARAM],
@type=[PARAM_HISTO_JOURNAL].[ID_TYPE]
FROM [CtrlPc].[dbo].[PARAM_HISTO_JOURNAL]
WHERE [ID_GUID]=@IdGuid
AND [PARAM_HISTO_JOURNAL].[DATE] = cast(GETDATE() as date)
SET @string = cast(@status as varchar)+';'+cast(@statusparam as varchar)+';'+cast(@type as varchar)
IF LEN(@string)>3
BEGIN
select @string
END
ELSE
BEGIN
INSERT INTO [CtrlPc].[dbo].[PARAM_HISTO_JOURNAL]
SELECT [PARAM_JOURNAL].ID_PARAM_JOURNAL,[PARAM_JOURNAL].ID_GUID,[PARAM_JOURNAL].ID_STATUS,[PARAM_JOURNAL].ID_STATUS,[PARAM_JOURNAL].ID_TYPE,cast(getdate() as date),0,0,[PARAM_JOURNAL].NB_INSERT_LIGNE,null,getdate()
FROM [CtrlPc].[dbo].[PARAM_JOURNAL]
WHERE [ID_GUID]=@IdGuid
SELECT
@status=[PARAM_HISTO_JOURNAL].[ID_STATUS],
@statusparam=[PARAM_HISTO_JOURNAL].[ID_STATUS_PARAM],
@type=[PARAM_HISTO_JOURNAL].[ID_TYPE]
FROM [CtrlPc].[dbo].[PARAM_HISTO_JOURNAL]
WHERE [ID_GUID]=@IdGuid
AND [PARAM_HISTO_JOURNAL].[DATE] = cast(GETDATE() as date)
SET @string = cast(@status as varchar)+';'+cast(@statusparam as varchar)+';'+cast(@type as varchar)
SELECT @string
END
");
return(MyExecReqSqlReader.result);
}
public string GetPresenceFileCommandAction(string guid, string file)
{
if (OnlyHexInString(guid))
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
EXEC CtrlPc.dbo.PS_FileManager '" + guid + @"','" + @file + @"'
");
return(MyExecReqSqlReader.result);
}
else
{
return("GUID KO");
}
}
public string GetAutoUploadAction(string guid)
{
if (OnlyHexInString(guid))
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
EXEC CtrlPc.dbo.PS_AutoUpload '" + @guid + @"'
");
return(MyExecReqSqlReader.result);
}
else
{
return("GUID KO");
}
}
public string GetExceptionCommandAction(string guid)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
DECLARE @guid varchar(50);
SET @guid='" + guid + @"';
SELECT [EXCEPTION].[EXCEPTION]
FROM [CtrlPc].[dbo].[EXCEPTION]
INNER JOIN [CtrlPc].[dbo].[GUID]
ON [EXCEPTION].[ID_GUID]=[GUID].[ID_GUID]
WHERE [GUID].[GUID]=@guid
");
return(MyExecReqSqlReader.result);
}
public string GetPlanningCommandAction(string guid)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
SELECT
[DATE_DEBUT]
,[DATE_FIN]
FROM [CtrlPc].[dbo].[PLANNING]
INNER JOIN [CtrlPc].[dbo].[GUID]
ON [PLANNING].[ID_GUID]=[GUID].[ID_GUID]
WHERE [GUID].[GUID] = '" + guid + @"'
AND (DATE_DEBUT between getdate()-1 and getdate()+7
OR DATE_FIN between getdate()-1 and getdate()+7)
ORDER BY DATE_DEBUT ASC
");
return(MyExecReqSqlReader.result);
}
public string VerifPresenceDate(string guid)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"EXEC CtrlPc.dbo.PS_ControleInsert '" + guid + "'");
string temp = MyExecReqSqlReader.result;
if (temp.Contains("KO"))
{
return("KO");
}
else if (temp.Contains("OK"))
{
return("OK");
}
else
{
return("RELICA");
}
}
public string GetDownloadFileCommandAction(string guid, DateTime date)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
DECLARE @guid varchar(50);
DECLARE @date datetime;
SET @guid='" + guid + @"';
SET @date='" + date.ToString("yyyyMMdd") + @"';
SELECT [FILE_UPLOAD].[DESTINATION],[FILE_UPLOAD].[SOURCE]
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
");
return(MyExecReqSqlReader.result);
}
public string GetExecProgramAction(string guid, DateTime date)
{
ExecReqSqlReader MyExecReqSqlReader = new ExecReqSqlReader();
MyExecReqSqlReader.ExecuteReq(@"
IF ((SELECT count(*) FROM CtrlPc.dbo.fn_ExecProgram('" + guid + @"',CONVERT(DATETIME,'" + date.ToString("yyyy-MM-dd HH:mm:ss") + @"',120)))>0)
BEGIN
SELECT ID_EXEC,LIBELLE FROM CtrlPc.dbo.fn_ExecProgram('" + guid + @"',CONVERT(DATETIME,'" + date.ToString("yyyy-MM-dd HH:mm:ss") + @"',120))
END
ELSE
BEGIN
(SELECT '0'as ID_EXEC,'0' as LIBELLE)
END
");
string temp = MyExecReqSqlReader.result;
if (temp.Length < 1 || temp == null || temp == "")
{
temp = "0";
}
return(temp);
}
