Ejemplo n.º 1
0
        public IActionResult GetStudent(string indexNumber)
        {
            var db      = new s19981Context();
            var student = db.Students.Where(student => student.IndexNumber == indexNumber).First();

            return(Ok(student));
        }
Ejemplo n.º 2
0
        public IActionResult GetStudents()
        {
            var db   = new s19981Context();
            var list = db.Students.ToList();

            return(Ok(list));
        }
Ejemplo n.º 3
0
        public IActionResult DeleteStudent(string indexNumber)
        {
            var db      = new s19981Context();
            var student = new Student
            {
                IndexNumber = indexNumber
            };

            db.Attach(student);
            db.Remove(student);

            db.SaveChanges();

            return(Ok());
        }
Ejemplo n.º 4
0
        public IActionResult CreateStudent(string indexNumber, string firstName, string lastName, DateTime birthDate)
        {
            var db      = new s19981Context();
            var student = new Student
            {
                IndexNumber  = indexNumber,
                FirstName    = firstName,
                LastName     = lastName,
                BirthDate    = DateTime.Parse(birthDate.ToString()),
                IdEnrollment = 1
            };

            db.Students.Add(student);
            db.SaveChanges();

            return(Ok(student));
        }
Ejemplo n.º 5
0
        public IActionResult UpdateStudent(string indexNumber, string firstName, string lastName)
        {
            var db      = new s19981Context();
            var student = new Student
            {
                IndexNumber = indexNumber,
                FirstName   = firstName,
                LastName    = lastName
            };

            db.Attach(student);
            db.Entry(student).Property("FirstName").IsModified = true;
            db.Entry(student).Property("LastName").IsModified  = true;
            db.SaveChanges();

            return(Ok(student));
        }