示例#1
0
        public async Task <ActionResult <BulkStudentCourseDto[]> > PostBulkStudentCourses(List <BulkStudentCourseDto> bulkStudentCourseDtos)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            List <StudentCourse> addedStudentCourses = new List <StudentCourse>();

            BulkStudentCourseDto bulkDto = new BulkStudentCourseDto();

            var validData = bulkStudentCourseDtos.Where(w => w.Username == User.Identity.Name);

            try
            {
                // get valid

                foreach (var b in validData)
                {
                    var studentCourse = await _context.StudentCourses
                                        // .Select(BulkStudentCourseDto.AsBulkStudentCourseDto)
                                        .FirstOrDefaultAsync(
                        x => x.Session.Name == b.Session &&
                        x.Semester.Name == b.Semester &&
                        x.Course.Code == b.Code &&
                        x.Student.MatricNo == b.MatricNo
                        );

                    if (studentCourse != null)
                    {
                        continue;
                    }

                    studentCourse = new StudentCourse {
                        Score = b.Score
                    };

                    // get session
                    var session = await _context.Sessions.FirstOrDefaultAsync(f => f.Name == b.Session);

                    if (session != null)
                    {
                        studentCourse.SessionId = session.Id;
                    }
                    else
                    {
                        var entity = new Session {
                            Name = b.Session
                        };
                        entity.AddTracker(User.Identity.Name);
                        await _context.Sessions.AddAsync(entity);

                        studentCourse.Session = entity;
                        this.RemoveCache(CacheKeys.Session);
                    }

                    // get semester
                    var semester = await _context.Semesters.FirstOrDefaultAsync(f => f.Name == b.Semester);

                    if (semester != null)
                    {
                        studentCourse.SemesterId = semester.Id;
                    }
                    else
                    {
                        var entity = new Semester {
                            Name = b.Semester
                        };
                        entity.AddTracker(User.Identity.Name);
                        await _context.Semesters.AddAsync(entity);

                        studentCourse.Semester = entity;
                        this.RemoveCache(CacheKeys.Semester);
                    }

                    // get course
                    var course = await _context.Courses.FirstOrDefaultAsync(f => f.Code == b.Code);

                    if (course != null)
                    {
                        studentCourse.CourseId = course.Id;
                    }
                    else
                    {
                        var entity = new Course
                        {
                            Code  = b.Code,
                            Title = b.Code,
                        };
                        entity.AddTracker(User.Identity.Name);
                        await _context.Courses.AddAsync(entity);

                        studentCourse.Course = entity;
                        this.RemoveCache(CacheKeys.Course);
                    }

                    // get student
                    var student = await _context.Students.FirstOrDefaultAsync(f => f.MatricNo == b.MatricNo);

                    if (student != null)
                    {
                        studentCourse.StudentId = student.Id;
                    }
                    else
                    {
                        var entity = new Student
                        {
                            MatricNo  = b.MatricNo,
                            Lastname  = b.MatricNo,
                            Firstname = b.MatricNo,
                        };
                        entity.AddTracker(User.Identity.Name);
                        await _context.Students.AddAsync(entity);

                        studentCourse.Student = entity;
                        this.RemoveCache(CacheKeys.Student);
                    }

                    studentCourse.AddTracker(User.Identity.Name);

                    await _context.StudentCourses.AddAsync(studentCourse);

                    int rows = await _context.SaveChangesAsync();

                    if (rows > 0)
                    {
                        addedStudentCourses.Add(studentCourse);

                        b.Id = studentCourse.Id;
                    }

                    bulkDto.Id = studentCourse.Id;
                }

                if (bulkStudentCourseDtos.Any(a => a.Id > 0) == true || addedStudentCourses.Count > 0)
                {
                    this.RemoveCache(CacheKeys.StudentCourse);
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.Message));
            }

            return(bulkStudentCourseDtos.ToArray());
        }