public static object LoadQuestionSets()
{
using (DbKiemTraStressEntities dbContext = new DbKiemTraStressEntities())
{
return(dbContext.QuestionSets.ToArray());
}
}
public static void CreateQuestion(Question question)
{
using (DbKiemTraStressEntities dbContext = new DbKiemTraStressEntities())
{
if (string.IsNullOrEmpty(question.QuestionId))
{
question.QuestionId = Guid.NewGuid().ToString();
}
question.IsActive = true;
dbContext.Questions.Add(question);
dbContext.SaveChanges();
}
}
public static Question[] LoadQuestions(string questionSetId)
{
using (DbKiemTraStressEntities dbContext = new DbKiemTraStressEntities())
{
var questionListId = dbContext.QuestionSets.Where(t => t.QuestionSetId == questionSetId)
.Select(t => t.QuestionListId).FirstOrDefault();
if (string.IsNullOrEmpty(questionListId))
{
questionListId = string.Empty;
}
var questionIdArray = questionListId.Split(new char[] { ';' });
return(dbContext.Questions.Where(t => questionIdArray.Contains(t.QuestionId))
.OrderBy(t => t.Index).ToArray());
}
}
