C# Class AspNet.StarterKits.Classifieds.BusinessLogicLayer.AdsDB

Afficher le fichier Open project: mono/gert

Méthodes publiques

Méthode	Description
ExpireAd ( int adId, int memberId ) : void
GetActiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
GetActiveAdsByQuery ( int recordLimit, int categoryId, int memberId, decimal maxPrice, string searchTerm, string location, int adType, int adLevel, int dayRange, bool mustHaveImage ) : AdsDataComponent.AdsDataTable
GetAdById ( int adId ) : AdsDataComponent.AdsRow
GetAdsByQuery ( int recordLimit, int categoryId, int memberId, decimal maxPrice, string searchTerm, string location, int adType, int adStatus, int adLevel, int dayRange, bool mustHaveImage ) : AdsDataComponent.AdsDataTable
GetAdsByStatus ( AdStatus adStatus ) : AdsDataComponent.AdsDataTable
GetAdsByStatus ( AdStatus adStatus, int memberId ) : AdsDataComponent.AdsDataTable
GetFeaturedAdsSelection ( int maxNumAds ) : AdsDataComponent.AdsDataTable
GetInactiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
GetPendingAds ( ) : AdsDataComponent.AdsDataTable
GetPendingAds ( int memberId ) : AdsDataComponent.AdsDataTable
GetSavedAds ( int memberId ) : AdsDataComponent.AdsDataTable
IncrementResponseCount ( int adId ) : void
IncrementViewCount ( int adId ) : void
InsertAd ( int memberId, int categoryId, string title, string description, string url, decimal price, string location, int numDaysActive, AdLevel adLevel, AdStatus adStatus, AdType adType ) : int
InsertSavedAd ( int adId, int memberId ) : void
InsertSavedAdList ( List adIds, int memberId ) : void
MoveAdsToCategory ( int currentCategoryId, int newCategoryId ) : void
RelistAd ( int adId, int categoryId, string title, string description, string url, decimal price, string location, int numDaysActive, AdLevel adLevel, AdStatus adStatus, AdType adType ) : void
RemoveFromDatabase ( int adId ) : void
RemoveFromDatabaseByStatus ( AdStatus adStatus ) : void
RemoveFromUserList ( int id ) : void
RemoveListFromDatabase ( List adIds ) : void
RemoveSavedAd ( int id, int memberId ) : void
SendAdInEmail ( int adId, string senderName, string senderAddress, string recipientEmail, string subject, string message ) : bool
SendResponse ( int adId, string senderName, string senderAddress, string comments ) : bool
UpdateAd ( int original_Id, int memberId, string title, string description, string url, decimal price, string location, bool isRelisting ) : void
UpdateAdCategory ( int adId, int categoryId ) : void
UpdateAdLevel ( int adId, AdLevel adLevel ) : void
UpdateAdLevelList ( List adIds, AdLevel adLevel ) : void
UpdateAdStatus ( int adId, AdStatus adStatus ) : void
UpdateAdStatusList ( List adIds, AdStatus adStatus ) : void

Private Methods

Méthode	Description
AdsDB ( ) : System
EscapeWildcardCharacters ( String input ) : String
GetFirstRow ( AdsDataComponent table ) : AdsDataComponent.AdsRow

Method Details

ExpireAd() public static méthode

public static ExpireAd ( int adId, int memberId ) : void
adId	int
memberId	int
Résultat	void

GetActiveAds() public static méthode

public static GetActiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId	int
Résultat	AdsDataComponent.AdsDataTable

GetActiveAdsByQuery() public static méthode

public static GetActiveAdsByQuery ( int recordLimit, int categoryId, int memberId, decimal maxPrice, string searchTerm, string location, int adType, int adLevel, int dayRange, bool mustHaveImage ) : AdsDataComponent.AdsDataTable
recordLimit	int
categoryId	int
memberId	int
maxPrice	decimal
searchTerm	string
location	string
adType	int
adLevel	int
dayRange	int
mustHaveImage	bool
Résultat	AdsDataComponent.AdsDataTable

GetAdById() public static méthode

public static GetAdById ( int adId ) : AdsDataComponent.AdsRow
adId	int
Résultat	AdsDataComponent.AdsRow

GetAdsByQuery() public static méthode

public static GetAdsByQuery ( int recordLimit, int categoryId, int memberId, decimal maxPrice, string searchTerm, string location, int adType, int adStatus, int adLevel, int dayRange, bool mustHaveImage ) : AdsDataComponent.AdsDataTable
recordLimit	int
categoryId	int
memberId	int
maxPrice	decimal
searchTerm	string
location	string
adType	int
adStatus	int
adLevel	int
dayRange	int
mustHaveImage	bool
Résultat	AdsDataComponent.AdsDataTable

GetAdsByStatus() public static méthode

public static GetAdsByStatus ( AdStatus adStatus ) : AdsDataComponent.AdsDataTable
adStatus	AdStatus
Résultat	AdsDataComponent.AdsDataTable

