C# Class DotNetNuke.Modules.UserDefinedTable.SqlDataProvider

The SqlDataProvider Class is an SQL Server implementation of the DataProvider Abstract class that provides the DataLayer for the UserDefinedTables Module.

Inheritance: DotNetNuke.Modules.UserDefinedTable.Components.DataProvider

Mostrar archivo Open project: DNNCommunity/DNN.FormAndList

Public Methods

Method	Description
AddData ( int UserDefinedRowId, int UserDefinedFieldId, string FieldValue ) : void
AddField ( int ModuleId, string FieldTitle, int BeforePos, 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 ModuleId ) : int
DeleteData ( int UserDefinedRowId, int UserDefinedFieldId ) : void
DeleteField ( int UserDefinedFieldId ) : void
DeleteRow ( int UserDefinedRowId, int ModuleId ) : void
DeleteRows ( int ModuleId ) : void
FillDefaultData ( int ModuleId, int FieldId, string DefaultValue ) : void
GetData ( int UserDefinedRowId, int UserDefinedFieldId ) : IDataReader
GetField ( int UserDefinedFieldId ) : IDataReader
GetFieldDataCount ( int UserDefinedFieldID ) : int
GetFieldSettings ( int moduleId ) : IDataReader
GetFields ( int ModuleId ) : IDataReader
GetMaxFieldSize ( ) : int
GetRow ( int UserDefinedRowId, int ModuleId ) : IDataReader
GetRows ( int ModuleId ) : IDataReader
Reset ( int ModuleId ) : void
SetFieldOrder ( int UserDefinedFieldID, int FieldOrder ) : void
SqlDataProvider ( ) : System
SwapFieldOrder ( int FirstUserDefinedFieldId, int SecondUserDefinedFieldId ) : void
UpdateData ( int rowId, string>.IDictionary values ) : void
UpdateData ( int UserDefinedRowId, int UserDefinedFieldId, string FieldValue ) : 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
UpdateFieldSetting ( int fieldid, string key, string value ) : void

Private Methods

Method	Description
GetNull ( object Field ) : object

Method Details

AddData() public method

public AddData ( int UserDefinedRowId, int UserDefinedFieldId, string FieldValue ) : void
UserDefinedRowId	int
UserDefinedFieldId	int
FieldValue	string
return	void

AddField() public method

public AddField ( int ModuleId, string FieldTitle, int BeforePos, 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
ModuleId	int
FieldTitle	string
BeforePos	int
HelpText	string
Required	bool
FieldType	string
Default	string
Visible	bool
ShowOnEdit	bool
Searchable	bool
IsPrivateColumn	bool
MultipleValues	bool
InputSettings	string
OutputSettings	string
NormalizeFlag	bool
validationRule	string
validationMessage	string
EditStyle	string
return	int

AddRow() public method

public AddRow ( int ModuleId ) : int
ModuleId	int
return	int

DeleteData() public method

public DeleteData ( int UserDefinedRowId, int UserDefinedFieldId ) : void
UserDefinedRowId	int
UserDefinedFieldId	int
return	void

DeleteField() public method

public DeleteField ( int UserDefinedFieldId ) : void
UserDefinedFieldId	int
return	void

DeleteRow() public method

public DeleteRow ( int UserDefinedRowId, int ModuleId ) : void
UserDefinedRowId	int
ModuleId	int
return	void

DeleteRows() public method

public DeleteRows ( int ModuleId ) : void
ModuleId	int
return	void

FillDefaultData() public method

public FillDefaultData ( int ModuleId, int FieldId, string DefaultValue ) : void
ModuleId	int
FieldId	int
DefaultValue	string
return	void

GetData() public method

public GetData ( int UserDefinedRowId, int UserDefinedFieldId ) : IDataReader
UserDefinedRowId	int
UserDefinedFieldId	int
return	IDataReader

GetField() public method

public GetField ( int UserDefinedFieldId ) : IDataReader
UserDefinedFieldId	int
return	IDataReader

GetFieldDataCount() public method

public GetFieldDataCount ( int UserDefinedFieldID ) : int
UserDefinedFieldID	int
return	int

GetFieldSettings() public method

public GetFieldSettings ( int moduleId ) : IDataReader
moduleId	int
return	IDataReader

GetFields() public method

public GetFields ( int ModuleId ) : IDataReader
ModuleId	int
return	IDataReader

GetMaxFieldSize() public method

public GetMaxFieldSize ( ) : int
return	int

GetRow() public method

public GetRow ( int UserDefinedRowId, int ModuleId ) : IDataReader
UserDefinedRowId	int
ModuleId	int
return	IDataReader

GetRows() public method

public GetRows ( int ModuleId ) : IDataReader
ModuleId	int
return	IDataReader

Reset() public method

public Reset ( int ModuleId ) : void
ModuleId	int
return	void

SetFieldOrder() public method

public SetFieldOrder ( int UserDefinedFieldID, int FieldOrder ) : void
UserDefinedFieldID	int
FieldOrder	int
return	void

SqlDataProvider() public method

public SqlDataProvider ( ) : System
return	System

SwapFieldOrder() public method

public SwapFieldOrder ( int FirstUserDefinedFieldId, int SecondUserDefinedFieldId ) : void
FirstUserDefinedFieldId	int
SecondUserDefinedFieldId	int
return	void

UpdateData() public method

public UpdateData ( int rowId, string>.IDictionary values ) : void
rowId	int
values	string>.IDictionary
return	void

UpdateData() public method

public UpdateData ( int UserDefinedRowId, int UserDefinedFieldId, string FieldValue ) : void
UserDefinedRowId	int
UserDefinedFieldId	int
FieldValue	string
return	void

UpdateField() public method

public 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
UserDefinedFieldId	int
FieldTitle	string
HelpText	string
Required	bool
FieldType	string
Default	string
Visible	bool
ShowOnEdit	bool
Searchable	bool
IsPrivateColumn	bool
MultipleValues	bool
InputSettings	string
OutputSettings	string
NormalizeFlag	bool
validationRule	string
validationMessage	string
EditStyle	string
return	void

UpdateFieldSetting() public method

public UpdateFieldSetting ( int fieldid, string key, string value ) : void
fieldid	int
key	string
value	string
return	void