public IHttpActionResult DeleteStudent(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var db = new EFDemoDBEntities())
{
var student = db.Students.Where(s => s.ID == id).FirstOrDefault();
if (student == null)
{
return(NotFound());
}
db.Entry(student).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
return(Ok());
}
/// <summary>
/// POST,请求，新增一个Student
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public IHttpActionResult PostNewStudent(StudentViewModel student)
{
/*
* 在Filder中的request body中这样写：
* {
* "name":"TestStudent",
* "sex":"女",
* "age":"18",
* "Grade":{"gradeid":2,"gradename":"软件1107班"}
*
* }
*/
if (student != null)
{
if (!ModelState.IsValid)
{
//400
return(BadRequest("Invalid data"));
}
using (var db = new EFDemoDBEntities())
{
//因为不要把EF的实体对象和客户端直接操作，就搞一个ViewModel实体
db.Students.Add(new Student()
{
ID = student.ID,
Name = student.Name,
Sex = student.Sex,
Age = student.Age,
Grade = null
//db.Grades.Where(s => s.GradeID == student.Grade.GradeID).FirstOrDefault()
//{ GradeID = student.Grade.GradeID, GradeName = student.Grade.GradeName }//这样写就会新增一个班级
});
db.SaveChanges();
}
return(Ok());
}
return(NotFound());
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public IHttpActionResult PutStudent(StudentViewModel student)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var db = new EFDemoDBEntities())
{
var existingStudent = db.Students.Where(s => s.ID == student.ID).FirstOrDefault <Student>();
if (existingStudent != null)
{
existingStudent.Name = student.Name;
existingStudent.Sex = student.Sex;
existingStudent.Age = student.Age;
db.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
