public static void ThemHS(HocSinh hs) { var db = new ConnectionsDBContext(); db.HocSinhDbSet.Add(hs); db.SaveChanges(); }
public static void ThemLH(LopHoc lh) { try { var db = new ConnectionsDBContext(); db.LopHocDbSet.Add(lh); db.SaveChanges(); } catch (Exception ex) { } }
public static void XoaHS(HocSinh hs) { var db = new ConnectionsDBContext(); var obj = db.HocSinhDbSet.Where(e => e.MaLH == hs.MaHS).FirstOrDefault(); if (obj != null) { db.HocSinhDbSet.Remove(obj); } db.SaveChanges(); }
public static void XoaLH(LopHoc lh) { var db = new ConnectionsDBContext(); var obj = db.LopHocDbSet.Where(e => e.MaLH == lh.MaLH).FirstOrDefault(); if (obj != null) { db.LopHocDbSet.Remove(obj); } db.SaveChanges(); }
public static List <HocSinh> GetListHocSinh(String malop = "") { if (!malop.Equals("")) { List <HocSinh> dshs = new ConnectionsDBContext().HocSinhDbSet.ToList(); List <HocSinh> hs = new List <HocSinh>(); foreach (HocSinh i in dshs) { if (i.MaLH.Equals(malop)) { hs.Add(i); } } return(hs); } else { return(new ConnectionsDBContext().HocSinhDbSet.ToList()); } }
public static List <LopHoc> GetListLopHoc(String khoihoc = "", String namhoc = "") { List <LopHoc> dslh = new ConnectionsDBContext().LopHocDbSet.ToList(); if (!khoihoc.Equals("") && !namhoc.Equals("")) { List <LopHoc> lh = new List <LopHoc>(); foreach (LopHoc i in dslh) { if (i.KhoiHoc.Equals(khoihoc) && i.NamHoc.Equals(namhoc)) { lh.Add(i); } } return(lh); } else { return(dslh); } }