public List <Question> GetQuestions()
{
using (var db = new EvalContext())
{
return(db.Question
.OrderBy(x => x.question_id)
.ToList());
}
}
public List <Answer> GetAnswers()
{
using (var db = new EvalContext())
{
return(db.Answer
.OrderBy(x => x.answer_id)
.ToList());
}
}
public List <Evaluation> GetEvaluations()
{
using (var db = new EvalContext())
{
return(db.Evaluation
.OrderBy(x => x.evaluation_id)
.ToList());
}
}
public List <Course> GetCourses()
{
using (var db = new EvalContext())
{
return(db.Course
.OrderBy(x => x.course_id)
.ToList());
}
}
public List <Question> GetQuestionsFromQuestionBank(int questionnaireID)
{
using (var db = new EvalContext())
{
return(db.Question
.Where(q => q.questionnaire_id == questionnaireID)
.OrderBy(x => x.question_id)
.ToList());
}
}
public List <Answer> GetAnswersFromQuestionnaire(int questionnaireID)
{
using (var db = new EvalContext())
{
return(db.Answer
.Where(a => a.questionnaire_id == questionnaireID)
.OrderBy(x => x.answer_id)
.ToList());
}
}
public bool DeleteQuestion(int questionID)
{
using (var db = new EvalContext())
{
var existingQuestion = db.Question.Find(questionID);
if (existingQuestion != null)
{
db.Question.Remove(existingQuestion);
db.SaveChanges();
return(true);
}
}
// statuscode kræver false hvis der ikke kunne findes noget at slette og true, hvis der var noget at slette som slettes.
return(false);
}
public Evaluation AddReport(int evaluationID, string report)
{
using (var db = new EvalContext())
{
//var existingEvaluation = db.Evaluation.AsNoTracking().Where(e => e.evaluation_id == evaluationID).First();
var existingEvaluation = db.Evaluation.Find(evaluationID);
existingEvaluation.report = report;
db.Evaluation.Attach(existingEvaluation);
var entry = db.Entry(existingEvaluation);
entry.Property(x => x.report).IsModified = true;
db.SaveChanges();
return(existingEvaluation);
}
}
public void CreateAnswer(int question_id, int questionnaire_id, int answer)
{
using (var db = new EvalContext())
{
var studyanswer = new Answer
{
question_id = question_id,
questionnaire_id = questionnaire_id,
answer = answer
};
db.Answer.Add(studyanswer);
db.SaveChanges();
// returner den nyoprettede answer
//return GetAnswers();
}
}
