public static IEnumerable <NHASANXUAT> DanhSachAdmin()
{
var db = new MiniShopConnectionDB();
return(db.Query <NHASANXUAT>("select * from NHASANXUAT "));
}
public static IEnumerable <NHASANXUAT> DanhSach()
{
var db = new MiniShopConnectionDB();
return(db.Query <NHASANXUAT>("select * from NHASANXUAT where TinhTrang = 0"));
}
public static IEnumerable <SANPHAM> ChiTiet(String id)
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select * from SANPHAM where MaNhaSanXuat = '" + id + "'"));
}
//------------------------------------------------------------------
public static IEnumerable <SANPHAM> DanhSachSP()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select * from SANPHAM"));
}
public static IEnumerable <SANPHAM> Top4Hot()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select Top 4 * from SANPHAM where LuotView > 0"));
}
public static IEnumerable <SANPHAM> Top4()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select Top 4 * from SANPHAM where GhiChu = N'New'"));
}
//--------------------------------------------------
public static IEnumerable <LOAISANPHAM> LoaiSanPhamAdmin()
{
var db = new MiniShopConnectionDB();
return(db.Query <LOAISANPHAM>("select * from LOAISANPHAM"));
}
public static IEnumerable <LOAISANPHAM> DanhSach()
{
var db = new MiniShopConnectionDB();
return(db.Query <LOAISANPHAM>("select * from LOAISANPHAM where TinhTrang = 0"));
}