C# Class SqlInteraction.SQLHandler

Class that handles all SQL interaction

Inheritance: ISQLHandler

Show file Open project: syre/SortingIndustrialRobot

Public Methods

Method	Description
addParameter ( SqlCommand _command, string _parameterName, object _parameterValue, SqlDbType _parameterType ) : void
changeConnectionparameter ( string _parameter, string _parameterValue ) : void
makeCommand ( string _commandText ) : SqlCommand
runQuery ( SqlCommand _command, string queryType ) : ISQLReader
setConnection ( string _server, string _database, string _username, string _password, string _timeout ) : bool

Private Methods

Method	Description
SQLHandler ( ) : System	Singleton Constructor

Method Details

addParameter() public method

public addParameter ( SqlCommand _command, string _parameterName, object _parameterValue, SqlDbType _parameterType ) : void
_command	System.Data.SqlClient.SqlCommand
_parameterName	string
_parameterValue	object
_parameterType	SqlDbType
return	void

changeConnectionparameter() public method

public changeConnectionparameter ( string _parameter, string _parameterValue ) : void
_parameter	string
_parameterValue	string
return	void

makeCommand() public method

public makeCommand ( string _commandText ) : SqlCommand
_commandText	string
return	SqlCommand

runQuery() public method

public runQuery ( SqlCommand _command, string queryType ) : ISQLReader
_command	SqlCommand
queryType	string
return	ISQLReader

setConnection() public method

public setConnection ( string _server, string _database, string _username, string _password, string _timeout ) : bool
_server	string
_database	string
_username	string
_password	string
_timeout	string
return	bool