/// <summary>
/// Method executed after the code related to the attribute. The action is to check if the value is null
/// </summary>
public void Postprocess(MarshalByRefObject inst, IMessage msg, ref IMessage msgReturn)
{
// Extract Action
ONAction lAction = inst as ONAction;
// Shared Event Control
if ((lAction != null) && (lAction.OnContext.InSharedContext == true)) // No-Principal Shared Event
{
return;
}
ReturnMessage lReturnMessage = msgReturn as ReturnMessage;
IONType lArgument = lReturnMessage.Args[IndexArgument] as IONType;
if (lArgument == null || lArgument.Value == null)
{
if (AllowsNull == false)
{
throw new ONNotNullArgumentException(null, IdService, IdClass, IdArgument, ServiceName, ClassName, Name);
}
}
else if ((Length > 0) && (lArgument.Value.ToString().Length > Length))
{
throw new ONMaxLenghtArgumentException(null, IdArgument, Name, Length.ToString());
}
}
/// <summary>
/// Generates a Not Equal operator with the right operand for querying the database.
/// </summary>
/// <param name="parameterName">Name of the parameter</param>
/// <param name="parameterValue">Value of the parameter</param>
/// <returns></returns>
public string AddNEQComparison(string parameterName, IONType parameterValue)
{
// If the value is null it returns the 'IS NOT NULL' operand.
if (parameterValue.Value == null)
{
return(" IS NOT NULL");
}
// It returns " <> ?" adding the parameter to the sentence
return(" <> " + AddWhereParameter(parameterName, parameterValue));
}
/// <summary>
/// Generates a Not Equal operator for querying the database.
/// </summary>
/// <param name="leftParameterName">Name of the left parameter</param>
/// <param name="leftparameterValue">Value of the left parameter</param>
/// <param name="rightParameterName">Name of the right parameter</param>
/// <param name="rightParameterValue">Name of the right parameter</param>
/// <returns></returns>
public string AddNEQComparison(string leftParameterName, IONType leftParameterValue, string rightParameterName, IONType rightParameterValue)
{
// If the value of the right parameter is null it returns the 'IS NOT NULL' operand.
if (rightParameterValue.Value == null)
{
return(AddWhereParameter(leftParameterName, leftParameterValue) + " IS NOT NULL");
}
else if (leftParameterValue.Value == null) //If the value of the left parameter is null it returns 'Right_Operand IS NOT NULL' operand but
{
return(AddWhereParameter(rightParameterName, rightParameterValue) + " IS NOT NULL");
}
// It returns "? <> ?" adding the parameters to the sentence
return(AddWhereParameter(leftParameterName, leftParameterValue) + " <> " + AddWhereParameter(rightParameterName, rightParameterValue));
}
public string AddWhereParameter(IONType parameterValue)
{
if (mInDisjunction)
{
mWhereDisjParametersName.Add("");
mWhereDisjParametersItem.Add(parameterValue);
}
else
{
mWhereParametersName.Add("");
mWhereParametersItem.Add(parameterValue);
}
if (parameterValue is ONString)
{
return("RTRIM(?)");
}
return("?");
}
public override IONType GetParameter(string name)
{
IONType lParameter = null;
lParameter = GetSelectParameter(name);
if (lParameter != null)
{
return(lParameter);
}
lParameter = GetWhereParameter(name);
if (lParameter != null)
{
return(lParameter);
}
lParameter = GetWhereDisjParameter(name);
if (lParameter != null)
{
return(lParameter);
}
return(null);
}
/// <summary>
/// Add OrderBy value parameter
/// </summary>
/// <param name="parameter">Value</param>
protected void AddOrderByParameter(IONType parameter)
{
OrderByParameters.Add(parameter);
}
public string AddWhereParameter(IONType parameterValue)
{
if (mInDisjunction)
{
mWhereDisjParametersName.Add("");
mWhereDisjParametersItem.Add(parameterValue);
}
else
{
mWhereParametersName.Add("");
mWhereParametersItem.Add(parameterValue);
}
if (parameterValue is ONString)
return "RTRIM(?)";
return "?";
}
/// <summary>
/// Add the parameter to the list of parameters of the SQL sentence
/// </summary>
/// <param name="name">Name of the parameter</param>
/// <param name="parameter">Data type of the parameter</param>
public void AddSelectParameter(string name, IONType parameter)
{
mSelectParametersName.Add(name);
mSelectParametersItem.Add(parameter);
}
public string AddNEQComparison(IONType parameterValue)
{
return AddNEQComparison("", parameterValue);
}
/// <summary>
/// Generates a Not Equal operator with the right operand for querying the database.
/// </summary>
/// <param name="parameterName">Name of the parameter</param>
/// <param name="parameterValue">Value of the parameter</param>
/// <returns></returns>
public string AddNEQComparison(string parameterName, IONType parameterValue)
{
// If the value is null it returns the 'IS NOT NULL' operand.
if (parameterValue.Value == null)
return " IS NOT NULL";
// It returns " <> ?" adding the parameter to the sentence
return " <> " + AddWhereParameter(parameterName, parameterValue);
}
public string AddNEQComparison(IONType leftParameterValue, IONType rightParameterValue)
{
return AddNEQComparison("", leftParameterValue, "", rightParameterValue);
}
/// <summary>
/// Add OrderBy value parameter
/// </summary>
/// <param name="parameter">Value</param>
protected void AddOrderByParameter(IONType parameter)
{
OrderByParameters.Add(parameter);
}
/// <summary>
/// Add the parameter to the list of parameters of the SQL sentence
/// </summary>
/// <param name="name">Name of the parameter</param>
/// <param name="parameter">Data type of the parameter</param>
public void AddSelectParameter(string name, IONType parameter)
{
mSelectParametersName.Add(name);
mSelectParametersItem.Add(parameter);
}
public string AddNEQComparison(IONType parameterValue)
{
return(AddNEQComparison("", parameterValue));
}
public string AddNEQComparison(IONType leftParameterValue, IONType rightParameterValue)
{
return(AddNEQComparison("", leftParameterValue, "", rightParameterValue));
}
/// <summary>
/// Add the parameter to the list of parameters of the SQL sentence
/// </summary>
/// <param name="name">Name of the parameter</param>
/// <param name="parameter">Data type of the parameter</param>
public void AddParameter(string name, IONType parameter)
{
ParametersName.Add(name);
ParametersItem.Add(parameter);
}
/// <summary>
/// Generates a Not Equal operator for querying the database.
/// </summary>
/// <param name="leftParameterName">Name of the left parameter</param>
/// <param name="leftparameterValue">Value of the left parameter</param>
/// <param name="rightParameterName">Name of the right parameter</param>
/// <param name="rightParameterValue">Name of the right parameter</param>
/// <returns></returns>
public string AddNEQComparison(string leftParameterName, IONType leftParameterValue, string rightParameterName, IONType rightParameterValue)
{
// If the value of the right parameter is null it returns the 'IS NOT NULL' operand.
if (rightParameterValue.Value == null)
return AddWhereParameter(leftParameterName, leftParameterValue) + " IS NOT NULL";
else if (leftParameterValue.Value == null) //If the value of the left parameter is null it returns 'Right_Operand IS NOT NULL' operand but
return AddWhereParameter(rightParameterName, rightParameterValue) + " IS NOT NULL";
// It returns "? <> ?" adding the parameters to the sentence
return AddWhereParameter(leftParameterName, leftParameterValue) + " <> " + AddWhereParameter(rightParameterName, rightParameterValue);
}
/// <summary>
/// Add the parameter to the list of parameters of the SQL sentence
/// </summary>
/// <param name="name">Name of the parameter</param>
/// <param name="parameter">Data type of the parameter</param>
public void AddParameter(string name, IONType parameter)
{
ParametersName.Add(name);
ParametersItem.Add(parameter);
}