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

Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database. More...

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

Public Member Functions

 GetSalesTaxProcedure ()
 Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database. More...
 
 GetSalesTaxProcedure (string tranBook, int storeId, string partyCode, string shippingAddressCode, int priceTypeId, string itemCode, decimal price, int quantity, decimal discount, decimal shippingCharge, int salesTaxId)
 Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database. More...
 
IEnumerable< DbGetSalesTaxResultExecute ()
 Prepares and executes the function "transactions.get_sales_tax". 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_sales_tax"
 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...
 
string TranBook [get, set]
 Maps to "_tran_book" argument of the function "transactions.get_sales_tax". More...
 
int StoreId [get, set]
 Maps to "_store_id" argument of the function "transactions.get_sales_tax". More...
 
string PartyCode [get, set]
 Maps to "_party_code" argument of the function "transactions.get_sales_tax". More...
 
string ShippingAddressCode [get, set]
 Maps to "_shipping_address_code" argument of the function "transactions.get_sales_tax". More...
 
int PriceTypeId [get, set]
 Maps to "_price_type_id" argument of the function "transactions.get_sales_tax". More...
 
string ItemCode [get, set]
 Maps to "_item_code" argument of the function "transactions.get_sales_tax". More...
 
decimal Price [get, set]
 Maps to "_price" argument of the function "transactions.get_sales_tax". More...
 
int Quantity [get, set]
 Maps to "_quantity" argument of the function "transactions.get_sales_tax". More...
 
decimal Discount [get, set]
 Maps to "_discount" argument of the function "transactions.get_sales_tax". More...
 
decimal ShippingCharge [get, set]
 Maps to "_shipping_charge" argument of the function "transactions.get_sales_tax". More...
 
int SalesTaxId [get, set]
 Maps to "_sales_tax_id" argument of the function "transactions.get_sales_tax". 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_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database.

MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.GetSalesTaxProcedure ( string  tranBook,
int  storeId,
string  partyCode,
string  shippingAddressCode,
int  priceTypeId,
string  itemCode,
decimal  price,
int  quantity,
decimal  discount,
decimal  shippingCharge,
int  salesTaxId 
)

Prepares, validates, and executes the function "transactions.get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer)" on the database.

Parameters
tranBookEnter argument value for "_tran_book" parameter of the function "transactions.get_sales_tax".
storeIdEnter argument value for "_store_id" parameter of the function "transactions.get_sales_tax".
partyCodeEnter argument value for "_party_code" parameter of the function "transactions.get_sales_tax".
shippingAddressCodeEnter argument value for "_shipping_address_code" parameter of the function "transactions.get_sales_tax".
priceTypeIdEnter argument value for "_price_type_id" parameter of the function "transactions.get_sales_tax".
itemCodeEnter argument value for "_item_code" parameter of the function "transactions.get_sales_tax".
priceEnter argument value for "_price" parameter of the function "transactions.get_sales_tax".
quantityEnter argument value for "_quantity" parameter of the function "transactions.get_sales_tax".
discountEnter argument value for "_discount" parameter of the function "transactions.get_sales_tax".
shippingChargeEnter argument value for "_shipping_charge" parameter of the function "transactions.get_sales_tax".
salesTaxIdEnter argument value for "_sales_tax_id" parameter of the function "transactions.get_sales_tax".

Member Function Documentation

IEnumerable<DbGetSalesTaxResult> MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.Execute ( )

Prepares and executes the function "transactions.get_sales_tax".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.ObjectName => "get_sales_tax"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

Login id of application user accessing this PostgreSQL function.

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

User id of application user accessing this table.

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

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

decimal MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.Discount
getset

Maps to "_discount" argument of the function "transactions.get_sales_tax".

string MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.ItemCode
getset

Maps to "_item_code" argument of the function "transactions.get_sales_tax".

string MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.PartyCode
getset

Maps to "_party_code" argument of the function "transactions.get_sales_tax".

decimal MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.Price
getset

Maps to "_price" argument of the function "transactions.get_sales_tax".

int MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.PriceTypeId
getset

Maps to "_price_type_id" argument of the function "transactions.get_sales_tax".

int MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.Quantity
getset

Maps to "_quantity" argument of the function "transactions.get_sales_tax".

int MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.SalesTaxId
getset

Maps to "_sales_tax_id" argument of the function "transactions.get_sales_tax".

string MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.ShippingAddressCode
getset

Maps to "_shipping_address_code" argument of the function "transactions.get_sales_tax".

decimal MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.ShippingCharge
getset

Maps to "_shipping_charge" argument of the function "transactions.get_sales_tax".

int MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.StoreId
getset

Maps to "_store_id" argument of the function "transactions.get_sales_tax".

string MixERP.Net.Schemas.Transactions.Data.GetSalesTaxProcedure.TranBook
getset

Maps to "_tran_book" argument of the function "transactions.get_sales_tax".


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