//INFO: Return all questions in the database.
public List <QuestionDO> GetQuestions(int id)
{
List <QuestionDO> questionDOs = new List <QuestionDO>();
using (riverkeeperEntities RKEntities = new riverkeeperEntities())
{
List <Question> questions = (from q in RKEntities.Questions
where q.SurveyId == id
select q).ToList();
foreach (var question in questions)
{
if (question != null)
{
QuestionDO questionDO = new QuestionDO()
{
QuestionId = question.QuestionId,
Type = (short)question.Type,
Wording = question.Wording,
PossibleAnswers = (String.IsNullOrEmpty(question.PossibleAnswers)) ? new string[0] : question.PossibleAnswers.Split(','),
SurveyId = question.SurveyId
};
questionDOs.Add(questionDO);
}
if (question == null)
{
throw new Exception("No questions in DB");
}
}
}
return(questionDOs);
}
public bool CreateQuestion(QuestionDO question)
{
if (question == null)
{
return(false);
}
return(questionDAO.CreateQuestion(question));
}
public static QuizDO QuizFixture_1()
{
var quiz = new QuizDO();
quiz.AnswerTime = 3000;
var questionLabel = new Label {
Text = "What is the highest mountain of the world?"
};
var questionImage = new Image {
ImagePath = "cdn://dksjdksjkd.com/image.png"
};
var questionContent = new ContentDO();
questionContent.AddControl(questionLabel);
questionContent.AddControl(questionImage);
var question = new QuestionDO();
question.Content = questionContent;
var quizItem = new ItemDO();
quizItem.SetQuestion(question);
for (int i = 0; i < 4; ++i)
{
var answerLabel = new Label {
Text = "Everest"
};
var answerImage = new Image {
ImagePath = "cdn://dkhfjdkl.io/everest.png"
};
var answerContent = new ContentDO();
answerContent.AddControl(answerLabel);
answerContent.AddControl(answerImage);
var answer = new AnswerDO();
answer.Content = answerContent;
quizItem.AddPossibleAnswer(answer);
}
quizItem.SetCorrectAnswer(new SingleChoiceAnswer {
Value = 1
});
quiz.AddQuizItem(quizItem);
return(quiz);
}
//INFO: Adds a question to the database.
public bool CreateQuestion(QuestionDO questionDO)
{
using (riverkeeperEntities RKEntities = new riverkeeperEntities())
{
Question questiondb = new Question();
questiondb.SurveyId = questionDO.SurveyId;
questiondb.Wording = questionDO.Wording;
questiondb.Type = (ResponseFormat)questionDO.Type;
questiondb.PossibleAnswers = String.Join(",", questionDO.PossibleAnswers);
RKEntities.Questions.Add(questiondb);
int dbResult = 0;
try
{
dbResult = RKEntities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
if (dbResult != 1)
{
return(false);
}
return(true);
}
}
//INFO: Retrieves the question with the given id
public QuestionDO GetQuestionById(int id)
{
QuestionDO questionDO = new QuestionDO();
using (riverkeeperEntities RKEntities = new riverkeeperEntities())
{
List <Question> questions = (from q in RKEntities.Questions where q.QuestionId == id
select q).ToList();
Question question = questions.ElementAt(0);
if (question != null)
{
questionDO.QuestionId = question.QuestionId;
questionDO.Type = (short)question.Type;
questionDO.Wording = question.Wording;
questionDO.PossibleAnswers = question.PossibleAnswers.Split(',');
}
else
{
throw new Exception("No questions with that ID in DB");
}
}
return(questionDO);
}
public bool Post(QuestionDO question)
{
return(questionTask.CreateQuestion(question));
}
