Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...

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

Public Member Functions
	GetTrialBalanceProcedure ()
	Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...

	GetTrialBalanceProcedure (DateTime dateFrom, DateTime dateTo, int userId, int officeId, bool compact, decimal factor, bool changeSideWhenNegative, bool includeZeroBalanceAccounts)
	Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...

IEnumerable< DbGetTrialBalanceResult >	Execute ()
	Prepares and executes the function "transactions.get_trial_balance". 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_trial_balance"
	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...

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

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

int	UserId `[get, set]`
	Maps to "_user_id" argument of the function "transactions.get_trial_balance". More...

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

bool	Compact `[get, set]`
	Maps to "_compact" argument of the function "transactions.get_trial_balance". More...

decimal	Factor `[get, set]`
	Maps to "_factor" argument of the function "transactions.get_trial_balance". More...

bool	ChangeSideWhenNegative `[get, set]`
	Maps to "_change_side_when_negative" argument of the function "transactions.get_trial_balance". More...

bool	IncludeZeroBalanceAccounts `[get, set]`
	Maps to "_include_zero_balance_accounts" argument of the function "transactions.get_trial_balance". 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_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.GetTrialBalanceProcedure	(	DateTime	dateFrom,
		DateTime	dateTo,
		int	userId,
		int	officeId,
		bool	compact,
		decimal	factor,
		bool	changeSideWhenNegative,
		bool	includeZeroBalanceAccounts
	)

Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.

Parameters

dateFrom	Enter argument value for "_date_from" parameter of the function "transactions.get_trial_balance".
dateTo	Enter argument value for "_date_to" parameter of the function "transactions.get_trial_balance".
userId	Enter argument value for "_user_id" parameter of the function "transactions.get_trial_balance".
officeId	Enter argument value for "_office_id" parameter of the function "transactions.get_trial_balance".
compact	Enter argument value for "_compact" parameter of the function "transactions.get_trial_balance".
factor	Enter argument value for "_factor" parameter of the function "transactions.get_trial_balance".
changeSideWhenNegative	Enter argument value for "_change_side_when_negative" parameter of the function "transactions.get_trial_balance".
includeZeroBalanceAccounts	Enter argument value for "_include_zero_balance_accounts" parameter of the function "transactions.get_trial_balance".

Member Function Documentation

IEnumerable<DbGetTrialBalanceResult> MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Execute ( )

Prepares and executes the function "transactions.get_trial_balance".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.ObjectName => "get_trial_balance"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

getset

Login id of application user accessing this PostgreSQL function.

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

getset

User id of application user accessing this table.

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

getset

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

bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.ChangeSideWhenNegative

getset

Maps to "_change_side_when_negative" argument of the function "transactions.get_trial_balance".

bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Compact

getset

Maps to "_compact" argument of the function "transactions.get_trial_balance".

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

getset

Maps to "_date_from" argument of the function "transactions.get_trial_balance".

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

getset

Maps to "_date_to" argument of the function "transactions.get_trial_balance".

decimal MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Factor

getset

Maps to "_factor" argument of the function "transactions.get_trial_balance".

bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.IncludeZeroBalanceAccounts

getset

Maps to "_include_zero_balance_accounts" argument of the function "transactions.get_trial_balance".

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

getset

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

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

getset

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

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

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

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation