C# Class OWASP.WebGoat.NET.App_Code.DB.SqliteDbProvider

Inheritance: IDbProvider

Exibir arquivo Open project: prevoty/WebGoat.NET

Public Methods

Method	Description
AddComment ( string productCode, string email, string comment ) : string
CreateCustomer ( string name, string email, string password, bool isAdmin, int question, string answer ) : bool
CustomCustomerLogin ( string email, string password ) : string
GetCatalogData ( ) : DataSet
GetComments ( string productCode ) : DataSet
GetCustomerDetails ( string customerNumber ) : DataSet
GetCustomerEmail ( string customerNumber ) : string
GetCustomerEmails ( string email ) : DataSet
GetEmailByCustomerNumber ( string num ) : string
GetEmailByName ( string name ) : DataSet
GetMessages ( string customerLogin ) : DataSet
GetOffice ( string city ) : DataSet
GetOrderDetails ( int orderNumber ) : DataSet
GetOrders ( int customerID ) : DataSet
GetPasswordByEmail ( string email ) : string
GetPayments ( int customerNumber ) : DataSet
GetProductDetails ( string productCode ) : DataSet
GetProductsAndCategories ( ) : DataSet
GetProductsAndCategories ( int catNumber ) : DataSet
GetSecurityQuestionAndAnswer ( string email ) : string[]
GetUsers ( ) : DataSet
IsAdminCustomerLogin ( string email ) : bool
IsValidCustomerLogin ( string email, string password ) : bool
RecreateGoatDb ( ) : bool
SqliteDbProvider ( ConfigFile configFile ) : System
TestConnection ( ) : bool
UpdateCustomerPassword ( int customerNumber, string password ) : string

Method Details

AddComment() public method

public AddComment ( string productCode, string email, string comment ) : string
productCode	string
email	string
comment	string
return	string

CreateCustomer() public method

public CreateCustomer ( string name, string email, string password, bool isAdmin, int question, string answer ) : bool
name	string
email	string
password	string
isAdmin	bool
question	int
answer	string
return	bool

CustomCustomerLogin() public method

public CustomCustomerLogin ( string email, string password ) : string
email	string
password	string
return	string

GetCatalogData() public method

public GetCatalogData ( ) : DataSet
return	System.Data.DataSet

GetComments() public method

public GetComments ( string productCode ) : DataSet
productCode	string
return	System.Data.DataSet

GetCustomerDetails() public method

public GetCustomerDetails ( string customerNumber ) : DataSet
customerNumber	string
return	System.Data.DataSet

GetCustomerEmail() public method

public GetCustomerEmail ( string customerNumber ) : string
customerNumber	string
return	string

GetCustomerEmails() public method

public GetCustomerEmails ( string email ) : DataSet
email	string
return	System.Data.DataSet

GetEmailByCustomerNumber() public method

public GetEmailByCustomerNumber ( string num ) : string
num	string
return	string

GetEmailByName() public method

public GetEmailByName ( string name ) : DataSet
name	string
return	System.Data.DataSet

GetMessages() public method

public GetMessages ( string customerLogin ) : DataSet
customerLogin	string
return	System.Data.DataSet

GetOffice() public method

public GetOffice ( string city ) : DataSet
city	string
return	System.Data.DataSet

GetOrderDetails() public method

public GetOrderDetails ( int orderNumber ) : DataSet
orderNumber	int
return	System.Data.DataSet

GetOrders() public method

public GetOrders ( int customerID ) : DataSet
customerID	int
return	System.Data.DataSet

GetPasswordByEmail() public method

public GetPasswordByEmail ( string email ) : string
email	string
return	string

GetPayments() public method

public GetPayments ( int customerNumber ) : DataSet
customerNumber	int
return	System.Data.DataSet

GetProductDetails() public method

public GetProductDetails ( string productCode ) : DataSet
productCode	string
return	System.Data.DataSet

GetProductsAndCategories() public method

public GetProductsAndCategories ( ) : DataSet
return	System.Data.DataSet

GetProductsAndCategories() public method

public GetProductsAndCategories ( int catNumber ) : DataSet
catNumber	int
return	System.Data.DataSet

GetSecurityQuestionAndAnswer() public method

public GetSecurityQuestionAndAnswer ( string email ) : string[]
email	string
return	string[]

GetUsers() public method

public GetUsers ( ) : DataSet
return	System.Data.DataSet

IsAdminCustomerLogin() public method

public IsAdminCustomerLogin ( string email ) : bool
email	string
return	bool

IsValidCustomerLogin() public method

public IsValidCustomerLogin ( string email, string password ) : bool
email	string
password	string
return	bool

RecreateGoatDb() public method

public RecreateGoatDb ( ) : bool
return	bool

SqliteDbProvider() public method

public SqliteDbProvider ( ConfigFile configFile ) : System
configFile	ConfigFile
return	System

TestConnection() public method

public TestConnection ( ) : bool
return	bool

UpdateCustomerPassword() public method

public UpdateCustomerPassword ( int customerNumber, string password ) : string
customerNumber	int
password	string
return	string