C# Class LIGHT.DatabaseManagerAuction

Mostra file Open project: lightphoenix2/LPX Class Usage Examples

Public Methods

Method	Description
AddAuctionItem ( int id, string itemid, string itemname, decimal price, decimal shopprice, int quality, string sellerID ) : bool
AuctionBuy ( int auctionID ) : string[]
AuctionCancel ( int auctionID ) : string[]
DeleteAuction ( string auctionID ) : void
FindAllItemNameWithQualityByID ( string ItemID ) : string[]
FindAllItemNameWithQualityByItemName ( string Itemname ) : string[]
FindAllItemPriceByID ( string ItemID ) : string[]
FindAllItemPriceByItemName ( string ItemName ) : string[]
FindItemByID ( string ItemID ) : string[]
FindItemByName ( string ItemName ) : string[]
GetAllAuctionID ( ) : string[]
GetAllItemNameWithQuality ( ) : string[]
GetAllItemPrice ( ) : string[]
GetLastAuctionNo ( ) : int
GetOwner ( int auctionID ) : string
checkAuctionExist ( int id ) : bool

Private Methods

Method	Description
CheckSchema ( ) : void
DatabaseManagerAuction ( ) : System
createConnection ( ) : MySqlConnection

Method Details

AddAuctionItem() public method

public AddAuctionItem ( int id, string itemid, string itemname, decimal price, decimal shopprice, int quality, string sellerID ) : bool
id	int
itemid	string
itemname	string
price	decimal
shopprice	decimal
quality	int
sellerID	string
return	bool

AuctionBuy() public method

public AuctionBuy ( int auctionID ) : string[]
auctionID	int
return	string[]

AuctionCancel() public method

public AuctionCancel ( int auctionID ) : string[]
auctionID	int
return	string[]

DeleteAuction() public method

public DeleteAuction ( string auctionID ) : void
auctionID	string
return	void

FindAllItemNameWithQualityByID() public method

public FindAllItemNameWithQualityByID ( string ItemID ) : string[]
ItemID	string
return	string[]

FindAllItemNameWithQualityByItemName() public method

public FindAllItemNameWithQualityByItemName ( string Itemname ) : string[]
Itemname	string
return	string[]

FindAllItemPriceByID() public method

public FindAllItemPriceByID ( string ItemID ) : string[]
ItemID	string
return	string[]

FindAllItemPriceByItemName() public method

public FindAllItemPriceByItemName ( string ItemName ) : string[]
ItemName	string
return	string[]

FindItemByID() public method

public FindItemByID ( string ItemID ) : string[]
ItemID	string
return	string[]

FindItemByName() public method

public FindItemByName ( string ItemName ) : string[]
ItemName	string
return	string[]

GetAllAuctionID() public method

public GetAllAuctionID ( ) : string[]
return	string[]

GetAllItemNameWithQuality() public method

public GetAllItemNameWithQuality ( ) : string[]
return	string[]

GetAllItemPrice() public method

public GetAllItemPrice ( ) : string[]
return	string[]

GetLastAuctionNo() public method

public GetLastAuctionNo ( ) : int
return	int

GetOwner() public method

public GetOwner ( int auctionID ) : string
auctionID	int
return	string

checkAuctionExist() public method

public checkAuctionExist ( int id ) : bool
id	int
return	bool