public ModelQuestion GetQuestion(int qid)
{
var model = new ModelQuestion();
List <ModelQuestion> temp = model.Get(_ctx).ToList();
return(model.Get(_ctx).FirstOrDefault(x => x.QuestionID == qid));
}
/// <summary>
/// add question to question database
/// </summary>
/// <param name="question"></param>
/// <param name="status"></param>
/// <param name="view"></param>
private void Add_To_QuestionDatabase(string question, bool status, int view)
{
var ques = new ModelQuestion()
{
Quaere = question,
Status = status,
View = view
};
_context.Questions.Add(ques);
_context.SaveChanges();
}
// GET: TakingSurvey
public ActionResult Taking(int id)
{
SurveyDbContext surveyEntities = new SurveyDbContext();
Test test = surveyEntities.Tests.Include(x => x.Questions.Select(s => s.Choices)).Single(x => x.TestId == id);
ModelTest modelTest = new ModelTest();
modelTest.id = id;
modelTest.Questions = new List <ModelQuestion>();
foreach (var item in test.Questions)
{
ModelQuestion modelQuestion = new ModelQuestion();
modelQuestion.Question = item;
modelTest.Questions.Add(modelQuestion);
}
return(View(modelTest));
}
public IQueryable <ModelStudentAnswer> GetStudentAnswersByStudentByTest(string username, int testid)
{
var model = new ModelStudentAnswer();
StoreQuestion questionStore = new StoreQuestion(_ctx);
List <ModelQuestion> questions = questionStore.GetQuestionsByTest(testid).ToList();
List <ModelStudentAnswer> modelQuestion = model.Get(_ctx).Where(x => x.Username == username).ToList();
List <ModelStudentAnswer> final = new List <ModelStudentAnswer>();
modelQuestion.ForEach(cur =>
{
ModelQuestion qq = questionStore.GetQuestion(cur.QuestionID);
foreach (ModelQuestion curQQ in questions)
{
if (curQQ.QuestionID == cur.QuestionID)
{
final.Add(cur);
}
}
});
return(final.AsQueryable());
}
public IQueryable <ModelStudentAnswer> GetStudentAnswersByTest(int testid)
{
//TODO: needs testing
var model = new ModelStudentAnswer();
StoreQuestion questionStore = new StoreQuestion(_ctx);
IQueryable <ModelQuestion> questions = questionStore.GetQuestionsByTest(testid);
List <ModelStudentAnswer> final = new List <ModelStudentAnswer>();
model.Get(_ctx).ToList().ForEach(cur =>
{
ModelQuestion qq = questionStore.GetQuestion(cur.QuestionID);
foreach (ModelQuestion curQQ in questions)
{
if (curQQ.QuestionID == cur.QuestionID)
{
final.Add(cur);
}
}
});
return(final.AsQueryable());
}
public void DeleteQuestion(ModelQuestion model)
{
using (var transaction = _ctx.Database.BeginTransaction())
{
try
{
var entity = _ctx.Questions.FirstOrDefault(x => x.QuestionID == model.QuestionID);
entity.QuestionActive = false;
_ctx.Update(entity);
_ctx.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new ArgumentException(e.Message);
}
}
}
public void CreateQuestion(ModelQuestion model)
{
using (var transaction = _ctx.Database.BeginTransaction())
{
try
{
model.QuestionActive = true;
var entity = model.ToEntity();
_ctx.Insert(entity);
_ctx.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new ArgumentException(e.Message);
}
}
}
public IQueryable <ModelQuestion> GetQuestionsByTest(int testid)
{
var model = new ModelQuestion();
return(model.Get(_ctx).Where(x => x.TestID == testid));
}
public IQueryable <ModelQuestion> ReadQuestions()
{
var model = new ModelQuestion();
return(model.Get(_ctx));
}
public CreateQuestionViewModel(ModelQuestion model)
{
_model = model;
}
/// <summary>
/// edit question in question database
/// </summary>
/// <param name="model"></param>
private void Update_In_QuestionDatabase(ModelQuestion model)
{
_context.Questions.Update(model);
_context.SaveChanges();
}
