//public static void CapNhat(string id, sanpham sp)
//{
// var db = new DienThoaiShopConnectionDB();
// //db.Update<sanpham>("Set MaSanPham= @0, TenSanPham=@1, hinhanh=@2, Gia=@3, MaLoai=@4, NhaSX=@5, SoLuongTon=@6, MoTa=@7 where BiXoa=0", sp.MaSanPham, sp.TenSanPham, sp.hinhanh, sp.Gia, sp.MaLoai, sp.NhaSX, sp.MoTa, id);
// sp = ChiTietSanPham(sp);
// db.Update("sanpham", "MaSanPham", sp);
//}
public static void CapNhat(string id, sanpham sp)
{
var db = new DienThoaiShopConnectionDB();
db.Update <sanpham>("Set MaSanPham= @0, TenSanPham=@1, hinhanh=@2, Gia=@3, MaLoai=@4, NhaSX=@5, SoLuongTon=@6, MoTa=@7, BiXoa=@7", sp.MaSanPham, sp.TenSanPham, sp.hinhanh, sp.Gia, sp.MaLoai, sp.NhaSX, sp.MoTa, sp.BiXoa, id);
db.Update(id, sp);
}
public static sanpham ChiTiet(int id)
{
var db = new DienThoaiShopConnectionDB();
return(db.SingleOrDefault <sanpham>("select * from sanpham where MaSanPham=@0", id));
}
public static IEnumerable <sanpham> DanhSach()
{
var db = new DienThoaiShopConnectionDB();
return(db.Query <sanpham>("select * from sanpham"));
}
public static void Them(sanpham sp)
{
var db = new DienThoaiShopConnectionDB();
db.Insert(sp);
}