public static bool KiemTraTonTaiMau(string maSanPham, string mauSac)
{
string query = string.Format("SELECT count(MaSP) FROM ChiTietSanPham WHERE MauSac = N'{0}' AND MaSP = '{1}'", mauSac, maSanPham);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}
public static bool KiemTraTonTaiMaCT(string _maCT)
{
string query = string.Format("select count(*) from ChiTietSanPham where MaCTSP = '{0}'", _maCT);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}
public static bool KiemTraTonTaiTenNCC(string tenNhaCungCap)
{
string query = string.Format("select count(TenNhaCungCap) from NhaCungCap where TenNhaCungCap = '{0}'", tenNhaCungCap);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}
public static bool KiemTraTrungSanPham(string tenSanPham)
{
string query = string.Format("SELECT count(TenSP) FROM SanPham WHERE TenSP = N'{0}'", tenSanPham);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}
public static bool KiemTraTonTaiTenDanhMuc(string TenDanhMuc)
{
string query = string.Format("SELECT count(TenDanhMuc) FROM DanhMuc WHERE TenDanhMuc = N'{0}'", TenDanhMuc);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}
public static bool KiemTraTaiKhoanDaTonTai(string tenTaiKhoan)
{
string query = string.Format("select count(*) from TaiKhoan where TenTaiKhoan = '{0}'", tenTaiKhoan);
return(XuLyDuLieu.ThucThiCauLenhWithScalar(query) >= 1);
}