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