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); }