C# Класс Profiles.Framework.Utilities.DataIO

This class is used for all database IO of the web data layer of profiles. Plus contains generic data base IO methods for building Command Objects, Data Readers ect...

Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
_ErrorMsg	string
_ErrorNumber	string

Private Properties

Свойство	Тип	Описание
ActivityLog	void

Открытые методы

Метод	Описание
AddSQLParameters ( SqlCommand sqlcmd, SqlParameter sqlParam ) : void
ExecuteSQLDataCommand ( SqlCommand sqlcmd ) : void
ExecuteSQLDataCommand ( SqlCommand sqlcmd, object o ) : void
ExecuteSQLDataCommand ( string sqltext ) : void
GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader
GetCommandTimeout ( ) : int
GetConnectionString ( ) : string
GetDBCommand ( SqlConnection sqlcn, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : SqlCommand
GetDBCommand ( string SqlConnectionString, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : SqlCommand
GetDBConnection ( string Connectionstring ) : SqlConnection	returns sqlconnection object
GetEagleI ( System.Int64 subject ) : List
GetProperty ( System.Int64 predicateId ) : string
GetPropertyRangeList ( string propertyuri ) : XmlDocument
GetRESTApplications ( ) : System.Data.SqlClient.SqlDataReader
GetRESTBasePath ( ) : string
GetRESTBaseURI ( ) : string
GetResolvedURL ( string applicationname, string param1, string param2, string param3, string param4, string param5, string param6, string param7, string param8, string param9, string sessionid, string resturl, string useragent, string contenttype ) : Profiles.Framework.Utilities.URLResolve	Method used to resolve the RESTful URL for Entities and Relationships. The Profiles framwork contains a database stored procedure that is used to process the application and 9 URL parameters in the RESTful URL Pattern that is defined in the RegisterRoutes method of the Global.asax file.
GetSQLDataReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
GetSQLDataReader ( String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : System.Data.SqlClient.SqlDataReader
GetSQLDataReader ( string ConnectionString, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : System.Data.SqlClient.SqlDataReader
GetSessionSecurityGroup ( ) : System.Int64
SessionActivityLog ( ) : void
SessionCreate ( Session &session ) : void	Used to create a custom Profiles Session instance. This instance is used to track and store user activity as a form of Profiles Network.
SessionUpdate ( Session &session ) : void	Used to create a custom Profiles Session instance. This instance is used to track and store user activity as a form of Profiles Network.
SetActiveNetwork ( System.Int64 subject, string relationshiptype, bool settoexists ) : void

Защищенные методы

Метод	Описание
EditActivityLog ( long subjectID, long propertyID, string privacyCode ) : void
EditActivityLog ( long subjectID, string property, string privacyCode ) : void
EditActivityLog ( long subjectID, string property, string privacyCode, string param1, string param2 ) : void

Приватные методы

Метод	Описание
ActivityLog ( long subjectID, int personId, string property, long propertyID, string privacyCode, string param1, string param2 ) : void

Описание методов

AddSQLParameters() публичный Метод

public AddSQLParameters ( SqlCommand sqlcmd, SqlParameter sqlParam ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
sqlParam	System.Data.SqlClient.SqlParameter
Результат	void

EditActivityLog() защищенный Метод

protected EditActivityLog ( long subjectID, long propertyID, string privacyCode ) : void
subjectID	long
propertyID	long
privacyCode	string
Результат	void

EditActivityLog() защищенный Метод

protected EditActivityLog ( long subjectID, string property, string privacyCode ) : void
subjectID	long
property	string
privacyCode	string
Результат	void

EditActivityLog() защищенный Метод

protected EditActivityLog ( long subjectID, string property, string privacyCode, string param1, string param2 ) : void
subjectID	long
property	string
privacyCode	string
param1	string
param2	string
Результат	void

ExecuteSQLDataCommand() публичный Метод

public ExecuteSQLDataCommand ( SqlCommand sqlcmd ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
Результат	void

ExecuteSQLDataCommand() публичный Метод

public ExecuteSQLDataCommand ( SqlCommand sqlcmd, object o ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
o	object
Результат	void

ExecuteSQLDataCommand() публичный Метод

public ExecuteSQLDataCommand ( string sqltext ) : void
sqltext	string
Результат	void

GetActiveNetwork() публичный Метод

public GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader
subject	System.Int64
details	bool
Результат	System.Data.SqlClient.SqlDataReader

GetCommandTimeout() публичный Метод

public GetCommandTimeout ( ) : int
Результат	int

GetConnectionString() публичный Метод

public GetConnectionString ( ) : string
Результат	string

GetDBCommand() публичный Метод

public GetDBCommand ( SqlConnection sqlcn, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : SqlCommand
sqlcn	System.Data.SqlClient.SqlConnection
CmdText	String
CmdType	CommandType
CmdBehavior	CommandBehavior
sqlParam	System.Data.SqlClient.SqlParameter
Результат	System.Data.SqlClient.SqlCommand

GetDBCommand() публичный Метод

public GetDBCommand ( string SqlConnectionString, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : SqlCommand
SqlConnectionString	string
CmdText	String
CmdType	CommandType
CmdBehavior	CommandBehavior
sqlParam	System.Data.SqlClient.SqlParameter
Результат	System.Data.SqlClient.SqlCommand

GetDBConnection() публичный Метод

returns sqlconnection object

public GetDBConnection ( string Connectionstring ) : SqlConnection
Connectionstring	string
Результат	System.Data.SqlClient.SqlConnection

GetEagleI() публичный Метод

public GetEagleI ( System.Int64 subject ) : List
subject	System.Int64
Результат	List

GetProperty() публичный Метод

public GetProperty ( System.Int64 predicateId ) : string
predicateId	System.Int64
Результат	string

GetPropertyRangeList() публичный Метод

public GetPropertyRangeList ( string propertyuri ) : XmlDocument
propertyuri	string
Результат	System.Xml.XmlDocument

GetRESTApplications() публичный Метод

public GetRESTApplications ( ) : System.Data.SqlClient.SqlDataReader
Результат	System.Data.SqlClient.SqlDataReader

GetRESTBasePath() публичный Метод

public GetRESTBasePath ( ) : string
Результат	string

GetRESTBaseURI() публичный Метод

public GetRESTBaseURI ( ) : string
Результат	string

GetResolvedURL() публичный Метод

Method used to resolve the RESTful URL for Entities and Relationships. The Profiles framwork contains a database stored procedure that is used to process the application and 9 URL parameters in the RESTful URL Pattern that is defined in the RegisterRoutes method of the Global.asax file.

public GetResolvedURL ( string applicationname, string param1, string param2, string param3, string param4, string param5, string param6, string param7, string param8, string param9, string sessionid, string resturl, string useragent, string contenttype ) : Profiles.Framework.Utilities.URLResolve
applicationname	string
param1	string	Param1 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param2	string	Param2 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param3	string	Param3 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param4	string	Param4 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param5	string	Param5 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param6	string	Param6 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param7	string	Param7 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param8	string	Param8 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
param9	string	Param9 in the RESTful URL pattern in the RegisterRoutes method of the Global.asax file
sessionid	string	The Profiles custom SessionID used to track the users navigation and activity that is stored as a Profiles Network.
resturl	string
useragent	string
contenttype	string
Результат	Profiles.Framework.Utilities.URLResolve

GetSQLDataReader() публичный Метод

public GetSQLDataReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
sqlcmd	System.Data.SqlClient.SqlCommand
Результат	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() публичный Метод

public GetSQLDataReader ( String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : System.Data.SqlClient.SqlDataReader
CmdText	String
CmdType	CommandType
CmdBehavior	CommandBehavior
sqlParam	System.Data.SqlClient.SqlParameter
Результат	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() публичный Метод

public GetSQLDataReader ( string ConnectionString, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : System.Data.SqlClient.SqlDataReader
ConnectionString	string
CmdText	String
CmdType	CommandType
CmdBehavior	CommandBehavior
sqlParam	System.Data.SqlClient.SqlParameter
Результат	System.Data.SqlClient.SqlDataReader

GetSessionSecurityGroup() публичный Метод

public GetSessionSecurityGroup ( ) : System.Int64
Результат	System.Int64

SessionActivityLog() публичный Метод

public SessionActivityLog ( ) : void
Результат	void

SessionCreate() публичный Метод

Used to create a custom Profiles Session instance. This instance is used to track and store user activity as a form of Profiles Network.

public SessionCreate ( Session &session ) : void
session	Session	ref of Framework.Session object that stores the state of a Profiles user session
Результат	void

SessionUpdate() публичный Метод

Used to create a custom Profiles Session instance. This instance is used to track and store user activity as a form of Profiles Network.

public SessionUpdate ( Session &session ) : void
session	Session	ref of Framework.Session object that stores the state of a Profiles user session
Результат	void

SetActiveNetwork() публичный Метод

public SetActiveNetwork ( System.Int64 subject, string relationshiptype, bool settoexists ) : void
subject	System.Int64
relationshiptype	string
settoexists	bool
Результат	void

Описание свойств

_ErrorMsg публичное свойство

public string _ErrorMsg
Результат	string

_ErrorNumber публичное свойство

public string _ErrorNumber
Результат	string