public IEnumerable<TuVung> Load(TuVung _tuvung) { IEnumerable<TuVung> query = from p in db.TuVungs where p.IDTuDien == _tuvung.IDTuDien && p.Tu == _tuvung.Tu select p; return query; }
public void Delete(TuVung _tuvung) { IEnumerable<TuVung> delquery = from p in db.TuVungs where p.IDTuVung == (int)_tuvung.IDTuVung select p; db.TuVungs.DeleteAllOnSubmit(delquery); db.SubmitChanges(); }
private bool KiemTraTrungCauTraLoi(TuVung[] tuvung, TuVung temp,int n) { for (int i = 0; i < n; i++) { if (temp == tuvung[i]) return true; } return false; }
private bool KiemTraTrungCauHoi(CauHoiCollection cauhoiColl,TuVung tv) { foreach (TracNghiemBO tn in cauhoiColl) { if (tv.IDTuVung == tn.Choices[0].IDTuVung) return true; } return false; }
public void Update(TuVung _tuvung) { TuVung _tudienedit = db.TuVungs.Single(p => p.IDTuVung == _tuvung.IDTuVung); _tudienedit.Tu = _tuvung.Tu; _tudienedit.LoaiTu = _tuvung.LoaiTu; _tudienedit.NghiaTu = _tuvung.NghiaTu; _tudienedit.HinhAnh = _tuvung.HinhAnh; _tudienedit.ApDung = _tuvung.ApDung; db.SubmitChanges(); }
public bool XoaTuVung(int IDTuvung) { try { TuVung tv= new TuVung(); tv.IDTuVung=IDTuvung; tuvungDAO.Delete(tv); return true; } catch { return false; } }
public IEnumerable<TuVung> LoadTuVung(int IDtudien,string tuvung) { try { TuVung tv = new TuVung(); tv.Tu = tuvung; tv.IDTuDien = IDtudien; return tuvungDAO.Load(tv); } catch { return null; } }
public bool SuaTuVung(int idtuvung,string tu, string loai, string nghia,string hinhanh, string apdung) { try { TuVung tv = new TuVung(); tv.IDTuVung = idtuvung; tv.Tu = tu; tv.LoaiTu = loai; tv.NghiaTu = nghia; tv.HinhAnh = hinhanh; tv.ApDung = apdung; tuvungDAO.Update(tv); return true; } catch { return false; } }
public bool ThemTuVung(int idtudien, string tu, string loai, string nghia,string hinhanh, string apdung) { try { TuVung tv = new TuVung(); tv.IDTuDien = idtudien; tv.Tu = tu; tv.LoaiTu = loai; tv.NghiaTu = nghia; tv.HinhAnh = hinhanh; tv.ApDung = apdung; tuvungDAO.Insert(tv); return true; } catch { return false; } }
public void Insert(TuVung _tuvung) { db.TuVungs.InsertOnSubmit(_tuvung); db.SubmitChanges(); }