Click or drag to resize

DataGrid Class

Settings and handling for data view of data list
Inheritance Hierarchy
System.Object
  SOWIData.Database.Connector<DataGrid>
    SOWIApp.Management.Data.DataGrid

Namespace:  SOWIApp.Management.Data
Assembly:  SOWIApp.Management (in SOWIApp.Management.dll) Version: 19.1.23.1 (19.1.23.622)
Syntax
public class DataGrid : Connector<DataGrid>

The DataGrid type exposes the following members.

Constructors
  NameDescription
Public methodDataGrid()
Standard database setting
Public methodDataGrid(String)
Standard database setting with definite User name
Public methodDataGrid(String, String)
Definite database setting and User name
Top
Properties
  NameDescription
Public propertyConnectionString
Gives database connection string of the app used
(Inherited from Connector<DataItemClass>.)
Protected propertyDB
Database object. Sets with method SetDB.
(Inherited from Connector<DataItemClass>.)
Public propertyNameUnchanged
Flag no change value in field Name Default: false
(Inherited from Connector<DataItemClass>.)
Public propertyNameUnique
Flag whether Name unique Default: false
(Inherited from Connector<DataItemClass>.)
Protected propertyProvider
Gives data provider type back.
(Inherited from Connector<DataItemClass>.)
Public propertyRecordStandard
Which data items read from database? All, active or archived records.
(Inherited from Connector<DataItemClass>.)
Public propertySortDirectionStandard
Standard sort direction by sort field for example method GeAll
(Inherited from Connector<DataItemClass>.)
Public propertySortFieldStandard
Standard sort field for example method GeAll
(Inherited from Connector<DataItemClass>.)
Public propertyUserName
Gives user name of the app used
(Inherited from Connector<DataItemClass>.)
Protected propertyXML
XML object. Sets with method SetDB
(Inherited from Connector<DataItemClass>.)
Top
Methods
  NameDescription
