public async Task <IActionResult> Create([Bind("ID,Weight,MaximumScore,SchoolId,SubjectId,AssessmentDate,AcademicPeriodId,AssessmentTypeId")] AcademicAssessment academicAssessment, int[] studentId, int[] score)
        {
            AcademicAssessment a = new AcademicAssessment
            {
                AssessmentDate   = DateTime.Now,
                Weight           = academicAssessment.Weight,
                SubjectId        = academicAssessment.SubjectId,
                SchoolId         = academicAssessment.SchoolId,
                AcademicPeriodId = academicAssessment.AcademicPeriodId,
                AssessmentTypeId = academicAssessment.AssessmentTypeId,
                MaximumScore     = academicAssessment.MaximumScore
            };

            int counter = 0;

            a.AcademicAssessmentDetails = new List <AcademicAssessmentDetails>();
            foreach (var student in studentId)
            {
                a.AcademicAssessmentDetails.Add(new AcademicAssessmentDetails
                {
                    StudentId = student,
                    Score     = score[counter]
                });
                counter++;
            }


            _context.Add(a);
            await _context.SaveChangesAsync();

            return(RedirectToAction(nameof(Index)));
        }
        public async Task <IActionResult> Edit(int id, [Bind("ID,Score,Weight,SchoolId,StudentId,SubjectId,AssessmentDate,AcademicPeriodId,AssessmentTypeId")] AcademicAssessment academicAssessment)
        {
            if (id != academicAssessment.ID)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(academicAssessment);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!AcademicAssessmentExists(academicAssessment.ID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["AcademicPeriodId"] = new SelectList(_context.Set <AcademicPeriod>(), "Id", "Id", academicAssessment.AcademicPeriodId);
            ViewData["AssessmentTypeId"] = new SelectList(_context.AcademicAssessmentTypes, "ID", "ID", academicAssessment.AssessmentTypeId);
            ViewData["SchoolId"]         = new SelectList(_context.Schools, "ID", "ID", academicAssessment.SchoolId);
            ViewData["SubjectId"]        = new SelectList(_context.Subjects, "Id", "Id", academicAssessment.SubjectId);
            return(View(academicAssessment));
        }