public int xoaDT(string madt)
{
DotThi dt = tnth.DotThis.Where(d => d.MaNgayThi == madt).FirstOrDefault();
if (dt != null)
{
KyThi kt = tnth.KyThis.Where(k => k.MaNgayThi == dt.MaNgayThi).FirstOrDefault();
if (kt != null)
{
ThongTinCaNhan tcn = tnth.ThongTinCaNhans.Where(tc => tc.MaKyThi == kt.MaKT).FirstOrDefault();
if (tcn != null)
{
KetQua k = tnth.KetQuas.Where(kq => kq.MaTS == tcn.MaTS && kq.MaKT == kt.MaKT).FirstOrDefault();
if (k != null)
{
tnth.KetQuas.DeleteOnSubmit(k);
tnth.SubmitChanges();
}
tnth.ThongTinCaNhans.DeleteOnSubmit(tcn);
tnth.SubmitChanges();
}
tnth.KyThis.DeleteOnSubmit(kt);
tnth.SubmitChanges();
}
tnth.DotThis.DeleteOnSubmit(dt);
tnth.SubmitChanges();
return(1);
}
return(0);
}
public int themKT(string makt, string madt, int dotthi, int thoigian)
{
KyThi kt = new KyThi();
kt.MaKT = makt;
kt.MaNgayThi = madt;
kt.ThoiGianLamBai = thoigian;
kt.DotThi = dotthi;
try {
tnth.KyThis.InsertOnSubmit(kt);
tnth.SubmitChanges();
return(1);
}
catch { return(0); }
}
public int suaKT(string makt, string madt, int dotthi, int thoigian)
{
KyThi kt = tnth.KyThis.Where(k => k.MaKT == makt).FirstOrDefault();
if (kt != null)
{
kt.MaNgayThi = madt;
kt.ThoiGianLamBai = thoigian;
kt.DotThi = dotthi;
tnth.SubmitChanges();
return(1);
}
else
{
return(0);
}
}
public int xoaKT(string kt)
{
KyThi k = tnth.KyThis.Where(t => t.MaKT == kt).FirstOrDefault();
if (k != null)
{
ThongTinCaNhan ttcn = tnth.ThongTinCaNhans.Where(c => c.MaKyThi == k.MaKT).FirstOrDefault();
if (ttcn != null)
{
tnth.ThongTinCaNhans.DeleteOnSubmit(ttcn);
tnth.SubmitChanges();
}
tnth.KyThis.DeleteOnSubmit(k);
tnth.SubmitChanges();
return(1);
}
else
{
return(2);
}
}
private void detach_KyThis(KyThi entity)
{
this.SendPropertyChanging();
entity.DotThi1 = null;
}
private void attach_KyThis(KyThi entity)
{
this.SendPropertyChanging();
entity.DotThi1 = this;
}
partial void DeleteKyThi(KyThi instance);
partial void UpdateKyThi(KyThi instance);
partial void InsertKyThi(KyThi instance);
public KyThi getThoiGianLamBai(string maKT)
{
KyThi kt = tnth.KyThis.Where(t => t.MaKT.Equals(maKT)).FirstOrDefault();
return(kt);
}
