public static QuizAttempt[] GetUserAttempts(int userId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.QuizAttempts.Where(a => a.UserID == userId).ToArray();
}
}
public static Question FindQuestion(int questionId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.Questions.Find(questionId);
}
}
public static QuestionResponse[] GetResponses(int attemptId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.QuestionResponses.Where(r => r.QuizAttemptID == attemptId).ToArray();
}
}
public static Scenario FindScenario(int scenarioId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.Scenarios.Find(scenarioId);
}
}
public static User FindUser(int id)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.Users.Find(id);
}
}
public static QuizAttempt FindQuizAttempt(int quizAttemptId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.QuizAttempts.Find(quizAttemptId);
}
}
public static Quiz FindQuiz(int quizId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return db.Quizzes.Find(quizId);
}
}
public static Question[] GetQuestions()
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return (from q in db.Questions
select q).ToArray<Question>();
}
}
public static Scenario[] GetScenarios()
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return (from s in db.Scenarios
select s).ToArray<Scenario>();
}
}
public static User[] GetUsers()
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return (from u in db.Users
select u).ToArray<User>();
}
}
public static QuestionOption[] FindOptions(int questionId)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
return (from q in db.QuestionOptions
where q.QuestionID == questionId
select q).ToArray<QuestionOption>();
}
}
public static QuestionResponse AddResponse(QuestionResponse response)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
QuestionResponse toAdd = response;
db.QuestionResponses.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static QuizAttempt AddQuizAttempt(QuizAttempt quizAttempt)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
QuizAttempt toAdd = quizAttempt;
db.QuizAttempts.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static Scenario AddScenario(Scenario scenario)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Scenario toAdd = scenario;
db.Scenarios.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static Question AddQuestion(Question question)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Question toAdd = question;
db.Questions.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static Quiz AddQuiz(Quiz quiz)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Quiz toAdd = quiz;
db.Quizzes.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static User AddUser(User newUser)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
User toAdd = newUser;
db.Users.Add(toAdd);
db.SaveChanges();
return toAdd;
}
}
public static User DeleteUser(int id)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
User toDelete = db.Users.Find(id);
db.Users.Remove(toDelete);
db.SaveChanges();
return toDelete;
}
}
public static User FindByName(string username)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
if (db.Users.Any(u => u.Username == username))
{
User user = db.Users.First(u => u.Username == username);
return user;
}
else
{
return null;
}
}
}
public static Quiz UpdateQuiz(Quiz updatedQuiz)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Quiz currentQuiz = db.Quizzes.Find(updatedQuiz.QuizID);
if (currentQuiz != null)
{
currentQuiz.QuizName = updatedQuiz.QuizName;
currentQuiz.QuizName = updatedQuiz.QuizAuthor;
currentQuiz.QuestionPoolID = updatedQuiz.QuestionPoolID;
db.SaveChanges();
return currentQuiz;
}
else
return currentQuiz;
}
}
public static Scenario UpdateScenario(Scenario updatedScenario)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Scenario currentScenario = db.Scenarios.Find(updatedScenario.ScenarioID);
if (currentScenario != null)
{
currentScenario.ScenarioName = updatedScenario.ScenarioName;
currentScenario.QuizID = updatedScenario.QuizID;
currentScenario.ScenarioSequence = updatedScenario.ScenarioSequence;
currentScenario.ScenarioText = updatedScenario.ScenarioText;
currentScenario.Questions = updatedScenario.Questions;
currentScenario.IsRichText = updatedScenario.IsRichText;
db.SaveChanges();
return currentScenario;
}
else
return currentScenario;
}
}
public static User UpdateUser(User updatedUser)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
User currentUser = db.Users.Find(updatedUser.UserID);
if (currentUser != null)
{
currentUser.FirstName = updatedUser.FirstName;
currentUser.LastName = updatedUser.LastName;
currentUser.Email = updatedUser.Email;
db.SaveChanges();
return currentUser;
}
else
{
return currentUser;
}
}
}
public static QuizAttempt UpdateQuizAttempt(QuizAttempt updatedAttempt)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
QuizAttempt currentAttempt = db.QuizAttempts.Find(updatedAttempt.QuizAttemptID);
if (currentAttempt != null)
{
currentAttempt.QuizDate = updatedAttempt.QuizDate;
currentAttempt.Score = updatedAttempt.Score;
db.SaveChanges();
return currentAttempt;
}
else
return currentAttempt;
}
}
public static User UpdateUser(QuizUserViewModel updatedUser)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
User currentUser = UserService.FindByName(updatedUser.UserName);
if (currentUser != null)
{
currentUser = db.Users.Find(currentUser.UserID);
currentUser.FirstName = updatedUser.FirstName;
currentUser.LastName = updatedUser.LastName;
currentUser.Email = updatedUser.EmailAddress;
db.SaveChanges();
return currentUser;
}
else
{
return currentUser;
}
}
}
public static QuestionOption UpdateOption(QuestionOption updatedOption)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
QuestionOption currentOption = db.QuestionOptions.Find(updatedOption.QuestionID);
if (currentOption != null)
{
currentOption.OptionText = updatedOption.OptionText;
currentOption.IsRichText = updatedOption.IsRichText;
currentOption.IsCorrect = updatedOption.IsCorrect;
currentOption.OptionSequence = updatedOption.OptionSequence;
db.SaveChanges();
return currentOption;
}
else
return currentOption;
}
}
public static Question UpdateQuestion(Question updatedQuestion)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
Question currentQuestion = db.Questions.Find(updatedQuestion.QuestionID);
if (currentQuestion != null)
{
currentQuestion.QuestionContent = updatedQuestion.QuestionContent;
currentQuestion.QuestionTypeID = updatedQuestion.QuestionTypeID;
currentQuestion.AnswerContent = updatedQuestion.AnswerContent;
db.SaveChanges();
return currentQuestion;
}
else
return currentQuestion;
}
}
public static QuestionResponse UpdateResponse(QuestionResponse updatedResponse)
{
using (QuizBuilderDb db = new QuizBuilderDb())
{
QuestionResponse currentReponse = db.QuestionResponses.Find(updatedResponse.QuestionResponseID);
if (currentReponse != null)
{
currentReponse.QuestionOptionID = updatedResponse.QuestionOptionID;
currentReponse.QuestionID = updatedResponse.QuestionID;
currentReponse.IsCorrect = updatedResponse.IsCorrect;
currentReponse.UserReviewFlag = updatedResponse.UserReviewFlag;
currentReponse.QuizAttemptID = updatedResponse.QuizAttemptID;
db.SaveChanges();
return currentReponse;
}
else
{
return currentReponse;
}
}
}
