Class RecordFileToDB

This class is useful for retrieving and recording blob and clob data from DB.

Inheritance

System.Object

RecordFileToDB

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: SDBCS.filework

Assembly: SDBCS.dll

Syntax

public class RecordFileToDB

Remarks

Author Mehmet Hayati KINAŞ

Version 1.0

Constructors

RecordFileToDB(RunDB, String[], String, String, String)

The basic variables of the constructor include database, table and file information.
In this way, the connection between the database and file is established and transactions are automated.

Declaration

public RecordFileToDB(RunDB runDB, string[] tableNames, string fileField, string keyField, string keyData)

Parameters

Type	Name	Description
RunDB	runDB	For connecting the database and executing processes.
System.String[]	tableNames	The table names to be accessed.
System.String	fileField	The name of file field of the table to access.
System.String	keyField	The key field name of the table to access.
System.String	keyData	Key field data.

RecordFileToDB(RunDB, String[], String, String[], String[], Int32[])

The basic variables of the constructor include database, table and file information.
In this way, the connection between the database and file is established and transactions are automated.

Declaration

public RecordFileToDB(RunDB runDB, string[] tableNames, string fileField, string[] unqFields, string[] unqFieldData, int[] unqFieldTypes)

Parameters

Type	Name	Description
RunDB	runDB	For connecting the database and executing processes.
System.String[]	tableNames	The table names to be accessed.
System.String	fileField	The name of file field of the table to access.
System.String[]	unqFields	Unique fields string array.
System.String[]	unqFieldData	Unique data string array.
System.Int32[]	unqFieldTypes	Unique field types string array.

Fields

CONNECTIONSTRING

Declaration

public const int CONNECTIONSTRING = 1

Field Value

Type	Description
System.Int32

DATAFILEPATH

Declaration

public const int DATAFILEPATH = 0

Field Value

Type	Description
System.Int32

DB2

Declaration

public const int DB2 = 4

Field Value

Type	Description
System.Int32

fileSF

Declaration

public string fileSF

Field Value

Type	Description
System.String

INTEGER

Declaration

public const int INTEGER = 1

Field Value

Type	Description
System.Int32

isDebug

Declaration

public bool isDebug

Field Value

Type	Description
System.Boolean

MYSQL

Declaration

public const int MYSQL = 0

Field Value

Type	Description
System.Int32

ORACLE

Declaration

public const int ORACLE = 2

Field Value

Type	Description
System.Int32

POSTGRESQL

Declaration

public const int POSTGRESQL = 3

Field Value

Type	Description
System.Int32

SQLSERVER

Declaration

public const int SQLSERVER = 1

Field Value

Type	Description
System.Int32

STRING

Declaration

public const int STRING = 0

Field Value

Type	Description
System.Int32

Properties

dbSystem

Declaration

public int dbSystem { get; set; }

Property Value

Type	Description
System.Int32

Methods

clearBCData()

For deleting blob and clob data from DB.

Declaration

public bool clearBCData()

Returns

Type	Description
System.Boolean	If process is ok it will return true, else return false.

getBlobData()

For retrieving blob data from DB.

Declaration

public byte[] getBlobData()

Returns

Type	Description
System.Byte[]	Byte array for blob data.

getClobData()

For retrieving clob data from DB.

Declaration

public byte[] getClobData()

Returns

Type	Description
System.Byte[]	Byte array for clob data.

getErrorString()

For getting errorString

Declaration

public string getErrorString()

Returns

Type	Description
System.String	errorString

getMessageScript()

For getting messageScript

Declaration

public string getMessageScript()

Returns

Type	Description
System.String	messageScript

getResultMessage()

For getting resultMessage

Declaration

public string getResultMessage()

Returns

Type	Description
System.String	resultMessage

recordBlobData(Byte[])

For recording blob data to DB

Declaration

public bool recordBlobData(byte[] data)

Parameters

Type	Name	Description
System.Byte[]	data	Byte array from blob data.

Returns

Type	Description
System.Boolean	If process is ok it will return true, else return false.

recordClobData(Byte[])

For recording clob data to DB

Declaration

public bool recordClobData(byte[] buffer)

Parameters

Type	Name	Description
System.Byte[]	buffer	Byte array from clob data.

Returns

Type	Description
System.Boolean	If process is ok it will return true, else return false.

setKeyData()

If the record is inserted DB, we don't have id yet. We can get id from DB with using unique data.

Declaration

public bool setKeyData()

Returns

Type	Description
System.Boolean	If process is ok it will return true, else return false.