public ICollection<ExamViewModel> GetExams()
{
List<ExamViewModel> examList = new List<ViewModel.ExamViewModel>();
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
List<Exam> exams = dbContext.Exams.ToList<Exam>();
foreach(Exam exam in exams)
{
examList.Add(GetExamViewModel(exam));
}
return examList;
}
private QuestionProposedAnswersViewModel GetQuestionViewModel(OnlineExamAppDBEntities3 dbContext, Question question)
{
QuestionProposedAnswersViewModel questionOptionsViewModel = new QuestionProposedAnswersViewModel();
List<ProposedAnswerViewModel> options = new List<ProposedAnswerViewModel>();
questionOptionsViewModel.Question = new QuestionViewModel() { ID = question.ID, Text = question.QuestionText };
List<QuestionProposedAnswer> questionProposedAnswers = dbContext.QuestionProposedAnswers.Where(qpa => qpa.QuestionID == question.ID).ToList<QuestionProposedAnswer>();
foreach (QuestionProposedAnswer questionProposedAnswer in questionProposedAnswers)
{
options.Add(new ProposedAnswerViewModel() { ID = questionProposedAnswer.ProposedAnswer.ID, Text = questionProposedAnswer.ProposedAnswer.AnswerText });
}
questionOptionsViewModel.ProposedAnswers = options;
return questionOptionsViewModel;
}
public QuestionProposedAnswersViewModel GetQuestion(int? currentQuestionId)
{
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
Question question = null;
if (currentQuestionId != null)
{
int detailID = _exam.ExamDetails.Where(ed => ed.QuestionID == currentQuestionId).FirstOrDefault().ID;
question = _exam.ExamDetails.Where(ed => ed.ID > detailID).FirstOrDefault().Question;
}
else
{
question = _exam.ExamDetails.FirstOrDefault().Question;
}
return GetQuestionViewModel(dbContext, question);
}
public void PopulateExamDetails(int examID)
{
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
_exam = dbContext.Exams.Where(qpa => qpa.ID == examID).FirstOrDefault();
}
public LoginViewModel Login(LoginViewModel loginViewModel)
{
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
User existingUser = dbContext.Users.Where(u => u.UserName == loginViewModel.UserName && u.Password == loginViewModel.Password).FirstOrDefault();
if (existingUser != null)
{
_candidate = new ViewModel.CandidateViewModel() { Name = existingUser.FirstName };
loginViewModel.ErrorDescription = string.Empty;
}
else
loginViewModel.ErrorDescription = "Unable to login. Please check the User Name and Password and try again !!";
return loginViewModel;
}
public RegisterViewModel RegisterUser(RegisterViewModel registerViewModel)
{
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
User existingUser = dbContext.Users.Where(u => u.UserName == registerViewModel.UserName).FirstOrDefault();
if (existingUser == null)
{
User user = new User();
user.FirstName = registerViewModel.FirstName;
user.LastName = registerViewModel.LastName;
user.UserName = registerViewModel.UserName;
user.Password = registerViewModel.Password;
dbContext.Users.Add(user);
dbContext.SaveChanges();
_candidate = new ViewModel.CandidateViewModel() { Name = registerViewModel.UserName };
registerViewModel.ErrorDescription = string.Empty;
}
else
registerViewModel.ErrorDescription = "The User Name already exists. Please supply a new User Name";
return registerViewModel;
}
public ExamResultViewModel EvaluateExam()
{
CommitUserResponse();
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
//UserResponseHeader userResponse = dbContext.UserResponseHeaders.Where(urh => urh.ExamID == _exam.ID).FirstOrDefault();
ExamResultViewModel examResult = new ViewModel.ExamResultViewModel();
List<QuestionResultViewModel> questionResults = new List<ViewModel.QuestionResultViewModel>();
bool result = false;
foreach(ExamDetail examDetail in _exam.ExamDetails)
{
List<QuestionAnswer> questionAnswers = dbContext.QuestionAnswers.Where(qa => qa.QuestionID == examDetail.QuestionID).ToList<QuestionAnswer>();
List<UserResponseDetail> userResponseDetails = dbContext.UserResponseDetails.Where(urd => urd.UserResponseHeaderID == _userResponseHeader.ID && urd.QuestionID == examDetail.QuestionID).ToList<UserResponseDetail>();
foreach(QuestionAnswer questionAnswer in questionAnswers)
{
result = userResponseDetails.Exists(urd => urd.AnswerID == questionAnswer.AnswerID);
if (!result)
break;
}
questionResults.Add(new ViewModel.QuestionResultViewModel() { Question = examDetail.Question.QuestionText, Result = result});
}
examResult.UserName = this._candidate.Name;
examResult.Results = questionResults;
return examResult;
}
private void CommitUserResponse()
{
if (_userResponseHeader != null)
{
OnlineExamAppDBEntities3 dbContext = new OnlineExamAppDBEntities3();
dbContext.UserResponseHeaders.Add(_userResponseHeader);
dbContext.SaveChanges();
}
}
