public static void SetMasterScriptWriteStatus(string testSuiteId)
{
string userName = WinComponent.loginUser;
string buildDate = GlobalFunction.ExecutionTime();
MySQLConnector.RunQuery("UPDATE testsuites SET WRITE_STATUS=1, BUILD_DATE='" + buildDate + "', BUILDER='" + userName + "' WHERE TS_ID=" + testSuiteId);
}
public static void SetScriptCommit(string testSuiteId, string testCaseId, string commitMessage)
{
string commitDate = GlobalFunction.ExecutionTime();
MySQLConnector.RunQuery("UPDATE testsuites SET LAST_COMMIT_DATE='" + commitDate + "', LAST_COMMIT_MESSAGE='" + commitMessage + "' WHERE ts_id=" + testSuiteId);
if (testCaseId != "XXX")
{
MySQLConnector.RunQuery("UPDATE testcases SET LAST_COMMIT_DATE='" + commitDate + "', LAST_COMMIT_MESSAGE='" + commitMessage + "' WHERE ts_id=" + testSuiteId + " AND tc_id=" + testCaseId);
}
}
public static void SetScriptWriteStatus(string testSuiteId, string testCaseId)
{
string ranorexVersion = Ranorex.Host.Local.RanorexVersion;
ranorexVersion = ranorexVersion.Remove(ranorexVersion.Length - 2);
string executionTime = GlobalFunction.ExecutionTime();
string userName = WinComponent.loginUser;
MySQLConnector.RunQuery("UPDATE testcases SET WRITE_STATUS=1, RX_VERSION='" + ranorexVersion + "', BUILD_DATE='" + executionTime + "', BUILDER='" + userName + "' WHERE TS_ID=" + testSuiteId + " AND TC_ID=" + testCaseId);
}
public static void SetUserStatus(string userName, bool logout)
{
if (WinComponent.isDbOk)
{
if (logout)
{
MySQLConnector.RunQuery("UPDATE designers SET ACCESS_POINT=REPLACE(ACCESS_POINT, 'Main|','') WHERE USERNAME='******' AND ACCESS_POINT LIKE '%Web%'");
MySQLConnector.RunQuery("UPDATE designers SET STATUS=0, ACCESS_POINT=NULL WHERE USERNAME='******' AND ACCESS_POINT='Main|'");
}
else
{
MySQLConnector.RunQuery("UPDATE designers SET STATUS=1, ACCESS_POINT=CONCAT(ACCESS_POINT, 'Main|') WHERE USERNAME='******' AND ACCESS_POINT NOT LIKE '%Main%'");
MySQLConnector.RunQuery("UPDATE designers SET STATUS=1, ACCESS_POINT='Main|' WHERE USERNAME='******' AND ACCESS_POINT IS NULL");
}
}
}