Class ImporterFormulaContext

The context used for evaluating formulas against OverrideValueFormula

Inheritance

object

StandardFunctions

FormulaFunctions

FormulaFunctionsWithUpdater

ImporterFormulaContext

Implements

IFormulaImporterContext

IFormulaFunctions

Inherited Members

FormulaFunctionsWithUpdater.SetCustomParameters(Dictionary<string, object>)

FormulaFunctionsWithUpdater.CreateNewData()

FormulaFunctionsWithUpdater.CreateNewItem(string)

FormulaFunctionsWithUpdater.CreateNewItem<T>()

FormulaFunctionsWithUpdater.GetCustomParamValue(string)

FormulaFunctionsWithUpdater.HasCustomParamValue(string)

FormulaFunctionsWithUpdater.HasCustomParamValueEqualTo(string, object)

FormulaFunctionsWithUpdater.CreateFormulaContext(Type)

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.API.Core.Processors.Importing

Assembly: LemonEdge.API.dll

Syntax

public class ImporterFormulaContext : FormulaFunctionsWithUpdater, IFormulaImporterContext, IFormulaFunctions

Properties

IsLastRow

Indicates this item being evaluated is the last row of the dataset being imported

Declaration

public bool IsLastRow { get; set; }

Property Value

Type	Description
bool

Item

The item being created/updated and imported

Declaration

public IBaseEntity Item { get; }

Property Value

Type	Description
IBaseEntity

MyRawValue

The raw value of the import source data for this column

Declaration

public string MyRawValue { get; set; }

Property Value

Type	Description
string

Methods

GetValueFromColumnIndex(short)

Returns the raw string data from the import file for the mapping property that matches on Sequence

Declaration

[FormulaFunction(Name = "GetValueFromColumnIndex", Type = "Context", Description = "Returns the raw string data from the import file for the mapping property that matches on Sequence. The column order.", Params = "1. The column sequence of the data mapping property you want to return the value of", ParamCount = 1)]
public string GetValueFromColumnIndex(short colIndex)

Parameters

Type	Name	Description
short	colIndex

Returns

Type	Description
string	The raw string data from the import file for the mapping property that matches on Sequence

GetValueFromHeaderName(string)

Returns the raw string data from the import file for the mapping property that matches on ColumnHeaderName

Declaration

[FormulaFunction(Name = "GetValueFromHeaderName", Type = "Context", Description = "Returns the raw string data from the import file for the mapping property that matches on ColumnHeaderName", Params = "1. The column header name of the data mapping property you want to return the value of", ParamCount = 1)]
public string GetValueFromHeaderName(string headerName)

Parameters

Type	Name	Description
string	headerName

Returns

Type	Description
string	The raw string data from the import file for the mapping property that matches on ColumnHeaderName

GetValueFromMappedProperty(string)

Returns the raw string data from the import file for the mapping property that matches on PropertyName

Declaration

[FormulaFunction(Name = "GetValueFromMappedProperty", Type = "Context", Description = "Returns the raw string data from the import file for the mapping property that matches on PropertyName", Params = "1. The propertyname of the data mapping property you want to return the value of", ParamCount = 1)]
public string GetValueFromMappedProperty(string header)

Parameters

Type	Name	Description
string	header	The property name of the mapping property to retrieve the value from that matches on PropertyName

Returns

Type	Description
string	The raw string data from the import file for the mapping property that matches on PropertyName

ItemAs<T>()

The imported item cast as the type of entity it should be

Declaration

public T ItemAs<T>() where T : IBaseEntity

Returns

Type	Description
T	The imported item cast as the type of entity it should be

Type Parameters

Name	Description
T	The type of entity that should be being imported

SetData(MappedData)

Declaration

public void SetData(CSVImporter.MappedData data)

Parameters

Type	Name	Description
CSVImporter.MappedData	data

Implements

IFormulaImporterContext

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)