C# Class mojoPortal.Data.DBLetterSubscription

ファイルを表示 Open project: joeaudette/mojoportal Class Usage Examples

Public Methods

Method	Description
CountUsersNotSubscribedByLetter ( System.Guid siteGuid, System.Guid letterInfoGuid, bool excludeIfAnyUnsubscribeHx ) : int
Create ( System.Guid guid, System.Guid siteGuid, System.Guid letterInfoGuid, System.Guid userGuid, string email, bool isVerified, System.Guid verifyGuid, System.DateTime beginUtc, bool useHtml, string ipAddress ) : int	Inserts a row in the mp_LetterSubscribe table. Returns rows affected count.
CreateHistory ( System.Guid rowGuid, System.Guid siteGuid, System.Guid subscribeGuid, System.Guid letterInfoGuid, System.Guid userGuid, string email, bool isVerified, bool useHtml, System.DateTime beginUtc, System.DateTime endUtc, string ipAddress ) : int	Inserts a row in the mp_LetterSubscribeHx table. Returns rows affected count.
Delete ( System.Guid guid ) : bool	Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.
DeleteByLetter ( System.Guid letterInfoGuid ) : bool	Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.
DeleteBySite ( System.Guid siteGuid ) : bool	Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.
DeleteByUser ( System.Guid userGuid ) : bool
DeleteHistoryByLetterInfo ( System.Guid letterInfoGuid ) : bool
DeleteHistoryBySite ( System.Guid siteGuid ) : bool
DeleteUnverified ( System.Guid letterInfoGuid, System.DateTime olderThanUtc ) : bool
Exists ( System.Guid letterInfoGuid, string email ) : bool	Gets a count of rows in the mp_LetterSubscribe table.
GetByEmail ( System.Guid siteGuid, System.Guid letterInfoGuid, string email ) : IDataReader
GetByEmail ( System.Guid siteGuid, string email ) : IDataReader	Gets an IDataReader with one row from the mp_LetterSubscribe table.
GetByLetter ( System.Guid letterInfoGuid ) : IDataReader	Gets an IDataReader with one row from the mp_LetterSubscribe table.
GetByUser ( System.Guid siteGuid, System.Guid userGuid ) : IDataReader	Gets an IDataReader with one row from the mp_LetterSubscribe table.
GetCountByLetter ( System.Guid letterInfoGuid ) : int	Gets a count of rows in the mp_LetterSubscribe table.
GetOne ( System.Guid guid ) : IDataReader	Gets an IDataReader with one row from the mp_LetterSubscribe table.
GetPage ( System.Guid letterInfoGuid, int pageNumber, int pageSize, int &totalPages ) : IDataReader	Gets a page of data from the mp_LetterSubscriber table.
GetSubscribersNotSentYet ( System.Guid letterGuid, System.Guid letterInfoGuid ) : IDataReader	Gets an IDataReader from the mp_LetterSubscriber table.
GetTop1000UsersNotSubscribed ( System.Guid siteGuid, System.Guid letterInfoGuid, bool excludeIfAnyUnsubscribeHx ) : IDataReader
Search ( System.Guid letterInfoGuid, string emailOrIpAddress ) : IDataReader
Update ( System.Guid guid, System.Guid userGuid, bool useHtml ) : bool	Updates a row in the mp_LetterSubscribe table. Returns true if row updated.
Verify ( System.Guid guid, bool isVerified, System.Guid verifyGuid ) : bool

Private Methods

Method	Description
GetConnectionString ( ) : String

Method Details

CountUsersNotSubscribedByLetter() public static method

public static CountUsersNotSubscribedByLetter ( System.Guid siteGuid, System.Guid letterInfoGuid, bool excludeIfAnyUnsubscribeHx ) : int
siteGuid	System.Guid
letterInfoGuid	System.Guid
excludeIfAnyUnsubscribeHx	bool
return	int

Create() public static method

Inserts a row in the mp_LetterSubscribe table. Returns rows affected count.

public static Create ( System.Guid guid, System.Guid siteGuid, System.Guid letterInfoGuid, System.Guid userGuid, string email, bool isVerified, System.Guid verifyGuid, System.DateTime beginUtc, bool useHtml, string ipAddress ) : int
guid	System.Guid	guid
siteGuid	System.Guid	siteGuid
letterInfoGuid	System.Guid	letterInfoGuid
userGuid	System.Guid	userGuid
email	string	email
isVerified	bool	isVerified
verifyGuid	System.Guid	verifyGuid
beginUtc	System.DateTime	beginUtc
useHtml	bool	useHtml
ipAddress	string
return	int

CreateHistory() public static method

Inserts a row in the mp_LetterSubscribeHx table. Returns rows affected count.

