public static void Xoa(int id)
{
var db = new ShopDienThoaiConnectionDB();
db.Update <SanPham>("Set BiXoa=1 where MaSP=@0", id);
}
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 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 void Sua(int id, LoaiSP lsp)
{
var db = new ShopDienThoaiConnectionDB();
db.Update <LoaiSP>("Set TenLoai = @0, BiXoa=0 where MaLoai=@1", lsp.TenLoai, id);
}
