private TestPass ExecuteTest(long indexer, HostedBenchmarkTest test)
{
if (test.CollectGarbage)
{
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
}
var testPassName = indexer == 0
? string.Format("{0} Initialization", test.Name)
: string.Format("{1} Execution, Pass #{0}", indexer, test.Name);
_logger.WriteEntry(testPassName + " Start", LogLevel.Execution);
test.PerPassSetup();
test.Execute();
test.PerPassTeardown();
var testPass = new TestPass
{
TestName = testPassName,
ExceptionOccurred = test.ThrewException,
ExceptionType = test.ExceptionType,
ExecutionTime = test.ExecutionTime,
Status = test.GetResult()
};
_logger.WriteEntry(testPass.TestName + " " + testPass.Status, LogLevel.Execution);
return(testPass);
}
public async Task <TestPass> SavePass(TestPass pass)
{
pass.PassedAt = DateTime.Now;
_db.Add(pass);
await _db.SaveChangesAsync();
return(pass);
}
/// <summary>
/// Writes all information from a TestPass to a file in JSON format.
/// </summary>
/// <param name="tests">The TestPass to be saved.</param>
public void WriteTestPassToFile(TestPass tests, System.DateTime dateTime, string filename = "tests")
{
try
{
string jsonString = JsonUtility.ToJson(tests);
Log(jsonString);
WriteToFile(filename + ".json", jsonString, dateTimeToPath(dateTime));
}
catch (System.Exception e)
{
Log(e.Message);
}
}
// Start is called before the first frame update
void Start()
{
logger = GetComponent <Logger>();
Time.timeScale = 1.0f;
testPass = new TestPass();
creator = GameObject.FindObjectOfType <RunTimeTestCreator>();
//SetUpTests();
SetUpTutorialTests();
logger.Log("tutorialActive: " + tutorialActive);
logger.Log("tutorials count: " + tutorialTests.Count);
DisableAllTests(GetAllTestsInScene());
screenFade = FindObjectOfType <OVRScreenFade>();
selectionHandler = gameObject.GetComponent <SelectionHandler>();
cameraRig = FindObjectOfType <OVRCameraRig>();
playerController = GameObject.Find("OVRPlayerController");
A_Button_Tooltip = GameObject.Find("A_Button_Tooltip");
X_Button_Tooltip = GameObject.Find("X_Button_Tooltip");
R2_Button_Tooltip = GameObject.Find("R2_Button_Tooltip");
DisableTooltips(R2: false, A: false);
UpdateInfoText();
}
public JsonResult InsertUpdateTestPass_1([FromBody] TestPass testpass)
{
if (string.IsNullOrEmpty(testpass.testPassName) || string.IsNullOrEmpty(testpass.tpStartDate) || string.IsNullOrEmpty(testpass.tpEndDate))
{
Dictionary <string, string> oError = new Dictionary <string, string>();
oError.Add("ERROR", "Mandatory fields are required");
return(Json(oError));
}
else if (testpass.listTestMgr.Count > 0)
{
if (string.IsNullOrEmpty(testpass.listTestMgr[0].alias) || string.IsNullOrEmpty(testpass.listTestMgr[0].email) || string.IsNullOrEmpty(testpass.listTestMgr[0].userName) || string.IsNullOrEmpty(testpass.listTestMgr[0].spUserId))
{
Dictionary <string, string> oError = new Dictionary <string, string>();
oError.Add("ERROR", "TestManager complete details required");
return(Json(oError));
}
}
else if (testpass.listTestMgr.Count == 0)
{
Dictionary <string, string> oError = new Dictionary <string, string>();
oError.Add("ERROR", "TestManager detail required");
return(Json(oError));
}
try
{
string AppUrl = HttpContext.Request.Headers["appurl"];
string SchemaName = "";
if (!string.IsNullOrEmpty(AppUrl))
{
SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl);
}
else
{
return(Json("Invalid Url"));
}
string statementType = string.Empty;
if (string.IsNullOrEmpty(testpass.testPassId))
{
statementType = "Insert";
}
else
{
statementType = "Update";
}
string SuccessMsg = "";
// string SchemaName = new clsUatClient(_context).GetClientSchema(Appurl);
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.CommandText = "UAT.SpTestPass";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TestPassId", SqlDbType.Int)
{
Value = testpass.testPassId
});
cmd.Parameters.Add(new SqlParameter("@ProjectId", SqlDbType.Int, 500)
{
Value = testpass.projectId
});
cmd.Parameters.Add(new SqlParameter("@TestMgrId", SqlDbType.Int, 500)
{
Value = testpass.listTestMgr[0].spUserId
});
cmd.Parameters.Add(new SqlParameter("@TestMgrName", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].userName
});
cmd.Parameters.Add(new SqlParameter("@TestMgrAlias", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].alias
});
cmd.Parameters.Add(new SqlParameter("@TestMgrEmailId", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].email
});
cmd.Parameters.Add(new SqlParameter("@TestMgrSecurityId", SqlDbType.Int, 500)
{
Value = testpass.listTestMgr[0].securityId
});
cmd.Parameters.Add(new SqlParameter("@TestPassName", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassName
});
cmd.Parameters.Add(new SqlParameter("@DisplayID", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassDisplayId
});
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassDesp
});
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.Date, 500)
{
Value = testpass.tpStartDate
});
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.Date, 500)
{
Value = testpass.tpEndDate
});
cmd.Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar, 500)
{
Value = testpass.tpStatus
});
if (!string.IsNullOrEmpty(testpass.tpStatus))
{
cmd.Parameters[cmd.Parameters.Count - 1].Value = GetShortStatus(testpass.tpStatus);
}
else
{
cmd.Parameters[cmd.Parameters.Count - 1].Value = DBNull.Value;
}
cmd.Parameters.Add(new SqlParameter("@StatementType", SqlDbType.VarChar, 500)
{
Value = statementType
});
SqlParameter outparam = new SqlParameter("@Ret_Parameter", SqlDbType.NVarChar, 500)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.NVarChar, 500)
{
Value = SchemaName
});
cmd.Parameters.Add(outparam);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
int i = cmd.ExecuteNonQuery();
var outparam1 = outparam.Value;
if (i == -1)
{
if (Convert.ToString(outparam1) != "" && outparam1 != null)
{
//SuccessMsg = "Insert Successfully..!!";
SuccessMsg = "Done";
}
}
return(Json(SuccessMsg));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public Dictionary <string, string> InsertUpdateTestPass([FromBody] TestPass testpass)
{
Dictionary <string, string> _result = new Dictionary <string, string>();
List <ProjectUser> listMgr = new List <ProjectUser>();
if (string.IsNullOrEmpty(testpass.testPassName) || string.IsNullOrEmpty(testpass.tpStartDate) || string.IsNullOrEmpty(testpass.tpEndDate))
{
//send service level Exception as service response
_result.Add(this._errorText, "Mandatory Fields data is required");
return(_result);
}
else if (testpass.listTestMgr.Count > 0)
{
if (string.IsNullOrEmpty(testpass.listTestMgr[0].alias) || string.IsNullOrEmpty(testpass.listTestMgr[0].email) || string.IsNullOrEmpty(testpass.listTestMgr[0].userName) || string.IsNullOrEmpty(testpass.listTestMgr[0].spUserId))
{
//send service level Exception as service response
_result.Add(this._errorText, "TestManager complete details required");
return(_result);
}
}
else if (testpass.listTestMgr.Count == 0)
{
//send service level Exception as service response
_result.Add(this._errorText, "TestManager detail required");
return(_result);
}
try
{
string AppUrl = HttpContext.Request.Headers["appurl"];
string SchemaName = "";
if (!string.IsNullOrEmpty(AppUrl))
{
SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl);
}
else
{
_result.Add(this._errorText, "Invalid Appurl");
return(_result);
}
string statementType = string.Empty;
if (string.IsNullOrEmpty(testpass.testPassId))
{
statementType = "Insert";
}
else
{
statementType = "Update";
}
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.CommandText = "UAT.SpTestPass";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TestPassId", SqlDbType.Int)
{
Value = testpass.testPassId
});
cmd.Parameters.Add(new SqlParameter("@ProjectId", SqlDbType.Int)
{
Value = testpass.projectId
});
cmd.Parameters.Add(new SqlParameter("@TestMgrId", SqlDbType.Int)
{
Value = testpass.listTestMgr[0].spUserId
});
cmd.Parameters.Add(new SqlParameter("@TestMgrName", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].userName
});
cmd.Parameters.Add(new SqlParameter("@TestMgrAlias", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].alias
});
cmd.Parameters.Add(new SqlParameter("@TestMgrEmailId", SqlDbType.VarChar, 500)
{
Value = testpass.listTestMgr[0].email
});
cmd.Parameters.Add(new SqlParameter("@TestMgrSecurityId", SqlDbType.Int)
{
Value = testpass.listTestMgr[0].securityId
});
cmd.Parameters.Add(new SqlParameter("@TestPassName", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassName
});
cmd.Parameters.Add(new SqlParameter("@DisplayID", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassDisplayId
});
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.NVarChar, 500)
{
Value = testpass.testPassDesp
});
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.VarChar, 500)
{
Value = testpass.tpStartDate
});
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.VarChar, 500)
{
Value = testpass.tpEndDate
});
cmd.Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar, 500)
{
Value = testpass.tpStatus
});
if (!string.IsNullOrEmpty(testpass.tpStatus))
{
cmd.Parameters[cmd.Parameters.Count - 1].Value = GetShortStatus(testpass.tpStatus);
}
else
{
cmd.Parameters[cmd.Parameters.Count - 1].Value = DBNull.Value;
}
cmd.Parameters.Add(new SqlParameter("@StatementType", SqlDbType.VarChar, 500)
{
Value = statementType
});
SqlParameter outparam = new SqlParameter("@Ret_Parameter", SqlDbType.NVarChar, 500)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.NVarChar, 500)
{
Value = SchemaName
});
cmd.Parameters.Add(outparam);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
// int i = cmd.ExecuteNonQuery();
int result = cmd.ExecuteNonQuery();
string _retValue = Convert.ToString(cmd.Parameters["@Ret_Parameter"].Value);
if (result == -1)
{
if (!string.IsNullOrEmpty(_retValue))
{
_result.Add("Value", _retValue);
_result.Add(this._statusText, "Done");
}
else
{
_result.Add(this._statusText, "Done");
}
}
}
}
catch (Exception ex)
{
_result.Add(this._errorText, ex.Message);
}
return(_result);
}
