C# Class 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...

Afficher le fichier Open project: ProfilesRNS/ProfilesRNS Class Usage Examples

Méthodes publiques

Свойство	Type	Description
_ErrorMsg	string
_ErrorNumber	string

Private Properties

Свойство	Type	Description
ActivityLog	void

Méthodes publiques

Méthode	Description
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

Méthodes protégées

Méthode	Description
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

Private Methods

Méthode	Description
ActivityLog ( long subjectID, int personId, string property, long propertyID, string privacyCode, string param1, string param2 ) : void

Method Details

AddSQLParameters() public méthode

public AddSQLParameters ( SqlCommand sqlcmd, SqlParameter sqlParam ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
sqlParam	System.Data.SqlClient.SqlParameter
Résultat	void

EditActivityLog() protected méthode

protected EditActivityLog ( long subjectID, long propertyID, string privacyCode ) : void
subjectID	long
propertyID	long
privacyCode	string
Résultat	void

EditActivityLog() protected méthode

protected EditActivityLog ( long subjectID, string property, string privacyCode ) : void
subjectID	long
property	string
privacyCode	string
Résultat	void

EditActivityLog() protected méthode

protected EditActivityLog ( long subjectID, string property, string privacyCode, string param1, string param2 ) : void
subjectID	long
property	string
privacyCode	string
param1	string
param2	string
Résultat	void

ExecuteSQLDataCommand() public méthode

public ExecuteSQLDataCommand ( SqlCommand sqlcmd ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
Résultat	void

ExecuteSQLDataCommand() public méthode

public ExecuteSQLDataCommand ( SqlCommand sqlcmd, object o ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
o	object
Résultat	void

ExecuteSQLDataCommand() public méthode

public ExecuteSQLDataCommand ( string sqltext ) : void
sqltext	string
Résultat	void

GetActiveNetwork() public méthode

public GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader
subject	System.Int64
details	bool
Résultat	System.Data.SqlClient.SqlDataReader

GetCommandTimeout() public méthode

public GetCommandTimeout ( ) : int
Résultat	int

GetConnectionString() public méthode

public GetConnectionString ( ) : string
Résultat	string

GetDBCommand() public méthode

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
Résultat	System.Data.SqlClient.SqlCommand

GetDBCommand() public méthode

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
Résultat	System.Data.SqlClient.SqlCommand

GetDBConnection() public méthode

returns sqlconnection object

public GetDBConnection ( string Connectionstring ) : SqlConnection
Connectionstring	string
Résultat	System.Data.SqlClient.SqlConnection

GetEagleI() public méthode

public GetEagleI ( System.Int64 subject ) : List
subject	System.Int64
Résultat	List

GetProperty() public méthode

public GetProperty ( System.Int64 predicateId ) : string
predicateId	System.Int64
Résultat	string

GetPropertyRangeList() public méthode

public GetPropertyRangeList ( string propertyuri ) : XmlDocument
propertyuri	string
Résultat	System.Xml.XmlDocument

GetRESTApplications() public méthode

public GetRESTApplications ( ) : System.Data.SqlClient.SqlDataReader
Résultat	System.Data.SqlClient.SqlDataReader

GetRESTBasePath() public méthode

public GetRESTBasePath ( ) : string
Résultat	string

GetRESTBaseURI() public méthode

public GetRESTBaseURI ( ) : string
Résultat	string

GetResolvedURL() public méthode

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
Résultat	Profiles.Framework.Utilities.URLResolve

GetSQLDataReader() public méthode

public GetSQLDataReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
sqlcmd	System.Data.SqlClient.SqlCommand
Résultat	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() public méthode

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
Résultat	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() public méthode

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
Résultat	System.Data.SqlClient.SqlDataReader

GetSessionSecurityGroup() public méthode

public GetSessionSecurityGroup ( ) : System.Int64
Résultat	System.Int64

SessionActivityLog() public méthode

public SessionActivityLog ( ) : void
Résultat	void

SessionCreate() public méthode

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
Résultat	void

SessionUpdate() public méthode

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
Résultat	void

SetActiveNetwork() public méthode

public SetActiveNetwork ( System.Int64 subject, string relationshiptype, bool settoexists ) : void
subject	System.Int64
relationshiptype	string
settoexists	bool
Résultat	void

Property Details

_ErrorMsg public_oe property

public string _ErrorMsg
Résultat	string

_ErrorNumber public_oe property

public string _ErrorNumber
Résultat	string