C# Class DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController

The UserDefinedTableController class provides Business Layer methods of UDT for managing, editing and diplaying User Defined Table
Inheritance: DotNetNuke.Modules.UserDefinedTable.Components.BaseController
Mostrar archivo Open project: DNNCommunity/DNN.FormAndList Class Usage Examples

Public Methods

Method Description
ColumnNameByDataType ( DataSet ds, string dataType ) : string

Returns the name of the first column with a given column type (valuable for Track Columns)

Context ( ) : DataTable
Context ( DotNetNuke.Entities.Modules.ModuleInfo moduleInfo, DotNetNuke.Entities.Users.UserInfo userInfo, string searchInput, string orderBy, string orderDirection, string paging ) : DataTable

Provides a list of context variables for XML output

Context ( string searchInput, string orderBy, string orderDirection, string paging ) : DataTable
DeleteRow ( int userDefinedRowId ) : void

deletes a data row in the database

DeleteRows ( ) : void

deletes all data rows of a module in the database

FieldHasData ( int fieldId ) : bool
FillDefaultData ( int fieldId, string defaultExpression ) : void

fills all missing values for a field in all rows with default values. If not default is provided or all fields are already initialized, nothing is changed.

GetDataSet ( ) : DataSet

Gets all Data values of an UDT table (module) from the Database as DataSet

GetDataSet ( bool withPreRenderedValues ) : DataSet

Gets all Data values of an UDT table (module) from the Database as DataSet

GetDataSet ( int moduleId ) : DataSet

Gets all Data values of an UDT table (module) from the Database as DataSet

GetRow ( int userDefinedRowId ) : DataSet
GetRow ( int userDefinedRowId, bool withPreRenderedValues, bool filterScript = false ) : DataSet
GetSchemaDataset ( ) : DataSet
RenderValuesToHtmlInsideDataSet ( DataSet ds, bool filterScript = false ) : void
ResetModule ( ) : void

delete a whole table of a module.

SetEditLinksAndVisibilityBasedOnPermissions ( DataSet ds ) : void
UpdateRow ( DataSet ds ) : void
UpdateRow ( DataSet ds, int rowNr, bool isDataToImport ) : void
UserDefinedTableController ( ) : System
UserDefinedTableController ( DotNetNuke.Entities.Modules.ModuleInfo moduleinfo ) : System
UserDefinedTableController ( DotNetNuke.UI.Modules.ModuleInstanceContext moduleContext ) : System
UserDefinedTableController ( int moduleid ) : System
UserDefinedTableController ( int moduleId, int tabId, DotNetNuke.Entities.Users.UserInfo userInfo ) : System

Private Methods

Method Description
AddField ( string fieldtitle ) : int
AddField ( string fieldTitle, int before, string helpText, bool required, string fieldType, string Default, bool visible, bool showOnEdit, bool searchable, bool isPrivateColumn, bool multipleValues, string inputSettings, string outputSettings, bool normalizeFlag, string validationRule, string validationMessage, string editStyle ) : int
AddRow ( ) : int

add a new data row in the database

BuildMainDataSet ( DataTable fieldsTable, IDataReader dr, bool rowMode ) : DataSet
DeleteField ( int userDefinedFieldId ) : void
GetFieldsTable ( ) : DataTable
GetFieldsTable ( bool addNewColumn ) : DataTable
GetFieldsTable ( bool addNewColumn, bool addAuditColumns ) : DataTable
GetMaxFieldSize ( ) : int
SwapFieldOrder ( int firstUserDefinedFieldId, int secondUserDefinedFieldId ) : void
UpdateData ( int rowId, string>.IDictionary values ) : void
UpdateField ( int userDefinedFieldId, string fieldTitle, string helpText, bool required, string fieldType, string Default, bool visible, bool showOnEdit, bool searchable, bool isPrivateColumn, bool multipleValues, string inputSettings, string outputSettings, bool normalizeFlag, string validationRule, string validationMessage, string editStyle ) : void

Method Details

ColumnNameByDataType() public method

Returns the name of the first column with a given column type (valuable for Track Columns)
public ColumnNameByDataType ( DataSet ds, string dataType ) : string
ds System.Data.DataSet DataSet with column definitions
dataType string type to be searched
return string

Context() public method

public Context ( ) : DataTable
return System.Data.DataTable

Context() public method

Provides a list of context variables for XML output
public Context ( DotNetNuke.Entities.Modules.ModuleInfo moduleInfo, DotNetNuke.Entities.Users.UserInfo userInfo, string searchInput, string orderBy, string orderDirection, string paging ) : DataTable
moduleInfo DotNetNuke.Entities.Modules.ModuleInfo
userInfo DotNetNuke.Entities.Users.UserInfo
searchInput string
orderBy string
orderDirection string
paging string
return System.Data.DataTable

Context() public method

public Context ( string searchInput, string orderBy, string orderDirection, string paging ) : DataTable
searchInput string
orderBy string
orderDirection string
paging string
return System.Data.DataTable

DeleteRow() public method

deletes a data row in the database
public DeleteRow ( int userDefinedRowId ) : void
userDefinedRowId int ID of the row to be deleted
return void

DeleteRows() public method

deletes all data rows of a module in the database
public DeleteRows ( ) : void
return void

FieldHasData() public method

public FieldHasData ( int fieldId ) : bool
fieldId int
return bool

FillDefaultData() public method

fills all missing values for a field in all rows with default values. If not default is provided or all fields are already initialized, nothing is changed.
public FillDefaultData ( int fieldId, string defaultExpression ) : void
fieldId int ID of the Field. /// If this param is omitted, all fields will be applied.
defaultExpression string Expression to be filled in, either constant or /// containing tokens.
return void

GetDataSet() public method

Gets all Data values of an UDT table (module) from the Database as DataSet
public GetDataSet ( ) : DataSet
return System.Data.DataSet

GetDataSet() public method

Gets all Data values of an UDT table (module) from the Database as DataSet
public GetDataSet ( bool withPreRenderedValues ) : DataSet
withPreRenderedValues bool specifies, whether links, dates etc. shall be prerendered for XML output
return System.Data.DataSet

GetDataSet() public method

Gets all Data values of an UDT table (module) from the Database as DataSet
public GetDataSet ( int moduleId ) : DataSet
moduleId int
return System.Data.DataSet

GetRow() public method

public GetRow ( int userDefinedRowId ) : DataSet
userDefinedRowId int
return System.Data.DataSet

GetRow() public method

public GetRow ( int userDefinedRowId, bool withPreRenderedValues, bool filterScript = false ) : DataSet
userDefinedRowId int
withPreRenderedValues bool
filterScript bool
return System.Data.DataSet

GetSchemaDataset() public method

public GetSchemaDataset ( ) : DataSet
return System.Data.DataSet

RenderValuesToHtmlInsideDataSet() public method

public RenderValuesToHtmlInsideDataSet ( DataSet ds, bool filterScript = false ) : void
ds System.Data.DataSet
filterScript bool
return void

ResetModule() public method

delete a whole table of a module.
public ResetModule ( ) : void
return void

SetEditLinksAndVisibilityBasedOnPermissions() public method

public SetEditLinksAndVisibilityBasedOnPermissions ( DataSet ds ) : void
ds System.Data.DataSet
return void

UpdateRow() public method

public UpdateRow ( DataSet ds ) : void
ds System.Data.DataSet
return void

UpdateRow() public method

public UpdateRow ( DataSet ds, int rowNr, bool isDataToImport ) : void
ds System.Data.DataSet
rowNr int
isDataToImport bool
return void

UserDefinedTableController() public method

public UserDefinedTableController ( ) : System
return System

UserDefinedTableController() public method

public UserDefinedTableController ( DotNetNuke.Entities.Modules.ModuleInfo moduleinfo ) : System
moduleinfo DotNetNuke.Entities.Modules.ModuleInfo
return System

UserDefinedTableController() public method

public UserDefinedTableController ( DotNetNuke.UI.Modules.ModuleInstanceContext moduleContext ) : System
moduleContext DotNetNuke.UI.Modules.ModuleInstanceContext
return System

UserDefinedTableController() public method

public UserDefinedTableController ( int moduleid ) : System
moduleid int
return System

UserDefinedTableController() public method

public UserDefinedTableController ( int moduleId, int tabId, DotNetNuke.Entities.Users.UserInfo userInfo ) : System
moduleId int
tabId int
userInfo DotNetNuke.Entities.Users.UserInfo
return System