C# Class Northwind.DataAccessLayer.CustomerDAO

ファイルを表示 Open project: vladislav-karamfilov/TelerikAcademy

Public Methods

Method	Description
AddCustomer ( string id, string companyName ) : void
AddCustomer ( string id, string companyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax ) : void
DeleteCustomer ( string id ) : bool
GetCustomersByOrdersYearAndShipCountry ( int year, string shipCountry ) : IEnumerable
GetCustomersByOrdersYearAndShipCountrySQL ( int year, string shipCountry ) : IEnumerable
ModifyCustomer ( string id, string newCompanyName, string newContactName, string newContactTitle, string newAddress, string newCity, string newRegion, string newPostalCode, string newCountry, string newPhone, string newFax ) : bool

Method Details

AddCustomer() public static method

public static AddCustomer ( string id, string companyName ) : void
id	string
companyName	string
return	void

AddCustomer() public static method

public static AddCustomer ( string id, string companyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax ) : void
id	string
companyName	string
contactName	string
contactTitle	string
address	string
city	string
region	string
postalCode	string
country	string
phone	string
fax	string
return	void

DeleteCustomer() public static method

public static DeleteCustomer ( string id ) : bool
id	string
return	bool

GetCustomersByOrdersYearAndShipCountry() public static method

public static GetCustomersByOrdersYearAndShipCountry ( int year, string shipCountry ) : IEnumerable
year	int
shipCountry	string
return	IEnumerable

GetCustomersByOrdersYearAndShipCountrySQL() public static method

public static GetCustomersByOrdersYearAndShipCountrySQL ( int year, string shipCountry ) : IEnumerable
year	int
shipCountry	string
return	IEnumerable

ModifyCustomer() public static method

public static ModifyCustomer ( string id, string newCompanyName, string newContactName, string newContactTitle, string newAddress, string newCity, string newRegion, string newPostalCode, string newCountry, string newPhone, string newFax ) : bool
id	string
newCompanyName	string
newContactName	string
newContactTitle	string
newAddress	string
newCity	string
newRegion	string
newPostalCode	string
newCountry	string
newPhone	string
newFax	string
return	bool