public static CreateHistory ( System.Guid rowGuid, System.Guid siteGuid, System.Guid subscribeGuid, System.Guid letterInfoGuid, System.Guid userGuid, string email, bool isVerified, bool useHtml, System.DateTime beginUtc, System.DateTime endUtc, string ipAddress ) : int
rowGuid	System.Guid	rowGuid
siteGuid	System.Guid	siteGuid
subscribeGuid	System.Guid	subscribeGuid
letterInfoGuid	System.Guid	letterInfoGuid
userGuid	System.Guid	userGuid
email	string	email
isVerified	bool	isVerified
useHtml	bool	useHtml
beginUtc	System.DateTime	beginUtc
endUtc	System.DateTime	endUtc
ipAddress	string
return	int

Delete() public static method

Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.

public static Delete ( System.Guid guid ) : bool
guid	System.Guid	guid
return	bool

DeleteByLetter() public static method

Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.

public static DeleteByLetter ( System.Guid letterInfoGuid ) : bool
letterInfoGuid	System.Guid
return	bool

DeleteBySite() public static method

Deletes a row from the mp_LetterSubscribe table. Returns true if row deleted.

public static DeleteBySite ( System.Guid siteGuid ) : bool
siteGuid	System.Guid
return	bool

DeleteByUser() public static method

public static DeleteByUser ( System.Guid userGuid ) : bool
userGuid	System.Guid
return	bool

DeleteHistoryByLetterInfo() public static method

public static DeleteHistoryByLetterInfo ( System.Guid letterInfoGuid ) : bool
letterInfoGuid	System.Guid
return	bool

DeleteHistoryBySite() public static method

public static DeleteHistoryBySite ( System.Guid siteGuid ) : bool
siteGuid	System.Guid
return	bool

DeleteUnverified() public static method

public static DeleteUnverified ( System.Guid letterInfoGuid, System.DateTime olderThanUtc ) : bool
letterInfoGuid	System.Guid
olderThanUtc	System.DateTime
return	bool

Exists() public static method

Gets a count of rows in the mp_LetterSubscribe table.

public static Exists ( System.Guid letterInfoGuid, string email ) : bool
letterInfoGuid	System.Guid
email	string
return	bool

GetByEmail() public static method

public static GetByEmail ( System.Guid siteGuid, System.Guid letterInfoGuid, string email ) : IDataReader
siteGuid	System.Guid
letterInfoGuid	System.Guid
email	string
return	IDataReader

GetByEmail() public static method

Gets an IDataReader with one row from the mp_LetterSubscribe table.

public static GetByEmail ( System.Guid siteGuid, string email ) : IDataReader
siteGuid	System.Guid
email	string
return	IDataReader

GetByLetter() public static method

Gets an IDataReader with one row from the mp_LetterSubscribe table.

public static GetByLetter ( System.Guid letterInfoGuid ) : IDataReader
letterInfoGuid	System.Guid
return	IDataReader

GetByUser() public static method

Gets an IDataReader with one row from the mp_LetterSubscribe table.

public static GetByUser ( System.Guid siteGuid, System.Guid userGuid ) : IDataReader
siteGuid	System.Guid
userGuid	System.Guid
return	IDataReader

GetCountByLetter() public static method

Gets a count of rows in the mp_LetterSubscribe table.

public static GetCountByLetter ( System.Guid letterInfoGuid ) : int
letterInfoGuid	System.Guid
return	int

GetOne() public static method

Gets an IDataReader with one row from the mp_LetterSubscribe table.

public static GetOne ( System.Guid guid ) : IDataReader
guid	System.Guid	guid
return	IDataReader

GetPage() public static method

Gets a page of data from the mp_LetterSubscriber table.

public static GetPage ( System.Guid letterInfoGuid, int pageNumber, int pageSize, int &totalPages ) : IDataReader
letterInfoGuid	System.Guid	letterGuid
pageNumber	int	The page number.
pageSize	int	Size of the page.
totalPages	int	total pages
return	IDataReader

GetSubscribersNotSentYet() public static method

Gets an IDataReader from the mp_LetterSubscriber table.

public static GetSubscribersNotSentYet ( System.Guid letterGuid, System.Guid letterInfoGuid ) : IDataReader
letterGuid	System.Guid
letterInfoGuid	System.Guid	letterInfoGuid
return	IDataReader

GetTop1000UsersNotSubscribed() public static method

public static GetTop1000UsersNotSubscribed ( System.Guid siteGuid, System.Guid letterInfoGuid, bool excludeIfAnyUnsubscribeHx ) : IDataReader
siteGuid	System.Guid
letterInfoGuid	System.Guid
excludeIfAnyUnsubscribeHx	bool
return	IDataReader

Search() public static method

public static Search ( System.Guid letterInfoGuid, string emailOrIpAddress ) : IDataReader
letterInfoGuid	System.Guid
emailOrIpAddress	string
return	IDataReader

Update() public static method

Updates a row in the mp_LetterSubscribe table. Returns true if row updated.

public static Update ( System.Guid guid, System.Guid userGuid, bool useHtml ) : bool
guid	System.Guid	guid
userGuid	System.Guid
useHtml	bool	useHtml
return	bool

Verify() public static method

public static Verify ( System.Guid guid, bool isVerified, System.Guid verifyGuid ) : bool
guid	System.Guid
isVerified	bool
verifyGuid	System.Guid
return	bool