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

파일 보기 프로젝트 열기: ProfilesRNS/ProfilesRNS 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
_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