Search Results for

    Show / Hide Table of Contents

    Class SQLWrapperDatasetReferenceGrid

    Inheritance
    object
    ModelViewController
    BaseGridController
    BaseGridControllerAny<SQLWrapperDatasetReference>
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>
    SQLWrapperDatasetReferenceGrid
    Implements
    IBaseGridController
    ICollectionExportable
    INewGridItemImplementor<SQLWrapperDatasetReference>
    ICopyGridItemImplementor<SQLWrapperDatasetReference>
    IGrid
    IDeleteGridItemImplementor<SQLWrapperDatasetReference>
    ISearchController
    IModelViewController
    Inherited Members
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.GetGridController(IBaseGridAnyRelatedAnyCollection<SQLWrapperDatasetReference>)
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.AlterQuery(QueryableExecuter<SQLWrapperDatasetReference>)
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.UpdateNewItem(SQLWrapperDatasetReference)
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.SingleItem
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.CollectionRelationshipColumnNameLabel
    BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>.PopulateNewFromLookupColumnName
    BaseGridControllerAny<SQLWrapperDatasetReference>.CanDelete(SQLWrapperDatasetReference)
    BaseGridControllerAny<SQLWrapperDatasetReference>.Clear()
    BaseGridControllerAny<SQLWrapperDatasetReference>.CloseController()
    BaseGridControllerAny<SQLWrapperDatasetReference>.Redisplay()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetGridController(IBaseGrid<SQLWrapperDatasetReference>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetInternalDescriptor()
    BaseGridControllerAny<SQLWrapperDatasetReference>.CanEditRowItem(SQLWrapperDatasetReference)
    BaseGridControllerAny<SQLWrapperDatasetReference>.CanEditRowItem(SQLWrapperDatasetReference, short)
    BaseGridControllerAny<SQLWrapperDatasetReference>.OnTrackedItemChanged(object, string)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetGridSourceItems(IEnumerable<SQLWrapperDatasetReference>, QueryableExecuterApplyType)
    BaseGridControllerAny<SQLWrapperDatasetReference>.AlterLoadedItems(IEnumerable<SQLWrapperDatasetReference>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.LoadExtendedItem(Type, object)
    BaseGridControllerAny<SQLWrapperDatasetReference>.InitDisplay()
    BaseGridControllerAny<SQLWrapperDatasetReference>.ResetColumnsAndGroups(bool)
    BaseGridControllerAny<SQLWrapperDatasetReference>.DisplayUI()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetItemToReselect(object)
    BaseGridControllerAny<SQLWrapperDatasetReference>.LoadAdditionalColumns()
    BaseGridControllerAny<SQLWrapperDatasetReference>.AddCol(short, ControlDisplayInfoLight, EntityDescriptor)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ColumnNames()
    BaseGridControllerAny<SQLWrapperDatasetReference>.PivotColumns(short)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ApplyGridSettingsToFilter(QueryableExecuter)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ApplyPaging(QueryableExecuter)
    BaseGridControllerAny<SQLWrapperDatasetReference>.SetTotalCount(int)
    BaseGridControllerAny<SQLWrapperDatasetReference>.SetPageIndex(int)
    BaseGridControllerAny<SQLWrapperDatasetReference>.TrackResults(IEnumerable<SQLWrapperDatasetReference>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.AlterColumnInfo(ControlDisplayInfo)
    BaseGridControllerAny<SQLWrapperDatasetReference>.UpdateColumnFromName(string)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetExportableColumnInfo(IEnumerable<ColumnDescriptor>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.IsZeroColumnColumnVisible(string)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ToggleZeroColumns()
    BaseGridControllerAny<SQLWrapperDatasetReference>.UpdateAllZeroColumns()
    BaseGridControllerAny<SQLWrapperDatasetReference>.UpdateTransferColumnStatus()
    BaseGridControllerAny<SQLWrapperDatasetReference>.OnSelectedItemsChanged(IEnumerable<SQLWrapperDatasetReference>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetStandardExtraColumns(string)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ReApply()
    BaseGridControllerAny<SQLWrapperDatasetReference>.InitCommands(IList<ViewCommand>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetPublicToggleCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetOpenGridCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetNewGridCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetCopyGridCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetDeleteCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.DeleteCommandIsQuickAccess()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetUpCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetDownCommand()
    BaseGridControllerAny<SQLWrapperDatasetReference>.MoveItemSequence(object, object)
    BaseGridControllerAny<SQLWrapperDatasetReference>.OnOpenRowItem(SQLWrapperDatasetReference)
    BaseGridControllerAny<SQLWrapperDatasetReference>.GetLookupIDsForNewItems(Func<IBaseEntity, Task>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.RemoveItems(IEnumerable<SQLWrapperDatasetReference>)
    BaseGridControllerAny<SQLWrapperDatasetReference>.AddItem(SQLWrapperDatasetReference)
    BaseGridControllerAny<SQLWrapperDatasetReference>.ToggleSearch(bool)
    BaseGridControllerAny<SQLWrapperDatasetReference>.CollectionType
    BaseGridControllerAny<SQLWrapperDatasetReference>.Descriptor
    BaseGridControllerAny<SQLWrapperDatasetReference>.ListenToChanges
    BaseGridControllerAny<SQLWrapperDatasetReference>.RowPreviewColumns
    BaseGridControllerAny<SQLWrapperDatasetReference>.GridView
    BaseGridControllerAny<SQLWrapperDatasetReference>.CurrentGridItems
    BaseGridControllerAny<SQLWrapperDatasetReference>.CurrentItems
    BaseGridControllerAny<SQLWrapperDatasetReference>.AutoSelectFirstRow
    BaseGridControllerAny<SQLWrapperDatasetReference>.AddStandardColumns
    BaseGridControllerAny<SQLWrapperDatasetReference>.StandardColumnsUniqueGroupKey
    BaseGridControllerAny<SQLWrapperDatasetReference>.DefaultRowCount
    BaseGridControllerAny<SQLWrapperDatasetReference>.DefaultOrOverridenRowCount
    BaseGridControllerAny<SQLWrapperDatasetReference>.UserOverridenPagingAmount
    BaseGridControllerAny<SQLWrapperDatasetReference>.PagerRequired
    BaseGridControllerAny<SQLWrapperDatasetReference>.TotalCount
    BaseGridControllerAny<SQLWrapperDatasetReference>.LimitPagesToTotal
    BaseGridControllerAny<SQLWrapperDatasetReference>.TotalPageCount
    BaseGridControllerAny<SQLWrapperDatasetReference>.Sortings
    BaseGridControllerAny<SQLWrapperDatasetReference>.Filters
    BaseGridControllerAny<SQLWrapperDatasetReference>.ShowCheckboxForMultiSelect
    BaseGridControllerAny<SQLWrapperDatasetReference>.TogglerZeroColumn
    BaseGridControllerAny<SQLWrapperDatasetReference>.TransferColToggler
    BaseGridControllerAny<SQLWrapperDatasetReference>.ItemRowColorProperty
    BaseGridControllerAny<SQLWrapperDatasetReference>.CanCreateNew
    BaseGridControllerAny<SQLWrapperDatasetReference>.SelectedItemForSubViews
    BaseGridControllerAny<SQLWrapperDatasetReference>.ItemCellDisableCell
    BaseGridControllerAny<SQLWrapperDatasetReference>.UpdateSubViewsWhenMultipleRowSelectionChanges
    BaseGridControllerAny<SQLWrapperDatasetReference>.ExcelExportCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.NewItemHelper
    BaseGridControllerAny<SQLWrapperDatasetReference>.CopyItemHelper
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowColumnSelection
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowPublicToggleCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowSearchCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowPageSizeCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowClearSearchSortFilter
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowOpenCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowDeleteCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowNewCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowCopyCommand
    BaseGridControllerAny<SQLWrapperDatasetReference>.ShowGrouping
    BaseGridControllerAny<SQLWrapperDatasetReference>.ShowFrozenColumnsSplitter
    BaseGridControllerAny<SQLWrapperDatasetReference>.ShowVerticalGridLines
    BaseGridControllerAny<SQLWrapperDatasetReference>.CanUserSelect
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowXMLImportExport
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowMultipleSelect
    BaseGridControllerAny<SQLWrapperDatasetReference>.AllowSequencing
    BaseGridControllerAny<SQLWrapperDatasetReference>.AutoOpenNewItemInTab
    BaseGridControllerAny<SQLWrapperDatasetReference>.OpenFromRelatedColumnName
    BaseGridControllerAny<SQLWrapperDatasetReference>.PreventDuplicateLookupIDs
    BaseGridControllerAny<SQLWrapperDatasetReference>.PopulateNewFromLookupRelationship
    BaseGridControllerAny<SQLWrapperDatasetReference>.SearchGroups
    BaseGridControllerAny<SQLWrapperDatasetReference>.SearchElements
    BaseGridController.ClearSearchSortFilter()
    BaseGridController.InitAsync()
    BaseGridController.AddCustomCommand(ICustomCommand)
    BaseGridController.ProcessCustomCommandResult(object)
    BaseGridController.ColumnGroups()
    BaseGridController.GetQueryForExcelResults()
    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.DefaultSearchColumn
    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
    ModelViewController.ContextHelpURL
    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 SQLWrapperDatasetReferenceGrid : BaseGridAnyRelatedAnyCollectionController<SQLWrapperDatasetReference>, IBaseGridController, ICollectionExportable, INewGridItemImplementor<SQLWrapperDatasetReference>, ICopyGridItemImplementor<SQLWrapperDatasetReference>, IGrid, IDeleteGridItemImplementor<SQLWrapperDatasetReference>, ISearchController, IModelViewController

    Constructors

    SQLWrapperDatasetReferenceGrid(IBaseGridAnyRelatedAnyCollection<SQLWrapperDatasetReference>)

    Declaration
    public SQLWrapperDatasetReferenceGrid(IBaseGridAnyRelatedAnyCollection<SQLWrapperDatasetReference> view)
    Parameters
    Type Name Description
    IBaseGridAnyRelatedAnyCollection<SQLWrapperDatasetReference> view

    Properties

    AllowExcelExport

    Indicates the command to allow the grid data to be exported by the user is included in the InitCommands(IList<ViewCommand>)

    The default is true

    Declaration
    public override bool AllowExcelExport { get; }
    Property Value
    Type Description
    bool
    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Core.Processors.Importing.SQLWrapperDatasetReference>.AllowExcelExport

    CollectionRelationshipColumnName

    This is the property on the SQLWrapperDatasetReference entities that holds a relationship value that points to the SingleItem type

    This controller will automatically use that to filter the correct entities for the grid in AlterQuery(QueryableExecuter<T>)

    Declaration
    public override string CollectionRelationshipColumnName { get; }
    Property Value
    Type Description
    string
    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridAnyRelatedAnyCollectionController<LemonEdge.API.Core.Processors.Importing.SQLWrapperDatasetReference>.CollectionRelationshipColumnName

    Methods

    Columns()

    Provides a list of all the columns to be created against the IBaseGrid<T> by this control

    The default behaviour is to enumerate ColumnNames() and create the list automatically. You can also override AlterColumnInfo(ControlDisplayInfo) to provide more detail for specific columns

    Alternatively you can override this to explicitly define them
    Declaration
    public override IEnumerable<ControlDisplayInfo> Columns()
    Returns
    Type Description
    IEnumerable<ControlDisplayInfo>

    A list of all the columns to be created against the IBaseGrid<T> by this control

    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Core.Processors.Importing.SQLWrapperDatasetReference>.Columns()

    GetGridSourceItems()

    A function that must be implemented by inheriting classes that returns the list of items to be displayed against the grid given all active filters, sorting, searches, paging, etc

    Declaration
    public override Task<IEnumerable<SQLWrapperDatasetReference>> GetGridSourceItems()
    Returns
    Type Description
    Task<IEnumerable<SQLWrapperDatasetReference>>

    A list of items to be displayed against the grid given all active filters, sorting, searches, paging, etc

    Overrides
    LemonEdge.Client.Core.Views.Core.BaseGridControllerAny<LemonEdge.API.Core.Processors.Importing.SQLWrapperDatasetReference>.GetGridSourceItems()

    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.