public IEnumerable <Answer> GetByQuestionId(int questionId) { using (var db = new EntitiesContainer()) { var result = db.Answers_ByQuestionId_Select(questionId).ToList(); if (result != null) { return(result.Select(x => new Answer { AnsVal = x.ansVal, ExendedDetails = x.ExtendedDetails, Id = x.ID, IdFromOldOT = x.id_FromOldOT, IsImage = x.isImage, ModifyBy = x.modifyBy, ModifyDate = x.modifyDate, Notes = x.Notes, OrdinalPos = x.ordinalPos, QID = x.QID, QuesdtionID_FromOldOT = x.questionID_FromOldOT, Txt = x.txt, Worth = x.worth })); } return(null); } }
public IEnumerable <Question> GetAll() { using (var db = new EntitiesContainer()) { return(db.Items_Select().ToList() .Select(x => new Question { ApproveDate = x.ApproveDate, ApproveUser = x.ApproveUser, Complexity = x.Complexity, Components = null, CourseId = x.courseID, CreateDate = x.CreateDate, CreateUserId = x.CreateUserID, Difficulty = x.Difficulty, ExtendedDetails = x.ExtendedDetails, GradeLevel = x.GradeLevel, Id = x.questionID, IdFromOldOT = x.QuestionID_FromOldOT, MasterQuestionId = x.masterQuestionID, MaxScore = x.maxScore, MinScore = x.minScore, ModifyDate = x.ModifyDate, ModifyUserId = x.ModifyUserID, Notes = x.Notes, PassageId = x.passageID, PassageIdFromOldOT = x.PassageID_FromOldOT, QuestionText = x.questionText, QuestionTypeId = x.QuestionTypeID, StatusId = x.statusID, SubjectId = x.SubjectID, Targ = x.targ }).ToList()); } }
public Question Get(int id) { using (var db = new EntitiesContainer()) { var result = db.Items_ById_Select(id).FirstOrDefault(); if (result != null) { var question = new Question { ApproveDate = result.ApproveDate, ApproveUser = result.ApproveUser, Complexity = result.Complexity, Components = null, CourseId = result.courseID, CreateDate = result.CreateDate, CreateUserId = result.CreateUserID, Difficulty = result.Difficulty, ExtendedDetails = result.ExtendedDetails, GradeLevel = result.GradeLevel, Id = result.questionID, IdFromOldOT = result.QuestionID_FromOldOT, MasterQuestionId = result.masterQuestionID, MaxScore = result.maxScore, MinScore = result.minScore, ModifyDate = result.ModifyDate, ModifyUserId = result.ModifyUserID, Notes = result.Notes, PassageId = result.passageID, PassageIdFromOldOT = result.PassageID_FromOldOT, QuestionText = result.questionText, QuestionTypeId = result.QuestionTypeID, StatusId = result.statusID, SubjectId = result.SubjectID, Targ = result.targ }; question.Answers = AnswerRepository.GetByQuestionId(question.Id).ToList(); return(question); } } return(null); }
public ConnectionProvider() { this.connection = new EntitiesContainer(); }