public ModelQuestion GetQuestion(int qid) { var model = new ModelQuestion(); List <ModelQuestion> temp = model.Get(_ctx).ToList(); return(model.Get(_ctx).FirstOrDefault(x => x.QuestionID == qid)); }
/// <summary> /// add question to question database /// </summary> /// <param name="question"></param> /// <param name="status"></param> /// <param name="view"></param> private void Add_To_QuestionDatabase(string question, bool status, int view) { var ques = new ModelQuestion() { Quaere = question, Status = status, View = view }; _context.Questions.Add(ques); _context.SaveChanges(); }
// GET: TakingSurvey public ActionResult Taking(int id) { SurveyDbContext surveyEntities = new SurveyDbContext(); Test test = surveyEntities.Tests.Include(x => x.Questions.Select(s => s.Choices)).Single(x => x.TestId == id); ModelTest modelTest = new ModelTest(); modelTest.id = id; modelTest.Questions = new List <ModelQuestion>(); foreach (var item in test.Questions) { ModelQuestion modelQuestion = new ModelQuestion(); modelQuestion.Question = item; modelTest.Questions.Add(modelQuestion); } return(View(modelTest)); }
public IQueryable <ModelStudentAnswer> GetStudentAnswersByStudentByTest(string username, int testid) { var model = new ModelStudentAnswer(); StoreQuestion questionStore = new StoreQuestion(_ctx); List <ModelQuestion> questions = questionStore.GetQuestionsByTest(testid).ToList(); List <ModelStudentAnswer> modelQuestion = model.Get(_ctx).Where(x => x.Username == username).ToList(); List <ModelStudentAnswer> final = new List <ModelStudentAnswer>(); modelQuestion.ForEach(cur => { ModelQuestion qq = questionStore.GetQuestion(cur.QuestionID); foreach (ModelQuestion curQQ in questions) { if (curQQ.QuestionID == cur.QuestionID) { final.Add(cur); } } }); return(final.AsQueryable()); }
public IQueryable <ModelStudentAnswer> GetStudentAnswersByTest(int testid) { //TODO: needs testing var model = new ModelStudentAnswer(); StoreQuestion questionStore = new StoreQuestion(_ctx); IQueryable <ModelQuestion> questions = questionStore.GetQuestionsByTest(testid); List <ModelStudentAnswer> final = new List <ModelStudentAnswer>(); model.Get(_ctx).ToList().ForEach(cur => { ModelQuestion qq = questionStore.GetQuestion(cur.QuestionID); foreach (ModelQuestion curQQ in questions) { if (curQQ.QuestionID == cur.QuestionID) { final.Add(cur); } } }); return(final.AsQueryable()); }
public void DeleteQuestion(ModelQuestion model) { using (var transaction = _ctx.Database.BeginTransaction()) { try { var entity = _ctx.Questions.FirstOrDefault(x => x.QuestionID == model.QuestionID); entity.QuestionActive = false; _ctx.Update(entity); _ctx.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new ArgumentException(e.Message); } } }
public void CreateQuestion(ModelQuestion model) { using (var transaction = _ctx.Database.BeginTransaction()) { try { model.QuestionActive = true; var entity = model.ToEntity(); _ctx.Insert(entity); _ctx.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new ArgumentException(e.Message); } } }
public IQueryable <ModelQuestion> GetQuestionsByTest(int testid) { var model = new ModelQuestion(); return(model.Get(_ctx).Where(x => x.TestID == testid)); }
public IQueryable <ModelQuestion> ReadQuestions() { var model = new ModelQuestion(); return(model.Get(_ctx)); }
public CreateQuestionViewModel(ModelQuestion model) { _model = model; }
/// <summary> /// edit question in question database /// </summary> /// <param name="model"></param> private void Update_In_QuestionDatabase(ModelQuestion model) { _context.Questions.Update(model); _context.SaveChanges(); }