public ObservableCollection<SubjectViewModel> getBusinessQuestions1(string gr)
{
string no = "no";
string yes = "yes";
subject = new ObservableCollection<SubjectViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
//var query = db.Table<English>();
var query = db.Query<Business>("select * from Business where GRADE ='" + gr + "' and read ='" + no + "'");
foreach (var j in query)
{
var sub = new SubjectViewModel()
{
ID = j.Id,
QUESTION = j.question,
ANSWER = j.answer,
ANSWER1 = j.answer2,
ANSWER2 = j.answer3,
GRADE = j.GRADE,
READ = j.read
};
subject.Add(sub);
}
}
return subject;
}
public ObservableCollection <SubjectViewModel> getEnglishQuestions1(string gr)
{
string no = "no";
string yes = "yes";
subject = new ObservableCollection <SubjectViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
//var query = db.Table<English>();
var query = db.Query <English>("select * from english where GRADE ='" + gr + "' and read ='" + no + "'");
foreach (var j in query)
{
var sub = new SubjectViewModel()
{
ID = j.Id,
QUESTION = j.question,
ANSWER = j.answer,
ANSWER1 = j.answer2,
ANSWER2 = j.answer3,
GRADE = j.GRADE,
READ = j.read
};
subject.Add(sub);
}
}
return(subject);
}
public QuestionsPage()
{
this.InitializeComponent();
subject = new SubjectViewModel();
correct_answer = new English();
maths = new Maths();
business = new Business();
accounting = new Accounting();
geography = new Geography();
history = new History();
life = new Life();
physics = new Physics();
time.Start();
}
public List <SubjectViewModel> getEnglishQuestion(string gr)
{
//string grade = "Grade 6";
subjects = new List <SubjectViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
//var query = db.Table<English>();
var query = db.Query <English>("select * from english where GRADE ='" + gr + "'");
foreach (var j in query)
{
var sub = new SubjectViewModel()
{
ID = j.Id,
QUESTION = j.question,
ANSWER = j.answer,
ANSWER1 = j.answer2,
ANSWER2 = j.answer3,
GRADE = gr
};
subject.Add(sub);
}
}
return(subjects);
}
public List<SubjectViewModel> getEnglishQuestion(string gr)
{
//string grade = "Grade 6";
subjects = new List<SubjectViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
//var query = db.Table<English>();
var query = db.Query<English>("select * from english where GRADE ='" + gr + "'");
foreach (var j in query)
{
var sub = new SubjectViewModel()
{
ID = j.Id,
QUESTION = j.question,
ANSWER = j.answer,
ANSWER1 = j.answer2,
ANSWER2 = j.answer3,
GRADE = gr
};
subject.Add(sub);
}
}
return subjects;
}
