public Response <Messages.Test> AddTest(NewTest newTest)
{
var test = new Models.Test()
{
IsActive = 1,
TestLabel = newTest.LabelIds.Select(l => new Models.TestLabel()
{
LabelId = l
}).ToArray(),
TestDataSet = newTest.TestDataSetIds.Select(d => new Models.TestDataSet()
{
IsTestSet = 1,
IsTraningSet = 0,
DataSetId = d
}).Union(newTest.TrainingDataSetIds.Select(d => new Models.TestDataSet()
{
IsTestSet = 0,
IsTraningSet = 1,
DataSetId = d
})).ToArray()
};
using (Entities db = new Entities())
{
var added = db.Test.Add(test);
db.SaveChanges();
return(GetTest(added.Id));
}
}
public async void StartNewTest(string fileName = "") // @TODO: Make this asynchronous
{
_testCompleted = false;
_completedWords = 0;
_testTimer.Restart();
_testManager.StartNewTest();
NewTest.Invoke(this, new WordEventArgs(_testManager.GetRemainingWords()));
await Task.Run(async() => RunTest());
}
public int CreateTestEntity(NewTest test)
{
var newTest = new Test
{
Id = UnitOfWork.NextSequenceValue(SequenceName.TestSequence),
Name = test.Name
};
_tests.Add(newTest);
return(newTest.Id);
}
// Use this for initialization
void Start()
{
//Initialization
TestList = new List <NewTest> ();
for (int i = 0; i < population; i++)
{
//insert net creation here
NewTest Trail = new NewTest(i, i.ToString(), testShape);
TestList.Add(Trail);
}
MakeExecuters();
}
private NewTest ParseNewContinueResult(List <usp_ContineTest_Result> result)
{
NewTest newtest = new NewTest();
newtest.TestID = result.First().TestID;
newtest.PersonID = result.First().PersonID;
int questid = result.First().QuestionID;
string questtext = result.First().QuestionText;
List <NewTestQuestAnswer> questanswlist = new List <NewTestQuestAnswer>();
foreach (usp_ContineTest_Result row in result)
{
if (questid != row.QuestionID)
{
var testq = new NewTestQuestion {
QuestionID = questid,
QuestionText = questtext,
Answers = questanswlist
};
newtest.Questions.Add(testq);
questid = row.QuestionID;
questtext = row.QuestionText;
questanswlist = new List <NewTestQuestAnswer>();
}
questanswlist.Add(new NewTestQuestAnswer {
AnswerID = (int)row.AnswerID,
AnswerText = row.AnswerText,
});
}
newtest.Questions.Add(new NewTestQuestion {
QuestionID = questid,
QuestionText = questtext,
Answers = questanswlist
});
return(newtest);
}
private void Categorize()
{
//TestList.Sort();
TestList.RemoveAt(2);
for (int i = 0; i < GameObjectList.Count; i++)
{
GameObject.Destroy(GameObjectList[i].gameObject);
}
MakeExecuters();
NewTest DoubleTrail = TestList[0];
TestList.Add(DoubleTrail);
ObjectTest person = ((GameObject)Instantiate(TestObject, new Vector3(0, 0, 0), Quaternion.identity)).GetComponent <ObjectTest>();
person.SetupTest(TestList[TestList.Count - 1]);
GameObjectList.Add(person);
for (int i = 0; i < TestList.Count; i++)
{
TestList[i].Speak();
}
}
public NewTest StartTest(string token, int count, List <int> topicids)
{
SessionManager sm = new SessionManager(token);
DataTable dtTopics = new DataTable();
dtTopics.Columns.Add("TID", typeof(int));
foreach (int i in topicids)
{
var r = dtTopics.NewRow();
r[0] = i;
dtTopics.Rows.Add(r);
}
SqlParameter ptopicid = new SqlParameter("@topicid", dtTopics);
ptopicid.SqlDbType = SqlDbType.Structured;
ptopicid.TypeName = "dbo.TopicIDs";
SqlParameter pcount = new SqlParameter("@count", count);
SqlParameter ppersonid = new SqlParameter("@personid", sm.Session.PersonID);
string query = "[test].[usp_NewTest] @count, @topicid, @personid";
string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["JolTudomESqlConnectionString"].ConnectionString;
var conn = new SqlConnection(connstring);
var cmd = conn.CreateCommand();
cmd.CommandText = query;
cmd.Parameters.Add(pcount);
cmd.Parameters.Add(ptopicid);
cmd.Parameters.Add(ppersonid);
cmd.CommandTimeout = 700;
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataTable dtresult = new DataTable();
bool closed = conn.State == System.Data.ConnectionState.Closed;
if (closed)
{
conn.Open();
}
try {
dap.Fill(dtresult);
}
finally {
if (closed)
{
conn.Close();
}
}
NewTest newtest = new NewTest();
newtest.TestID = int.Parse(dtresult.Rows[0]["TestID"].ToString());
newtest.PersonID = int.Parse(dtresult.Rows[0]["PersonID"].ToString());
int questid = int.Parse(dtresult.Rows[0]["QuestionID"].ToString());
string questtext = dtresult.Rows[0]["QuestionText"].ToString();
List <NewTestQuestAnswer> questanswlist = new List <NewTestQuestAnswer>();
foreach (DataRow drow in dtresult.Rows)
{
if (questid != int.Parse(drow["QuestionID"].ToString()))
{
var testq = new NewTestQuestion {
QuestionID = questid,
QuestionText = questtext,
Answers = questanswlist
};
newtest.Questions.Add(testq);
questid = int.Parse(drow["QuestionID"].ToString());
questtext = drow["QuestionText"].ToString();
questanswlist = new List <NewTestQuestAnswer>();
}
questanswlist.Add(new NewTestQuestAnswer {
AnswerID = int.Parse(drow["AnswerID"].ToString()),
AnswerText = drow["AnswerText"].ToString(),
});
}
newtest.Questions.Add(new NewTestQuestion {
QuestionID = questid,
QuestionText = questtext,
Answers = questanswlist
});
sm.UpdateSessionLastAction();
return(newtest);
}
public NewTest StartTest(int personid, int count, string topicids)
{
// topicids needs to be parsed to List<int>
List <int> inttopics = new List <int>();
topicids.Split(',').ToList().ForEach(t => inttopics.Add(int.Parse(t)));
DataTable dtTopics = new DataTable();
dtTopics.Columns.Add("TID", typeof(int));
foreach (int i in inttopics)
{
var r = dtTopics.NewRow();
r[0] = i;
dtTopics.Rows.Add(r);
}
SqlParameter ptopicid = new SqlParameter("@topicid", dtTopics);
ptopicid.SqlDbType = SqlDbType.Structured;
ptopicid.TypeName = "dbo.TopicIDs";
SqlParameter pcount = new SqlParameter("@count", count);
SqlParameter ppersonid = new SqlParameter("@personid", personid);
string query = "[test].[usp_NewTest] @count, @topicid, @personid";
string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["JolTudomEEntities"].ConnectionString;
string searchterm = ";provider connection string=\"";
connstring = connstring.Substring(connstring.IndexOf(searchterm) + searchterm.Length);
connstring = connstring.Substring(0, connstring.IndexOf('"'));
var conn = new SqlConnection(connstring);
var cmd = conn.CreateCommand();
cmd.CommandText = query;
cmd.Parameters.Add(pcount);
cmd.Parameters.Add(ptopicid);
cmd.Parameters.Add(ppersonid);
cmd.CommandTimeout = 700;
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataTable dtresult = new DataTable();
bool closed = conn.State == System.Data.ConnectionState.Closed;
if (closed)
{
conn.Open();
}
try {
dap.Fill(dtresult);
}
finally {
if (closed)
{
conn.Close();
}
}
List <usp_ContineTest_Result> resultlist = new List <usp_ContineTest_Result>();
foreach (DataRow drow in dtresult.Rows)
{
resultlist.Add(new usp_ContineTest_Result {
TestID = int.Parse(drow["TestID"].ToString()),
PersonID = int.Parse(drow["PersonID"].ToString()),
QuestionID = int.Parse(drow["QuestionID"].ToString()),
QuestionText = drow["QuestionText"].ToString(),
AnswerID = int.Parse(drow["AnswerID"].ToString()),
AnswerText = drow["AnswerText"].ToString(),
});
}
NewTest newtest = ParseNewContinueResult(resultlist);
UpdateSession();
return(newtest);
}
public void SetupTest(NewTest Trail)
{
this.ownTest = Trail;
beenSet = true;
ownTest.Speak();
}
/// <summary>
/// On New Test
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OnNewTest(object sender, EventArgs e)
{
NewTest?.Invoke(this, e);
}