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