Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database. More...

Inheritance diagram for MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure:

Public Member Functions
	GetCostOfGoodsSoldProcedure ()
	Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database. More...

	GetCostOfGoodsSoldProcedure (int itemId, int unitId, int storeId, int quantity)
	Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database. More...

decimal	Execute ()
	Prepares and executes the function "transactions.get_cost_of_goods_sold". More...

Public Member Functions inherited from PetaPoco.DbAccess
void	Validate (AccessTypeEnum type, long loginId, bool noException)
	Validates application user access rights to execute the function. More...

Public Attributes
override string	ObjectNamespace => "transactions"
	The schema of this PostgreSQL function. More...

override string	ObjectName => "get_cost_of_goods_sold"
	The schema unqualified name of this PostgreSQL function. More...

Properties
long	_LoginId `[get, set]`
	Login id of application user accessing this PostgreSQL function. More...

int	_UserId `[get, set]`
	User id of application user accessing this table. More...

string	Catalog `[get, set]`
	The name of the database on which queries are being executed to. More...

int	ItemId `[get, set]`
	Maps to "_item_id" argument of the function "transactions.get_cost_of_goods_sold". More...

int	UnitId `[get, set]`
	Maps to "_unit_id" argument of the function "transactions.get_cost_of_goods_sold". More...

int	StoreId `[get, set]`
	Maps to "_store_id" argument of the function "transactions.get_cost_of_goods_sold". More...

int	Quantity `[get, set]`
	Maps to "_quantity" argument of the function "transactions.get_cost_of_goods_sold". More...

Properties inherited from PetaPoco.DbAccess
abstract string	ObjectNamespace `[get]`

abstract string	ObjectName `[get]`

bool	HasAccess `[get]`

bool	Validated `[get]`

bool	SkipValidation `[get, set]`

Properties inherited from PetaPoco.IDBAccess
bool	HasAccess `[get]`

Detailed Description

Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database.

Constructor & Destructor Documentation

MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.GetCostOfGoodsSoldProcedure ( )

Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.GetCostOfGoodsSoldProcedure	(	int	itemId,
		int	unitId,
		int	storeId,
		int	quantity
	)

Prepares, validates, and executes the function "transactions.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer)" on the database.

Parameters

itemId	Enter argument value for "_item_id" parameter of the function "transactions.get_cost_of_goods_sold".
unitId	Enter argument value for "_unit_id" parameter of the function "transactions.get_cost_of_goods_sold".
storeId	Enter argument value for "_store_id" parameter of the function "transactions.get_cost_of_goods_sold".
quantity	Enter argument value for "_quantity" parameter of the function "transactions.get_cost_of_goods_sold".

Member Function Documentation

decimal MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.Execute ( )

Prepares and executes the function "transactions.get_cost_of_goods_sold".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.ObjectName => "get_cost_of_goods_sold"

The schema unqualified name of this PostgreSQL function.

override string MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.ObjectNamespace => "transactions"

The schema of this PostgreSQL function.

Property Documentation

long MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure._LoginId

getset

Login id of application user accessing this PostgreSQL function.

int MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure._UserId

getset

User id of application user accessing this table.

string MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.Catalog

getset

The name of the database on which queries are being executed to.

int MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.ItemId

getset

Maps to "_item_id" argument of the function "transactions.get_cost_of_goods_sold".

int MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.Quantity

getset

Maps to "_quantity" argument of the function "transactions.get_cost_of_goods_sold".

int MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.StoreId

getset

Maps to "_store_id" argument of the function "transactions.get_cost_of_goods_sold".

int MixERP.Net.Schemas.Transactions.Data.GetCostOfGoodsSoldProcedure.UnitId

getset

Maps to "_unit_id" argument of the function "transactions.get_cost_of_goods_sold".

The documentation for this class was generated from the following file:

C:/Users/nirvan/Desktop/mixerp/0. GitHub/src/Libraries/DAL/Transactions/GetCostOfGoodsSoldProcedure.cs

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation