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