Class ImporterFormulaContext

The context used for evaluating formulas against OverrideValueFormula

Inheritance

System.Object

StandardFunctions

FormulaFunctions

ImporterFormulaContext

Implements

IFormulaImporterContext

IFormulaFunctions

Inherited Members

FormulaFunctions.Data

FormulaFunctions.Cache

FormulaFunctions.User

FormulaFunctions.GetContextItemType(Object)

FormulaFunctions.GetItemPropertyValue(Object, String)

FormulaFunctions.GetItemFromDataSourceID(String, String)

FormulaFunctions.GetItemFromDataSourceID(String, String, String)

FormulaFunctions.GetItem(String, Guid)

FormulaFunctions.RunQuery(String, String, String[])

FormulaFunctions.GetQueryItems(String, String, String, String)

StandardFunctions.FormatAsString(Object)

StandardFunctions.Null()

StandardFunctions.IsNull(Object)

StandardFunctions.Not(Boolean)

StandardFunctions.Or(Boolean, Boolean)

StandardFunctions.And(Boolean, Boolean)

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(Int32, Int32)

StandardFunctions.Trim(String)

StandardFunctions.TrimStart(String, Char[])

StandardFunctions.TrimEnd(String, Char[])

StandardFunctions.PadLeft(String, Int32, Char)

StandardFunctions.PadRight(String, Int32, Char)

StandardFunctions.Mod(Double, Double)

StandardFunctions.If(Boolean, 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(Int32, Int32, Int32)

StandardFunctions.Year(DateTime)

StandardFunctions.Month(DateTime)

StandardFunctions.Day(DateTime)

StandardFunctions.WeekDay(DateTime)

StandardFunctions.Replace(String, String, String)

StandardFunctions.Substr(String, Int32, Int32)

StandardFunctions.Len(String)

StandardFunctions.Abs(Double)

StandardFunctions.Int(Object)

StandardFunctions.Trunc(Double, Int32)

StandardFunctions.Dec(Object)

StandardFunctions.Round(Object)

StandardFunctions.IsBlank(String)

StandardFunctions.Round(Object, Int32)

StandardFunctions.Min(Double, Double, Double, Double, Double)

StandardFunctions.Max(Double, Double, Double, Double, Double)

StandardFunctions.Chr(Int32)

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.ValDecimal(Object)

StandardFunctions.ValLong(Object)

StandardFunctions.ValID(Object)

StandardFunctions.DateAdd(DateTime, 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()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: LemonEdge.Entities.Processors.Importing

Assembly: API.dll

Syntax

public class ImporterFormulaContext : FormulaFunctions, IFormulaImporterContext, IFormulaFunctions

Properties

Item

The item being created/updated and imported

Declaration

public IBaseEntity Item { get; }

Property Value

Type	Description
IBaseEntity

Methods

GetValueFromColumnIndex(Int16)

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

Declaration

public string GetValueFromColumnIndex(short colIndex)

Parameters

Type	Name	Description
System.Int16	colIndex

Returns

Type	Description
System.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

public string GetValueFromHeaderName(string headerName)

Parameters

Type	Name	Description
System.String	headerName

Returns

Type	Description
System.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

public string GetValueFromMappedProperty(string header)

Parameters

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

Returns

Type	Description
System.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

Implements

IFormulaImporterContext

IFormulaFunctions

Extension Methods

MiscExtensions.SetIfNotEqual<T, P>(T, Expression<Func<T, P>>, P)

ReflectionExtensions.ClearEventInvocations(Object, String)

StringExtensions.ToCSVFormatString(Object, Type)

SQLExtensions.ToSQLValue(Object, Boolean)