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);
}
