public ActionResult Create([Bind(Include = "ID,Name,Date,Course,NumberOfQuestions,Rating,Progress")] Quiz quiz)
{
if (ModelState.IsValid)
{
db.Quizzes.Add(quiz);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(quiz));
}
public ActionResult Register([Bind(Include = "Username,Password,FirstName,LastName")] User userIn, string ReturnUrl = "~/Home/Index")
{
if (User.Identity.IsAuthenticated)
{
FormsAuthentication.RedirectFromLoginPage(User.Identity.Name, false);
}
if (ModelState.IsValid)
{
//This has been already done by the
User user = (from u in db.Users
where u.Username.Equals(userIn.Username)
select u).FirstOrDefault <User>();
if (user == null)
{
db.Users.Add(userIn);
db.SaveChanges();
FormsAuthentication.RedirectFromLoginPage(userIn.Username, false);
}
else
{
ModelState.AddModelError("", "User already exists");
}
}
ViewBag.ReturnUrl = ReturnUrl;
return(View());
}
public void PunkteEintragen()
{
Player player = new Player();
player.playerNAME = name;
player.playerPUNKTE = score;
ctx.Player.Add(player);
ctx.SaveChanges();
}
public ActionResult Post([FromBody] QuestionDto questionDto)
{
if (questionDto == null || questionDto.Answers == null || questionDto.Answers.Count <= 0 || string.IsNullOrEmpty(questionDto.Content))
{
return(BadRequest());
}
foreach (AnswerDto answer in questionDto.Answers)
{
if (string.IsNullOrEmpty(answer.Content))
{
return(BadRequest());
}
}
using (QuizDBContext quizDbContext = new QuizDBContext())
{
int newQuestionId = quizDbContext.Question.Max(q => q.Id) + 1;
Question question = questionDto.Question;
question.Id = newQuestionId;
ICollection <QuestionAnswer> questionAnswers = question.QuestionAnswer;
question.QuestionAnswer = new List <QuestionAnswer>();
quizDbContext.Question.Add(question);
int newQuestionAnswerId = quizDbContext.QuestionAnswer.Max(q => q.Id) + 1;
int newAnswerId = quizDbContext.Answer.Max(q => q.Id) + 1;
foreach (QuestionAnswer questionAnswer in questionAnswers)
{
questionAnswer.Id = newQuestionAnswerId;
Answer answer = questionAnswer.Answer;
answer.Id = newAnswerId;
questionAnswer.Answer = null;
questionAnswer.AnswerId = answer.Id;
questionAnswer.QuestionId = question.Id;
quizDbContext.Answer.Add(answer);
quizDbContext.QuestionAnswer.Add(questionAnswer);
newQuestionAnswerId++;
newAnswerId++;
}
quizDbContext.SaveChanges();
}
return(Ok());
}
public ActionResult SubmitForm(QuestionResult[] questionsResults)
{
List <Question> questions = (from questionResult in questionsResults
join question in db.Questions on questionResult.QuestionId equals question.ID
select question).ToList();
if (!ModelState.IsValid)
{
ModelState.AddModelError("", "All questions should be answered");
return(View("Quiz", questions));
}
else
{
List <Answer> rightAnswers = (from result in questionsResults
join question in db.Questions on result.QuestionId equals question.ID
where result.Selected == question.right_option
select new Answer
{
Questions_ID = question.ID,
Username = User.Identity.Name,
Correct_Answer = false
}).ToList();
//We can already define the wrong answers and display them
List <Answer> wrongAnswers = (from result in questionsResults
join question in db.Questions on result.QuestionId equals question.ID
where result.Selected != question.right_option
select new Answer
{
Questions_ID = question.ID,
Username = User.Identity.Name,
Correct_Answer = false
}).ToList();
db.Answers.AddRange(rightAnswers);
db.Answers.AddRange(wrongAnswers);
db.SaveChanges();
ViewBag.QuestionResuslts = questionsResults;
ViewBag.Score = rightAnswers.Count + "/" + questionsResults.Length;
return(View("QuizResults", questions));
}
}
public void AddQuestion()
{
//First add the Question, than add the results
Questions question = new Questions();
question.questionTEXT = this.qText;
ctx.Questions.Add(question);
ctx.SaveChanges();
int qID = ctx.Questions.Where(x => x.questionTEXT.Equals(this.qText)).FirstOrDefault().qID;
results.AddAnswers(qID);
}
//Add the Results
public void AddAnswers(int qID)
{
Results newResults = new Results();
Questions q = ctx.Questions.Where(x => x.qID.Equals(qID)).FirstOrDefault();
newResults.Questions = q;
newResults.trueRESULT = this.results["resultTrue"];
newResults.resultONE = this.results["resultOne"];
newResults.relultTWO = this.results["resultTwo"];
newResults.resultTHREE = this.results["resultThree"];
ctx.Results.Add(newResults);
ctx.SaveChanges();
}
public ActionResult GenerateQuestions()
{
using (QuizDBContext quizDbContext = new QuizDBContext())
{
int newQuestionId = quizDbContext.Question.Count() != 0 ? quizDbContext.Question.Max(q => q.Id) + 1 : 0;
int newAnswerId = quizDbContext.Answer.Count() != 0 ? quizDbContext.Answer.Max(q => q.Id) + 1 : 0;
int newQuestionAnswerId = quizDbContext.QuestionAnswer.Count() != 0 ? quizDbContext.QuestionAnswer.Max(q => q.Id) + 1 : 0;
for (int i = 0; i < 20; i++)
{
Question question = new Question()
{
Content = $"Pytanie nr {i}",
Id = newQuestionId + i,
CategoryId = 0,
Difficulty = i % 3
};
quizDbContext.Question.Add(question);
for (int j = 0; j < 3; j++)
{
Answer answer = new Answer()
{
Id = newAnswerId + i * 3 + j,
Content = $"Odpowiedź {j}"
};
QuestionAnswer questionAnswer = new QuestionAnswer()
{
Id = newQuestionAnswerId + i * 3 + j,
IsCorrect = j == 0,
QuestionId = question.Id,
AnswerId = answer.Id
};
quizDbContext.Answer.Add(answer);
quizDbContext.QuestionAnswer.Add(questionAnswer);
}
}
quizDbContext.SaveChanges();
}
return(Ok());
}
public ActionResult Post([FromBody] Category category)
{
if (category == null)
{
return(BadRequest("category is null"));
}
else if (string.IsNullOrEmpty(category.Name))
{
return(BadRequest("category name is null"));
}
using (QuizDBContext quizDbContext = new QuizDBContext())
{
category.Id = quizDbContext.Category.Max(q => q.Id) + 1;
quizDbContext.Category.Add(category);
quizDbContext.SaveChanges();
}
return(Ok());
}
public int _Save()
{
return(_context.SaveChanges());
}
public ActionResult Post([FromBody] QuestionDto questionDto)
{
if (questionDto == null)
{
return(BadRequest("question is null"));
}
if (questionDto.Answers == null)
{
return(BadRequest("answers are null"));
}
if (questionDto.Answers.Count <= 0)
{
return(BadRequest("answers count is 0"));
}
if (string.IsNullOrEmpty(questionDto.Content))
{
return(BadRequest("question has no content"));
}
foreach (AnswerDto answer in questionDto.Answers)
{
if (string.IsNullOrEmpty(answer.Content))
{
return(BadRequest("answer has no content"));
}
}
using (QuizDBContext quizDbContext = new QuizDBContext())
{
int newQuestionId = quizDbContext.Question.Max(q => q.Id) + 1;
Question question = questionDto.Question;
question.Id = newQuestionId;
ICollection <QuestionAnswer> questionAnswers = question.QuestionAnswer;
question.QuestionAnswer = new List <QuestionAnswer>();
question.CategoryId = 0;
quizDbContext.Question.Add(question);
int newQuestionAnswerId;
if (quizDbContext.QuestionAnswer.Count() != 0)
{
newQuestionAnswerId = quizDbContext.QuestionAnswer.Max(q => q.Id) + 1;
}
else
{
newQuestionAnswerId = 0;
}
int newAnswerId;
if (quizDbContext.Answer.Count() != 0)
{
newAnswerId = quizDbContext.Answer.Max(q => q.Id) + 1;
}
else
{
newAnswerId = 0;
}
foreach (QuestionAnswer questionAnswer in questionAnswers)
{
questionAnswer.Id = newQuestionAnswerId;
Answer answer = questionAnswer.Answer;
answer.Id = newAnswerId;
questionAnswer.Answer = null;
questionAnswer.AnswerId = answer.Id;
questionAnswer.QuestionId = question.Id;
quizDbContext.Answer.Add(answer);
quizDbContext.QuestionAnswer.Add(questionAnswer);
newQuestionAnswerId++;
newAnswerId++;
}
quizDbContext.SaveChanges();
}
return(Ok());
}
