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 + "'")); }