Search Results for

    Show / Hide Table of Contents

    Class QueryRunnersController

    Inheritance
    object
    ModelViewController
    BaseGridController
    BaseGridControllerAny<IQueryRunner>
    BaseGridController<IQueryRunner>
    QueryRunnersController
    Implements
    IBaseGridController
    ICollectionExportable
    INewGridItemImplementor<IQueryRunner>
    ICopyGridItemImplementor<IQueryRunner>
    IGrid
    IDeleteGridItemImplementor<IQueryRunner>
    ISearchController
    IModelViewController
    Inherited Members
    BaseGridController<IQueryRunner>.LoadExtendedItem(Type, object)
    BaseGridController<IQueryRunner>.GetGridSourceItems()
    BaseGridController<IQueryRunner>.LoadExtendedData(IEnumerable<IQueryRunner>)
    BaseGridController<IQueryRunner>.ConvertParameterItemsFilterToItems(IEnumerable<IBaseEntity>)
    BaseGridController<IQueryRunner>.GetInternalDescriptor()
    BaseGridController<IQueryRunner>.GetCurrentQuery()
    BaseGridController<IQueryRunner>.GetQueryForExcelResults()
    BaseGridController<IQueryRunner>.GetCreationQuery()
    BaseGridController<IQueryRunner>.AddParameterIDFilterToQuery(QueryableExecuter<IQueryRunner>, IEnumerable<Guid>)
    BaseGridController<IQueryRunner>.AddParameterFilterToQuery(QueryableExecuter<IQueryRunner>, QueryableFilter)
    BaseGridController<IQueryRunner>.GetOpenGridCommand()
    BaseGridController<IQueryRunner>.GetCopyGridCommand()
    BaseGridController<IQueryRunner>.OnOpenRowItem(IQueryRunner)
    BaseGridController<IQueryRunner>.ProcessCustomCommandResult(object)
    BaseGridController<IQueryRunner>.AllowIDFilter
    BaseGridController<IQueryRunner>.NewItemHelper
    BaseGridController<IQueryRunner>.CopyItemHelper
    BaseGridController<IQueryRunner>.AllowNewCommand
    BaseGridController<IQueryRunner>.AllowCopyCommand
    BaseGridController<IQueryRunner>.AllowDeleteCommand
    BaseGridController<IQueryRunner>.OpenInSameContext
    BaseGridController<IQueryRunner>.HasGlobalFilter
    BaseGridControllerAny<IQueryRunner>.CanDelete(IQueryRunner)
    BaseGridControllerAny<IQueryRunner>.Clear()
    BaseGridControllerAny<IQueryRunner>.CloseController()
    BaseGridControllerAny<IQueryRunner>.Redisplay()
    BaseGridControllerAny<IQueryRunner>.GetGridController(IBaseGrid<IQueryRunner>)
    BaseGridControllerAny<IQueryRunner>.CanEditRowItem(IQueryRunner)
    BaseGridControllerAny<IQueryRunner>.CanEditRowItem(IQueryRunner, short)
    BaseGridControllerAny<IQueryRunner>.OnTrackedItemChanged(object, string)
    BaseGridControllerAny<IQueryRunner>.GetGridSourceItems(IEnumerable<IQueryRunner>, QueryableExecuterApplyType)
    BaseGridControllerAny<IQueryRunner>.AlterLoadedItems(IEnumerable<IQueryRunner>)
    BaseGridControllerAny<IQueryRunner>.InitDisplay()
    BaseGridControllerAny<IQueryRunner>.ResetColumnsAndGroups(bool)
    BaseGridControllerAny<IQueryRunner>.DisplayUI()
    BaseGridControllerAny<IQueryRunner>.GetItemToReselect(object)
    BaseGridControllerAny<IQueryRunner>.LoadAdditionalColumns()
    BaseGridControllerAny<IQueryRunner>.Columns()
    BaseGridControllerAny<IQueryRunner>.AddCol(short, ControlDisplayInfoLight, EntityDescriptor)
    BaseGridControllerAny<IQueryRunner>.PivotColumns(short)
    BaseGridControllerAny<IQueryRunner>.ApplyGridSettingsToFilter(QueryableExecuter)
    BaseGridControllerAny<IQueryRunner>.ApplyPaging(QueryableExecuter)
    BaseGridControllerAny<IQueryRunner>.SetTotalCount(int)
    BaseGridControllerAny<IQueryRunner>.SetPageIndex(int)
    BaseGridControllerAny<IQueryRunner>.TrackResults(IEnumerable<IQueryRunner>)
    BaseGridControllerAny<IQueryRunner>.AlterColumnInfo(ControlDisplayInfo)
    BaseGridControllerAny<IQueryRunner>.UpdateColumnFromName(string)
    BaseGridControllerAny<IQueryRunner>.GetExportableColumnInfo(IEnumerable<ColumnDescriptor>)
    BaseGridControllerAny<IQueryRunner>.IsZeroColumnColumnVisible(string)
    BaseGridControllerAny<IQueryRunner>.ToggleZeroColumns()
    BaseGridControllerAny<IQueryRunner>.UpdateAllZeroColumns()
    BaseGridControllerAny<IQueryRunner>.UpdateTransferColumnStatus()
    BaseGridControllerAny<IQueryRunner>.OnSelectedItemsChanged(IEnumerable<IQueryRunner>)
    BaseGridControllerAny<IQueryRunner>.GetStandardExtraColumns(string)
    BaseGridControllerAny<IQueryRunner>.ReApply()
    BaseGridControllerAny<IQueryRunner>.GetPublicToggleCommand()
    BaseGridControllerAny<IQueryRunner>.GetNewGridCommand()
    BaseGridControllerAny<IQueryRunner>.GetDeleteCommand()
    BaseGridControllerAny<IQueryRunner>.DeleteCommandIsQuickAccess()
    BaseGridControllerAny<IQueryRunner>.GetUpCommand()
    BaseGridControllerAny<IQueryRunner>.GetDownCommand()
    BaseGridControllerAny<IQueryRunner>.MoveItemSequence(object, object)
    BaseGridControllerAny<IQueryRunner>.GetLookupIDsForNewItems(Func<IBaseEntity, Task>)
    BaseGridControllerAny<IQueryRunner>.RemoveItems(IEnumerable<IQueryRunner>)
    BaseGridControllerAny<IQueryRunner>.AddItem(IQueryRunner)
    BaseGridControllerAny<IQueryRunner>.ToggleSearch(bool)
    BaseGridControllerAny<IQueryRunner>.CollectionType
    BaseGridControllerAny<IQueryRunner>.Descriptor
    BaseGridControllerAny<IQueryRunner>.ListenToChanges
    BaseGridControllerAny<IQueryRunner>.RowPreviewColumns
    BaseGridControllerAny<IQueryRunner>.GridView
    BaseGridControllerAny<IQueryRunner>.CurrentGridItems
    BaseGridControllerAny<IQueryRunner>.CurrentItems
    BaseGridControllerAny<IQueryRunner>.AutoSelectFirstRow
    BaseGridControllerAny<IQueryRunner>.AddStandardColumns
    BaseGridControllerAny<IQueryRunner>.StandardColumnsUniqueGroupKey
    BaseGridControllerAny<IQueryRunner>.DefaultRowCount
    BaseGridControllerAny<IQueryRunner>.DefaultOrOverridenRowCount
    BaseGridControllerAny<IQueryRunner>.UserOverridenPagingAmount
    BaseGridControllerAny<IQueryRunner>.PagerRequired
    BaseGridControllerAny<IQueryRunner>.TotalCount
    BaseGridControllerAny<IQueryRunner>.LimitPagesToTotal
    BaseGridControllerAny<IQueryRunner>.TotalPageCount
    BaseGridControllerAny<IQueryRunner>.Sortings
    BaseGridControllerAny<IQueryRunner>.Filters
    BaseGridControllerAny<IQueryRunner>.ShowCheckboxForMultiSelect
    BaseGridControllerAny<IQueryRunner>.TogglerZeroColumn
    BaseGridControllerAny<IQueryRunner>.TransferColToggler
    BaseGridControllerAny<IQueryRunner>.ItemRowColorProperty
    BaseGridControllerAny<IQueryRunner>.CanCreateNew
    BaseGridControllerAny<IQueryRunner>.SelectedItemForSubViews
    BaseGridControllerAny<IQueryRunner>.ItemCellDisableCell
    BaseGridControllerAny<IQueryRunner>.UpdateSubViewsWhenMultipleRowSelectionChanges
    BaseGridControllerAny<IQueryRunner>.ExcelExportCommand
    BaseGridControllerAny<IQueryRunner>.AllowColumnSelection
    BaseGridControllerAny<IQueryRunner>.AllowPublicToggleCommand
    BaseGridControllerAny<IQueryRunner>.AllowSearchCommand
    BaseGridControllerAny<IQueryRunner>.AllowPageSizeCommand
    BaseGridControllerAny<IQueryRunner>.AllowClearSearchSortFilter
    BaseGridControllerAny<IQueryRunner>.ShowGrouping
    BaseGridControllerAny<IQueryRunner>.ShowFrozenColumnsSplitter
    BaseGridControllerAny<IQueryRunner>.ShowVerticalGridLines
    BaseGridControllerAny<IQueryRunner>.CanUserSelect
    BaseGridControllerAny<IQueryRunner>.AllowXMLImportExport
    BaseGridControllerAny<IQueryRunner>.AllowMultipleSelect
    BaseGridControllerAny<IQueryRunner>.AllowExcelExport
    BaseGridControllerAny<IQueryRunner>.AllowSequencing
    BaseGridControllerAny<IQueryRunner>.OpenFromRelatedColumnName
    BaseGridControllerAny<IQueryRunner>.PopulateNewFromLookupColumnName
    BaseGridControllerAny<IQueryRunner>.PreventDuplicateLookupIDs
    BaseGridControllerAny<IQueryRunner>.PopulateNewFromLookupRelationship
    BaseGridControllerAny<IQueryRunner>.SearchGroups
    BaseGridControllerAny<IQueryRunner>.SearchElements
    BaseGridController.ClearSearchSortFilter()
    BaseGridController.InitAsync()
    BaseGridController.AddCustomCommand(ICustomCommand)
    BaseGridController.ColumnGroups()
    BaseGridController.GetVisibleColumnNames()
    BaseGridController.AllPossibleSearchColumns()
    BaseGridController.SetOrdering(IEnumerable<QueryableSort>)
    BaseGridController.SetFilters(IEnumerable<QueryableFilter>)
    BaseGridController.SetSearch(string, IEnumerable<string>)
    BaseGridController.SetCreated(bool)
    BaseGridController.BulkUpdateMultipleSelectedItemsOnEdit
    BaseGridController.ComboItemsClear
    BaseGridController.DefaultColumnGroupIndexes
    BaseGridController.ExpandDefaultGroups
    BaseGridController.DefaultFrozenColumnCount
    BaseGridController.SearchColumns
    BaseGridController.Search
    BaseGridController.BaseGridView
    BaseGridController.Created
    BaseGridController.InternalFilter
    BaseGridController.IsSelected
    BaseGridController.ColumnSortings
    BaseGridController.ColumnFilters
    BaseGridController.CustomCommandParam
    BaseGridController.OnlyExportGrid
    BaseGridController.OnlyExportFromQuery
    BaseGridController.LoadPager
    BaseGridController.LoadOrOverridenPager
    BaseGridController.UserOverridenPagingVisible
    BaseGridController.CurrentPageIndex
    ModelViewController.DisplayItem(object)
    ModelViewController.GetCurrentDisplayedItem(object)
    ModelViewController.GetCanWrite(object)
    ModelViewController.ShouldDisplayItem(object)
    ModelViewController.RemoveHandlers(object)
    ModelViewController.AddHandlers(object)
    ModelViewController.RemoveCommand(ViewCommand)
    ModelViewController.RemoveCommands<TOfType>()
    ModelViewController.InsertCommand(ViewCommand, int)
    ModelViewController.InsertCommand(ViewCommand, ViewCommand, ViewCommand)
    ModelViewController.UpdateAllCommands()
    ModelViewController.GetNestedViews()
    ModelViewController.RootController
    ModelViewController.ServiceContext
    ModelViewController.UIContext
    ModelViewController.CanWrite
    ModelViewController.TrackChanges
    ModelViewController.CheckIsLockedForCanWrite
    ModelViewController.DisplayIfNull
    ModelViewController.CurrentDisplayedItem
    ModelViewController.View
    ModelViewController.Commands
    object.GetType()
    object.MemberwiseClone()
    object.ToString()
    object.Equals(object)
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    object.GetHashCode()
    Namespace: LemonEdge.Client.Core.Views.Controllers
    Assembly: LemonEdge.ClientEntities.dll
    Syntax
    public class QueryRunnersController : BaseGridController<IQueryRunner>, IBaseGridController, ICollectionExportable, INewGridItemImplementor<IQueryRunner>, ICopyGridItemImplementor<IQueryRunner>, IGrid, IDeleteGridItemImplementor<IQueryRunner>, ISearchController, IModelViewController

    Constructors

    QueryRunnersController(IBaseGrid<IQueryRunner>)

    Declaration
    public QueryRunnersController(IBaseGrid<IQueryRunner> view)
    Parameters
    Type Name Description
    IBaseGrid<IQueryRunner> view

    Properties

    AllowOpenCommand

    Indicates that by default selected entities can be opened by the user with the open command

    Declaration
    public override bool AllowOpenCommand { get; }
    Property Value
    Type Description
    bool
    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridController<LemonEdge.API.Entities.Reporting.IQueryRunner>.AllowOpenCommand

    AutoOpenNewItemInTab

    Indicates when creating a new item in the grid that it should automatically be opened in a new tab as well

    The default is true if the type IQueryRunner is an entity that is not a IsStandingDataEntity

    Declaration
    public override bool AutoOpenNewItemInTab { get; }
    Property Value
    Type Description
    bool
    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Entities.Reporting.IQueryRunner>.AutoOpenNewItemInTab

    ContextHelpURL

    An optional associated url of a help file for the view this controller works with

    Declaration
    public override string ContextHelpURL { get; }
    Property Value
    Type Description
    string
    Overrides
    ModelViewController.ContextHelpURL

    DefaultSearchColumn

    The name of the column to use in the default search of text in the grid

    Declaration
    protected override string DefaultSearchColumn { get; }
    Property Value
    Type Description
    string
    Overrides
    BaseGridController.DefaultSearchColumn

    Methods

    AlterQuery(QueryableExecuter<IQueryRunner>)

    Provides the inheriting controller an opportunity to modify the query used to load the data for this IBaseGrid<T>

    Default implementation does nothing unless the type IQueryRunner is an entity with a property with a SequenceStart, in which case it is ordered by that

    Declaration
    protected override QueryableExecuter<IQueryRunner> AlterQuery(QueryableExecuter<IQueryRunner> query)
    Parameters
    Type Name Description
    QueryableExecuter<IQueryRunner> query

    The query for this grid to always be altered before being executed

    Returns
    Type Description
    QueryableExecuter<IQueryRunner>

    The query to be used to execute results for this grid

    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Entities.Reporting.IQueryRunner>.AlterQuery(LemonEdge.Utils.QueryableExecuter<LemonEdge.API.Entities.Reporting.IQueryRunner>)

    ColumnNames()

    A list of all the columns to be dynamically created in the IBaseGrid<T>

    This is used by the system to create the actual ControlDisplayInfo classes required from the Columns() property

    You can override this to provide a simple definition of each column (combined with AlterControlInfo(ControlDisplayInfo) for more detail), or you can just override Columns() and ignore this
    Declaration
    protected override IEnumerable<ControlDisplayInfoLight> ColumnNames()
    Returns
    Type Description
    IEnumerable<ControlDisplayInfoLight>

    A list of all the columns to be dynamically created in the IBaseGrid<T>

    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Entities.Reporting.IQueryRunner>.ColumnNames()

    InitCommands(IList<ViewCommand>)

    Adds the following commands, if the associated AllowXXXCommand property returns true: A public toggle, multi-select row, open, column visiblitiy, transfer visible, search, view cancelled, view system, export, new, copy, move up/down, xml export, and delete commands

    Declaration
    protected override void InitCommands(IList<ViewCommand> commands)
    Parameters
    Type Name Description
    IList<ViewCommand> commands

    The initial set of commands for this view

    Overrides
    BaseGridControllerAny<IQueryRunner>.InitCommands(IList<ViewCommand>)

    UpdateNewItem(IQueryRunner)

    Provides an inheriting controller an opportunity to alter the newly created item by the grid before it is added to the IBaseGrid<T> itself

    By default this ensures the item has the next maximum sequence number if the item is an entity that has a property with a SequenceStart

    Declaration
    protected override Task UpdateNewItem(IQueryRunner item)
    Parameters
    Type Name Description
    IQueryRunner item

    The newly created item to be added to the grid

    Returns
    Type Description
    Task

    A task indicating the completion of the operation

    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Entities.Reporting.IQueryRunner>.UpdateNewItem(LemonEdge.API.Entities.Reporting.IQueryRunner)

    Implements

    IBaseGridController
    ICollectionExportable
    INewGridItemImplementor<T>
    ICopyGridItemImplementor<T>
    IGrid
    IDeleteGridItemImplementor<T>
    ISearchController
    IModelViewController

    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.