public static void UpdateMinus(int id, int soLuong) { using (var db = new ASP_OnlineShopConnectionDB()) { if (soLuong == 1) { db.Execute("update GioHang set [SoLuong] = @0 where Id=@1", 1, id); } else { db.Execute("update GioHang set [SoLuong] = @0 where Id=@1", soLuong - 1, id); } } }
public static void Delete(int id) { using (var db = new ASP_OnlineShopConnectionDB()) { db.Execute("delete GioHang where Id=@0", id); } }
public static void BuyNow(string mataikhoan) { using (var db = new ASP_OnlineShopConnectionDB()) { db.Execute("EXEC usp_InsertChiTietDonHang @@mataikhoan = @0", mataikhoan); //db.Fetch<dynamic>("EXEC usp_InsertChiTietDonHang @0", mataikhoan); } }
public static void Them(string NoiDungBinhLuan, int?MaSanPham, string MaTaiKhoan, string TenTaiKhoan) { using (var db = new ASP_OnlineShopConnectionDB()) { //BinhLuan bl = new BinhLuan(); //bl.MaSanPham = MaSanPham; //bl.MaTaiKhoan = MaTaiKhoan; //bl.NoiDungBinhLuan = NoiDung; //bl.MaThanhVien = 2; db.Execute("INSERT INTO [dbo].[BinhLuan] ([NoiDungBinhLuan], [MaSanPham],[MaTaiKhoan],[TenTaiKhoan]) VALUES(@0,@1,@2,@3)", NoiDungBinhLuan, MaSanPham, MaTaiKhoan, TenTaiKhoan); } }