public static void delete(string id) { var db = new BaiMotContext(); var dataHP = db.lopHocPhans.Where(e => e.Id == id).FirstOrDefault(); db.lopHocPhans.Remove(dataHP); db.SaveChanges(); }
public static void delete(string maHP, string maSV) { var db = new BaiMotContext(); var dataHP = db.lopHocs.Where(e => e.maSinhVien == maSV && e.maLopHocPhan == maHP).FirstOrDefault(); db.lopHocs.Remove(dataHP); db.SaveChanges(); }
public static void addData(string malHP, string maSV) { var db = new BaiMotContext(); LopHoc lh = new LopHoc(); lh.maLopHocPhan = malHP; lh.maSinhVien = maSV; db.lopHocs.Add(lh); db.SaveChanges(); }
public static void edit(LopHocPhan lhp) { var db = new BaiMotContext(); var data = db.lopHocPhans.Where(e => e.Id == lhp.Id).FirstOrDefault(); data.Id = lhp.Id; data.giaoVienPhuTrach = lhp.giaoVienPhuTrach; data.hanMucSinhVien = lhp.hanMucSinhVien; data.maMonHoc = lhp.maMonHoc; db.SaveChanges(); }
public static void addData(string id, string giaoVien, string hanMuc, string maMonHoc) { var db = new BaiMotContext(); LopHocPhan LHP = new LopHocPhan(); LHP.Id = id; LHP.giaoVienPhuTrach = giaoVien; LHP.hanMucSinhVien = hanMuc; LHP.maMonHoc = maMonHoc; db.lopHocPhans.Add(LHP); db.SaveChanges(); }