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

Datei anzeigen Open project: mono/gert

Public Methods

Method 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

Method Description
AdsDB ( ) : System
EscapeWildcardCharacters ( String input ) : String
GetFirstRow ( AdsDataComponent table ) : AdsDataComponent.AdsRow

Method Details

ExpireAd() public static method

public static ExpireAd ( int adId, int memberId ) : void
adId int
memberId int
return void

GetActiveAds() public static method

public static GetActiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
return AdsDataComponent.AdsDataTable

GetActiveAdsByQuery() public static method

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
return AdsDataComponent.AdsDataTable

GetAdById() public static method

public static GetAdById ( int adId ) : AdsDataComponent.AdsRow
adId int
return AdsDataComponent.AdsRow

GetAdsByQuery() public static method

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
return AdsDataComponent.AdsDataTable

GetAdsByStatus() public static method

public static GetAdsByStatus ( AdStatus adStatus ) : AdsDataComponent.AdsDataTable
adStatus AdStatus
return AdsDataComponent.AdsDataTable

GetAdsByStatus() public static method

public static GetAdsByStatus ( AdStatus adStatus, int memberId ) : AdsDataComponent.AdsDataTable
adStatus AdStatus
memberId int
return AdsDataComponent.AdsDataTable

GetFeaturedAdsSelection() public static method

public static GetFeaturedAdsSelection ( int maxNumAds ) : AdsDataComponent.AdsDataTable
maxNumAds int
return AdsDataComponent.AdsDataTable

GetInactiveAds() public static method

public static GetInactiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
return AdsDataComponent.AdsDataTable

GetPendingAds() public static method

public static GetPendingAds ( ) : AdsDataComponent.AdsDataTable
return AdsDataComponent.AdsDataTable

GetPendingAds() public static method

public static GetPendingAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
return AdsDataComponent.AdsDataTable

GetSavedAds() public static method

public static GetSavedAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
return AdsDataComponent.AdsDataTable

IncrementResponseCount() public static method

public static IncrementResponseCount ( int adId ) : void
adId int
return void

IncrementViewCount() public static method

public static IncrementViewCount ( int adId ) : void
adId int
return void

InsertAd() public static method

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

InsertSavedAd() public static method

public static InsertSavedAd ( int adId, int memberId ) : void
adId int
memberId int
return void

InsertSavedAdList() public static method

public static InsertSavedAdList ( List adIds, int memberId ) : void
adIds List
memberId int
return void

MoveAdsToCategory() public static method

public static MoveAdsToCategory ( int currentCategoryId, int newCategoryId ) : void
currentCategoryId int
newCategoryId int
return void

RelistAd() public static method

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

RemoveFromDatabase() public static method

public static RemoveFromDatabase ( int adId ) : void
adId int
return void

RemoveFromDatabaseByStatus() public static method

public static RemoveFromDatabaseByStatus ( AdStatus adStatus ) : void
adStatus AdStatus
return void

RemoveFromUserList() public static method

public static RemoveFromUserList ( int id ) : void
id int
return void

RemoveListFromDatabase() public static method

public static RemoveListFromDatabase ( List adIds ) : void
adIds List
return void

RemoveSavedAd() public static method

public static RemoveSavedAd ( int id, int memberId ) : void
id int
memberId int
return void

SendAdInEmail() public static method

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

SendResponse() public static method

public static SendResponse ( int adId, string senderName, string senderAddress, string comments ) : bool
adId int
senderName string
senderAddress string
comments string
return bool

UpdateAd() public static method

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

UpdateAdCategory() public static method

public static UpdateAdCategory ( int adId, int categoryId ) : void
adId int
categoryId int
return void

UpdateAdLevel() public static method

public static UpdateAdLevel ( int adId, AdLevel adLevel ) : void
adId int
adLevel AdLevel
return void

UpdateAdLevelList() public static method

public static UpdateAdLevelList ( List adIds, AdLevel adLevel ) : void
adIds List
adLevel AdLevel
return void

UpdateAdStatus() public static method

public static UpdateAdStatus ( int adId, AdStatus adStatus ) : void
adId int
adStatus AdStatus
return void

UpdateAdStatusList() public static method

public static UpdateAdStatusList ( List adIds, AdStatus adStatus ) : void
adIds List
adStatus AdStatus
return void