public static SubScenarioViewModel ToViewModel(this SubScenario entity)
{
return(new SubScenarioViewModel
{
Sub_Scen_Id = entity.Sub_Scen_Id,
Scen_Id = entity.Scen_Id,
ProjectId = entity.ProjectId,
SubScenarioId = entity.SubScenarioId,
ScenarioName = entity.ScenarioName,
SubScenarioName = entity.SubScenarioName,
SubScenarioDesc = entity.SubScenarioDescription,
RunMode = entity.RunMode,
Status = entity.Status,
Active = entity.Active,
IsAutomated = entity.IsAutomated,
IsCompleted = entity.IsCompleted,
TestSubScenExecDate = entity.TestSubScenExecDate,
TestSubScenExecBy = entity.TestSubScenExecBy,
TestSubScenLastStatus = entity.TestSubScenLastStatus,
CreatedBy = entity.CreatedBy,
CreatedDate = entity.CreatedDate,
UpdatedBy = entity.UpdatedBy,
UpdatedDate = entity.UpdatedDate
});
}
public void ShowAnswers()
{
// LoopThroughScenarios();
SubScenario currentSub = scenarios[_currentScenario].GetSub();
_scenarioText.text = currentSub.GetText();
// check if the end of the scenario has been reached
if (currentSub.GetIsEnd())
{
answer1Btn.gameObject.SetActive(false);
// button you won / failed. Return to home
answer2Btn.onClick.RemoveAllListeners();
answer2Btn.onClick.AddListener(delegate { FinishGame(); });
_answerButton2.text = "finish game";
}
else
{
_answers = currentSub.GetAnswers();
_answerButton1.text = _answers[0].Get_answerText();
_answerButton2.text = _answers[1].Get_answerText();
}
}
public async Task <bool> UpdateSubScenario(SubScenario subScenario, int scenId, int projectId)
{
//using (IDbConnection dbConnection = _connectionFactory.GetConnection())
// {
IDbConnection dbConnection = _connectionFactory.GetConnection();
try
{
dbConnection.Open();
// var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId);
// string updateQuery = @"update tblSubScenarios set subscenarioid = @subscenarioid, subscenarioname = @subscenarioname, subscenariodescription = @subscenariodescription, runmode = @runmode, status = @status, active = @active, isautomated = @isautomated, iscompleted = @iscompleted, testsubscenexecdate = @testsubscenexecdate, testsubscenexecby = @testsubscenexecby, testsubscenlaststatus = @testsubscenlaststatus, createdby = @createdby, createddate = @createddate, updatedby = @updatedby, updateddate = @updateddate where cast(sub_scen_id as int) = cast(@sub_scen_id as int) and cast(scen_id as int) = cast(@scenId as int) and cast(projectid as int) = cast(@projectId as int)";
string updateQuery = @"update tblSubScenarios set subscenarioname = @subscenarioname, subscenariodescription = @subscenariodescription where cast(sub_scen_id as int) = cast(@sub_scen_id as int) and cast(scen_id as int) = cast(@scenId as int) and cast(projectid as int) = cast(@projectId as int)";
// string updateQuery = @"update tblScenarios set projectid = @projectid, mainscenarioid = @mainscenarioid, mainscenarioname = @mainscenarioname, mainscenariodescription = @mainscenariodescription, runmode = @runmode, status = @status, active = @active, testscenexecdate = @testscenexecdate, testscenexecby = @testscenexecby, testscenlaststatus = @testscenlaststatus, createdby = @createdby, createddate = @createddate, updatedby = @updatedby, updateddate = @updateddate where scen_id = @scen_id and projectId = @projectId";
var result = await dbConnection.ExecuteAsync(updateQuery, new
{
subScenario.SubScenarioId,
subScenario.SubScenarioName,
subScenario.SubScenarioDescription,
subScenario.RunMode,
subScenario.Status,
subScenario.Active,
subScenario.IsAutomated,
subScenario.IsCompleted,
subScenario.TestSubScenExecDate,
subScenario.TestSubScenExecBy,
subScenario.TestSubScenLastStatus,
subScenario.CreatedBy,
subScenario.CreatedDate,
subScenario.UpdatedBy,
subScenario.UpdatedDate,
subScenario.Sub_Scen_Id,
scenId,
projectId
});
return(Convert.ToBoolean(result));
}
catch (NpgsqlException ex)
{
Console.Write(ex.Message);
throw ex;
}
catch (Exception ex)
{
Console.Write(ex.Message);
throw ex;
}
finally
{
dbConnection.Close();
dbConnection.Dispose();
}
}
public async Task <bool> CreateSubScenario(SubScenario SubScenario)
{
// throw new NotImplementedException();
// using (IDbConnection dbConnection = _connectionFactory.GetConnection())
// {
IDbConnection dbConnection = _connectionFactory.GetConnection();
try
{
dbConnection.Open();
// var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId);
// string updateQuery = @"Update tblUsers set email = @email where userid =@userid";
string createQuery = @"Insert into tblSubScenarios(projectid, scen_id, sub_scen_id, subscenarioid, subscenarioname, subscenariodescription,runmode, status, active, isautomated, iscompleted, testsubscenexecdate, testsubscenexecby, testsubscenlaststatus, createdby, createddate, updatedby, updateddate) values (@projectId, @scen_id, nextval('tblsubscenarios_sub_scen_id_seq'::regclass), @subscenarioid, @subscenarioname, @subscenariodescription, @runmode, @status, @active, @isautomated, @iscompleted, @testsubscenexecdate, @testsubscenexecby, @testsubscenlaststatus, @createdby, @createdDate, @updatedBy, @updateddate)";
var result = await dbConnection.ExecuteAsync(createQuery, new
{
SubScenario.ProjectId,
SubScenario.Scen_Id,
//SubScenario.Sub_Scen_Id,
SubScenario.SubScenarioId,
SubScenario.SubScenarioName,
SubScenario.SubScenarioDescription,
SubScenario.RunMode,
SubScenario.Status,
SubScenario.Active,
SubScenario.IsAutomated,
SubScenario.IsCompleted,
SubScenario.TestSubScenExecDate,
SubScenario.TestSubScenExecBy,
SubScenario.TestSubScenLastStatus,
SubScenario.CreatedBy,
SubScenario.CreatedDate,
SubScenario.UpdatedBy,
SubScenario.UpdatedDate
});
return(Convert.ToBoolean(result));
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConnection.Close();
dbConnection.Dispose();
}
}
public void ClickOn()
{
SubScenario currentSub = scenarios[_currentScenario].GetSub();
_answers = currentSub.GetAnswers();
if (_currentButtonId == 1)
{
scenarios[_currentScenario].SetCurrentSub(_answers[0].Get_nextScenario());
}
else
{
scenarios[_currentScenario].SetCurrentSub(_answers[1].Get_nextScenario());
}
ShowAnswers();
}
public async Task <bool> DeleteSubScenario(SubScenario subScenario)
{
//throw new NotImplementedException();
//using (IDbConnection dbConnection = _connectionFactory.GetConnection())
//{
IDbConnection dbConnection = _connectionFactory.GetConnection();
try
{
// IDbConnection dbConnection = _connectionFactory.GetConnection()
dbConnection.Open();
// var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId);
// string delQuery = @"delete from tblprojects where projectid = '" + projId + "'";
string delQuery = @"delete from tblteststeps where cast(sub_scen_id as int) = cast(@sub_scen_id as int) and cast(projectid as int) = cast(@projectid as int)";
var result = await dbConnection.ExecuteAsync(delQuery, new
{
sub_scen_id = subScenario.Sub_Scen_Id,
projectid = subScenario.ProjectId
});
delQuery = @"delete from tblsubscenarios where cast(sub_scen_id as int) = cast(@sub_scen_id as int) and cast(projectid as int) = cast(@projectid as int)";
result = await dbConnection.ExecuteAsync(delQuery, new
{
sub_scen_id = subScenario.Sub_Scen_Id,
projectid = subScenario.ProjectId
});
// var result = await dbConnection.ExecuteAsync(delQuery);
var result1 = Convert.ToBoolean(result);
return(Convert.ToBoolean(result));
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConnection.Close();
dbConnection.Dispose();
}
}
