public static bool VerifyMemberPackageAllowCertainClass(int nPackageID, string strClassCode)
{
TblClassInstance clsInstance = new TblClassInstance();
string cmdText = " Select Count (*) from tblPackageClass A " +
" inner join tblMemberPackage B on A.strPackageCode = B.strPackageCode " +
" Where B.nPackageID = @nPackageID and A.strClassCode = @strClassCode";
object obj = clsInstance.ExecuteScalar(cmdText, new string[] {"@nPackageID", "@strClassCode"}, new object[] {nPackageID, strClassCode});
if (obj != null)
{
Int32 r = (Int32) obj;
if (r > 0)
return true;
else
return false;
}
else
return true;
}
