C# Class Project_Marmelade.DataProductDevelopment

Datei anzeigen Open project: DMOe15a/ProjectMarmelade

Public Properties

Property	Type	Description
conn	System.Data.SqlClient.SqlConnection

Public Methods

Method	Description
CreateNewRecipe ( string name, bool approved, int primary, int secondary, int quality, List ingredients, List testers, string description ) : void
GetEmployeeByID ( int id ) : object[]
GetIngredients ( ) : List
GetMatches ( int Empid ) : List
GetRecipes ( ) : List
GetTaskDescription ( int id ) : object[]
GetTestResults ( ) : List
GetTesters ( ) : List
InsertTestData ( int Taste, int Texture, int Appearance, int Scent, int Total, string Comment, int Recipe_ID, int idEmployees, bool Complete ) : void
LoadRecipe ( ) : List

Private Methods

Method	Description
CreateNewRecipe_create ( string name, string description, int quality ) : int
CreateNewRecipe_ingredient ( int ingredient, int recipeID ) : void
CreateNewRecipe_tester ( int tester, int recipeID ) : void

Method Details

CreateNewRecipe() public method

public CreateNewRecipe ( string name, bool approved, int primary, int secondary, int quality, List ingredients, List testers, string description ) : void
name	string
approved	bool
primary	int
secondary	int
quality	int
ingredients	List
testers	List
description	string
return	void

GetEmployeeByID() public method

public GetEmployeeByID ( int id ) : object[]
id	int
return	object[]

GetIngredients() public method

public GetIngredients ( ) : List
return	List

GetMatches() public method

public GetMatches ( int Empid ) : List
Empid	int
return	List

GetRecipes() public method

public GetRecipes ( ) : List
return	List

GetTaskDescription() public method

public GetTaskDescription ( int id ) : object[]
id	int
return	object[]

GetTestResults() public method

public GetTestResults ( ) : List
return	List

GetTesters() public method

public GetTesters ( ) : List
return	List

InsertTestData() public method

public InsertTestData ( int Taste, int Texture, int Appearance, int Scent, int Total, string Comment, int Recipe_ID, int idEmployees, bool Complete ) : void
Taste	int
Texture	int
Appearance	int
Scent	int
Total	int
Comment	string
Recipe_ID	int
idEmployees	int
Complete	bool
return	void

LoadRecipe() public method

public LoadRecipe ( ) : List
return	List

Property Details

conn public_oe property

public SqlConnection,System.Data.SqlClient conn
return	System.Data.SqlClient.SqlConnection