public IActionResult GetStudent(string indexNumber) { var db = new s19981Context(); var student = db.Students.Where(student => student.IndexNumber == indexNumber).First(); return(Ok(student)); }
public IActionResult GetStudents() { var db = new s19981Context(); var list = db.Students.ToList(); return(Ok(list)); }
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()); }
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)); }
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)); }