Search Results for

    Show / Hide Table of Contents

    Class GetInstrumentSets

    A helper class for executing the system default GetPaths query

    See https://help.lemonedge.com/getinstrumentsets/ for more information.

    Inheritance
    object
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>
    SQLWrapperExecuter<IInstrumentSetInfo>
    GetInstrumentSets
    Inherited Members
    SQLWrapperExecuter<IInstrumentSetInfo>.Execute(CancellationToken)
    SQLWrapperExecuter<IInstrumentSetInfo>.ExecuteCount()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>._sqlWrapperName
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>._sqlWrapperID
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>._sqlWrapper
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>._params
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.GetWrapper()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.ClearParameters()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddParameters(IReadOnlyDictionary<string, string>)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddParameter<V>(string, V)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddParameter(string, bool)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddParameter<V>(string, V?)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddAsOfDate(DateTimeOffset)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.AddCanvasID(Guid)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.ClearFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.SetFilter(QueryableExecuter<IInstrumentSetInfo>)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.ParametersAreValid()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.GetFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.GetQueryArgumentsAndFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.Execute(CancellationToken)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.ExecuteCount()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.Retriever
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.Cache
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.Parameters
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IInstrumentSetInfo>, IInstrumentSetInfo>.Filter
    object.GetType()
    object.MemberwiseClone()
    object.ToString()
    object.Equals(object)
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    object.GetHashCode()
    Namespace: LemonEdge.API.Core.FinancialServices.Helpers
    Assembly: LemonEdge.API.Core.FinancialServices.dll
    Syntax
    public class GetInstrumentSets : SQLWrapperExecuter<IInstrumentSetInfo>

    Constructors

    GetInstrumentSets(IEntityRetriever, IReadOnlyCache)

    Creates a new SQLWrapperExecuter for the GetInstrumentSets standard SQL Wrapper query

    Declaration
    public GetInstrumentSets(IEntityRetriever retriever, IReadOnlyCache cache)
    Parameters
    Type Name Description
    IEntityRetriever retriever

    A IEntityRetriever context for querying the LemonEdge platform

    IReadOnlyCache cache

    A local cache

    Fields

    PARAM_INSTRUMENTSETID

    The ParameterName for the InstrumentSetID parameter

    Declaration
    public const string PARAM_INSTRUMENTSETID = "@instrumentSetID"
    Field Value
    Type Description
    string

    QUERYNAME

    Global name of the SQLWrapper query

    Declaration
    public const string QUERYNAME = "GetInstrumentSets"
    Field Value
    Type Description
    string

    Methods

    AddInstrumentSetID(Guid)

    Indicates only to use allocations that have an effective date less than or equal to this. This would exclude new allocations, or transfers depending on the date

    Declaration
    public GetInstrumentSets AddInstrumentSetID(Guid instrumentSetID)
    Parameters
    Type Name Description
    Guid instrumentSetID

    The ID of the instrument set to return all matching instruments for. If null it will return all instrument sets and the instruments that belong to them.

    Returns
    Type Description
    GetInstrumentSets

    This GetInstrumentSets instance for chaining commands

    Execute(IEntityRetriever, IReadOnlyCache, Guid, QueryableExecuter<IInstrumentSetInfo>)

    Executes the GetInstrumentSets system SQLWrapper using the specified parameters, and returns the results of the results of that query

    Declaration
    public static Task<IEnumerable<IInstrumentSetInfo>> Execute(IEntityRetriever retriever, IReadOnlyCache cache, Guid instrumentSetID, QueryableExecuter<IInstrumentSetInfo> filter = null)
    Parameters
    Type Name Description
    IEntityRetriever retriever

    A IEntityRetriever context for querying the LemonEdge platform

    IReadOnlyCache cache

    A local cache

    Guid instrumentSetID

    Indicates only to use allocations that have an effective date less than or equal to this. This would exclude new allocations, or transfers depending on the date

    QueryableExecuter<IInstrumentSetInfo> filter

    An optional QueryableExecuter<T> that holds any filtering to apply to the query

    Returns
    Type Description
    Task<IEnumerable<IInstrumentSetInfo>>

    A task holding the results of executing the GetInstrumentSets query with the specified parameters

    Execute(Guid, QueryableExecuter<IInstrumentSetInfo>)

    Executes the GetInstrumentSets system SQLWrapper using the specified parameters, and returns the results of the results of that query

    Declaration
    public Task<IEnumerable<IInstrumentSetInfo>> Execute(Guid instrumentSetID, QueryableExecuter<IInstrumentSetInfo> filter = null)
    Parameters
    Type Name Description
    Guid instrumentSetID

    Indicates only to use allocations that have an effective date less than or equal to this. This would exclude new allocations, or transfers depending on the date

    QueryableExecuter<IInstrumentSetInfo> filter

    An optional QueryableExecuter<T> that holds any filtering to apply to the query

    Returns
    Type Description
    Task<IEnumerable<IInstrumentSetInfo>>

    A task holding the results of executing the GetInstrumentSets query with the specified parameters

    ParametersAreValid()

    Indicates if the parameters are valid for executing the query

    Declaration
    protected override bool ParametersAreValid()
    Returns
    Type Description
    bool

    True if the parameters contain a value for @instrumentSetID

    Overrides
    LemonEdge.API.Entities.Helpers.BaseSQLWrapperExecuter<LemonEdge.API.Entities.Helpers.SQLWrapperExecuter<LemonEdge.API.Entities.FinancialServices.Transactions.IInstrumentSetInfo>, LemonEdge.API.Entities.FinancialServices.Transactions.IInstrumentSetInfo>.ParametersAreValid()

    Extension Methods

    LinqExtensions.AsArray<T>(T)
    LinqExtensions.ToArrayOfOne<T>(T)
    LinqExtensions.ToListOfOne<T>(T)
    MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)
    WeakReferenceExtensions.WeakReference(object)
    SQLExtensions.ToSQLValue(object, bool)
    ReflectionExtensions.ClearEventInvocations(object, string)
    StringExtensions.ToCSVFormatString(object, Type)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.