public static void UpdateProductType(LoaiSanPham lsp)
{
using (var db = new ShopConnectionDB())
{
db.Update <LoaiSanPham>("SET TenLoaiSanPham=@0 WHERE MaLoaiSanPham=@1", lsp.TenLoaiSanPham, lsp.MaLoaiSanPham);
}
}
public static void UpdateManufacturer(HangSanXuat hsx)
{
using (var db = new ShopConnectionDB())
{
db.Update <HangSanXuat>("SET TenHangSanXuat=@0 WHERE MaHangSanXuat=@1", hsx.TenHangSanXuat, hsx.MaHangSanXuat);
}
}
public static void DeleteManufacturer(int id)
{
try
{
using (var db = new ShopConnectionDB())
{
db.Execute("delete from HangSanXuat where MaHangSanXuat = @0", id);
}
}
catch
{
}
}
public static void DeleteProductType(int id)
{
try
{
using (var db = new ShopConnectionDB())
{
db.Execute("delete from loaisanpham where MaLoaiSanPham = @0", id);
}
}
catch
{
}
}
public static void UpdateProduct(SanPham sp, int valueImg)
{
if (valueImg == 0)
{
using (var db = new ShopConnectionDB())
{
db.Update <SanPham>("SET TenSanPham=@0, Gia=@1 , GiamGia=@2 , MoTa=@3 , LoaiSp=@4 , HangSx=@5 WHERE MaSanPham=@6", sp.TenSanPham, sp.Gia, sp.GiamGia, sp.MoTa, sp.LoaiSp, sp.HangSx, sp.MaSanPham);
}
}
else
{
using (var db = new ShopConnectionDB())
{
db.Update <SanPham>("SET TenSanPham=@0, Gia=@1 , GiamGia=@2 , TenHinh=@3 , MoTa=@4 , LoaiSp=@5 , HangSx=@6 WHERE MaSanPham=@7", sp.TenSanPham, sp.Gia, sp.GiamGia, sp.TenHinh, sp.MoTa, sp.LoaiSp, sp.HangSx, sp.MaSanPham);
}
}
}
public static IEnumerable <HangSanXuat> ListManufacturer()
{
var db = new ShopConnectionDB();
return(db.Query <HangSanXuat>("select * from HangSanXuat"));
}
public static HangSanXuat GetManufacturer(int id)
{
var db = new ShopConnectionDB();
return(db.SingleOrDefault <HangSanXuat>("select * from HangSanXuat where MaHangSanXuat=@0", id));
}
public static IEnumerable <SanPham> DanhSach()
{
var db = new ShopConnectionDB();
return(db.Query <SanPham>("select * from SanPham where TinhTrang = 0"));
}
public static IEnumerable <SanPham> TopHot()
{
var db = new ShopConnectionDB();
return(db.Query <SanPham>("select Top 4 * from SanPham where LuotView > 0 "));
}
public static IEnumerable <SanPham> Top4New()
{
var db = new ShopConnectionDB();
return(db.Query <SanPham>("select Top 4 * from SanPham where GhiChu = 'new'"));
}
public static SanPham ChiTiet(string a)
{
var db = new ShopConnectionDB();
return(db.SingleOrDefault <SanPham>("select * from SanPham where MaSanPham = @0", a));
}
public static LoaiSanPham GetProductType(int id)
{
var db = new ShopConnectionDB();
return(db.SingleOrDefault <LoaiSanPham>("select * from LoaiSanPham where MaLoaiSanPham=@0", id));
}
public static IEnumerable <LoaiSanPham> ListProductType()
{
var db = new ShopConnectionDB();
return(db.Query <LoaiSanPham>("select * from LoaiSanPham"));
}
public static IEnumerable <View_lsp_hsx> ListProduct()
{
var db = new ShopConnectionDB();
return(db.Query <View_lsp_hsx>("select * from View_lsp_hsx"));
}
public static IEnumerable <SanPham> ChiTiet(String id)
{
var db = new ShopConnectionDB();
return(db.Query <SanPham>("select * from SanPham where MaLoaiSanPham = '" + id + "'"));
}
