//----------------------------------------------------------
public static void ThemNSX(NHASANXUAT nsx)
{
var db = new MiniShopConnectionDB();
db.Insert(nsx);
}
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 void InsertSP(SANPHAM sp)
{
var db = new MiniShopConnectionDB();
db.Insert(sp);
}
public static void UpdateSP(String id, SANPHAM sp)
{
var db = new MiniShopConnectionDB();
db.Update(sp, id);
}
public static IEnumerable <SANPHAM> Top4Hot()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select Top 4 * from SANPHAM where LuotView > 0"));
}
//--------------------------------------------------
public static IEnumerable <LOAISANPHAM> LoaiSanPhamAdmin()
{
var db = new MiniShopConnectionDB();
return(db.Query <LOAISANPHAM>("select * from LOAISANPHAM"));
}
public static SANPHAM ChiTiet(String a)
{
var db = new MiniShopConnectionDB();
return(db.SingleOrDefault <SANPHAM>("select * from SANPHAM where MaSanPham = @0", a));
}
public static IEnumerable <SANPHAM> Top4()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select Top 4 * from SANPHAM where GhiChu = N'New'"));
}
public static void EditLoaiSanPham(String id, LOAISANPHAM lsp)
{
var db = new MiniShopConnectionDB();
db.Update(lsp, id);
}
public static LOAISANPHAM ChiTietLoaiSanPhamAdmin(String id)
{
var db = new MiniShopConnectionDB();
return(db.SingleOrDefault <LOAISANPHAM>("select * from LOAISANPHAM where MaLoaiSanPham = '" + id + "'"));
}
public static void InsertLSP(LOAISANPHAM lsp)
{
var db = new MiniShopConnectionDB();
db.Insert(lsp);
}
public static NHASANXUAT ChiTietAdmin(String id)
{
var db = new MiniShopConnectionDB();
return(db.SingleOrDefault <NHASANXUAT>("select * from NHASANXUAT where MaNhaSanXuat = '" + id + "'"));
}
//------------------------------------------------------------------
public static IEnumerable <SANPHAM> DanhSachSP()
{
var db = new MiniShopConnectionDB();
return(db.Query <SANPHAM>("select * from SANPHAM"));
}
public static void UpdateNSX(String id, NHASANXUAT nsx)
{
var db = new MiniShopConnectionDB();
db.Update(nsx, id);
}
public static IEnumerable <LOAISANPHAM> DanhSach()
{
var db = new MiniShopConnectionDB();
return(db.Query <LOAISANPHAM>("select * from LOAISANPHAM where TinhTrang = 0"));
}
