Class ViewSetting

Namespace

Dynamicweb.DataManagement

Assembly

Dynamicweb.DataManagement.dll

View settings class

public class ViewSetting : DbObject

Inheritance

object

DbObject

ViewSetting

Inherited Members

DbObject._id

DbObject._tableName

DbObject._keyField

DbObject.ID

DbObject.IsNew

DbObject.Delete()

DbObject.Delete(int)

DbObject.Load(int)

DbObject.Save()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

ViewSetting()

Defaulkt constructor

public ViewSetting()

Properties

AllQueryVariables

Collection of all query variables

public IEnumerable<QueryVariable> AllQueryVariables { get; }

Property Value

IEnumerable<QueryVariable>

IEnumerable(Of QueryVariable)

Columns

View columns

public IEnumerable<ViewColumn> Columns { get; }

Property Value

IEnumerable<ViewColumn>

Connection

Connection

public DMConnection Connection { get; set; }

Property Value

DMConnection

DMConnection object

ConnectionDBName

Database name

public string ConnectionDBName { get; set; }

Property Value

string

ConnectionID

Connection ID

public int ConnectionID { get; set; }

Property Value

int

CurrentTestVariables

Gets and sets current test variables

public Dictionary<string, string> CurrentTestVariables { get; set; }

Property Value

Dictionary<string, string>

Dictionary of kv-pairs of test variables

Data

Data

public DataTable Data { get; }

Property Value

DataTable

DataTable object

IsDesigner

Shows if current ViewSetting is designer

public bool IsDesigner { get; }

Property Value

bool

IsVariablesListComplete

Shows if variables list complete

public bool IsVariablesListComplete { get; }

Property Value

bool

Name

Name

public string Name { get; set; }

Property Value

string

Query

Query

public Criteria Query { get; set; }

Property Value

Criteria

TableName

Name of table

public string TableName { get; }

Property Value

string

Methods

Fill(IDataReader)

Fills ViewSetting object with DataReader data

public override void Fill(IDataReader dataReader)

Parameters

dataReader IDataReader

DataReader object

FillRow(DataRow)

Fills cirret ViewSetting with DataRow data

protected override void FillRow(DataRow row)

Parameters

row DataRow

DataRow object

GetDataForCriteria(Criteria)

Gets data by createria

public DataTable GetDataForCriteria(Criteria criteria)

Parameters

criteria Criteria

Criteria object

Returns

DataTable

DataTable object with filtered data

GetNativeQueryString()

Provides current connection data cruterau as native string

public string GetNativeQueryString()

Returns

string

String result

GetViewSettingById(int)

Gets ViewSetting by specified ID

public static ViewSetting GetViewSettingById(int id)

Parameters

id int

ViewSetting ID

Returns

ViewSetting

ViewSetting object. If ID is invalid the result will be 'Nothing'

GetViewSettings()

Gets collection of ViewSettings

public static ViewSettingCollection GetViewSettings()

Returns

ViewSettingCollection

GetViewSettingsBySql(string)

Gets ViewSettings using sql command text

public static ViewSettingCollection GetViewSettingsBySql(string sqlCommandText)

Parameters

sqlCommandText string

Sql command text

Returns

ViewSettingCollection

Collection of ViewSettings

GetXML()

Provides current object data in xml format

public XmlDocument GetXML()

Returns

XmlDocument