public IEnumerable <QuizAttemptsUser> ReadQuizAttemptUserByAnyParameter(string _parameterName, string _parameterData, string _exactMatch)
{
Quiz _quizInstance = new Quiz();
DataTable _quizAttemptDataFromDataBase = new DataTable();
_quizAttemptDataFromDataBase = _quizInstance.ReadQuizAttemptUserByAnyParameter(_parameterName, _parameterData, _exactMatch);
QuizAttemptsUser[] _listOfQuizAttempts = new QuizAttemptsUser[_quizAttemptDataFromDataBase.Rows.Count];
int quizAttemptCounter = 0;
foreach (DataRow _quizAttemptRow in _quizAttemptDataFromDataBase.Rows)
{
QuizAttemptsUser _quizAttempt = new QuizAttemptsUser
{
ID = int.Parse(_quizAttemptRow["ID"].ToString()),
UserID = int.Parse(_quizAttemptRow["UserID"].ToString()),
QuizID = int.Parse(_quizAttemptRow["QuizID"].ToString()),
QuizVersion = int.Parse(_quizAttemptRow["QuizVersion"].ToString()),
QuizScore = int.Parse(_quizAttemptRow["QuizScore"].ToString()),
UserAnswers = _quizAttemptRow["UserAnswers"].ToString(),
IsFinished = _quizAttemptRow["IsFinished"].ToString(),
DateTaken = _quizAttemptRow["DateTaken"].ToString(),
};
_listOfQuizAttempts[quizAttemptCounter] = _quizAttempt;
quizAttemptCounter++;
}
return(_listOfQuizAttempts);
}
public IHttpActionResult UpdateUserQuizAttempt(QuizAttemptsUser _quizInformation)
{
Quiz _quizReceived = new Quiz();
string _updateStatus = _quizReceived.UpdateQuizAttemptUser(_quizInformation);
if (_updateStatus != "User Quiz Attempt was stored successfully")
{
return(Ok(_updateStatus));
}
return(Ok(_updateStatus));
}
public IHttpActionResult InsertUserQuizAttempt(QuizAttemptsUser _quizInformation)
{
Quiz _quizReceived = new Quiz();
string _insertionStatus = _quizReceived.InsertUserQuizAttempt(_quizInformation);
if (_insertionStatus != "User Quiz Attempt was stored successfully")
{
return(Ok(_insertionStatus));
}
return(Ok(_insertionStatus));
}