Public methodCount(Records)
Gives the count by all, active or archive data records
(Inherited from Connector<DataItemClass>.)
Public methodCount(String, Records)
Gives the count by all, active or archive data records and filtering by Name
(Inherited from Connector<DataItemClass>.)
Public methodCode exampleDelete(List<Int32>)
Delete all data items
(Inherited from Connector<DataItemClass>.)
Public methodDelete(Int32)
Delete a data item - set Status = Delete (except XML provider)
(Inherited from Connector<DataItemClass>.)
Public methodDelete(String)
Delete data item by Name
(Inherited from Connector<DataItemClass>.)
Protected methodDeleteByUser
Delete all data items by user name
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExist(Int32)
Check exist data item by ID (hits can be multiple)
(Inherited from Connector<DataItemClass>.)
Public methodExist(String)
Check exist data item by Name (can be multiple)
(Inherited from Connector<DataItemClass>.)
Public methodExistOne
Check exist one data item by Name
(Inherited from Connector<DataItemClass>.)
Public methodExistView
Check exists Data Grid View
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetAll()
Get data list by standards value without parameter.
(Inherited from Connector<DataItemClass>.)
Public methodGetAll(Records)
Get data list by Records (all, active, archived)
(Inherited from Connector<DataItemClass>.)
Public methodGetAll(String, SortDirections)
Get data list details with sort parameters
(Inherited from Connector<DataItemClass>.)
Public methodGetAll(String, Operators, Object)
Get data list by search parameter.
(Inherited from Connector<DataItemClass>.)
Public methodGetAll(String, SortDirections, String, Operators, Object, Records)
Get data list with all parameters.
(Inherited from Connector<DataItemClass>.)
Public methodGetAppNameList
List of App names in table DataGrid
Public methodGetByID
Gives one data item by ID
(Inherited from Connector<DataItemClass>.)
Public methodGetByName
Data item search by field Name
(Inherited from Connector<DataItemClass>.)
Public methodGetByView
Gives a data list DataGrid from database by App, View and User name order by field Order, OrderDefault
Public methodGetClientNameList
List of Client names from table Client
Public methodStatic memberGetDataGridViewFromProperties
Create data list of DataGrid from list of property
Protected methodGetDataGridViewTemplate
Check first exists "TemplateClient" and secound exists "TemplateDatabase" in table DataGrid. If no exists the template then create a template by reference to data class and save this in database as TemplateDatabase.
Public methodGetDataGridViewTemplates
Gives all Data Grid View list by Template Database and Client
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Protected methodGetList
Gives raw data list and is basis for all data processing
(Overrides Connector<DataItemClass>.GetList().)
Public methodGetTableNameList
List of Table names in table DataGrid
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGetUserNameList
List of User names in table DataGrid
Public methodGetViewNameList
List of View names in table DataGrid
Public methodInsert(List<DataItemClass>)
Insert list of data items
(Inherited from Connector<DataItemClass>.)
Public methodInsert(DataItemClass)
Insert data item
(Inherited from Connector<DataItemClass>.)
Public methodInsertOrUpdateByName
If not exists data record by Name then call method Insert. If exists data record unique then call method Update. If more data records then trigger an exception DataFoundMoreAsOne
(Inherited from Connector<DataItemClass>.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodResetClient
Data Grid View client App reset to database setting
Public methodSetDataGridView
Save data records of Data Grid View
Public methodSetDataGridViewItem
Save data record of Data Grid View item
Protected methodSetDB
Set database
(Overrides Connector<DataItemClass>.SetDB().)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUpdate(List<DataItemClass>)
Data list update
(Inherited from Connector<DataItemClass>.)
Public methodUpdate(DataItemClass)
Data item update
(Inherited from Connector<DataItemClass>.)
Public methodUpdateClient
Crate or update Client Data Grid View setting
Public methodValidate
Validate data item
(Inherited from Connector<DataItemClass>.)
Top
Fields
  NameDescription
Public fieldDBActionAfter
Triggered by methods Get*, Insert, Update and Delete
(Inherited from Connector<DataItemClass>.)
Public fieldDBActionBefore
Triggered by methods Get*, Insert, Update and Delete
(Inherited from Connector<DataItemClass>.)
Protected fieldDBActionDone
Triggered by methods Get*, Insert, Update and Delete
(Inherited from Connector<DataItemClass>.)
Protected fieldDBActionPermission
Triggered by methods Get*, Insert, Update and Delete
(Inherited from Connector<DataItemClass>.)
Protected fieldCode exampleDBActionPrepare
Triggered by methods Get*, Insert, Update and Delete
(Inherited from Connector<DataItemClass>.)
Protected fieldValidating
Triggered by method Validate
(Inherited from Connector<DataItemClass>.)
Top
Extension Methods
  NameDescription
Public Extension MethodGetObjectToBytes
Convert an object to byte array
(Defined by Extensions.)
Public Extension MethodIsNumber
Check is value a number
(Defined by Convert.)
Public Extension MethodToHTMLDisplay(DataGrid, TempDataDictionary)Overloaded. (Defined by Extensions.)
Public Extension MethodCode exampleToHTMLDisplay(String, DataGridDataTypes, String, String, String, String, TempDataDictionary)Overloaded.
Gives HTML code for display.
(Defined by Extensions.)
Public Extension MethodToHTMLEditor(DataGrid, TempDataDictionary, String)Overloaded. (Defined by Extensions.)
Public Extension MethodToHTMLEditor(String, DataGridDataTypes, String, String, String, TempDataDictionary, Boolean, String, DataPlacements, String, String)Overloaded.
Gives HTML code for Input field
(Defined by Extensions.)
Public Extension MethodCode exampleToHTMLHidden(String)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodToHTMLHidden(DataGrid)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodXMLWrite
Gives XML string from data item
(Defined by Helper.)
Top
See Also