/// <summary>
/// Initializes a new instance of the <see cref="CommandGroup" /> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="commandFilters">Array of command Filters</param>
public CommandMultiFilter(ConcatenationType concatType, params CommandFilter[] commandFilters)
: base(string.Empty, null, ComparisonType.EqualTo, concatType)
{
if (commandFilters == null)
{
throw new ArgumentException("Invalid group elements specified.");
}
_commandFilters = commandFilters;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandFilterNestedQuery"/> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="nestedTableName">Name of the nested Table</param>
/// <param name="nestedJoinningFieldName">Name of the field from the nested table use to join the outer table</param>
/// <param name="outerJoinningFieldName">Name of the field from the outer table use to join the nested table</param>
/// <param name="commandFilters">Array of command Filters</param>
public CommandFilterNestedQuery(ConcatenationType concatType,
string nestedTableName,
string nestedJoinningFieldName,
string outerJoinningFieldName,
CommandFilter[] commandFilters)
: base(concatType, commandFilters)
{
_nestedTableName = nestedTableName;
_nestedJoinningFieldName = nestedJoinningFieldName;
_outerJoinningFieldName = outerJoinningFieldName;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandFilterPISArticlesDescLookup"/> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="parentPISArticleCode">Parent PIS article code</param>
public CommandFilterPISArticlesDescLookup(ConcatenationType concatType, string parentPISArticleCode)
: base(concatType,
"PISArticlesTree",
"RobotArticleCode",
"RobotArticleCode",
new CommandFilter[1] {
new CommandFilter("RobotArticleCode", DBNull.Value, ComparisonType.NotEqualTo)
})
{
_parentPISArticleCode = parentPISArticleCode;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandFilterPISArticlesAscLookup"/> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="childPISArticleID">child PIS Article ID</param>
public CommandFilterPISArticlesAscLookup(ConcatenationType concatType, int childPISArticleID)
: base(concatType,
"PISArticlesTree",
"Code",
"Code",
new CommandFilter[1] {
new CommandFilter("ParentPisArticleID", DBNull.Value, ComparisonType.EqualTo)
})
{
_childPISArticleID = childPISArticleID;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandFilterPISArticlesAscLookup"/> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="robotArticleCode">robot article code</param>
public CommandFilterPISArticlesAscLookup(ConcatenationType concatType, string robotArticleCode)
: base(concatType,
"PISArticlesTree",
"Code",
"Code",
new CommandFilter[1] {
new CommandFilter("ParentPisArticleID", DBNull.Value, ComparisonType.EqualTo)
})
{
_childRobotArticleCode = robotArticleCode;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandFilter" /> class.
/// </summary>
/// <param name="columnName">Name of the database column which is used to filter within a command.</param>
/// <param name="columnValue">Value of the database column which is used to filter within a command.</param>
/// <param name="comparisonType">Type of comparison to process.</param>
/// <param name="concatenationType">Type of the concatenation.</param>
/// <param name="filterIndex">Optional index of the filter to use - if the same filter type is used multiple times.</param>
public CommandFilter(string columnName,
object columnValue,
ComparisonType comparisonType = ComparisonType.EqualTo,
ConcatenationType concatenationType = ConcatenationType.And,
int filterIndex = 0)
{
_columnName = columnName;
_comparisonType = comparisonType;
_filterIndex = filterIndex;
_concatenationType = concatenationType;
_columnValue = (columnValue != null) ? columnValue : DBNull.Value;
}
public string ConcatenateArrayText(IEnumerable<string> array, ConcatenationType concatenationType)
{
var toReturn = "";
if (concatenationType.Equals(ConcatenationType.Asterisks))
{
toReturn = array.Aggregate(toReturn, (current, element) => current + (element + "*"));
toReturn = toReturn.Remove(toReturn.Length - 1);
}
else
{
for (int i = 0; i < array.Count(); i++)
{
var value = Encoding.ASCII.GetBytes(new[] { array.ElementAt((i == 0 ? array.Count() : i) - 1).ElementAt(0) })[0];
toReturn += array.ElementAt(i) + value;
}
}
return toReturn;
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandGroup" /> class.
/// </summary>
/// <param name="concatType">Concatination type of the group.</param>
/// <param name="groupElements">Elements of the group.</param>
public CommandGroup(ConcatenationType concatType, params CommandFilter[] groupElements)
: base(concatType, groupElements)
{
}
public static List <SearchFilter> AddById(this List <SearchFilter> thisValue, string value, ComparisonType comparisonType = ComparisonType.EqualTo, ConcatenationType concatenationType = ConcatenationType.Or) => thisValue.AddSearchFilter(ById, value, comparisonType, concatenationType);
public static List <SearchFilter> AddParentOrderIdentifier(this List <SearchFilter> thisValue, string value, ComparisonType comparisonType = ComparisonType.EqualTo, ConcatenationType concatenationType = ConcatenationType.Or) => thisValue.AddSearchFilter(ParentOrderIdentifierName, value, comparisonType, concatenationType);
public static List <SearchFilter> AddSearchFilter(this List <SearchFilter> thisValue,
string name, string value, ComparisonType comparisonType, ConcatenationType concatenationType)
=> thisValue.AddSearchFilters(SearchFilter.New(name, value, comparisonType, concatenationType));
public static SearchFilter New(string name, string value, ComparisonType comparisonType, ConcatenationType concatenationType)
=> new SearchFilter()
{
Name = name,
Value = value,
ComparisonType = comparisonType,
ConcatenationType = concatenationType
};
