public void InsertDinhKem(tblDinhKem dinhkem)
{
int dinhkemID = GetMaxIDDinhKem();
dinhkem.DinhKemID = dinhkemID + 1;
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
_libraryContext.tblDinhKems.InsertOnSubmit(dinhkem);
_libraryContext.SubmitChanges();
}
public tblTaiLieu GetTailieuByID(int id)
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblTaiLieus.Where("TailieuID=@0", id);
if(query.ToList().Count > 0)
return query.ToList().First();
return new tblTaiLieu();
}
public List<Models.tblNhomTaiLieu> GetNhomTaiLieus()
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblNhomTaiLieus;
return query.ToList();
}
public List<Models.tblDinhKem> GetDinhKems()
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblDinhKems;
return query.ToList();
}
public void InsertTailieu(tblTaiLieu tailieu)
{
int tailieuID = GetMaxIDTailieu();
tailieu.TaiLieuID = tailieuID + 1;
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
_libraryContext.tblTaiLieus.InsertOnSubmit(tailieu);
_libraryContext.SubmitChanges();
tblDinhKem dinhkem = new tblDinhKem();
dinhkem.TaiLieuID = tailieuID;
InsertDinhKem(dinhkem);
}
public void SaveTaiLieu(tblTaiLieu tailieu)
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblTaiLieus.Where("TailieuID=@0", tailieu.TaiLieuID);
tblTaiLieu tmp = (tblTaiLieu)query.ToList().First();
tmp.MaTaiLieu = tailieu.MaTaiLieu;
tmp.NgonNgu = tailieu.NgonNgu;
tmp.NhomTaiLieuID = tailieu.NhomTaiLieuID;
tmp.SoLanXem = tailieu.SoLanXem;
tmp.TacGia = tailieu.TacGia;
tmp.TaiLieuID = tailieu.TaiLieuID;
tmp.TenTaiLieu = tailieu.TenTaiLieu;
tmp.TomTatNoiDung = tailieu.TomTatNoiDung;
tmp.TrangThaiTaiLieu = tailieu.TrangThaiTaiLieu;
tmp.TuKhoa = tailieu.TuKhoa;
tmp.VongDoi_EndDate = tailieu.VongDoi_EndDate;
tmp.VongDoi_StartDate = tailieu.VongDoi_StartDate;
_libraryContext.SubmitChanges();
}
public int GetMaxIDTailieu()
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblTaiLieus.Max(ib=>ib.TaiLieuID);
return query;
}
public int GetMaxIDDinhKem()
{
ABDH_DemoDataContext _libraryContext = new ABDH_DemoDataContext();
var query = _libraryContext.tblDinhKems.Max(dk => dk.DinhKemID);
return query;
}