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...

Mostrar archivo Open project: ProfilesRNS/ProfilesRNS Class Usage Examples

Public Properties

Property	Type	Description
_ErrorMsg	string
_ErrorNumber	string

Private Properties

Property	Type	Description
ActivityLog	void

Public Methods

Method	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

Protected Methods

Method	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

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

Method Details

AddSQLParameters() public method

public AddSQLParameters ( SqlCommand sqlcmd, SqlParameter sqlParam ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
sqlParam	System.Data.SqlClient.SqlParameter
return	void

EditActivityLog() protected method

protected EditActivityLog ( long subjectID, long propertyID, string privacyCode ) : void
subjectID	long
propertyID	long
privacyCode	string
return	void

EditActivityLog() protected method

protected EditActivityLog ( long subjectID, string property, string privacyCode ) : void
subjectID	long
property	string
privacyCode	string
return	void

EditActivityLog() protected method

protected EditActivityLog ( long subjectID, string property, string privacyCode, string param1, string param2 ) : void
subjectID	long
property	string
privacyCode	string
param1	string
param2	string
return	void

ExecuteSQLDataCommand() public method

public ExecuteSQLDataCommand ( SqlCommand sqlcmd ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
return	void

ExecuteSQLDataCommand() public method

public ExecuteSQLDataCommand ( SqlCommand sqlcmd, object o ) : void
sqlcmd	System.Data.SqlClient.SqlCommand
o	object
return	void

ExecuteSQLDataCommand() public method

public ExecuteSQLDataCommand ( string sqltext ) : void
sqltext	string
return	void

GetActiveNetwork() public method

public GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader
subject	System.Int64
details	bool
return	System.Data.SqlClient.SqlDataReader

GetCommandTimeout() public method

public GetCommandTimeout ( ) : int
return	int

GetConnectionString() public method

public GetConnectionString ( ) : string
return	string

GetDBCommand() public method

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
return	System.Data.SqlClient.SqlCommand

GetDBCommand() public method

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
return	System.Data.SqlClient.SqlCommand

GetDBConnection() public method

returns sqlconnection object

public GetDBConnection ( string Connectionstring ) : SqlConnection
Connectionstring	string
return	System.Data.SqlClient.SqlConnection

GetEagleI() public method

public GetEagleI ( System.Int64 subject ) : List
subject	System.Int64
return	List

GetProperty() public method

public GetProperty ( System.Int64 predicateId ) : string
predicateId	System.Int64
return	string

GetPropertyRangeList() public method

public GetPropertyRangeList ( string propertyuri ) : XmlDocument
propertyuri	string
return	System.Xml.XmlDocument

GetRESTApplications() public method

public GetRESTApplications ( ) : System.Data.SqlClient.SqlDataReader
return	System.Data.SqlClient.SqlDataReader

GetRESTBasePath() public method

public GetRESTBasePath ( ) : string
return	string

GetRESTBaseURI() public method

public GetRESTBaseURI ( ) : string
return	string

GetResolvedURL() public method

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
return	Profiles.Framework.Utilities.URLResolve

GetSQLDataReader() public method

public GetSQLDataReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
sqlcmd	System.Data.SqlClient.SqlCommand
return	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() public method

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
return	System.Data.SqlClient.SqlDataReader

GetSQLDataReader() public method

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
return	System.Data.SqlClient.SqlDataReader

GetSessionSecurityGroup() public method

public GetSessionSecurityGroup ( ) : System.Int64
return	System.Int64

SessionActivityLog() public method

public SessionActivityLog ( ) : void
return	void

SessionCreate() public method

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
return	void

SessionUpdate() public method

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
return	void

SetActiveNetwork() public method

public SetActiveNetwork ( System.Int64 subject, string relationshiptype, bool settoexists ) : void
subject	System.Int64
relationshiptype	string
settoexists	bool
return	void

Property Details

_ErrorMsg public_oe property

public string _ErrorMsg
return	string

_ErrorNumber public_oe property

public string _ErrorNumber
return	string