public static string GetTenNhaSanXuat(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaNhaSanXuat from SanPham where MaSanPham = @0", id).MaNhaSanXuat;
return(db.SingleOrDefault <NhaSanXuat>("select TenNhaSanXuat from NhaSanXuat where MaNhaSanXuat = @0", Ma).TenNhaSanXuat);
}
public static string GetTenLoaiSanPham(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaLoaiSanPham from SanPham where MaSanPham = @0", id).MaLoaiSanPham;
return(db.SingleOrDefault <LoaiSanPham>("select TenLoaiSanPham from LoaiSanPham where MaLoaiSanPham = @0", Ma).TenLoaiSanPham);
}
public static string GetTenNhaCungCap(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaNhacungCap from SanPham where MaSanPham = @0", id).MaNhaCungCap;
return(db.SingleOrDefault <NhaCungCap>("select TenNhaCungCap from NhaCungCap where MaNhaCungCap = @0", Ma).TenNhaCungCap);
}
public static SanPham ProductDetail(int id)
{
var db = new ASP_OnlineShopConnectionDB();
return(db.SingleOrDefault <SanPham>("select * from SanPham where MaSanPham = @0", id));
}
