public async Task <IActionResult> ReturnSubjList()
{
using (var db = new DbConnection())
{
await db.Connection.OpenAsync();
var query = new TestDBWorker(db);
List <string> subj = await query.GetSubjects();
return(View("TestSubjList", subj));
}
}
public async Task <string> TestControl([FromForm] AddPost post)
{
using (var db = new DbConnection())
{
await db.Connection.OpenAsync();
var query = new TestDBWorker(db);
await query.AddTest(post.subject, post.name, post.questionsInTest, post.questionsAll, post.resultOfQuestion, post.mixAnswers, post.mixQuestions, post.notAnsweredForbidden, post.json);
return("added");
}
}
public async Task <string> TestingGet(string id)
{
List <string> model = new List <string>();
using (var db = new DbConnection())
{
await db.Connection.OpenAsync();
var query = new TestDBWorker(db);
model = await query.GetTest(id);
}
return(model[9]);
}
public async Task <IActionResult> TestingList(string id)
{
List <string> model = new List <string>();
using (var db = new DbConnection())
{
await db.Connection.OpenAsync();
var query = new TestDBWorker(db);
model = await query.GetTestList();
}
return(View("TestList", model));
}
