public static IEnumerable <BinhLuan> DanhSach(int id) { var db = new ShopDienThoaiConnectionDB(); return(db.Query <BinhLuan>("Select * from BinhLuan where TinhTrang != 1 AND MaSP=@0 order by ThoiGian desc", id)); }
public static void Them(SanPham sp) { var db = new ShopDienThoaiConnectionDB(); db.Insert(sp); }
public static IEnumerable <SanPham> SanPhamHot() { var db = new ShopDienThoaiConnectionDB(); return(db.Query <SanPham>("select TOP 3 * from SanPham where BiXoa=0 and GhiChu=N'New'")); }
public static SanPham ChiTiet(int id) { var db = new ShopDienThoaiConnectionDB(); return(db.SingleOrDefault <SanPham>("select * from SanPham where BiXoa=0 and MaSP=@0", id)); }
public static Page <SanPham> DanhSach(int pageNumber, int itemPerPage) { var db = new ShopDienThoaiConnectionDB(); return(db.Page <SanPham>(pageNumber, itemPerPage, "select * from SanPham where BiXoa=0")); }
public static IEnumerable <SanPham> DanhSach() { var db = new ShopDienThoaiConnectionDB(); return(db.Query <SanPham>("select * from SanPham where BiXoa=0")); }
public static void Sua(int id, LoaiSP lsp) { var db = new ShopDienThoaiConnectionDB(); db.Update <LoaiSP>("Set TenLoai = @0, BiXoa=0 where MaLoai=@1", lsp.TenLoai, id); }
public static void Sua(int id, HangSP hsp) { var db = new ShopDienThoaiConnectionDB(); db.Update <HangSP>("Set TenHang = @0, BiXoa=0 where MaLoai=@1", hsp.TenHang, id); }
public static void Xoa(int id) { var db = new ShopDienThoaiConnectionDB(); db.Update <HangSP>("Set BiXoa=1 where MaHang=@0", id); }
public static HangSP ChiTiet(int id) { var db = new ShopDienThoaiConnectionDB(); return(db.SingleOrDefault <HangSP>("select * from HangSP where BiXoa=0 and MaHang=@0", id)); }
public static void Them(HangSP hsp) { var db = new ShopDienThoaiConnectionDB(); db.Insert(hsp); }
public static Page <SanPham> DanhSachChiTetPage(int id, int pageNumber, int itemPerPage) { var db = new ShopDienThoaiConnectionDB(); return(db.Page <SanPham>(pageNumber, itemPerPage, "select * from SanPham where BiXoa=0 and MaHang='" + id + "'")); }
public static IEnumerable <HangSP> DanhSach() { var db = new ShopDienThoaiConnectionDB(); return(db.Query <HangSP>("select * from HangSP where BiXoa=0")); }
public static IEnumerable <TinhTrangSP> DanhSach() { var db = new ShopDienThoaiConnectionDB(); return(db.Query <TinhTrangSP>("select * from TinhTrangSP where MaTinhTrang=1")); }
public static void Sua(int id, SanPham sp) { var db = new ShopDienThoaiConnectionDB(); db.Update <SanPham>("Set TenSP=@0, MaHang=@1, MaLoai=@2, HinhAnh=@3, TinhTrang=@4, GiaBan=@5, SoLuong=@6, ThongTin=@7, GhiChu=@8 where MaSP=@9", sp.TenSP, sp.MaHang, sp.MaLoai, sp.HinhAnh, sp.TinhTrang, sp.GiaBan, sp.SoLuong, sp.ThongTin, sp.GhiChu, id); }
public static void ThemBinhLuan(BinhLuan bl) { var db = new ShopDienThoaiConnectionDB(); db.Insert(bl); }
public static void Xoa(int id) { var db = new ShopDienThoaiConnectionDB(); db.Update <SanPham>("Set BiXoa=1 where MaSP=@0", id); }
public static void Them(LoaiSP lsp) { var db = new ShopDienThoaiConnectionDB(); db.Insert(lsp); }