static public bool themChiTietKyThiVaoDB(CHITIETKYTHI ctkt)
{
using (QLTTNDataContext qlttn = new QLTTNDataContext())
{
try
{
qlttn.CHITIETKYTHIs.InsertOnSubmit(ctkt);
qlttn.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
static public bool xoaChiTietKyThiVaoDB(CHITIETKYTHI ctkt)
{
using (QLTTNDataContext qlttn = new QLTTNDataContext())
{
try
{
var chiTietKyThi = qlttn.CHITIETKYTHIs.Where(ctktt => ctktt.MaDeThi.Equals(ctkt.MaDeThi) && ctktt.MaKyThi.Equals(ctkt.MaKyThi));
foreach (var ctktt in chiTietKyThi)
{
qlttn.CHITIETKYTHIs.DeleteOnSubmit(ctktt);
}
qlttn.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
static public bool capNhatChiTietKyThiVaoDB(CHITIETKYTHI ctkt)
{
using (QLTTNDataContext qlttn = new QLTTNDataContext())
{
try
{
var chiTietKyThi = qlttn.CHITIETKYTHIs.Where(ctktt => ctktt.MaDeThi.Equals(ctkt.MaDeThi) && ctktt.MaKyThi.Equals(ctkt.MaKyThi));
foreach (var ctktt in chiTietKyThi)
{
ctktt.ThoiGianBatDau = ctkt.ThoiGianBatDau;
ctktt.ThoiGianKetThuc = ctkt.ThoiGianKetThuc;
}
qlttn.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
static public bool capNhatChiTietKyThiVaoDB(CHITIETKYTHI ctkt)
{
return(DAO_Giao_Vien.capNhatChiTietKyThiVaoDB(ctkt));
}
static public bool themChiTietKyThiVaoDB(CHITIETKYTHI ctkt)
{
return(DAO_Giao_Vien.themChiTietKyThiVaoDB(ctkt));
}
