ASP.NET problem with saving quizzes to a SQL database

Question

I have a problem with my application namely I want to create the possibility to create dynamic quizzes. Currently I have a problem related to saving the created quiz with questions to the database.

No matter if I want to create a new one or edit the one default one it is not sent to the database. According to me the problem must lie in the controller or in the js code in the Upsert file, but I can't tell where.Please help

My models - Quiz:

public class Quiz
{
    [Key]
    public int Id { get; set; }
    [DisplayName("Tytuł")]
    [Required]
    public string Title { get; set; }
    
    [DisplayName("Dział")]
    public int SectionId { get; set; }
    [ForeignKey("SectionId")]
    [ValidateNever]
    public Section Section { get; set; }

    public List Questions { get; set; }
}

Question:

public class Question
{
    [Key]
    public int Id {  get; set; }
    [Required]
    [DisplayName("Pytanie")]
    public string QuestionText { get; set; }
    [Required]
    [DisplayName("Odpowiedź 1")]
    public string Answer1 { get; set; }
    [Required]
    [DisplayName("Odpowiedź 2")]
    public string Answer2 { get; set; }
    [Required]
    [DisplayName("Odpowiedź 3")]
    public string Answer3 { get; set; }
    [Required]
    [DisplayName("Odpowiedź 4")]
    public string Answer4 { get; set; }
    public int IsCorrect { get; set; }

    [DisplayName("Quiz")]
    public int QuizId { get; set; }
    [ForeignKey("QuizId")]
    [ValidateNever]
    public Quiz Quiz { get; set; }
}

QuizVM:

public class QuizVM
{ 
    public Quiz Quiz { get; set; }

    [ValidateNever]
    public IEnumerable SectionList { get; set; }

    public List Questions { get; set; }
}

My index view:

@model List


    
        
            
                List Quizów
            
        
    
    
        
            
            
            
                
                     Add new Quiz
                
            
        

        
            
                
                    Title
                    Section
                    
                
            
        
    


@section Scripts {
    
}

Upsert:

@model QuizVM
Create Quiz


    
        
        
        
    

    
        
        
        
    

    
        @for (var questionCounter = 0; questionCounter < Model.Questions.Count; questionCounter++)
        {
            
                Pytanie @questionCounter

                
                    Question Text
                    
                

                
                    Odpowiedzi
                    
                    
                    
                    
                

                
                    Correct Answer
                    
                
            
        }
    

    

    
        
            
                @if (Model.Quiz.Id != 0)
                {
                    
                }
                else
                {
                    
                }
            
        
            Back to List
        
    


@section Scripts {
    
}

And QuizController:

[Area("Admin")]
[Authorize(Roles = SD.Role_Admin)]
public class QuizController : Controller
{
    private readonly IUnitOfWork _unitOfWork;
    private readonly ILogger _logger;

    public QuizController(IUnitOfWork unitOfWork, ILogger logger)
    {
        _unitOfWork = unitOfWork;
        _logger = logger;
    }

    public IActionResult Index()
    {
        List objQuizlsList = _unitOfWork.Quiz.GetAll(includeProperties: "Section").ToList();

        return View(objQuizlsList);
    }

    public IActionResult Upsert(int? id)
    {
        QuizVM quizVM = new()
        {
            SectionList = _unitOfWork.Section.GetAll().Select(u => new SelectListItem
            {
                Text = u.Title,
                Value = u.Id.ToString()
            }),
            Quiz = new Quiz(),
            Questions = new List()
        };

        if (id == null || id == 0)
        {
            return View(quizVM);
        }
        else
        {
            // Edit quiz
            quizVM.Quiz = _unitOfWork.Quiz.Get(u => u.Id == id);
            // Get question from quiz
            quizVM.Questions = _unitOfWork.Question.GetAll().Where(q => q.QuizId == id).ToList();
            return View(quizVM);
        }
    }

    [HttpPost]
    public IActionResult Upsert(QuizVM quizVM)
    {
        if (ModelState.IsValid)
        {
            if (quizVM.Quiz.Id == 0)
            {
                // add new quiz
                _unitOfWork.Quiz.Add(quizVM.Quiz);
                _unitOfWork.Save(); // save changes to generate the id for the quiz

                //add question
                foreach (var question in quizVM.Questions)
                {
                    question.QuizId = quizVM.Quiz.Id;
                    _unitOfWork.Question.Add(question);
                }

                _unitOfWork.Save();
            }
            else
            {
                // Update quiz
                _unitOfWork.Quiz.Update(quizVM.Quiz);

                // Update question
                var existingQuestions = _unitOfWork.Question.GetAll().Where(q => q.QuizId == quizVM.Quiz.Id).ToList();

                foreach (var question in existingQuestions)
                {
                    _unitOfWork.Question.Remove(question);
                }

                foreach (var question in quizVM.Questions)
                {
                    question.QuizId = quizVM.Quiz.Id;
                    _unitOfWork.Question.Add(question);
                }
            }

            _unitOfWork.Save();

            TempData["success"] = "Quiz created successfully";

            return RedirectToAction("Index");
        }
        else
        {
            //Back list
            quizVM.SectionList = _unitOfWork.Section.GetAll().Select(u => new SelectListItem
            {
                Text = u.Title,
                Value = u.Id.ToString()
            });

            return View(quizVM);
        }
    }

    #region API CALLS
    [HttpGet]
    public IActionResult GetAll()
    {
        List objQuizList = _unitOfWork.Quiz.GetAll(includeProperties: "Section").ToList();
        return Json(new { data = objQuizList });
    }

    [HttpDelete]
    public IActionResult Delete(int? id)
    {
        var QuizToBeDeleted = _unitOfWork.Quiz.Get(u => u.Id == id);
        if (QuizToBeDeleted == null)
        {
            return Json(new { success = false, message = "Error while deleting" });
        }

        _unitOfWork.Quiz.Remove(QuizToBeDeleted);
        _unitOfWork.Save();

        return Json(new { success = true, message = "Delete Successful" });
    }
    #endregion
}

Share via

ASP.NET problem with saving quizzes to a SQL database

Your answer