Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database. More...

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

Public Member Functions
	GetProductViewProcedure ()
	Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database. More...

	GetProductViewProcedure (int userId, string book, int officeId, DateTime dateFrom, DateTime dateTo, string office, string party, string priceType, string user, string referenceNumber, string statementReference)
	Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database. More...

IEnumerable< DbGetProductViewResult >	Execute ()
	Prepares and executes the function "transactions.get_product_view". 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_product_view"
	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	UserId `[get, set]`
	Maps to "user_id_" argument of the function "transactions.get_product_view". More...

string	Book `[get, set]`
	Maps to "book_" argument of the function "transactions.get_product_view". More...

int	OfficeId `[get, set]`
	Maps to "office_id_" argument of the function "transactions.get_product_view". More...

DateTime	DateFrom `[get, set]`
	Maps to "date_from_" argument of the function "transactions.get_product_view". More...

DateTime	DateTo `[get, set]`
	Maps to "date_to_" argument of the function "transactions.get_product_view". More...

string	Office `[get, set]`
	Maps to "office_" argument of the function "transactions.get_product_view". More...

string	Party `[get, set]`
	Maps to "party_" argument of the function "transactions.get_product_view". More...

string	PriceType `[get, set]`
	Maps to "price_type_" argument of the function "transactions.get_product_view". More...

string	User `[get, set]`
	Maps to "user_" argument of the function "transactions.get_product_view". More...

string	ReferenceNumber `[get, set]`
	Maps to "reference_number_" argument of the function "transactions.get_product_view". More...

string	StatementReference `[get, set]`
	Maps to "statement_reference_" argument of the function "transactions.get_product_view". 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_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.GetProductViewProcedure	(	int	userId,
		string	book,
		int	officeId,
		DateTime	dateFrom,
		DateTime	dateTo,
		string	office,
		string	party,
		string	priceType,
		string	user,
		string	referenceNumber,
		string	statementReference
	)

Prepares, validates, and executes the function "transactions.get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text)" on the database.

Parameters

userId	Enter argument value for "user_id_" parameter of the function "transactions.get_product_view".
book	Enter argument value for "book_" parameter of the function "transactions.get_product_view".
officeId	Enter argument value for "office_id_" parameter of the function "transactions.get_product_view".
dateFrom	Enter argument value for "date_from_" parameter of the function "transactions.get_product_view".
dateTo	Enter argument value for "date_to_" parameter of the function "transactions.get_product_view".
office	Enter argument value for "office_" parameter of the function "transactions.get_product_view".
party	Enter argument value for "party_" parameter of the function "transactions.get_product_view".
priceType	Enter argument value for "price_type_" parameter of the function "transactions.get_product_view".
user	Enter argument value for "user_" parameter of the function "transactions.get_product_view".
referenceNumber	Enter argument value for "reference_number_" parameter of the function "transactions.get_product_view".
statementReference	Enter argument value for "statement_reference_" parameter of the function "transactions.get_product_view".

Member Function Documentation

IEnumerable<DbGetProductViewResult> MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.Execute ( )

Prepares and executes the function "transactions.get_product_view".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.ObjectName => "get_product_view"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

getset

Login id of application user accessing this PostgreSQL function.

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

getset

User id of application user accessing this table.

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.Book

getset

Maps to "book_" argument of the function "transactions.get_product_view".

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

getset

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

DateTime MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.DateFrom

getset

Maps to "date_from_" argument of the function "transactions.get_product_view".

DateTime MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.DateTo

getset

Maps to "date_to_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.Office

getset

Maps to "office_" argument of the function "transactions.get_product_view".

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

getset

Maps to "office_id_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.Party

getset

Maps to "party_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.PriceType

getset

Maps to "price_type_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.ReferenceNumber

getset

Maps to "reference_number_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.StatementReference

getset

Maps to "statement_reference_" argument of the function "transactions.get_product_view".

string MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.User

getset

Maps to "user_" argument of the function "transactions.get_product_view".

int MixERP.Net.Schemas.Transactions.Data.GetProductViewProcedure.UserId

getset

Maps to "user_id_" argument of the function "transactions.get_product_view".

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

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

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation