//Tìm kiếm
public static List <MuonSachView> TimKiemTheoMaPhieu(string p)
{
List <MuonSachView> phieus = new List <MuonSachView>();
using (IDocumentSession session = store.OpenSession()) // Open a session for a default 'Database'
{
List <PhieuMuonSachSV> phieu = session
.Query <PhieuMuonSachSV>() // Query for Products
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.Where(x => x.MaPhieu == p) // Filter
.ToList(); // Materialize query
foreach (PhieuMuonSachSV x in phieu)
{
DocGiaSV dg = session.Load <DocGiaSV>(x.DocGia);
ChiNhanh cn = session.Load <ChiNhanh>(x.ChiNhanh);
Sach s = session.Load <Sach>(x.Sach);
MuonSachView detail = new MuonSachView
{
MaPhieu = x.MaPhieu,
TenDG = dg.TenDG,
TenSach = s.TenSach,
TenChiNhanh = cn.TenChiNhanh,
SoLuongMuon = x.SoLuongMuon,
NgayMuon = x.NgayMuon
};
phieus.Add(detail);
}
}
return(phieus);
}
//Load phiếu
public static List <MuonSachView> List(string id)
{
List <MuonSachView> res = new List <MuonSachView>();
using (IDocumentSession session = store.OpenSession())
{
List <PhieuMuonSachSV> sv;
if (id != null)
{
sv = session
.Query <PhieuMuonSachSV>()
.Where(x => x.Id == id)
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.ToList <PhieuMuonSachSV>();
}
else
{
sv = session
.Query <PhieuMuonSachSV>()
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.ToList <PhieuMuonSachSV>();
}
foreach (PhieuMuonSachSV pms in sv)
{
DocGiaSV dg = session.Load <DocGiaSV>(pms.DocGia);
ChiNhanh cn = session.Load <ChiNhanh>(pms.ChiNhanh);
Sach s = session.Load <Sach>(pms.Sach);
MuonSachView detail = new MuonSachView
{
Id = pms.Id,
MaPhieu = pms.MaPhieu,
TenDG = dg.TenDG,
TenSach = s.TenSach,
TenChiNhanh = cn.TenChiNhanh,
SoLuongMuon = pms.SoLuongMuon,
NgayMuon = pms.NgayMuon
};
res.Add(detail);
}
}
return(res);
}
