コード例 #1
0
        public EnrollStudentResponse EnrollStudent(EnrollStudentRequest request)
        {
            EnrollStudentResponse response = new EnrollStudentResponse();



            var studies = _dbContext.Studies
                          .Where(s => s.Name.Equals(request.Studies))
                          .Single();

            var enrollment = _dbContext.Enrollment
                             .Where(e => e.IdStudy == studies.IdStudy && e.Semester == 1)
                             .SingleOrDefault();

            int idEnrollment;

            if (enrollment == null)
            {
                idEnrollment = _dbContext.Enrollment.Count();
                var e = new Enrollment
                {
                    IdEnrollment = idEnrollment,
                    Semester     = 1,
                    IdStudy      = studies.IdStudy,
                    StartDate    = DateTime.Now
                };

                _dbContext.Enrollment.Add(e);
                _dbContext.SaveChanges();
            }
            else
            {
                idEnrollment = enrollment.IdEnrollment;
            }

            var student = new Student
            {
                IndexNumber  = request.IndexNumber,
                IdEnrollment = idEnrollment,
                FirstName    = request.FirstName,
                LastName     = request.LastName,
                BirthDate    = request.birthDate
            };

            _dbContext.Student.Add(student);
            _dbContext.SaveChanges();
            response = new EnrollStudentResponse
            {
                LastName  = student.LastName,
                Semester  = enrollment.Semester,
                StartDate = enrollment.StartDate
            };
            return(response);
        }
コード例 #2
0
ファイル: PatientsController.cs プロジェクト: s18986/cw12
        public IActionResult Delete(Patients pat)
        {
            if (!ModelState.IsValid)
            {
                return(View(pat));
            }
            var db = new s18986Context();

            db.Patients.Remove(pat);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }