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