public void Delete(DalQuestion e) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Questions question = context.Set<Questions>().FirstOrDefault(q => q.id == e.Id); context.Set<Questions>().Remove(question); }
public void Create(DalQuestion e) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Questions question = new Questions() { id = e.Id, QuestionNumberInTest = e.QuestionNumberInTest, TestId = e.TestId, QuestionStructure = e.QuestionStructure }; context.Set<Questions>().Add(question); }
public bool ExistAnswer(DalQuestion question, DalAnswer answer) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); return context.Set<Answers>() .Any(answers => answers.AnswerStructure == answer.AnswerStructure && answers.QuestionId == question.Id); }
public IEnumerable<DalAnswer> GetAllAnswers(DalQuestion question) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); IEnumerable<Answers> ormanswers = context.Set<Answers>().Where(answers => answers.QuestionId == question.Id).AsEnumerable(); List<DalAnswer> result = new List<DalAnswer>(); foreach(Answers a in ormanswers) { result.Add(new DalAnswer() { AnswerStructure = a.AnswerStructure, AnswerValue = a.AnswerValue, Id = a.id, QuestionId = a.QuestionId }); } return result; }
public void Update(DalQuestion entity) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Questions question = context.Set<Questions>().FirstOrDefault(q => q.id == entity.Id); question.QuestionNumberInTest = entity.QuestionNumberInTest; question.QuestionStructure = entity.QuestionStructure; question.TestId = entity.TestId; }