GetAdsByStatus() public static méthode

public static GetAdsByStatus ( AdStatus adStatus, int memberId ) : AdsDataComponent.AdsDataTable
adStatus	AdStatus
memberId	int
Résultat	AdsDataComponent.AdsDataTable

GetFeaturedAdsSelection() public static méthode

public static GetFeaturedAdsSelection ( int maxNumAds ) : AdsDataComponent.AdsDataTable
maxNumAds	int
Résultat	AdsDataComponent.AdsDataTable

GetInactiveAds() public static méthode

public static GetInactiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId	int
Résultat	AdsDataComponent.AdsDataTable

GetPendingAds() public static méthode

public static GetPendingAds ( ) : AdsDataComponent.AdsDataTable
Résultat	AdsDataComponent.AdsDataTable

GetPendingAds() public static méthode

public static GetPendingAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId	int
Résultat	AdsDataComponent.AdsDataTable

GetSavedAds() public static méthode

public static GetSavedAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId	int
Résultat	AdsDataComponent.AdsDataTable

IncrementResponseCount() public static méthode

public static IncrementResponseCount ( int adId ) : void
adId	int
Résultat	void

IncrementViewCount() public static méthode

public static IncrementViewCount ( int adId ) : void
adId	int
Résultat	void

InsertAd() public static méthode

public static InsertAd ( int memberId, int categoryId, string title, string description, string url, decimal price, string location, int numDaysActive, AdLevel adLevel, AdStatus adStatus, AdType adType ) : int
memberId	int
categoryId	int
title	string
description	string
url	string
price	decimal
location	string
numDaysActive	int
adLevel	AdLevel
adStatus	AdStatus
adType	AdType
Résultat	int

InsertSavedAd() public static méthode

public static InsertSavedAd ( int adId, int memberId ) : void
adId	int
memberId	int
Résultat	void

InsertSavedAdList() public static méthode

public static InsertSavedAdList ( List adIds, int memberId ) : void
adIds	List
memberId	int
Résultat	void

MoveAdsToCategory() public static méthode

public static MoveAdsToCategory ( int currentCategoryId, int newCategoryId ) : void
currentCategoryId	int
newCategoryId	int
Résultat	void

RelistAd() public static méthode

public static RelistAd ( int adId, int categoryId, string title, string description, string url, decimal price, string location, int numDaysActive, AdLevel adLevel, AdStatus adStatus, AdType adType ) : void
adId	int
categoryId	int
title	string
description	string
url	string
price	decimal
location	string
numDaysActive	int
adLevel	AdLevel
adStatus	AdStatus
adType	AdType
Résultat	void

RemoveFromDatabase() public static méthode

public static RemoveFromDatabase ( int adId ) : void
adId	int
Résultat	void

RemoveFromDatabaseByStatus() public static méthode

public static RemoveFromDatabaseByStatus ( AdStatus adStatus ) : void
adStatus	AdStatus
Résultat	void

RemoveFromUserList() public static méthode

public static RemoveFromUserList ( int id ) : void
id	int
Résultat	void

RemoveListFromDatabase() public static méthode

public static RemoveListFromDatabase ( List adIds ) : void
adIds	List
Résultat	void

RemoveSavedAd() public static méthode

public static RemoveSavedAd ( int id, int memberId ) : void
id	int
memberId	int
Résultat	void

SendAdInEmail() public static méthode

public static SendAdInEmail ( int adId, string senderName, string senderAddress, string recipientEmail, string subject, string message ) : bool
adId	int
senderName	string
senderAddress	string
recipientEmail	string
subject	string
message	string
Résultat	bool

SendResponse() public static méthode

public static SendResponse ( int adId, string senderName, string senderAddress, string comments ) : bool
adId	int
senderName	string
senderAddress	string
comments	string
Résultat	bool

UpdateAd() public static méthode

public static UpdateAd ( int original_Id, int memberId, string title, string description, string url, decimal price, string location, bool isRelisting ) : void
original_Id	int
memberId	int
title	string
description	string
url	string
price	decimal
location	string
isRelisting	bool
Résultat	void

UpdateAdCategory() public static méthode

public static UpdateAdCategory ( int adId, int categoryId ) : void
adId	int
categoryId	int
Résultat	void

UpdateAdLevel() public static méthode

public static UpdateAdLevel ( int adId, AdLevel adLevel ) : void
adId	int
adLevel	AdLevel
Résultat	void

UpdateAdLevelList() public static méthode

public static UpdateAdLevelList ( List adIds, AdLevel adLevel ) : void
adIds	List
adLevel	AdLevel
Résultat	void

UpdateAdStatus() public static méthode

public static UpdateAdStatus ( int adId, AdStatus adStatus ) : void
adId	int
adStatus	AdStatus
Résultat	void

UpdateAdStatusList() public static méthode

public static UpdateAdStatusList ( List adIds, AdStatus adStatus ) : void
adIds	List
adStatus	AdStatus
Résultat	void