public IHttpActionResult Search([FromBody]string mssv) { using (QLSVEntities db = new QLSVEntities()) { SINHVIEN sv = (from s in db.SINHVIENs where s.MSSV == mssv select s).First(); return Ok(sv); } }
public IHttpActionResult GetAll() { using (QLSVEntities db = new QLSVEntities()) { var list = db.SINHVIENs.ToList(); return Ok(list); } }
public IHttpActionResult Add([FromBody]SINHVIEN st) { using (QLSVEntities db = new QLSVEntities()) { db.SINHVIENs.Add(st); db.SaveChanges(); return Ok(); } }
public IHttpActionResult Delete([FromBody]string mssv) { using (QLSVEntities db = new QLSVEntities()) { SINHVIEN sv = (from s in db.SINHVIENs where s.MSSV == mssv select s).First(); db.SINHVIENs.Remove(sv); db.SaveChanges(); return Ok(); } }
public IHttpActionResult Update([FromBody]SINHVIEN news_sv) { using (QLSVEntities db = new QLSVEntities()) { SINHVIEN sv = (from s in db.SINHVIENs where s.MSSV == news_sv.MSSV select s).First(); sv.HOTEN = news_sv.HOTEN; sv.KHOA = news_sv.KHOA; sv.NGANH = news_sv.NGANH; sv.DIACHI = news_sv.DIACHI; sv.SDT = news_sv.SDT; db.SaveChanges(); return Ok(); } }