Esempio n. 1
0
        public Enrollment Promote(int idStudy, int semester)
        {
            var getEnrollment = GetEnrollment(idStudy, semester);

            if (getEnrollment == null)
            {
                return(null);
            }

            var setEnrollment = GetEnrollment(idStudy, semester + 1);

            if (setEnrollment == null)
            {
                setEnrollment = new Enrollment
                {
                    IdEnrollment = _dbcont.Enrollments.Max(e => e.IdEnrollment) + 1,
                    IdStudy      = getEnrollment.IdStudy,
                    Semester     = getEnrollment.Semester + 1
                };
                _dbcont.Attach(setEnrollment);
                _dbcont.Add(setEnrollment);
            }
            _dbcont.Students
            .Where(s => s.IdEnrollment == getEnrollment.IdEnrollment)
            .ToList()
            .ForEach(s =>
            {
                s.IdEnrollment = setEnrollment.IdEnrollment;
                _dbcont.Attach(s);
                _dbcont.Entry(s).State = EntityState.Modified;
            });
            _dbcont.SaveChanges();
            return(setEnrollment);
        }
Esempio n. 2
0
        public ActionResult UpdateStudentEF(UpdateStudentRequest request)
        {
            var db  = new s16061Context();
            var res = new Students {
                IndexNumber  = request.IndexNumber,
                FirstName    = request.FirstName,
                LastName     = request.LastName,
                Birthdate    = request.Birthdate,
                IdEnrollment = request.IdEnrollment
            };

            db.Entry(res).State = EntityState.Modified;
            db.SaveChanges();
            return(Ok("Zaktualizowano"));
        }