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

Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database. More...

Inheritance diagram for MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure:
PetaPoco.DbAccess PetaPoco.IDBAccess

Public Member Functions

 GetAccountStatementProcedure ()
 Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database. More...
 
 GetAccountStatementProcedure (DateTime valueDateFrom, DateTime valueDateTo, int userId, long accountId, int officeId)
 Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database. More...
 
IEnumerable< DbGetAccountStatementResultExecute ()
 Prepares and executes the function "transactions.get_account_statement". 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_account_statement"
 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 ValueDateFrom [get, set]
 Maps to "_value_date_from" argument of the function "transactions.get_account_statement". More...
 
DateTime ValueDateTo [get, set]
 Maps to "_value_date_to" argument of the function "transactions.get_account_statement". More...
 
int UserId [get, set]
 Maps to "_user_id" argument of the function "transactions.get_account_statement". More...
 
long AccountId [get, set]
 Maps to "_account_id" argument of the function "transactions.get_account_statement". More...
 
int OfficeId [get, set]
 Maps to "_office_id" argument of the function "transactions.get_account_statement". 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_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.GetAccountStatementProcedure ( DateTime  valueDateFrom,
DateTime  valueDateTo,
int  userId,
long  accountId,
int  officeId 
)

Prepares, validates, and executes the function "transactions.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer)" on the database.

Parameters
valueDateFromEnter argument value for "_value_date_from" parameter of the function "transactions.get_account_statement".
valueDateToEnter argument value for "_value_date_to" parameter of the function "transactions.get_account_statement".
userIdEnter argument value for "_user_id" parameter of the function "transactions.get_account_statement".
accountIdEnter argument value for "_account_id" parameter of the function "transactions.get_account_statement".
officeIdEnter argument value for "_office_id" parameter of the function "transactions.get_account_statement".

Member Function Documentation

IEnumerable<DbGetAccountStatementResult> MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.Execute ( )

Prepares and executes the function "transactions.get_account_statement".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.ObjectName => "get_account_statement"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

long MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure._LoginId
getset

Login id of application user accessing this PostgreSQL function.

int MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure._UserId
getset

User id of application user accessing this table.

long MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.AccountId
getset

Maps to "_account_id" argument of the function "transactions.get_account_statement".

string MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.Catalog
getset

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

int MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.OfficeId
getset

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

int MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.UserId
getset

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

DateTime MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.ValueDateFrom
getset

Maps to "_value_date_from" argument of the function "transactions.get_account_statement".

DateTime MixERP.Net.Schemas.Transactions.Data.GetAccountStatementProcedure.ValueDateTo
getset

Maps to "_value_date_to" argument of the function "transactions.get_account_statement".


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