public bool commitInsert(string _question) { quizDataContext objQuizDC = new quizDataContext(); using (objQuizDC) { quiz objNewQuiz = new quiz(); objNewQuiz.Questions = _question; objQuizDC.quizs.InsertOnSubmit(objNewQuiz); objQuizDC.SubmitChanges(); return true; } }
public IQueryable<quiz> getQuiz() { quizDataContext objQuizDC = new quizDataContext(); var allQuiz = objQuizDC.quizs.Select(x => x); return allQuiz; }
public bool commitDelete(int _id) { quizDataContext objQuizDC = new quizDataContext(); using (objQuizDC) { var objDelQuiz = objQuizDC.quizs.Single(x => x.Id == _id); objQuizDC.quizs.DeleteOnSubmit(objDelQuiz); objQuizDC.SubmitChanges(); return true; } }
public bool commitUpdate(int _id, string _question) { quizDataContext objQuizDC = new quizDataContext(); using (objQuizDC) { var objUpQuiz = objQuizDC.quizs.Single(x =>x.Id == _id); objUpQuiz.Questions = _question; objQuizDC.SubmitChanges(); return true; } }
public IQueryable<quiz> getQuizByID(int _id) { quizDataContext objQuizDC = new quizDataContext(); var allQuiz = objQuizDC.quizs.Where(x => x.Id == _id).Select(x => x); return allQuiz; }