Search Results for

    Show / Hide Table of Contents

    Class FormulaFunctionsWithViewContext<T>

    The context supplied while executing a formula that has a custom context item, and a view that it operates against

    This context is mainly used against formulas that configure and work against a view itself, such as ones that can specify if a view is visible dynamically, or more.

    Inheritance
    object
    StandardFunctions
    FormulaFunctions
    FormulaFunctionsWithUpdater
    FormulaFunctionsWithContext<T>
    FormulaFunctionsWithViewModel<T>
    FormulaFunctionsWithViewContext<T>
    FormulaFunctionsWithViewContext
    Implements
    IFormulaFunctionsWithViewContext<T>
    IFormulaFunctionsWithViewContext
    IFormulaFunctionsWithViewModel<T>
    IFormulaFunctionsWithViewModel
    IFormulaFunctionsWithContext<T>
    IFormulaFunctionsWithContext
    IFormulaFunctions
    Inherited Members
    FormulaFunctionsWithViewModel<T>.DisplayYesNoCancelQuestion(string, string)
    FormulaFunctionsWithViewModel<T>.DisplayYesNoQuestion(string, string)
    FormulaFunctionsWithViewModel<T>.DisplayInformationMessage(string, string)
    FormulaFunctionsWithViewModel<T>.DisplayError(Exception)
    FormulaFunctionsWithViewModel<T>.OpenItem(IBaseEntity)
    FormulaFunctionsWithViewModel<T>.OpenItemFromID(Type, Guid)
    FormulaFunctionsWithViewModel<T>.SetBusy(string)
    FormulaFunctionsWithViewModel<T>.StopBusy()
    FormulaFunctionsWithViewModel<T>.RootController
    FormulaFunctionsWithViewModel<T>.MyDataUI
    FormulaFunctionsWithViewModel<T>.IgnoreEvents
    FormulaFunctionsWithViewModel<T>.Host
    FormulaFunctionsWithContext<T>.TestEvents()
    FormulaFunctionsWithContext<T>.ItemAs<T1>()
    FormulaFunctionsWithContext<T>.SetExtendedPropertyValue(IBaseEntity, string, string, object)
    FormulaFunctionsWithContext<T>.GetValue(string)
    FormulaFunctionsWithContext<T>.GetValue<T2>(string)
    FormulaFunctionsWithContext<T>.GetAnswerTotal(string)
    FormulaFunctionsWithContext<T>.GetContextType(EntityDescriptor)
    FormulaFunctionsWithContext<T>.MyItem
    FormulaFunctionsWithContext<T>.Item
    FormulaFunctionsWithContext<T>.PropertyChangedItem
    FormulaFunctionsWithContext<T>.PropertyChangedName
    FormulaFunctionsWithContext<T>.PropertyChangedAlias
    FormulaFunctionsWithContext<T>.ChangedItemType
    FormulaFunctionsWithUpdater.SetCustomParameters(Dictionary<string, object>)
    FormulaFunctionsWithUpdater.CreateNewData()
    FormulaFunctionsWithUpdater.CreateNewItem(string)
    FormulaFunctionsWithUpdater.CreateNewItem<T>()
    FormulaFunctionsWithUpdater.GetCustomParamValue(string)
    FormulaFunctionsWithUpdater.HasCustomParamValue(string)
    FormulaFunctionsWithUpdater.HasCustomParamValueEqualTo(string, object)
    FormulaFunctionsWithUpdater.RunCodeSnippet(string, params string[])
    FormulaFunctionsWithUpdater.MyData
    FormulaFunctions.ShareThisQueryCacheWithTarget(IFormulaFunctions)
    FormulaFunctions.SetQueryRunnerHelper(Func<IEntityUpdater, ISQLWrapperInterpretor, Dictionary<string, string>, QueryableExecuter<ISQLWrapperResult>, Task<DataRow[]>>)
    FormulaFunctions.GetItemPropertyValue(object, string)
    FormulaFunctions.GetTaskID(string)
    FormulaFunctions.GetTaskParameter(string)
    FormulaFunctions.SetObjectValue(object, string, object)
    FormulaFunctions.GetObjectValue(object, string)
    FormulaFunctions.GetExtendedPropertyValue(IBaseEntity, string, string)
    FormulaFunctions.GetExtendedPropertyItem(IBaseEntity, string)
    FormulaFunctions.GetExtendedObject(IBaseEntity, string, bool)
    FormulaFunctions.GetEntityTypeID(string)
    FormulaFunctions.Evaluate<T>(string, bool)
    FormulaFunctions.IsValid<T>(string)
    FormulaFunctions.IsValid<T>(string, Type)
    FormulaFunctions.GetContextItemType(object)
    FormulaFunctions.GetItemFromDataSourceID(string, string)
    FormulaFunctions.GetItemFromDataSourceID(string, string, string)
    FormulaFunctions.GetItem(string, Guid)
    FormulaFunctions.GetItemAs<T>(Guid)
    FormulaFunctions.GetItems(string, QueryableFilter)
    FormulaFunctions.GetFirstOrDefaultItem(string, QueryableFilter)
    FormulaFunctions.GetItems(string, string, SQLOperator, object)
    FormulaFunctions.GetFirstOrDefaultItem(string, string, SQLOperator, object)
    FormulaFunctions.GetItems<T>(QueryableFilter)
    FormulaFunctions.GetFirstOrDefaultItem<T>(QueryableFilter)
    FormulaFunctions.GetItems<T>(string, SQLOperator, object)
    FormulaFunctions.GetFirstOrDefaultItem<T>(string, SQLOperator, object)
    FormulaFunctions.GetEnumValue(object)
    FormulaFunctions.GetEnumCode(object)
    FormulaFunctions.XIRR(string, string, string, params string[])
    FormulaFunctions.XIRR(string, string, string, (string, object)[], params string[])
    FormulaFunctions.TWR(string, string, string, string, params string[])
    FormulaFunctions.TWRRow(string, string, string, string, params string[])
    FormulaFunctions.RunQuery(string, string, params string[])
    FormulaFunctions.HasQueryResult(string, params string[])
    FormulaFunctions.GetQueryResult(ISQLWrapperResult, string)
    FormulaFunctions.GetQueryResult(DataRow, string)
    FormulaFunctions.GetQueryResult(string, string, ISQLWrapperResult)
    FormulaFunctions.GetQueryResult(string, string, DataRow)
    FormulaFunctions.GetQueryResult(string, string, ISQLWrapperResult[], string, object)
    FormulaFunctions.RunQueryResult(string, params string[])
    FormulaFunctions.RunDRQueryResult(string, params string[])
    FormulaFunctions.LogInfo(string, params object[])
    FormulaFunctions.LogError(Exception, string, params object[])
    FormulaFunctions.GetQueryCount(string, string, string)
    FormulaFunctions.GetQueryItems(string, string, string, string)
    FormulaFunctions.GetDRQueryItems(string, string, string, string)
    FormulaFunctions.Data
    FormulaFunctions.Cache
    FormulaFunctions.Services
    FormulaFunctions.User
    StandardFunctions.FormatAsString(object)
    StandardFunctions.Null()
    StandardFunctions.IsNull(object)
    StandardFunctions.Not(bool)
    StandardFunctions.Or(bool, bool)
    StandardFunctions.And(bool, bool)
    StandardFunctions.Sin(double)
    StandardFunctions.Cos(double)
    StandardFunctions.Now()
    StandardFunctions.Today()
    StandardFunctions.TodayString()
    StandardFunctions.EndOfMonth(DateTime)
    StandardFunctions.BeginningOfMonth(DateTime)
    StandardFunctions.BeginningOfWeek(DateTime)
    StandardFunctions.EndOfYear(DateTime)
    StandardFunctions.EndOfDay(DateTime)
    StandardFunctions.Floor(decimal)
    StandardFunctions.Ceiling(decimal)
    StandardFunctions.BeginningOfYear(DateTime)
    StandardFunctions.BeginningOfDay(DateTime)
    StandardFunctions.Random(int, int)
    StandardFunctions.Trim(string)
    StandardFunctions.TrimStart(string, char[])
    StandardFunctions.TrimEnd(string, char[])
    StandardFunctions.PadLeft(string, int, char)
    StandardFunctions.PadRight(string, int, char)
    StandardFunctions.Mod(double, double)
    StandardFunctions.If(bool, object, object)
    StandardFunctions.IsIn(object, object)
    StandardFunctions.IsIn(object, object, object)
    StandardFunctions.IsIn(object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object, object, object)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.Format(object, string)
    StandardFunctions.Lower(string)
    StandardFunctions.Upper(string)
    StandardFunctions.WCase(string)
    StandardFunctions.Date(int, int, int)
    StandardFunctions.Year(DateTime)
    StandardFunctions.Month(DateTime)
    StandardFunctions.Day(DateTime)
    StandardFunctions.WeekDay(DateTime)
    StandardFunctions.Replace(string, string, string)
    StandardFunctions.Substr(string, int, int)
    StandardFunctions.Len(string)
    StandardFunctions.Abs(double)
    StandardFunctions.Int(object)
    StandardFunctions.Trunc(double, int)
    StandardFunctions.Dec(object)
    StandardFunctions.Round(object)
    StandardFunctions.IsBlank(string)
    StandardFunctions.Round(object, int)
    StandardFunctions.Min(double, double, double, double, double)
    StandardFunctions.Max(double, double, double, double, double)
    StandardFunctions.Chr(int)
    StandardFunctions.ChCR()
    StandardFunctions.ChLF()
    StandardFunctions.ChCRLF()
    StandardFunctions.Money(object)
    StandardFunctions.Contains(string, string)
    StandardFunctions.FormatDate(DateTime, string)
    StandardFunctions.Sqrt(double)
    StandardFunctions.Power(double, double)
    StandardFunctions.ValString(object)
    StandardFunctions.ValBool(object)
    StandardFunctions.ValDate(object)
    StandardFunctions.ValDateTimeOffset(object)
    StandardFunctions.ValDecimal(object)
    StandardFunctions.ValLong(object)
    StandardFunctions.ValID(object)
    StandardFunctions.DateAdd(DateTime, decimal, decimal, decimal)
    StandardFunctions.DateAdd(DateTimeOffset, decimal, decimal, decimal)
    StandardFunctions.DateAddWorkDays(DateTime, decimal)
    StandardFunctions.DateAdd(DateTime, DateTime)
    StandardFunctions.DayDifference(DateTime, DateTime)
    StandardFunctions.DayDifferenceWorkDays(DateTime, DateTime)
    StandardFunctions.HourDifference(DateTime, DateTime)
    StandardFunctions.MinuteDifference(DateTime, DateTime)
    StandardFunctions.YearDifference(DateTime, DateTime)
    StandardFunctions.NullDate()
    StandardFunctions.NullDateTimeOffset()
    StandardFunctions.TempValue1
    object.GetType()
    object.MemberwiseClone()
    object.ToString()
    object.Equals(object)
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    object.GetHashCode()
    Namespace: LemonEdge.Client.Core
    Assembly: LemonEdge.ClientCore.dll
    Syntax
    public class FormulaFunctionsWithViewContext<T> : FormulaFunctionsWithViewModel<T>, IFormulaFunctionsWithViewContext<T>, IFormulaFunctionsWithViewContext, IFormulaFunctionsWithViewModel<T>, IFormulaFunctionsWithViewModel, IFormulaFunctionsWithContext<T>, IFormulaFunctionsWithContext, IFormulaFunctions
    Type Parameters
    Name Description
    T The context supplied while executing a formula that has a custom context item, and a view that it operates against This context is mainly used against formulas that configure and work against a view itself, such as ones that can specify if a view is visible dynamically, or more.

    Constructors

    FormulaFunctionsWithViewContext(IEntityRetriever, IReadOnlyCache, UserInfo, T, IModelLayoutDisplayerController, IModelView, object, IFormulaFunctionsServiceContext)

    Declaration
    public FormulaFunctionsWithViewContext(IEntityRetriever retriever, IReadOnlyCache cache, UserInfo user, T mainItem, IModelLayoutDisplayerController controller, IModelView view, object rowItem, IFormulaFunctionsServiceContext services)
    Parameters
    Type Name Description
    IEntityRetriever retriever
    IReadOnlyCache cache
    UserInfo user
    T mainItem
    IModelLayoutDisplayerController controller
    IModelView view
    object rowItem
    IFormulaFunctionsServiceContext services

    Properties

    RowItem

    Declaration
    public object RowItem { get; }
    Property Value
    Type Description
    object

    SelectedItems

    Declaration
    public IEnumerable<IBaseEntity> SelectedItems { get; }
    Property Value
    Type Description
    IEnumerable<IBaseEntity>

    SelectedObjects

    Declaration
    public IEnumerable<object> SelectedObjects { get; }
    Property Value
    Type Description
    IEnumerable<object>

    View

    The view this formula can work with

    Declaration
    public IModelView View { get; }
    Property Value
    Type Description
    IModelView

    Methods

    CreateFormulaContext(Type)

    Declaration
    protected override FormulaFunctions CreateFormulaContext(Type ofType)
    Parameters
    Type Name Description
    Type ofType
    Returns
    Type Description
    FormulaFunctions
    Overrides
    FormulaFunctionsWithViewModel<T>.CreateFormulaContext(Type)

    GetResultValue(object, string)

    Declaration
    public Task<object> GetResultValue(object item, string columnName)
    Parameters
    Type Name Description
    object item
    string columnName
    Returns
    Type Description
    Task<object>

    GetView(ViewDescriptorInstance)

    Returns a view from the overall layout that can be referenced by this formula

    Declaration
    public IModelView GetView(ViewDescriptorInstance descriptor)
    Parameters
    Type Name Description
    ViewDescriptorInstance descriptor

    A descriptor for the view that you want returned that also exists within the current layout this formula is executing within

    Returns
    Type Description
    IModelView

    A view from the overall layout that can be referenced by this formula

    GetView(string)

    Declaration
    [FormulaFunction(Name = "RedisplayView", Type = "UI", Description = "Returns the view model from the specified view name.", Params = "1. The name of the view to return.", ParamCount = 1, IsAsync = false)]
    public IModelView GetView(string viewName)
    Parameters
    Type Name Description
    string viewName
    Returns
    Type Description
    IModelView

    GetViewContextType(EntityDescriptor)

    Declaration
    public static Type GetViewContextType(EntityDescriptor desc)
    Parameters
    Type Name Description
    EntityDescriptor desc
    Returns
    Type Description
    Type

    RecalculateGridAggregates(string)

    Declaration
    [FormulaFunction(Name = "RecalculateGridAggregates", Type = "UI", Description = "Recalculates aggregates in grid of specified view.", Params = "1. The name of the view to recalculate aggregates on.", ParamCount = 1, IsAsync = false)]
    public void RecalculateGridAggregates(string viewName)
    Parameters
    Type Name Description
    string viewName

    RedisplayView(string)

    Declaration
    [FormulaFunction(Name = "RedisplayView", Type = "UI", Description = "Redisplays the object against the specified view.", Params = "1. The name of the view to redisplay.", ParamCount = 1, IsAsync = true)]
    public Task RedisplayView(string viewName)
    Parameters
    Type Name Description
    string viewName
    Returns
    Type Description
    Task

    SetRowItem(object)

    Declaration
    public void SetRowItem(object rowItem)
    Parameters
    Type Name Description
    object rowItem

    Implements

    IFormulaFunctionsWithViewContext<T>
    IFormulaFunctionsWithViewContext
    IFormulaFunctionsWithViewModel<T>
    IFormulaFunctionsWithViewModel
    IFormulaFunctionsWithContext<T>
    IFormulaFunctionsWithContext
    IFormulaFunctions

    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.