Exemplo n.º 1
0
        public IActionResult GetStudents(string orderBy)
        {
            //return Ok(_dbService.GetStudents());
            var db  = new s16770Context();
            var res = db.Student.ToList();

            return(Ok(res));
        }
Exemplo n.º 2
0
        public IActionResult DeleteStudent(string id)
        {
            var db = new s16770Context();
            var st = db.Student.Where(st => st.IndexNumber == id).ToList().First();

            db.Student.Remove(st);
            db.SaveChanges();

            return(Ok("Student usuniety"));
        }
Exemplo n.º 3
0
        public IActionResult UpdateStudent(ModelsAuto.Student student, string id)
        {
            var db = new s16770Context();
            var st = new ModelsAuto.Student
            {
                IndexNumber = id,
                FirstName   = student.FirstName,
                LastName    = student.LastName,
                BirthDate   = student.BirthDate,
                Passwd      = student.Passwd
            };

            db.Attach(st);
            db.Entry(st).Property("FirstName").IsModified = true;
            db.Entry(st).Property("LastName").IsModified  = true;
            db.Entry(st).Property("BirthDate").IsModified = true;
            db.Entry(st).Property("Passwd").IsModified    = true;

            db.SaveChanges();

            return(Ok("Student zaktualizowany"));
        }