public static void CapNhat(string masanpham, string mataikhoan, int gia, int soluong, string tensanpham) { using (var sql = new MobileShopConnectionDB()) { GioHang giohang = new GioHang() { MaSP = masanpham, MaTaiKhoan = mataikhoan, Gia = gia, SoLuong = soluong, TenSP = tensanpham, TongTien = gia * soluong }; var tamp = sql.Query <GioHang>("select id from GioHang Where MaTaiKhoan = '" + mataikhoan + "'and MaSP ='" + masanpham + "'").FirstOrDefault(); sql.Update(giohang, tamp.Id); } }
public static void XoaTamSanPham(string id) { var db = new MobileShopConnectionDB(); db.Update <SanPham>("SET TinhTrang=1 where MaSP=@0", id); }
public static void SuaSanPham(string id, MobileShopConnection.SanPham sp) { var db = new MobileShopConnectionDB(); db.Update <SanPham>("SET TenSP=@0, MoTa=@1, MaNhaSX=@2, Gia=@3, HeDieuHanh=@4, HinhChinh=@5, ManHinh=@6, RAM=@7, CameraSau=@8, CameraTruoc=@9, MaLoaiSP=@10, BoNhoTrong=@11, TinhTrang=@12 where MaSanPham=@13", sp.TenSP, sp.MoTa, sp.MaNhaSX, sp.Gia, sp.HeDieuHanh, sp.HinhChinh, sp.ManHinh, sp.RAM, sp.CameraSau, sp.CameraTruoc, sp.MaLoaiSP, sp.BoNhoTrong, sp.TinhTrang, id); }
public static void UpdateNSX(String id, NhaSanXuat NSX) { var sql = new MobileShopConnectionDB(); sql.Update(NSX, id); }
public static void Sua(MobileShopConnection.LoaiSP LoaiSP) { var db = new MobileShopConnectionDB(); db.Update(LoaiSP); }
public static void UpdateLSP(String id, LoaiSP LSP) { var sql = new MobileShopConnectionDB(); sql.Update(LSP, id); }
public static void Sua(MobileShopConnection.HangSP HangSp) { var db = new MobileShopConnectionDB(); db.Update(HangSp); }
public static void Sua(MobileShopConnection.SanPham sp) { var db = new MobileShopConnectionDB(); db.Update(sp); }