C# 클래스 AspNet.StarterKits.Classifieds.BusinessLogicLayer.AdsDB

파일 보기 프로젝트 열기: mono/gert

공개 메소드들

메소드 설명
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

비공개 메소드들

메소드 설명
AdsDB ( ) : System
EscapeWildcardCharacters ( String input ) : String
GetFirstRow ( AdsDataComponent table ) : AdsDataComponent.AdsRow

메소드 상세

ExpireAd() 공개 정적인 메소드

public static ExpireAd ( int adId, int memberId ) : void
adId int
memberId int
리턴 void

GetActiveAds() 공개 정적인 메소드

public static GetActiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
리턴 AdsDataComponent.AdsDataTable

GetActiveAdsByQuery() 공개 정적인 메소드

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
리턴 AdsDataComponent.AdsDataTable

GetAdById() 공개 정적인 메소드

public static GetAdById ( int adId ) : AdsDataComponent.AdsRow
adId int
리턴 AdsDataComponent.AdsRow

GetAdsByQuery() 공개 정적인 메소드

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
리턴 AdsDataComponent.AdsDataTable

GetAdsByStatus() 공개 정적인 메소드

public static GetAdsByStatus ( AdStatus adStatus ) : AdsDataComponent.AdsDataTable
adStatus AdStatus
리턴 AdsDataComponent.AdsDataTable

GetAdsByStatus() 공개 정적인 메소드

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

GetFeaturedAdsSelection() 공개 정적인 메소드

public static GetFeaturedAdsSelection ( int maxNumAds ) : AdsDataComponent.AdsDataTable
maxNumAds int
리턴 AdsDataComponent.AdsDataTable

GetInactiveAds() 공개 정적인 메소드

public static GetInactiveAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
리턴 AdsDataComponent.AdsDataTable

GetPendingAds() 공개 정적인 메소드

public static GetPendingAds ( ) : AdsDataComponent.AdsDataTable
리턴 AdsDataComponent.AdsDataTable

GetPendingAds() 공개 정적인 메소드

public static GetPendingAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
리턴 AdsDataComponent.AdsDataTable

GetSavedAds() 공개 정적인 메소드

public static GetSavedAds ( int memberId ) : AdsDataComponent.AdsDataTable
memberId int
리턴 AdsDataComponent.AdsDataTable

IncrementResponseCount() 공개 정적인 메소드

public static IncrementResponseCount ( int adId ) : void
adId int
리턴 void

IncrementViewCount() 공개 정적인 메소드

public static IncrementViewCount ( int adId ) : void
adId int
리턴 void

InsertAd() 공개 정적인 메소드

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
리턴 int

InsertSavedAd() 공개 정적인 메소드

public static InsertSavedAd ( int adId, int memberId ) : void
adId int
memberId int
리턴 void

InsertSavedAdList() 공개 정적인 메소드

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

MoveAdsToCategory() 공개 정적인 메소드

public static MoveAdsToCategory ( int currentCategoryId, int newCategoryId ) : void
currentCategoryId int
newCategoryId int
리턴 void

RelistAd() 공개 정적인 메소드

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
리턴 void

RemoveFromDatabase() 공개 정적인 메소드

public static RemoveFromDatabase ( int adId ) : void
adId int
리턴 void

RemoveFromDatabaseByStatus() 공개 정적인 메소드

public static RemoveFromDatabaseByStatus ( AdStatus adStatus ) : void
adStatus AdStatus
리턴 void

RemoveFromUserList() 공개 정적인 메소드

public static RemoveFromUserList ( int id ) : void
id int
리턴 void

RemoveListFromDatabase() 공개 정적인 메소드

public static RemoveListFromDatabase ( List adIds ) : void
adIds List
리턴 void

RemoveSavedAd() 공개 정적인 메소드

public static RemoveSavedAd ( int id, int memberId ) : void
id int
memberId int
리턴 void

SendAdInEmail() 공개 정적인 메소드

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
리턴 bool

SendResponse() 공개 정적인 메소드

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

UpdateAd() 공개 정적인 메소드

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
리턴 void

UpdateAdCategory() 공개 정적인 메소드

public static UpdateAdCategory ( int adId, int categoryId ) : void
adId int
categoryId int
리턴 void

UpdateAdLevel() 공개 정적인 메소드

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

UpdateAdLevelList() 공개 정적인 메소드

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

UpdateAdStatus() 공개 정적인 메소드

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

UpdateAdStatusList() 공개 정적인 메소드

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