• Accueil
• mojoPortal
• Data
• DBLetterSubscription

C# Class mojoPortal.Data.DBLetterSubscription

Afficher le fichier Open project: joeaudette/mojoportal Class Usage Examples

Méthodes publiques

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

Méthode	Description
GetConnectionString ( ) : String

Method Details