C# Class lnhpd.DBConnection

Datei anzeigen Open project: hres/api-lnhpd

Private Properties

Property	Type	Description

Public Methods

Method	Description
DBConnection ( string lang ) : System
GetAllIngredient ( string lang ) : List
GetAllIngredientQuantity ( string lang ) : List
GetAllIngredientQuantityByMatrixId ( int matrix_id, string lang ) : List
GetAllIngredientSource ( string lang ) : List
GetAllIngredientSubmission ( string lang ) : List
GetAllProductByCriteria ( string brandname, string ingredient, string companyname, string din, string lang ) : List
GetAllProductBySingleTerm ( string term, string lang ) : List
GetAllProductDose ( string lang ) : List
GetAllProductLicence ( string lang ) : List
GetAllProductPurpose ( string lang ) : List
GetAllProductRisk ( string lang ) : List
GetAllProductRiskText ( string lang ) : List
GetAllProductRiskTextByRiskId ( int riskId, string lang ) : List
GetAllProductRoute ( string lang ) : List
GetIngredientById ( int id, string lang ) : Ingredient
GetIngredientQuantityById ( int id, string lang ) : IngredientQuantity
GetIngredientSourceById ( int id, string lang ) : IngredientSource
GetIngredientSubmissionById ( int id, string lang ) : IngredientSubmission
GetMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
GetNonMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductDoseById ( int id, string lang ) : ProductDose
GetProductDoseByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductLicenceById ( int id, string lang ) : ProductLicence
GetProductPurposeById ( int id, string lang ) : ProductPurpose
GetProductPurposeByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductRiskById ( int id, string lang ) : ProductRisk
GetProductRiskTextById ( int id, string lang ) : ProductRiskText
GetProductRouteById ( int id, string lang ) : ProductRoute
GetProductRouteByLicenceNumber ( int licenceNumber, string lang ) : List
GetRiskByLicenceNumber ( int licenceNumber, string lang ) : List
GetSecondaryBrandNameList ( int licenceNumber, string lang ) : List
mergeMedIngredientRow ( List medInglist, List newMedInglist ) : List

Method Details

DBConnection() public method

public DBConnection ( string lang ) : System
lang	string
return	System

GetAllIngredient() public method

public GetAllIngredient ( string lang ) : List
lang	string
return	List

GetAllIngredientQuantity() public method

public GetAllIngredientQuantity ( string lang ) : List
lang	string
return	List

GetAllIngredientQuantityByMatrixId() public method

public GetAllIngredientQuantityByMatrixId ( int matrix_id, string lang ) : List
matrix_id	int
lang	string
return	List

GetAllIngredientSource() public method

public GetAllIngredientSource ( string lang ) : List
lang	string
return	List

GetAllIngredientSubmission() public method

public GetAllIngredientSubmission ( string lang ) : List
lang	string
return	List

GetAllProductByCriteria() public method

public GetAllProductByCriteria ( string brandname, string ingredient, string companyname, string din, string lang ) : List
brandname	string
ingredient	string
companyname	string
din	string
lang	string
return	List

GetAllProductBySingleTerm() public method

public GetAllProductBySingleTerm ( string term, string lang ) : List
term	string
lang	string
return	List

GetAllProductDose() public method

public GetAllProductDose ( string lang ) : List
lang	string
return	List

GetAllProductLicence() public method

public GetAllProductLicence ( string lang ) : List
lang	string
return	List

GetAllProductPurpose() public method

public GetAllProductPurpose ( string lang ) : List
lang	string
return	List

GetAllProductRisk() public method

public GetAllProductRisk ( string lang ) : List
lang	string
return	List

GetAllProductRiskText() public method

public GetAllProductRiskText ( string lang ) : List
lang	string
return	List

GetAllProductRiskTextByRiskId() public method

public GetAllProductRiskTextByRiskId ( int riskId, string lang ) : List
riskId	int
lang	string
return	List

GetAllProductRoute() public method

public GetAllProductRoute ( string lang ) : List
lang	string
return	List

GetIngredientById() public method

public GetIngredientById ( int id, string lang ) : Ingredient
id	int
lang	string
return	lnhpdWebApi.Models.Ingredient

GetIngredientQuantityById() public method

public GetIngredientQuantityById ( int id, string lang ) : IngredientQuantity
id	int
lang	string
return	lnhpdWebApi.Models.IngredientQuantity

GetIngredientSourceById() public method

public GetIngredientSourceById ( int id, string lang ) : IngredientSource
id	int
lang	string
return	lnhpdWebApi.Models.IngredientSource

GetIngredientSubmissionById() public method

public GetIngredientSubmissionById ( int id, string lang ) : IngredientSubmission
id	int
lang	string
return	lnhpdWebApi.Models.IngredientSubmission

GetMedIngredientByLicenceNumber() public method

public GetMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetNonMedIngredientByLicenceNumber() public method

public GetNonMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetProductDoseById() public method

public GetProductDoseById ( int id, string lang ) : ProductDose
id	int
lang	string
return	lnhpdWebApi.Models.ProductDose

GetProductDoseByLicenceNumber() public method

public GetProductDoseByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetProductLicenceById() public method

public GetProductLicenceById ( int id, string lang ) : ProductLicence
id	int
lang	string
return	lnhpdWebApi.Models.ProductLicence

GetProductPurposeById() public method

public GetProductPurposeById ( int id, string lang ) : ProductPurpose
id	int
lang	string
return	lnhpdWebApi.Models.ProductPurpose

GetProductPurposeByLicenceNumber() public method

public GetProductPurposeByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetProductRiskById() public method

public GetProductRiskById ( int id, string lang ) : ProductRisk
id	int
lang	string
return	lnhpdWebApi.Models.ProductRisk

GetProductRiskTextById() public method

public GetProductRiskTextById ( int id, string lang ) : ProductRiskText
id	int
lang	string
return	lnhpdWebApi.Models.ProductRiskText

GetProductRouteById() public method

public GetProductRouteById ( int id, string lang ) : ProductRoute
id	int
lang	string
return	lnhpdWebApi.Models.ProductRoute

GetProductRouteByLicenceNumber() public method

public GetProductRouteByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetRiskByLicenceNumber() public method

public GetRiskByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

GetSecondaryBrandNameList() public method

public GetSecondaryBrandNameList ( int licenceNumber, string lang ) : List
licenceNumber	int
lang	string
return	List

mergeMedIngredientRow() public method

public mergeMedIngredientRow ( List medInglist, List newMedInglist ) : List
medInglist	List
newMedInglist	List
return	List