public static List <TimSachDTO> GetDSSachTheoTheLoai(string strTheLoai)
{
List <TimSachDTO> DsSachTTL = new List <TimSachDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
// var timKiem = dbMain.Saches.Where(p => p.TheLoai == (strTheLoai)).ToList(); ;
var lst = from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk;
//from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk;
foreach (var row in lst)
{
TimSachDTO sach = new TimSachDTO();
sach.MaSach = row.MaSach;
sach.TenSach = row.TenSach;
sach.TheLoai = row.TheLoai;
sach.TacGia = row.TacGia;
sach.DonGia = row.DonGia.ToString("###,###,###' 'VNĐ");
sach.Luongton = row.TonCuoi.ToString();
DsSachTTL.Add(sach);
}
}
return(DsSachTTL);
}
public static List <TimSachDTO> GetSachLikeTenSach(string strTenSach)
{
List <TimSachDTO> DsSachTTS = new List <TimSachDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var tk = from p in dbMain.Saches where p.TenSach.Contains(strTenSach) select p;
foreach (var row in tk)
{
TimSachDTO sach = new TimSachDTO();
sach.MaSach = row.MaSach;
sach.TenSach = row.TenSach;
sach.TheLoai = row.TheLoai;
sach.TacGia = row.TacGia;
sach.DonGia = row.DonGia.ToString("###,###,###' 'VNĐ");
sach.Luongton = row.TonCuoi.ToString();
DsSachTTS.Add(sach);
}
}
return(DsSachTTS);
}
public static List <TimSachDTO> GetDSSach()
{
List <TimSachDTO> DsSach = new List <TimSachDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.Saches select p;
foreach (var row in query)
{
TimSachDTO sach = new TimSachDTO();
sach.MaSach = row.MaSach;
sach.TenSach = row.TenSach;
sach.TheLoai = row.TheLoai;
sach.TacGia = row.TacGia;
sach.DonGia = row.DonGia.ToString("###,###,###' 'VNĐ");
sach.Luongton = row.TonCuoi.ToString();
DsSach.Add(sach);
}
}
return(DsSach);
}
