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