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();
}
