Search Results for

    Show / Hide Table of Contents

    Class GetPaths

    A helper class for executing the system default GetPaths query

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

    Inheritance
    object
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>
    SQLWrapperExecuter<IAllocationMapping>
    GetPaths
    Inherited Members
    SQLWrapperExecuter<IAllocationMapping>.Execute(CancellationToken)
    SQLWrapperExecuter<IAllocationMapping>.ExecuteCount()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>._sqlWrapperName
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>._sqlWrapperID
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>._sqlWrapper
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>._params
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.GetWrapper()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.ClearParameters()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddParameters(IReadOnlyDictionary<string, string>)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddParameter<V>(string, V)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddParameter(string, bool)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddParameter<V>(string, V?)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddAsOfDate(DateTimeOffset)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.AddCanvasID(Guid)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.ClearFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.SetFilter(QueryableExecuter<IAllocationMapping>)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.ParametersAreValid()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.GetFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.GetQueryArgumentsAndFilter()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.Execute(CancellationToken)
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.ExecuteCount()
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.Retriever
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.Cache
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.Parameters
    BaseSQLWrapperExecuter<SQLWrapperExecuter<IAllocationMapping>, IAllocationMapping>.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 GetPaths : SQLWrapperExecuter<IAllocationMapping>

    Constructors

    GetPaths(IEntityRetriever, IReadOnlyCache)

    Creates a new SQLWrapperExecuter for the GetPaths standard SQL Wrapper query

    Declaration
    public GetPaths(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_ENTITYSET

    Declaration
    public const string PARAM_ENTITYSET = "@entitySetID"
    Field Value
    Type Description
    string

    PARAM_INSTRUMENT

    Declaration
    public const string PARAM_INSTRUMENT = "@instrumentID"
    Field Value
    Type Description
    string

    PARAM_PATH

    Declaration
    public const string PARAM_PATH = "@pathID"
    Field Value
    Type Description
    string

    QUERYNAME

    Global name of the SQLWrapper query

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

    Methods

    AddEntitySetID(Guid?)

    The Entity set within which the instruments/paths belong

    Declaration
    public GetPaths AddEntitySetID(Guid? entitySetID)
    Parameters
    Type Name Description
    Guid? entitySetID

    The entity set id to run the GetPaths query with

    Returns
    Type Description
    GetPaths

    This GetPaths instance for chaining commands

    AddInstrumentID(Guid?)

    The instrument ID to return its mapped paths for. If this is null it will return all paths within an entity set and their associated instruments that are mapped to those paths

    Declaration
    public GetPaths AddInstrumentID(Guid? instrumentID)
    Parameters
    Type Name Description
    Guid? instrumentID

    The instrument id to run the GetPaths query with

    Returns
    Type Description
    GetPaths

    This GetPaths instance for chaining commands

    AddPathID(Guid?)

    The path to return

    Declaration
    public GetPaths AddPathID(Guid? pathID)
    Parameters
    Type Name Description
    Guid? pathID

    The path to run the GetPaths query with

    Returns
    Type Description
    GetPaths

    This GetPaths instance for chaining commands

    Execute(IEntityRetriever, IReadOnlyCache, Guid?, Guid?, QueryableExecuter<IAllocationMapping>)

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

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

    A IEntityRetriever context for querying the LemonEdge platform

    IReadOnlyCache cache

    A local cache

    Guid? entitySetID

    The Entity set within which the instruments/paths belong

    Guid? instrumentID

    The instrument ID to return its mapped paths for. If this is null it will return all paths within an entity set and their associated instruments that are mapped to those paths

    QueryableExecuter<IAllocationMapping> filter

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

    Returns
    Type Description
    Task<IEnumerable<IAllocationMapping>>

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

    Execute(IEntityRetriever, IReadOnlyCache, Guid?, Guid?, Guid?, QueryableExecuter<IAllocationMapping>)

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

    Declaration
    public static Task<IEnumerable<IAllocationMapping>> Execute(IEntityRetriever retriever, IReadOnlyCache cache, Guid? entitySetID, Guid? pathID, Guid? instrumentID, QueryableExecuter<IAllocationMapping> filter = null)
    Parameters
    Type Name Description
    IEntityRetriever retriever

    A IEntityRetriever context for querying the LemonEdge platform

    IReadOnlyCache cache

    A local cache

    Guid? entitySetID

    The Entity set within which the instruments/paths belong

    Guid? pathID

    The path to return

    Guid? instrumentID

    The instrument ID to return its mapped paths for. If this is null it will return all paths within an entity set and their associated instruments that are mapped to those paths

    QueryableExecuter<IAllocationMapping> filter

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

    Returns
    Type Description
    Task<IEnumerable<IAllocationMapping>>

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

    Execute(Guid?, Guid?, Guid?, QueryableExecuter<IAllocationMapping>)

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

    Declaration
    public Task<IEnumerable<IAllocationMapping>> Execute(Guid? entitySetID, Guid? pathID, Guid? instrumentID, QueryableExecuter<IAllocationMapping> filter = null)
    Parameters
    Type Name Description
    Guid? entitySetID

    The Entity set within which the instruments/paths belong

    Guid? pathID

    The path to return

    Guid? instrumentID

    The instrument ID to return its mapped paths for. If this is null it will return all paths within an entity set and their associated instruments that are mapped to those paths

    QueryableExecuter<IAllocationMapping> filter

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

    Returns
    Type Description
    Task<IEnumerable<IAllocationMapping>>

    A task holding the results of executing the GetPaths 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

    Overrides
    LemonEdge.API.Entities.Helpers.BaseSQLWrapperExecuter<LemonEdge.API.Entities.Helpers.SQLWrapperExecuter<LemonEdge.API.Entities.FinancialServices.Transactions.IAllocationMapping>, LemonEdge.API.Entities.FinancialServices.Transactions.IAllocationMapping>.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.