private int getProfileID(string subString)
{
int retValue = -1;
try
{
string stmt = "select profile_id from PROFILE_REP where upper(PROFILE_NAME) like '%" + subString.ToUpper() + "'";
SQLTransaction transaction = new SQLTransaction(this.session, APP_CODE, stmt);
foreach (SQLRow row in transaction.GetResultRows())
{
retValue = Convert.ToInt32(row.GetColumn(0));
break;
}
return(retValue);
}
catch (Exception ex)
{
HConsole.WriteError(ex);
return(retValue);
}
}
