Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database. More...

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

Public Member Functions
	PostSalesProcedure ()
	Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database. More...

	PostSalesProcedure (string bookName, int officeId, int userId, long loginIdParameter, DateTime valueDate, int costCenterId, string referenceNumber, string statementReference, bool isCredit, int paymentTermId, string partyCode, int priceTypeId, int salespersonId, int shipperId, string shippingAddressCode, int storeId, bool isNonTaxableSales, MixERP.Net.Entities.Transactions.StockDetailType[][] details, MixERP.Net.Entities.Core.AttachmentType[][] attachments, long[] nonGlTranIds)
	Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database. More...

long	Execute ()
	Prepares and executes the function "transactions.post_sales". 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 => "post_sales"
	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	BookName `[get, set]`
	Maps to "_book_name" argument of the function "transactions.post_sales". More...

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

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

long	LoginIdParameter `[get, set]`
	Maps to "_login_id" argument of the function "transactions.post_sales". More...

DateTime	ValueDate `[get, set]`
	Maps to "_value_date" argument of the function "transactions.post_sales". More...

int	CostCenterId `[get, set]`
	Maps to "_cost_center_id" argument of the function "transactions.post_sales". More...

string	ReferenceNumber `[get, set]`
	Maps to "_reference_number" argument of the function "transactions.post_sales". More...

string	StatementReference `[get, set]`
	Maps to "_statement_reference" argument of the function "transactions.post_sales". More...

bool	IsCredit `[get, set]`
	Maps to "_is_credit" argument of the function "transactions.post_sales". More...

int	PaymentTermId `[get, set]`
	Maps to "_payment_term_id" argument of the function "transactions.post_sales". More...

string	PartyCode `[get, set]`
	Maps to "_party_code" argument of the function "transactions.post_sales". More...

int	PriceTypeId `[get, set]`
	Maps to "_price_type_id" argument of the function "transactions.post_sales". More...

int	SalespersonId `[get, set]`
	Maps to "_salesperson_id" argument of the function "transactions.post_sales". More...

int	ShipperId `[get, set]`
	Maps to "_shipper_id" argument of the function "transactions.post_sales". More...

string	ShippingAddressCode `[get, set]`
	Maps to "_shipping_address_code" argument of the function "transactions.post_sales". More...

int	StoreId `[get, set]`
	Maps to "_store_id" argument of the function "transactions.post_sales". More...

bool	IsNonTaxableSales `[get, set]`
	Maps to "_is_non_taxable_sales" argument of the function "transactions.post_sales". More...

MixERP.Net.Entities.Transactions.StockDetailType[][]	Details `[get, set]`
	Maps to "_details" argument of the function "transactions.post_sales". More...

MixERP.Net.Entities.Core.AttachmentType[][]	Attachments `[get, set]`
	Maps to "_attachments" argument of the function "transactions.post_sales". More...

long[]	NonGlTranIds `[get, set]`
	Maps to "_non_gl_tran_ids" argument of the function "transactions.post_sales". 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.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database.

Constructor & Destructor Documentation

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

Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database.

MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.PostSalesProcedure	(	string	bookName,
		int	officeId,
		int	userId,
		long	loginIdParameter,
		DateTime	valueDate,
		int	costCenterId,
		string	referenceNumber,
		string	statementReference,
		bool	isCredit,
		int	paymentTermId,
		string	partyCode,
		int	priceTypeId,
		int	salespersonId,
		int	shipperId,
		string	shippingAddressCode,
		int	storeId,
		bool	isNonTaxableSales,
		MixERP.Net.Entities.Transactions.StockDetailType	details[][],
		MixERP.Net.Entities.Core.AttachmentType	attachments[][],
		long[]	nonGlTranIds
	)

Prepares, validates, and executes the function "transactions.post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[], _non_gl_tran_ids bigint[])" on the database.

Parameters

bookName	Enter argument value for "_book_name" parameter of the function "transactions.post_sales".
officeId	Enter argument value for "_office_id" parameter of the function "transactions.post_sales".
userId	Enter argument value for "_user_id" parameter of the function "transactions.post_sales".
loginIdParameter	Enter argument value for "_login_id" parameter of the function "transactions.post_sales".
valueDate	Enter argument value for "_value_date" parameter of the function "transactions.post_sales".
costCenterId	Enter argument value for "_cost_center_id" parameter of the function "transactions.post_sales".
referenceNumber	Enter argument value for "_reference_number" parameter of the function "transactions.post_sales".
statementReference	Enter argument value for "_statement_reference" parameter of the function "transactions.post_sales".
isCredit	Enter argument value for "_is_credit" parameter of the function "transactions.post_sales".
paymentTermId	Enter argument value for "_payment_term_id" parameter of the function "transactions.post_sales".
partyCode	Enter argument value for "_party_code" parameter of the function "transactions.post_sales".
priceTypeId	Enter argument value for "_price_type_id" parameter of the function "transactions.post_sales".
salespersonId	Enter argument value for "_salesperson_id" parameter of the function "transactions.post_sales".
shipperId	Enter argument value for "_shipper_id" parameter of the function "transactions.post_sales".
shippingAddressCode	Enter argument value for "_shipping_address_code" parameter of the function "transactions.post_sales".
storeId	Enter argument value for "_store_id" parameter of the function "transactions.post_sales".
isNonTaxableSales	Enter argument value for "_is_non_taxable_sales" parameter of the function "transactions.post_sales".
details	Enter argument value for "_details" parameter of the function "transactions.post_sales".
attachments	Enter argument value for "_attachments" parameter of the function "transactions.post_sales".
nonGlTranIds	Enter argument value for "_non_gl_tran_ids" parameter of the function "transactions.post_sales".

Member Function Documentation

long MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.Execute ( )

Prepares and executes the function "transactions.post_sales".

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.ObjectName => "post_sales"

The schema unqualified name of this PostgreSQL function.

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

The schema of this PostgreSQL function.

Property Documentation

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

getset

Login id of application user accessing this PostgreSQL function.

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

getset

User id of application user accessing this table.

MixERP.Net.Entities.Core.AttachmentType [][] MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.Attachments

getset

Maps to "_attachments" argument of the function "transactions.post_sales".

string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.BookName

getset

Maps to "_book_name" argument of the function "transactions.post_sales".

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

getset

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

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.CostCenterId

getset

Maps to "_cost_center_id" argument of the function "transactions.post_sales".

MixERP.Net.Entities.Transactions.StockDetailType [][] MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.Details

getset

Maps to "_details" argument of the function "transactions.post_sales".

bool MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.IsCredit

getset

Maps to "_is_credit" argument of the function "transactions.post_sales".

bool MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.IsNonTaxableSales

getset

Maps to "_is_non_taxable_sales" argument of the function "transactions.post_sales".

long MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.LoginIdParameter

getset

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

long [] MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.NonGlTranIds

getset

Maps to "_non_gl_tran_ids" argument of the function "transactions.post_sales".

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

getset

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

string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.PartyCode

getset

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

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.PaymentTermId

getset

Maps to "_payment_term_id" argument of the function "transactions.post_sales".

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.PriceTypeId

getset

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

string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.ReferenceNumber

getset

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

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.SalespersonId

getset

Maps to "_salesperson_id" argument of the function "transactions.post_sales".

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.ShipperId

getset

Maps to "_shipper_id" argument of the function "transactions.post_sales".

string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.ShippingAddressCode

getset

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

string MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.StatementReference

getset

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

int MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.StoreId

getset

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

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

getset

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

DateTime MixERP.Net.Schemas.Transactions.Data.PostSalesProcedure.ValueDate

getset

Maps to "_value_date" argument of the function "transactions.post_sales".

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

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

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation