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