Пример #1
0
        public string EnrollStudent(Models.Student s)
        {
            if (!(_context.Studies.Any(st => st.Name == s.Studies)))
            {
                return("Nie ma takich studiow");
            }
            if ((_context.Student.Any(st => st.IndexNumber == s.IndexNumber)))
            {
                // JEST TAKI INDEX
                return("Nie jest to unikalny index");
            }
            var s2 = new Models2.Student()
            {
                IndexNumber = s.IndexNumber,
                FirstName   = s.FirstName,
                LastName    = s.LastName,
                BirthDate   = DateTime.Parse(s.BirthDate)
            };
            //var result = _context.Studies.Where(stu => stu.Name == s.Studies).;

            var study   = _context.Studies.Where(stu => stu.Name == s.Studies).FirstOrDefault();
            int idStudy = study.IdStudy;

            if (!(_context.Enrollment.Any(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date)))
            {
                var setStudent = new HashSet <Student> {
                    s2
                };

                var enroll = new Models2.Enrollment()
                {
                    IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1,
                    Semester     = 1,
                    StartDate    = DateTime.Now.Date,
                    Student      = setStudent,
                };

                study.Enrollment.Add(enroll);
                _context.Add(enroll);
                _context.Attach(study);
                _context.Entry(study).State = EntityState.Modified;
                _context.SaveChanges();

                return("Utworzono enrollment i student");
            }
            else
            {
                var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault();

                enroll.Student.Add(s2);
                _context.Attach(enroll);
                _context.Entry(enroll).State = EntityState.Modified;
                _context.SaveChanges();

                return("Utworzono student");
            }
        }
Пример #2
0
        public string EnrollStudent(Models.Student s)
        {
            int eskaUnik = 1;
            var student  = new Student();

            var studia = _context.Studies.Where(stu => stu.Name == s.Studies).ToList();

            if (studia.Count == 0)
            {
                return("nie ma takiego kierunku");
            }
            var unikId = _context.Student.Where(stu => stu.IndexNumber == s.IndexNumber).ToList();

            if (unikId.Count != 0)
            {
                eskaUnik = 0;
                student  = unikId[0];
            }
            var stud = new Models2.Student()
            {
                IndexNumber = s.IndexNumber,
                FirstName   = s.FirstName,
                LastName    = s.LastName,
                BirthDate   = DateTime.Parse(s.BirthDate)
            };

            var study   = _context.Studies.Where(stu => stu.Name == s.Studies).FirstOrDefault();
            int idStudy = study.IdStudy;

            if ((!(_context.Enrollment.Any(enrl => enrl.IdStudy == idStudy && enrl.Semester == 1 && enrl.StartDate.Date == DateTime.Now.Date))))
            {
                if (eskaUnik == 1)
                {
                    var setStudent = new HashSet <Student> {
                        stud
                    };
                    var enroll = new Models2.Enrollment()
                    {
                        IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1,
                        Semester     = 1,
                        StartDate    = DateTime.Now.Date,
                        Student      = setStudent,
                    };
                    study.Enrollment.Add(enroll);
                    _context.Add(enroll);
                    _context.Attach(study);
                    _context.Entry(study).State = EntityState.Modified;

                    _context.SaveChanges();
                    return("dodano nowego studenta i nowy enroll");
                }
                else
                {
                    var setStudent = new HashSet <Student> {
                        student
                    };
                    var enroll = new Models2.Enrollment()
                    {
                        IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1,
                        Semester     = 1,
                        StartDate    = DateTime.Now.Date,
                        Student      = setStudent,
                    };
                    study.Enrollment.Add(enroll);
                    _context.Add(enroll);
                    _context.Attach(study);
                    _context.Entry(study).State = EntityState.Modified;

                    _context.SaveChanges();
                    return("zapisano studenta na nowy enroll");
                }
            }
            else
            {
                if (eskaUnik == 1)
                {
                    var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault();
                    enroll.Student.Add(stud);
                    _context.Attach(study);
                    _context.Entry(study).State = EntityState.Modified;
                    _context.SaveChanges();
                    return("dodano nowego studenta na instniejacy enroll");
                }
                else
                {
                    var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault();
                    enroll.Student.Add(student);
                    _context.Attach(study);
                    _context.Entry(study).State = EntityState.Modified;
                    _context.SaveChanges();
                    return("dodano studenta na instniejacy enroll");
                }
            }
        }