public QuestionOption GetQuestionOption(int questionOptionID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.QuestionOptions.FirstOrDefault(qo => qo.QuestionOptionID == questionOptionID);
}
}
public User GetUser(int userID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.Users.FirstOrDefault(u => u.UserID == userID);
}
}
public QuizAttempt GetQuizAttempt(int quizAttemptID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.QuizAttempts.FirstOrDefault(qa => qa.QuizAttemptID == quizAttemptID);
}
}
public Quiz GetQuiz(int quizID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.Quizzes.FirstOrDefault(q => q.QuizID == quizID);
}
}
public User GetUser(string username, string password)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.Users.FirstOrDefault(u => u.UserName == username && u.Password == password);
}
}
public void SaveQuiz(Quiz quiz)
{
using (var ctx = new QuizBuilderEntities())
{
ctx.AddToQuizzes(quiz);
ctx.SaveChanges();
}
}
public void SaveUser(User user)
{
using (var ctx = new QuizBuilderEntities())
{
ctx.AddToUsers(user);
ctx.SaveChanges();
}
}
public void SaveQuizAttempt(QuizAttempt quizAttempt)
{
using (var ctx = new QuizBuilderEntities())
{
ctx.AddToQuizAttempts(quizAttempt);
ctx.SaveChanges();
}
}
public void SaveQuestionOption(QuestionOption questionOption)
{
using (var ctx = new QuizBuilderEntities())
{
ctx.AddToQuestionOptions(questionOption);
ctx.SaveChanges();
}
}
public List<Quiz> GetQuizzes()
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.Quizzes
.OrderBy(q => q.QuizName)
.ToList();
}
}
public List<QuizAttempt> GetQuizAttempts(int userID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.QuizAttempts
.Where(qa => qa.UserID == userID)
.OrderBy(qa => qa.QuizDate)
.ToList();
}
}
public List<QuestionOption> GetQuestionOptions(int questionID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.QuestionOptions
.Where(qo => qo.QuestionID == questionID)
.OrderBy(qo => qo.OptionSequence)
.ToList();
}
}
public List<User> GetUsers()
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.Users
.OrderBy(u => u.LastName)
.OrderBy(u => u.FirstName)
.ToList();
}
}
//added 4/10/2013
public Question GetLast(int scenarioID)
{
using (var ctx = new QuizBuilderEntities())
{
var question = ctx.Questions
.Where(s => s.ScenarioID == scenarioID)
.OrderByDescending(s => s.QuestionSequence)
.FirstOrDefault();
return question;
}
}
//added 4/10/2013
public Scenario GetLast(int quizID)
{
using (var ctx = new QuizBuilderEntities())
{
var scenario = ctx.Scenarios
.Where(s => s.QuizID == quizID)
.OrderByDescending(s => s.ScenarioSequence)
.FirstOrDefault();
return scenario;
}
}
public QuestionResponse GetLastQuestionResponse(int quizAttemptID)
{
using (var ctx = new QuizBuilderEntities())
{
return ctx.QuestionResponses
.Where(qr => qr.QuizAttemptID == quizAttemptID)
.OrderByDescending(qr => qr.Question.Scenario.ScenarioSequence)
.ThenByDescending(qr => qr.Question.QuestionSequence)
.FirstOrDefault();
}
}
//added 4/10/2013
public QuestionOption GetLast(int questionID)
{
using (var ctx = new QuizBuilderEntities())
{
var questionOption = ctx.QuestionOptions
.Where(q => q.QuestionID == questionID)
.OrderByDescending(o => o.OptionSequence)
.FirstOrDefault();
return questionOption;
}
}
public void DeleteQuiz(int quizID)
{
using (var ctx = new QuizBuilderEntities())
{
var quiz = ctx.Quizzes.FirstOrDefault(q => q.QuizID == quizID);
if (quiz != null)
{
ctx.DeleteObject(quiz);
ctx.SaveChanges();
}
}
}
public void DeleteQuestionResponse(int questionResponseID)
{
using (var ctx = new QuizBuilderEntities())
{
var questionResponse = ctx.QuestionResponses.FirstOrDefault(qr => qr.QuestionResponseID == questionResponseID);
if (questionResponse != null)
{
ctx.DeleteObject(questionResponse);
ctx.SaveChanges();
}
}
}
public void DeleteQuizAttempt(int quizAttemptID)
{
using (var ctx = new QuizBuilderEntities())
{
var quizAttempt = ctx.QuizAttempts.FirstOrDefault(qa => qa.QuizAttemptID == quizAttemptID);
if (quizAttempt != null)
{
ctx.DeleteObject(quizAttempt);
ctx.SaveChanges();
}
}
}
public void DeleteScenario(int scenarioID)
{
using (var ctx = new QuizBuilderEntities())
{
var scenario = ctx.Scenarios.FirstOrDefault(s => s.ScenarioID == scenarioID);
if (scenario != null)
{
ctx.DeleteObject(scenario);
ctx.SaveChanges();
}
}
}
public void DeleteUser(int userID)
{
using (var ctx = new QuizBuilderEntities())
{
var user = ctx.Users.FirstOrDefault(u => u.UserID == userID);
if (user != null)
{
ctx.DeleteObject(user);
ctx.SaveChanges();
}
}
}
public void DeleteQuestion(int questionID)
{
using (var ctx = new QuizBuilderEntities())
{
var question = ctx.Questions.FirstOrDefault(q => q.QuestionID == questionID);
if (question != null)
{
ctx.DeleteObject(question);
ctx.SaveChanges();
}
}
}
public void UpdateQuizAttempt(QuizAttempt quizAttempt)
{
using (var ctx = new QuizBuilderEntities())
{
ctx.Attach(quizAttempt);
var stateEntry = ctx.ObjectStateManager.GetObjectStateEntry(quizAttempt);
foreach (var propertyName in stateEntry.CurrentValues
.DataRecordInfo.FieldMetadata
.Select(fm => fm.FieldType.Name))
{
stateEntry.SetModifiedProperty(propertyName);
}
ctx.SaveChanges();
}
}
protected void btnAddQuestion_Click(object sender, EventArgs e)
{
using (QuizBuilderEntities QBContext = new QuizBuilderEntities())
{
Question question = new Question();
question.ScenarioID = Convert.ToInt32(txtNewQScenarioID.Text);
question.QuestionSequence = Convert.ToInt32(txtNewQSequenceNumb.Text);
question.QuestionText = txtNewQTxt.Text;
QuestionRepository qR = new QuestionRepository();
qR.SaveQuestion(question);
/*Reload page so gridview will display new scenario */
Response.Redirect("Admin_Quiz.aspx");
}
clearQuestionInputControls();
}
protected void submitNewUserInfo_Click(object sender, EventArgs e)
{
using (QuizBuilderEntities QBContext = new QuizBuilderEntities())
{
User obj = new User();
obj.FirstName = txtFirstName.Text;
obj.LastName = txtLastName.Text;
obj.UserName = txtUserName.Text;
obj.Password = txtPassword.Text;
obj.Email = txtEmail.Text;
UserRepository uR = new UserRepository();
uR.SaveUser(obj);
Response.Redirect("Admin_Users.aspx");
}
clearInputControls();
}
protected void btnAddScenario_Click(object sender, EventArgs e)
{
using (QuizBuilderEntities QBContext = new QuizBuilderEntities())
{
Scenario scenario = new Scenario();
scenario.ScenarioName = txtNewScenarioTxt.Text;
scenario.ScenarioSequence = Convert.ToInt32(txtNewScenarioSeq.Text);
scenario.ScenarioText = txtNewScenarioTxt.Text;
ScenarioRepository sR = new ScenarioRepository();
sR.SaveScenario(scenario);
/*Reload page so gridview will display new scenario */
Response.Redirect("Admin_Quiz.aspx");
}
clearScenarioInputControls();
PanelScenario.Visible = false;
}
public Scenario GetPrevious(int scenarioID)
{
using (var ctx = new QuizBuilderEntities())
{
Scenario previousScenario = null;
//fetch the scenario
var currentScenario = ctx.Scenarios.FirstOrDefault(s => s.ScenarioID == scenarioID);
if (currentScenario != null)
{
//get the collection of scenarios based on the quiz
var quizScenarios = GetScenarios(currentScenario.QuizID);
//find this scenario in the collection
var current = quizScenarios.First(s => s.ScenarioID == scenarioID);
//is there a previous scenario? If not - return null
previousScenario = quizScenarios.ElementAtOrDefault(quizScenarios.IndexOf(current) - 1);
}
return previousScenario;
}
}
public Question GetPrevious(int questionID)
{
using (var ctx = new QuizBuilderEntities())
{
Question previousQuestion = null;
//fetch the question
var currentQuestion = ctx.Questions.FirstOrDefault(q => q.QuestionID == questionID);
if (currentQuestion != null)
{
//get the collection of questions based on the scenario
var quizQuestions = GetQuestions(currentQuestion.ScenarioID);
//find this question in the collection
var current = quizQuestions.First(q => q.QuestionID == questionID);
//is there a previous question? If not - return null
previousQuestion = quizQuestions.ElementAtOrDefault(quizQuestions.IndexOf(current) - 1);
}
return previousQuestion;
}
}
//added 2/29/2012
public QuestionResponse GetPrevious(int questionResponseID)
{
using (var ctx = new QuizBuilderEntities())
{
QuestionResponse previousQuestionResponse = null;
//fetch the questionResponse
var currentQuestionResponse = ctx.QuestionResponses.FirstOrDefault(q => q.QuestionResponseID == questionResponseID);
if (currentQuestionResponse != null)
{
//get the collection of questionResponses based on the scenario
var quizQuestionResponses = GetQuestionResponses(currentQuestionResponse.QuizAttemptID);
//find this questionResponse in the collection
var current = quizQuestionResponses.First(q => q.QuestionResponseID == questionResponseID);
//is there a previous questionResponse? If not - return null
previousQuestionResponse = quizQuestionResponses.ElementAtOrDefault(quizQuestionResponses.IndexOf(current) - 1);
}
return previousQuestionResponse;
}
}
