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