public List <LoaiSach> LayDanhSach()
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
return(db.LoaiSaches.Select(ls => ls).Where(ls => ls.Disable == false).ToList());
}
}
public PhieuMuonSach LayPhieuMuonSach(int id)
{
QLThuVienDataContext db = new QLThuVienDataContext();
PhieuMuonSach phieu = db.PhieuMuonSaches.Single(p => p.id == id && p.Disable == false);
return(phieu);
}
public Sach LaySachTheoId(int idSach)
{
QLThuVienDataContext db = new QLThuVienDataContext();
Sach sach = db.Saches.Single(s => s.id == idSach && s.Disable == false);
return(sach);
}
public Sach LaySach(string pid)
{
QLThuVienDataContext db = new QLThuVienDataContext();
Sach sach = db.Saches.Single(s => s.pid == pid && s.Disable == false);
return(sach);
}
public void ThemDocGia(DocGia docGia)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
db.DocGias.InsertOnSubmit(docGia);
db.SubmitChanges();
}
}
public List <PhieuMuonSach> TimKiemTheoMaPhieu(string keyword)
{
keyword = keyword.ToLower();
QLThuVienDataContext db = new QLThuVienDataContext();
return(db.PhieuMuonSaches.Where(p => p.Disable == false && p.pid.Contains(keyword)).Select(p => p).ToList());
}
public List <PhieuMuonSach> LayDanhSach()
{
List <PhieuMuonSach> dsPhieu = null;
QLThuVienDataContext db = new QLThuVienDataContext();
dsPhieu = db.PhieuMuonSaches.Select(p => p).Where(p => p.Disable == false).ToList();
return(dsPhieu);
}
public List <Sach> LayDanhSach()
{
List <Sach> sachs = null;
QLThuVienDataContext db = new QLThuVienDataContext();
sachs = db.Saches.Select(s => s).Where(s => s.Disable == false).ToList();
return(sachs);
}
public void ThemSach(Sach sach)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
db.Saches.InsertOnSubmit(sach);
db.SubmitChanges();
}
}
public void XoaSach(int id)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
Sach sachXoa = db.Saches.Single(s => s.id == id);
sachXoa.Disable = true;
db.SubmitChanges();
}
}
public void XoaDocGia(String maDocGia)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
DocGia docGiaXoa = db.DocGias.Single(s => s.mssv == maDocGia);
docGiaXoa.Disable = true;
db.SubmitChanges();
}
}
public void XoaNganhKhoa(string pid)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
NganhKhoa nkXoa = db.NganhKhoas.Single(nk => nk.pid == pid);
nkXoa.Disable = true;
db.SubmitChanges();
}
}
public void SuaNganhKhoa(NganhKhoa nganhKhoa)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
NganhKhoa nkMoi = db.NganhKhoas.Single(nk => nk.pid == nganhKhoa.pid);
nkMoi.Ten = nganhKhoa.Ten;
db.SubmitChanges();
}
}
public void XoaLoaiSach(string pid)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
LoaiSach lsXoa = db.LoaiSaches.Single(ls => ls.pid == pid);
lsXoa.Disable = true;
db.SubmitChanges();
}
}
public void SuaLoaiSach(LoaiSach loaiSach)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
LoaiSach lsMoi = db.LoaiSaches.Single(ls => ls.pid == loaiSach.pid);
lsMoi.Ten = loaiSach.Ten;
db.SubmitChanges();
}
}
public void XoaNhaXuatBan(string pid)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
NhaXuatBan nxbXoa = db.NhaXuatBans.Single(nxb => nxb.pid == pid);
nxbXoa.Disable = true;
db.SubmitChanges();
}
}
public void SuaNhaXuatBan(NhaXuatBan nhaXuatBan)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
NhaXuatBan nxbSua = db.NhaXuatBans.Single(nxb => nxb.pid == nhaXuatBan.pid);
nxbSua.Ten = nhaXuatBan.Ten;
db.SubmitChanges();
}
}
public List <DocGia> TimKiemTheoTen(String keywordTen)
{
List <DocGia> docgias = null;
QLThuVienDataContext db = new QLThuVienDataContext();
docgias = db.DocGias.Select(dg => dg).Where(dg => dg.Disable == false && dg.HoTen.ToLower().Contains(keywordTen)).ToList();
return(docgias);
}
public DocGia LayDocGia(string maDocGia)
{
DocGia docGia = null;
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
docGia = db.DocGias.Single(dg => dg.mssv == maDocGia && dg.Disable == false);
}
return(docGia);
}
public List <DocGia> LayDanhSach()
{
List <DocGia> listDocGia = null;
QLThuVienDataContext db = new QLThuVienDataContext();
listDocGia = db.DocGias.Select(dg => dg).Where(dg => dg.Disable == false).ToList();
return(listDocGia);
}
public List <LoaiSach> TimKiemTheoTen(string keywordTen)
{
List <LoaiSach> loaiSachs = null;
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
loaiSachs = db.LoaiSaches.Select(ls => ls).Where(ls => ls.Disable == false && ls.Ten.Contains(keywordTen)).ToList();
}
return(loaiSachs);
}
public List <NhaXuatBan> TimKiemTheoTen(string keywordTen)
{
List <NhaXuatBan> nxbs = null;
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
nxbs = db.NhaXuatBans.Select(nxb => nxb).Where(nxb => nxb.Disable == false && nxb.Ten.Contains(keywordTen)).ToList();
}
return(nxbs);
}
public List <NhaXuatBan> LayDanhSach()
{
List <NhaXuatBan> nxbs = null;
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
nxbs = db.NhaXuatBans.Select(nxb => nxb).Where(nxb => nxb.Disable == false).ToList();
}
return(nxbs);
}
public List <SoLuongSachMuon> LayDanhSachSachMuon(DateTime begin, DateTime end)
{
List <SoLuongSachMuon> dsSLSachMuon = null;
QLThuVienDataContext db = new QLThuVienDataContext();
dsSLSachMuon = db.ChiTietPhieuMuons
.Where(ct => ct.PhieuMuonSach.Disable == false && ct.PhieuMuonSach.NgayMuon >= begin && ct.PhieuMuonSach.NgayMuon <= end)
.GroupBy(ct => ct.Sach).Select(group => new SoLuongSachMuon(group.Key.pid, group.Key.Ten, group.Sum(ct => ct.SoLuong))).ToList();
return(dsSLSachMuon);
}
public List <NganhKhoa> TimKiemTheoTen(string keywordTen)
{
List <NganhKhoa> nks = null;
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
nks = db.NganhKhoas.Select(nk => nk).Where(nk => nk.Disable == false && nk.Ten.Contains(keywordTen)).ToList();
}
return(nks);
}
public List <Sach> TimKiemTheoMa(string keywordMa)
{
List <Sach> sachs = null;
QLThuVienDataContext db = new QLThuVienDataContext();
sachs = db.Saches.Select(s => s).Where(s => s.Disable == false && s.pid.ToLower().Contains(keywordMa)).ToList();
return(sachs);
}
public List <NganhKhoa> LayDanhSach()
{
List <NganhKhoa> nganhKhoas = new List <NganhKhoa>();
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
nganhKhoas = db.NganhKhoas.Select(nk => nk).Where(nk => nk.Disable == false).ToList();
}
return(nganhKhoas);
}
public void ThemNhaXuatBan(string tenNXB)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
NhaXuatBan nxbMoi = new NhaXuatBan
{
Ten = tenNXB
};
db.NhaXuatBans.InsertOnSubmit(nxbMoi);
db.SubmitChanges();
}
}
public void SuaPhieuMuon(PhieuMuonSach phieuMuonSach, List <ChiTietPhieuMuon> dsChiTietPhieuMuonFinal)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
PhieuMuonSach pmsSua = db.PhieuMuonSaches.Single(pms => pms.id == phieuMuonSach.id);
pmsSua.NgayMuon = phieuMuonSach.NgayMuon;
pmsSua.HanTra = phieuMuonSach.HanTra;
pmsSua.NguoiLapPhieu = phieuMuonSach.NguoiLapPhieu;
pmsSua.NguoiMuon = phieuMuonSach.NguoiMuon;
foreach (var ctpmUpdate in dsChiTietPhieuMuonFinal)
{
bool timDuoc = false;
foreach (var ctpmCurrent in pmsSua.ChiTietPhieuMuons)
{
if (ctpmUpdate.MaSach == ctpmCurrent.MaSach && ctpmUpdate.MaPhieuMuon == ctpmCurrent.MaPhieuMuon)
{
ctpmCurrent.Sach.SoLuongHienCo += (ctpmCurrent.SoLuong - ctpmUpdate.SoLuong);
ctpmCurrent.Sach.SoLuongDaMuon -= (ctpmCurrent.SoLuong - ctpmUpdate.SoLuong);
ctpmCurrent.SoLuong = ctpmUpdate.SoLuong;
timDuoc = true;
break;
}
}
if (!timDuoc)
{
db.ChiTietPhieuMuons.InsertOnSubmit(ctpmUpdate);
}
}
foreach (var ctpmCurrent in pmsSua.ChiTietPhieuMuons)
{
bool timDuoc = false;
foreach (var ctpmUpdate in dsChiTietPhieuMuonFinal)
{
if (ctpmUpdate.MaSach == ctpmCurrent.MaSach && ctpmUpdate.MaPhieuMuon == ctpmCurrent.MaPhieuMuon)
{
timDuoc = true;
break;
}
}
if (!timDuoc)
{
ctpmCurrent.Sach.SoLuongHienCo += ctpmCurrent.SoLuong;
ctpmCurrent.Sach.SoLuongDaMuon -= ctpmCurrent.SoLuong;
db.ChiTietPhieuMuons.DeleteOnSubmit(ctpmCurrent);
}
}
db.SubmitChanges();
}
}
public void ThemNganhKhoa(string ten)
{
using (QLThuVienDataContext db = new QLThuVienDataContext())
{
LoaiSach loaiSachMoi = new LoaiSach
{
Ten = ten
};
db.LoaiSaches.InsertOnSubmit(loaiSachMoi);
db.SubmitChanges();
}
}
