Class AlgorithmContext

Inheritance

object

StandardFunctions

FormulaFunctions

FormulaFunctionsWithUpdater

FormulaFunctionsWithContext<IAlgorithmRunData>

AlgorithmContext

Implements

IFormulaFunctionsWithContext<IAlgorithmRunData>

IFormulaFunctionsWithContext

IFormulaFunctions

Inherited Members

FormulaFunctionsWithContext<IAlgorithmRunData>.TestEvents()

FormulaFunctionsWithContext<IAlgorithmRunData>.ItemAs<T1>()

FormulaFunctionsWithContext<IAlgorithmRunData>.SetExtendedPropertyValue(IBaseEntity, string, string, object)

FormulaFunctionsWithContext<IAlgorithmRunData>.SetBusy(string)

FormulaFunctionsWithContext<IAlgorithmRunData>.StopBusy()

FormulaFunctionsWithContext<IAlgorithmRunData>.CreateFormulaContext(Type)

FormulaFunctionsWithContext<IAlgorithmRunData>.GetValue(string)

FormulaFunctionsWithContext<IAlgorithmRunData>.GetValue<T2>(string)

FormulaFunctionsWithContext<IAlgorithmRunData>.GetAnswerTotal(string)

FormulaFunctionsWithContext<IAlgorithmRunData>.GetContextType(EntityDescriptor)

FormulaFunctionsWithContext<IAlgorithmRunData>.MyItem

FormulaFunctionsWithContext<IAlgorithmRunData>.Item

FormulaFunctionsWithContext<IAlgorithmRunData>.PropertyChangedItem

FormulaFunctionsWithContext<IAlgorithmRunData>.PropertyChangedName

FormulaFunctionsWithContext<IAlgorithmRunData>.PropertyChangedAlias

FormulaFunctionsWithContext<IAlgorithmRunData>.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.Connections.Database.Formulas

Assembly: LemonEdge.Database.Connector.dll

Syntax

public class AlgorithmContext : FormulaFunctionsWithContext<IAlgorithmRunData>, IFormulaFunctionsWithContext<IAlgorithmRunData>, IFormulaFunctionsWithContext, IFormulaFunctions

Constructors

AlgorithmContext(IEntityUpdater, IReadOnlyCache, UserInfo, IAlgorithmRunData, IAlgorithmRun, IAlgorithm, IExcelWorkbook, IFormulaFunctionsServiceContext)

Declaration

public AlgorithmContext(IEntityUpdater updater, IReadOnlyCache cache, UserInfo user, IAlgorithmRunData data, IAlgorithmRun run, IAlgorithm algorithm, IExcelWorkbook workbook, IFormulaFunctionsServiceContext context)

Parameters

Type	Name	Description
IEntityUpdater	updater
IReadOnlyCache	cache
UserInfo	user
IAlgorithmRunData	data
IAlgorithmRun	run
IAlgorithm	algorithm
IExcelWorkbook	workbook
IFormulaFunctionsServiceContext	context

Properties

Algorithm

Declaration

public IAlgorithm Algorithm { get; }

Property Value

Type	Description
IAlgorithm

AlgorithmRun

Declaration

public IAlgorithmRun AlgorithmRun { get; }

Property Value

Type	Description
IAlgorithmRun

AlgorithmRunData

Declaration

public IAlgorithmRunData AlgorithmRunData { get; }

Property Value

Type	Description
IAlgorithmRunData

AlgorithmWorkbook

Declaration

public IExcelWorkbook AlgorithmWorkbook { get; }

Property Value

Type	Description
IExcelWorkbook

Implements

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)