Example #1
0
        public IActionResult UpDateStudent(string id, Student student)
        {
            var db = new s16985Context();

            var st = db.Student.Where(stud => stud.IndexNumber.Equals(id)).First();

            if (student.FirstName != null)
            {
                st.FirstName = student.FirstName;
            }
            if (student.LastName != null)
            {
                st.LastName = student.LastName;
            }
            if (student.BirthDate != null)
            {
                st.BirthDate = student.BirthDate;
            }
            if (student.IndexNumber != null)
            {
                st.IndexNumber = student.IndexNumber;
            }


            db.SaveChanges();
            return(Ok("Aktualizacja dokończona"));
        }
Example #2
0
        public IActionResult GetStudents()
        {
            var db = new s16985Context();

            var res = db.Student.ToList();

            return(Ok(res));
        }
Example #3
0
        public IActionResult DeleteStudent(string id)
        {
            var db = new s16985Context();

            var st = db.Student.Where(stud => stud.IndexNumber.Equals(id)).First();

            // db.Attach(st);
            db.Remove(st);
            db.SaveChanges();
            return(Ok("Usuwanie ukończone"));
        }
Example #4
0
        public IActionResult CreateStudent(Student student)
        {
            var db = new s16985Context();

            student.Salt = "VDIPYS6X9MSB8EPMNZTB";
            db.Student.Add(student);

            db.SaveChanges();

            return(Ok("Poprawnie dodano studenta: " + student.IndexNumber));
        }
Example #5
0
        public IActionResult EnrollStudent(EnrollStudentRequest request)
        {
            int semestr = 1;
            var db      = new s16985Context();
            int idStudy;
            int idEnroll;

            try
            {
                idStudy = db.Studies.Where(study => study.Name.Equals(request.Studies)).Select(s => s.IdStudy).First();
            }
            catch (Exception e)
            {
                return(BadRequest("Podane studia nie istnieją!"));
            }

            try
            {
                idEnroll = db.Enrollment.Where(idEnroll => idEnroll.Semester.Equals(semestr) && idEnroll.IdStudy.Equals(idStudy)).Select(e => e.IdEnrollment).First();
            }
            catch (Exception e)
            {
                var enrollment = new Enrollment();
                idEnroll = db.Enrollment.Max(e => e.IdEnrollment) + 1;
                enrollment.IdEnrollment = idEnroll;
                enrollment.IdStudy      = idStudy;
                enrollment.Semester     = semestr;
                enrollment.StartDate    = DateTime.Today;

                db.Enrollment.Add(enrollment);
            }



            if (db.Student.Where(s => s.IndexNumber.Equals(request.IndexNumber)).Count() > 0)
            {
                return(BadRequest("Podany numer indeksu już istnieje!"));
            }

            Student student = new Student();

            student.IndexNumber  = request.IndexNumber;
            student.FirstName    = request.FirstName;
            student.LastName     = request.LastName;
            student.BirthDate    = request.BirthDate;
            student.IdEnrollment = idEnroll;
            student.Salt         = "VDIPYS6X9MSB8EPMNZTB";


            db.SaveChanges();
            return(Ok("Pomyślnie dodano studenta"));
        }
Example #6
0
        public IActionResult PromoteStudents(PromoteStudentRequest request)
        {
            int idStudy;
            int semester;
            var db = new s16985Context();
            int idEnrollOld;
            int idEnrollNew;

            try
            {
                idStudy  = db.Studies.Where(st => st.Name.Equals(request.Studies)).Select(st => st.IdStudy).First();
                semester = db.Enrollment.Where(enroll => enroll.IdStudy.Equals(idStudy)).Select(enroll => enroll.Semester).First();
                if (!semester.Equals(request.Semester))
                {
                    return(BadRequest("Semestr tych studiów nie istnieje!"));
                }
            }
            catch (Exception e)
            {
                return(BadRequest("Podane studia nie istnieją!"));
            }

            try
            {
                idEnrollNew = db.Enrollment.Where(enroll => enroll.Semester.Equals(semester + 1) && enroll.IdStudy.Equals(idStudy)).Select(e => e.IdEnrollment).First();
            }
            catch (Exception e)
            {
                var enrollment = new Enrollment();
                idEnrollNew             = db.Enrollment.Max(e => e.IdEnrollment) + 1;
                enrollment.IdEnrollment = idEnrollNew;
                enrollment.IdStudy      = idStudy;
                enrollment.Semester     = semester + 1;
                enrollment.StartDate    = DateTime.Today;

                db.Enrollment.Add(enrollment);
            }
            idEnrollOld = db.Enrollment.Where(enroll => enroll.IdStudy.Equals(idStudy) && enroll.Semester.Equals(semester)).Select(enroll => enroll.IdEnrollment).First();

            foreach (Student student in db.Student)
            {
                if (student.IdEnrollment.Equals(idEnrollOld))
                {
                    student.IdEnrollment = idEnrollNew;
                    db.Student.Update(student);
                }
            }
            db.SaveChanges();

            return(Ok("Promocja zakończona sukcesem"));
        }