Prepares, validates, and executes the function "transactions.get_non_gl_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...
|
| GetNonGlProductViewProcedure () |
| Prepares, validates, and executes the function "transactions.get_non_gl_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...
|
|
| GetNonGlProductViewProcedure (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_non_gl_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< DbGetNonGlProductViewResult > | Execute () |
| Prepares and executes the function "transactions.get_non_gl_product_view". More...
|
|
void | Validate (AccessTypeEnum type, long loginId, bool noException) |
| Validates application user access rights to execute the function. More...
|
|
|
override string | ObjectNamespace => "transactions" |
| The schema of this PostgreSQL function. More...
|
|
override string | ObjectName => "get_non_gl_product_view" |
| The schema unqualified name of this PostgreSQL function. More...
|
|
|
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_non_gl_product_view". More...
|
|
string | Book [get, set] |
| Maps to "book_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
int | OfficeId [get, set] |
| Maps to "office_id_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
DateTime | DateFrom [get, set] |
| Maps to "date_from_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
DateTime | DateTo [get, set] |
| Maps to "date_to_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | Office [get, set] |
| Maps to "office_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | Party [get, set] |
| Maps to "party_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | PriceType [get, set] |
| Maps to "price_type_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | User [get, set] |
| Maps to "user_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | ReferenceNumber [get, set] |
| Maps to "reference_number_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
string | StatementReference [get, set] |
| Maps to "statement_reference_" argument of the function "transactions.get_non_gl_product_view". More...
|
|
abstract string | ObjectNamespace [get] |
|
abstract string | ObjectName [get] |
|
bool | HasAccess [get] |
|
bool | Validated [get] |
|
bool | SkipValidation [get, set] |
|
bool | HasAccess [get] |
|
Prepares, validates, and executes the function "transactions.get_non_gl_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.GetNonGlProductViewProcedure.GetNonGlProductViewProcedure |
( |
| ) |
|
Prepares, validates, and executes the function "transactions.get_non_gl_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.GetNonGlProductViewProcedure.GetNonGlProductViewProcedure |
( |
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_non_gl_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_non_gl_product_view". |
book | Enter argument value for "book_" parameter of the function "transactions.get_non_gl_product_view". |
officeId | Enter argument value for "office_id_" parameter of the function "transactions.get_non_gl_product_view". |
dateFrom | Enter argument value for "date_from_" parameter of the function "transactions.get_non_gl_product_view". |
dateTo | Enter argument value for "date_to_" parameter of the function "transactions.get_non_gl_product_view". |
office | Enter argument value for "office_" parameter of the function "transactions.get_non_gl_product_view". |
party | Enter argument value for "party_" parameter of the function "transactions.get_non_gl_product_view". |
priceType | Enter argument value for "price_type_" parameter of the function "transactions.get_non_gl_product_view". |
user | Enter argument value for "user_" parameter of the function "transactions.get_non_gl_product_view". |
referenceNumber | Enter argument value for "reference_number_" parameter of the function "transactions.get_non_gl_product_view". |
statementReference | Enter argument value for "statement_reference_" parameter of the function "transactions.get_non_gl_product_view". |
Prepares and executes the function "transactions.get_non_gl_product_view".
override string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.ObjectName => "get_non_gl_product_view" |
The schema unqualified name of this PostgreSQL function.
override string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.ObjectNamespace => "transactions" |
The schema of this PostgreSQL function.
long MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure._LoginId |
|
getset |
Login id of application user accessing this PostgreSQL function.
int MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure._UserId |
|
getset |
User id of application user accessing this table.
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.Book |
|
getset |
Maps to "book_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.Catalog |
|
getset |
The name of the database on which queries are being executed to.
DateTime MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.DateFrom |
|
getset |
Maps to "date_from_" argument of the function "transactions.get_non_gl_product_view".
DateTime MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.DateTo |
|
getset |
Maps to "date_to_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.Office |
|
getset |
Maps to "office_" argument of the function "transactions.get_non_gl_product_view".
int MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.OfficeId |
|
getset |
Maps to "office_id_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.Party |
|
getset |
Maps to "party_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.PriceType |
|
getset |
Maps to "price_type_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.ReferenceNumber |
|
getset |
Maps to "reference_number_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.StatementReference |
|
getset |
Maps to "statement_reference_" argument of the function "transactions.get_non_gl_product_view".
string MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.User |
|
getset |
Maps to "user_" argument of the function "transactions.get_non_gl_product_view".
int MixERP.Net.Schemas.Transactions.Data.GetNonGlProductViewProcedure.UserId |
|
getset |
Maps to "user_id_" argument of the function "transactions.get_non_gl_product_view".
The documentation for this class was generated from the following file:
- C:/Users/nirvan/Desktop/mixerp/0. GitHub/src/Libraries/DAL/Transactions/GetNonGlProductViewProcedure.cs