MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure Class Reference

Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database. More...

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

Public Member Functions
	GetTopSellingProductsByOfficeProcedure ()
	Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database. More...
	GetTopSellingProductsByOfficeProcedure (int officeId, int top)
	Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database. More...
IEnumerable< DbGetTopSellingProductsByOfficeResult >	Execute ()
	Prepares and executes the function "transactions.get_top_selling_products_by_office". 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_top_selling_products_by_office"
	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	OfficeId [get, set]
	Maps to "_office_id" argument of the function "transactions.get_top_selling_products_by_office". More...
int	Top [get, set]
	Maps to "top" argument of the function "transactions.get_top_selling_products_by_office". 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_top_selling_products_by_office(_office_id integer, top integer)" on the database.

Constructor & Destructor Documentation

MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.GetTopSellingProductsByOfficeProcedure

(

)

Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.GetTopSellingProductsByOfficeProcedure	(	int	officeId,
		int	top
	)

Prepares, validates, and executes the function "transactions.get_top_selling_products_by_office(_office_id integer, top integer)" on the database.

Parameters

officeId	Enter argument value for "_office_id" parameter of the function "transactions.get_top_selling_products_by_office".
top	Enter argument value for "top" parameter of the function "transactions.get_top_selling_products_by_office".

Member Function Documentation

IEnumerable<DbGetTopSellingProductsByOfficeResult> MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.Execute

(

)

Prepares and executes the function "transactions.get_top_selling_products_by_office".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.ObjectName => "get_top_selling_products_by_office"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

getset

Login id of application user accessing this PostgreSQL function.

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

getset

User id of application user accessing this table.

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

getset

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

int MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.OfficeId

getset

Maps to "_office_id" argument of the function "transactions.get_top_selling_products_by_office".

int MixERP.Net.Schemas.Transactions.Data.GetTopSellingProductsByOfficeProcedure.Top

getset

Maps to "top" argument of the function "transactions.get_top_selling_products_by_office".

---

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

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