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

Show file 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