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

Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database. More...

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

Public Member Functions

 GetInventoryTransferRequestViewProcedure ()
 Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database. More...
 
 GetInventoryTransferRequestViewProcedure (int userId, long loginIdParameter, int officeId, DateTime from, DateTime to, string office, string store, string authorized, string delivered, string received, string user, string referenceNumber, string statementReference)
 Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database. More...
 
IEnumerable< DbGetInventoryTransferRequestViewResultExecute ()
 Prepares and executes the function "transactions.get_inventory_transfer_request_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_inventory_transfer_request_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_inventory_transfer_request_view". More...
 
long LoginIdParameter [get, set]
 Maps to "_login_id" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
int OfficeId [get, set]
 Maps to "_office_id" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
DateTime From [get, set]
 Maps to "_from" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
DateTime To [get, set]
 Maps to "_to" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string Office [get, set]
 Maps to "_office" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string Store [get, set]
 Maps to "_store" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string Authorized [get, set]
 Maps to "_authorized" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string Delivered [get, set]
 Maps to "_delivered" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string Received [get, set]
 Maps to "_received" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string User [get, set]
 Maps to "_user" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string ReferenceNumber [get, set]
 Maps to "_reference_number" argument of the function "transactions.get_inventory_transfer_request_view". More...
 
string StatementReference [get, set]
 Maps to "_statement_reference" argument of the function "transactions.get_inventory_transfer_request_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_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.GetInventoryTransferRequestViewProcedure ( int  userId,
long  loginIdParameter,
int  officeId,
DateTime  from,
DateTime  to,
string  office,
string  store,
string  authorized,
string  delivered,
string  received,
string  user,
string  referenceNumber,
string  statementReference 
)

Prepares, validates, and executes the function "transactions.get_inventory_transfer_request_view(_user_id integer, _login_id bigint, _office_id integer, _from date, _to date, _office text, _store text, _authorized text, _delivered text, _received text, _user text, _reference_number text, _statement_reference text)" on the database.

Parameters
userIdEnter argument value for "_user_id" parameter of the function "transactions.get_inventory_transfer_request_view".
loginIdParameterEnter argument value for "_login_id" parameter of the function "transactions.get_inventory_transfer_request_view".
officeIdEnter argument value for "_office_id" parameter of the function "transactions.get_inventory_transfer_request_view".
fromEnter argument value for "_from" parameter of the function "transactions.get_inventory_transfer_request_view".
toEnter argument value for "_to" parameter of the function "transactions.get_inventory_transfer_request_view".
officeEnter argument value for "_office" parameter of the function "transactions.get_inventory_transfer_request_view".
storeEnter argument value for "_store" parameter of the function "transactions.get_inventory_transfer_request_view".
authorizedEnter argument value for "_authorized" parameter of the function "transactions.get_inventory_transfer_request_view".
deliveredEnter argument value for "_delivered" parameter of the function "transactions.get_inventory_transfer_request_view".
receivedEnter argument value for "_received" parameter of the function "transactions.get_inventory_transfer_request_view".
userEnter argument value for "_user" parameter of the function "transactions.get_inventory_transfer_request_view".
referenceNumberEnter argument value for "_reference_number" parameter of the function "transactions.get_inventory_transfer_request_view".
statementReferenceEnter argument value for "_statement_reference" parameter of the function "transactions.get_inventory_transfer_request_view".

Member Function Documentation

IEnumerable<DbGetInventoryTransferRequestViewResult> MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Execute ( )

Prepares and executes the function "transactions.get_inventory_transfer_request_view".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.ObjectName => "get_inventory_transfer_request_view"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

Login id of application user accessing this PostgreSQL function.

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

User id of application user accessing this table.

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Authorized
getset

Maps to "_authorized" argument of the function "transactions.get_inventory_transfer_request_view".

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

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

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Delivered
getset

Maps to "_delivered" argument of the function "transactions.get_inventory_transfer_request_view".

DateTime MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.From
getset

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

long MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.LoginIdParameter
getset

Maps to "_login_id" argument of the function "transactions.get_inventory_transfer_request_view".

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Office
getset

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

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

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

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Received
getset

Maps to "_received" argument of the function "transactions.get_inventory_transfer_request_view".

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.ReferenceNumber
getset

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

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.StatementReference
getset

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

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.Store
getset

Maps to "_store" argument of the function "transactions.get_inventory_transfer_request_view".

DateTime MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.To
getset

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

string MixERP.Net.Schemas.Transactions.Data.GetInventoryTransferRequestViewProcedure.User
getset

Maps to "_user" argument of the function "transactions.get_inventory_transfer_request_view".

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

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


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