public static void Add(CTLopHP lop)
{
var db = new OnthiDB();
db.CTLopHPDbSet.Add(lop);
db.SaveChanges();
}
public static int CheckMon(string ma, string msv)
{
var db = new OnthiDB();
var result = db.CTLopHPDbSet.Where(e => e.mamh == ma && e.masv == msv).FirstOrDefault();
if (result != null)
{
return(1);
}
return(0);
}
public static void Remove(CTLopHP ten)
{
var db = new OnthiDB();
var ojbSV = db.CTLopHPDbSet.Where(e => e.mact == ten.mact).FirstOrDefault();
if (ojbSV != null)
{
db.CTLopHPDbSet.Remove(ojbSV);
}
db.SaveChanges();
}
public static int CheckTen(string ten)
{
var db = new OnthiDB();
var result = db.LopHPDbSet.Where(e => e.tenlhp == ten).FirstOrDefault();
if (result != null)
{
return(1);
}
return(0);
}
public static int CheckMa(string ma)
{
var db = new OnthiDB();
var result = db.LopHPDbSet.Where(e => e.malhp == ma).FirstOrDefault();
if (result != null)
{
return(1);
}
return(0);
}
public static string GetMaMH(string mh)
{
string ma = null;
var db = new OnthiDB();
var result = db.MonHocDbSet.Where(e => e.tenmh == mh).FirstOrDefault();
if (result != null)
{
ma = result.mamh;
}
return(ma);
}
public static void Update(LopHP sv)
{
var db = new OnthiDB();
var result = db.LopHPDbSet.Where(e => e.malhp == sv.malhp).FirstOrDefault();
if (result != null)
{
result.malhp = sv.malhp;
result.tenlhp = sv.tenlhp;
result.gv = sv.gv;
result.dmsv = sv.dmsv;
result.mamh = sv.mamh;
}
db.SaveChanges();
}
