public IHttpActionResult Put(StudentViewModel student) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new schoolEntities2()) { var existingStudent = ctx.Students.Where(s => s.ID == student.Id) .FirstOrDefault <Student>(); if (existingStudent != null) { existingStudent.Name = student.Name; existingStudent.Address = student.Address; existingStudent.Email = student.Email; existingStudent.Class = student.Class; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
public IHttpActionResult Delete(int id) { if (id <= 0) { return(BadRequest("Not a valid student id")); } using (var ctx = new schoolEntities2()) { var student = ctx.Students .Where(s => s.ID == id) .FirstOrDefault(); ctx.Entry(student).State = System.Data.Entity.EntityState.Deleted; ctx.SaveChanges(); } return(Ok()); }
public IHttpActionResult PostNewStudent(StudentViewModel student) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new schoolEntities2()) { ctx.Students.Add(new Student() { Name = student.Name, Email = student.Email, Address = student.Address, Class = student.Class }); ctx.SaveChanges(); } return(Ok()); }
public IHttpActionResult GetAllStudents() { IList <StudentViewModel> students = null; using (var ctx = new schoolEntities2()) { students = ctx.Students .Select(s => new StudentViewModel() { Id = s.ID, Name = s.Name, Email = s.Email, Class = s.Class, Address = s.Address }).ToList <StudentViewModel>(); } if (students.Count == 0) { return(NotFound()); } return(Ok(students)); }