Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database. More...

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

Public Member Functions
	GetJournalViewProcedure ()
	Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database. More...

	GetJournalViewProcedure (int userId, int officeId, DateTime from, DateTime to, long tranId, string tranCode, string book, string referenceNumber, string statementReference, string postedBy, string office, string status, string verifiedBy, string reason)
	Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database. More...

IEnumerable< DbGetJournalViewResult >	Execute ()
	Prepares and executes the function "transactions.get_journal_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_journal_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_journal_view". More...

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

DateTime	From `[get, set]`
	Maps to "_from" argument of the function "transactions.get_journal_view". More...

DateTime	To `[get, set]`
	Maps to "_to" argument of the function "transactions.get_journal_view". More...

long	TranId `[get, set]`
	Maps to "_tran_id" argument of the function "transactions.get_journal_view". More...

string	TranCode `[get, set]`
	Maps to "_tran_code" argument of the function "transactions.get_journal_view". More...

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

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

string	StatementReference `[get, set]`
	Maps to "_statement_reference" argument of the function "transactions.get_journal_view". More...

string	PostedBy `[get, set]`
	Maps to "_posted_by" argument of the function "transactions.get_journal_view". More...

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

string	Status `[get, set]`
	Maps to "_status" argument of the function "transactions.get_journal_view". More...

string	VerifiedBy `[get, set]`
	Maps to "_verified_by" argument of the function "transactions.get_journal_view". More...

string	Reason `[get, set]`
	Maps to "_reason" argument of the function "transactions.get_journal_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_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.GetJournalViewProcedure	(	int	userId,
		int	officeId,
		DateTime	from,
		DateTime	to,
		long	tranId,
		string	tranCode,
		string	book,
		string	referenceNumber,
		string	statementReference,
		string	postedBy,
		string	office,
		string	status,
		string	verifiedBy,
		string	reason
	)

Prepares, validates, and executes the function "transactions.get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying)" on the database.

Parameters

userId	Enter argument value for "_user_id" parameter of the function "transactions.get_journal_view".
officeId	Enter argument value for "_office_id" parameter of the function "transactions.get_journal_view".
from	Enter argument value for "_from" parameter of the function "transactions.get_journal_view".
to	Enter argument value for "_to" parameter of the function "transactions.get_journal_view".
tranId	Enter argument value for "_tran_id" parameter of the function "transactions.get_journal_view".
tranCode	Enter argument value for "_tran_code" parameter of the function "transactions.get_journal_view".
book	Enter argument value for "_book" parameter of the function "transactions.get_journal_view".
referenceNumber	Enter argument value for "_reference_number" parameter of the function "transactions.get_journal_view".
statementReference	Enter argument value for "_statement_reference" parameter of the function "transactions.get_journal_view".
postedBy	Enter argument value for "_posted_by" parameter of the function "transactions.get_journal_view".
office	Enter argument value for "_office" parameter of the function "transactions.get_journal_view".
status	Enter argument value for "_status" parameter of the function "transactions.get_journal_view".
verifiedBy	Enter argument value for "_verified_by" parameter of the function "transactions.get_journal_view".
reason	Enter argument value for "_reason" parameter of the function "transactions.get_journal_view".

Member Function Documentation

IEnumerable<DbGetJournalViewResult> MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.Execute ( )

Prepares and executes the function "transactions.get_journal_view".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.ObjectName => "get_journal_view"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

getset

Login id of application user accessing this PostgreSQL function.

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

getset

User id of application user accessing this table.

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

getset

Maps to "_book" argument of the function "transactions.get_journal_view".

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

getset

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

DateTime MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.From

getset

Maps to "_from" argument of the function "transactions.get_journal_view".

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

getset

Maps to "_office" argument of the function "transactions.get_journal_view".

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

getset

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

string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.PostedBy

getset

Maps to "_posted_by" argument of the function "transactions.get_journal_view".

string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.Reason

getset

Maps to "_reason" argument of the function "transactions.get_journal_view".

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

getset

Maps to "_reference_number" argument of the function "transactions.get_journal_view".

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

getset

Maps to "_statement_reference" argument of the function "transactions.get_journal_view".

string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.Status

getset

Maps to "_status" argument of the function "transactions.get_journal_view".

DateTime MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.To

getset

Maps to "_to" argument of the function "transactions.get_journal_view".

string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.TranCode

getset

Maps to "_tran_code" argument of the function "transactions.get_journal_view".

long MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.TranId

getset

Maps to "_tran_id" argument of the function "transactions.get_journal_view".

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

getset

Maps to "_user_id" argument of the function "transactions.get_journal_view".

string MixERP.Net.Schemas.Transactions.Data.GetJournalViewProcedure.VerifiedBy

getset

Maps to "_verified_by" argument of the function "transactions.get_journal_view".

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

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

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation