Prepares, validates, and executes the function "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database. More...

Inheritance diagram for MixERP.Net.Schemas.Office.Data.AddOfficeProcedure:

Public Member Functions
	AddOfficeProcedure ()
	Prepares, validates, and executes the function "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database. More...

	AddOfficeProcedure (string officeCode, string officeName, string nickName, DateTime registrationDate, string currencyCode, string currencySymbol, string currencyName, string hundredthName, string fiscalYearCode, string fiscalYearName, DateTime startsFrom, DateTime endsOn, bool salesTaxIsVat, bool hasStateSalesTax, bool hasCountySalesTax, int quotationValidDays, decimal incomeTaxRate, int weekStartDay, DateTime transactionStartDate, bool isPerpetual, string invValuationMethod, string logoFile, string adminName, string userName, string password)
	Prepares, validates, and executes the function "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database. More...

void	Execute ()
	Prepares and executes the function "office.add_office". 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 => "office"
	The schema of this PostgreSQL function. More...

override string	ObjectName => "add_office"
	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	OfficeCode `[get, set]`
	Maps to "_office_code" argument of the function "office.add_office". More...

string	OfficeName `[get, set]`
	Maps to "_office_name" argument of the function "office.add_office". More...

string	NickName `[get, set]`
	Maps to "_nick_name" argument of the function "office.add_office". More...

DateTime	RegistrationDate `[get, set]`
	Maps to "_registration_date" argument of the function "office.add_office". More...

string	CurrencyCode `[get, set]`
	Maps to "_currency_code" argument of the function "office.add_office". More...

string	CurrencySymbol `[get, set]`
	Maps to "_currency_symbol" argument of the function "office.add_office". More...

string	CurrencyName `[get, set]`
	Maps to "_currency_name" argument of the function "office.add_office". More...

string	HundredthName `[get, set]`
	Maps to "_hundredth_name" argument of the function "office.add_office". More...

string	FiscalYearCode `[get, set]`
	Maps to "_fiscal_year_code" argument of the function "office.add_office". More...

string	FiscalYearName `[get, set]`
	Maps to "_fiscal_year_name" argument of the function "office.add_office". More...

DateTime	StartsFrom `[get, set]`
	Maps to "_starts_from" argument of the function "office.add_office". More...

DateTime	EndsOn `[get, set]`
	Maps to "_ends_on" argument of the function "office.add_office". More...

bool	SalesTaxIsVat `[get, set]`
	Maps to "_sales_tax_is_vat" argument of the function "office.add_office". More...

bool	HasStateSalesTax `[get, set]`
	Maps to "_has_state_sales_tax" argument of the function "office.add_office". More...

bool	HasCountySalesTax `[get, set]`
	Maps to "_has_county_sales_tax" argument of the function "office.add_office". More...

int	QuotationValidDays `[get, set]`
	Maps to "_quotation_valid_days" argument of the function "office.add_office". More...

decimal	IncomeTaxRate `[get, set]`
	Maps to "_income_tax_rate" argument of the function "office.add_office". More...

int	WeekStartDay `[get, set]`
	Maps to "_week_start_day" argument of the function "office.add_office". More...

DateTime	TransactionStartDate `[get, set]`
	Maps to "_transaction_start_date" argument of the function "office.add_office". More...

bool	IsPerpetual `[get, set]`
	Maps to "_is_perpetual" argument of the function "office.add_office". More...

string	InvValuationMethod `[get, set]`
	Maps to "_inv_valuation_method" argument of the function "office.add_office". More...

string	LogoFile `[get, set]`
	Maps to "_logo_file" argument of the function "office.add_office". More...

string	AdminName `[get, set]`
	Maps to "_admin_name" argument of the function "office.add_office". More...

string	UserName `[get, set]`
	Maps to "_user_name" argument of the function "office.add_office". More...

string	Password `[get, set]`
	Maps to "_password" argument of the function "office.add_office". 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 "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database.

Constructor & Destructor Documentation

MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.AddOfficeProcedure ( )

Prepares, validates, and executes the function "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database.

MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.AddOfficeProcedure	(	string	officeCode,
		string	officeName,
		string	nickName,
		DateTime	registrationDate,
		string	currencyCode,
		string	currencySymbol,
		string	currencyName,
		string	hundredthName,
		string	fiscalYearCode,
		string	fiscalYearName,
		DateTime	startsFrom,
		DateTime	endsOn,
		bool	salesTaxIsVat,
		bool	hasStateSalesTax,
		bool	hasCountySalesTax,
		int	quotationValidDays,
		decimal	incomeTaxRate,
		int	weekStartDay,
		DateTime	transactionStartDate,
		bool	isPerpetual,
		string	invValuationMethod,
		string	logoFile,
		string	adminName,
		string	userName,
		string	password
	)

Prepares, validates, and executes the function "office.add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _fiscal_year_code character varying, _fiscal_year_name character varying, _starts_from date, _ends_on date, _sales_tax_is_vat boolean, _has_state_sales_tax boolean, _has_county_sales_tax boolean, _quotation_valid_days integer, _income_tax_rate numeric, _week_start_day integer, _transaction_start_date date, _is_perpetual boolean, _inv_valuation_method character varying, _logo_file text, _admin_name character varying, _user_name character varying, _password character varying)" on the database.

Parameters

officeCode	Enter argument value for "_office_code" parameter of the function "office.add_office".
officeName	Enter argument value for "_office_name" parameter of the function "office.add_office".
nickName	Enter argument value for "_nick_name" parameter of the function "office.add_office".
registrationDate	Enter argument value for "_registration_date" parameter of the function "office.add_office".
currencyCode	Enter argument value for "_currency_code" parameter of the function "office.add_office".
currencySymbol	Enter argument value for "_currency_symbol" parameter of the function "office.add_office".
currencyName	Enter argument value for "_currency_name" parameter of the function "office.add_office".
hundredthName	Enter argument value for "_hundredth_name" parameter of the function "office.add_office".
fiscalYearCode	Enter argument value for "_fiscal_year_code" parameter of the function "office.add_office".
fiscalYearName	Enter argument value for "_fiscal_year_name" parameter of the function "office.add_office".
startsFrom	Enter argument value for "_starts_from" parameter of the function "office.add_office".
endsOn	Enter argument value for "_ends_on" parameter of the function "office.add_office".
salesTaxIsVat	Enter argument value for "_sales_tax_is_vat" parameter of the function "office.add_office".
hasStateSalesTax	Enter argument value for "_has_state_sales_tax" parameter of the function "office.add_office".
hasCountySalesTax	Enter argument value for "_has_county_sales_tax" parameter of the function "office.add_office".
quotationValidDays	Enter argument value for "_quotation_valid_days" parameter of the function "office.add_office".
incomeTaxRate	Enter argument value for "_income_tax_rate" parameter of the function "office.add_office".
weekStartDay	Enter argument value for "_week_start_day" parameter of the function "office.add_office".
transactionStartDate	Enter argument value for "_transaction_start_date" parameter of the function "office.add_office".
isPerpetual	Enter argument value for "_is_perpetual" parameter of the function "office.add_office".
invValuationMethod	Enter argument value for "_inv_valuation_method" parameter of the function "office.add_office".
logoFile	Enter argument value for "_logo_file" parameter of the function "office.add_office".
adminName	Enter argument value for "_admin_name" parameter of the function "office.add_office".
userName	Enter argument value for "_user_name" parameter of the function "office.add_office".
password	Enter argument value for "_password" parameter of the function "office.add_office".

Member Function Documentation

void MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.Execute ( )

Prepares and executes the function "office.add_office".

Member Data Documentation

override string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.ObjectName => "add_office"

The schema unqualified name of this PostgreSQL function.

override string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.ObjectNamespace => "office"

The schema of this PostgreSQL function.

Property Documentation

long MixERP.Net.Schemas.Office.Data.AddOfficeProcedure._LoginId

getset

Login id of application user accessing this PostgreSQL function.

int MixERP.Net.Schemas.Office.Data.AddOfficeProcedure._UserId

getset

User id of application user accessing this table.

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.AdminName

getset

Maps to "_admin_name" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.Catalog

getset

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

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.CurrencyCode

getset

Maps to "_currency_code" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.CurrencyName

getset

Maps to "_currency_name" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.CurrencySymbol

getset

Maps to "_currency_symbol" argument of the function "office.add_office".

DateTime MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.EndsOn

getset

Maps to "_ends_on" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.FiscalYearCode

getset

Maps to "_fiscal_year_code" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.FiscalYearName

getset

Maps to "_fiscal_year_name" argument of the function "office.add_office".

bool MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.HasCountySalesTax

getset

Maps to "_has_county_sales_tax" argument of the function "office.add_office".

bool MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.HasStateSalesTax

getset

Maps to "_has_state_sales_tax" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.HundredthName

getset

Maps to "_hundredth_name" argument of the function "office.add_office".

decimal MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.IncomeTaxRate

getset

Maps to "_income_tax_rate" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.InvValuationMethod

getset

Maps to "_inv_valuation_method" argument of the function "office.add_office".

bool MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.IsPerpetual

getset

Maps to "_is_perpetual" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.LogoFile

getset

Maps to "_logo_file" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.NickName

getset

Maps to "_nick_name" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.OfficeCode

getset

Maps to "_office_code" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.OfficeName

getset

Maps to "_office_name" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.Password

getset

Maps to "_password" argument of the function "office.add_office".

int MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.QuotationValidDays

getset

Maps to "_quotation_valid_days" argument of the function "office.add_office".

DateTime MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.RegistrationDate

getset

Maps to "_registration_date" argument of the function "office.add_office".

bool MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.SalesTaxIsVat

getset

Maps to "_sales_tax_is_vat" argument of the function "office.add_office".

DateTime MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.StartsFrom

getset

Maps to "_starts_from" argument of the function "office.add_office".

DateTime MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.TransactionStartDate

getset

Maps to "_transaction_start_date" argument of the function "office.add_office".

string MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.UserName

getset

Maps to "_user_name" argument of the function "office.add_office".

int MixERP.Net.Schemas.Office.Data.AddOfficeProcedure.WeekStartDay

getset

Maps to "_week_start_day" argument of the function "office.add_office".

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

C:/Users/nirvan/Desktop/mixerp/0. GitHub/src/Libraries/DAL/Office/AddOfficeProcedure.cs

Public Member Functions

Public Attributes

Properties

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation