MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure Class Reference

Prepares, validates, and executes the function "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database. More...

Inheritance diagram for MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure:

Public Member Functions
	CalculateInterestProcedure ()
	Prepares, validates, and executes the function "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database. More...
	CalculateInterestProcedure (decimal principal, decimal rate, int days, int roundUp, int numOfDaysInYear)
	Prepares, validates, and executes the function "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database. More...
decimal	Execute ()
	Prepares and executes the function "core.calculate_interest". 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 => "core"
	The schema of this PostgreSQL function. More...
override string	ObjectName => "calculate_interest"
	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...
decimal	Principal [get, set]
	Maps to "principal" argument of the function "core.calculate_interest". More...
decimal	Rate [get, set]
	Maps to "rate" argument of the function "core.calculate_interest". More...
int	Days [get, set]
	Maps to "days" argument of the function "core.calculate_interest". More...
int	RoundUp [get, set]
	Maps to "round_up" argument of the function "core.calculate_interest". More...
int	NumOfDaysInYear [get, set]
	Maps to "num_of_days_in_year" argument of the function "core.calculate_interest". 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 "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database.

Constructor & Destructor Documentation

MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.CalculateInterestProcedure

(

)

Prepares, validates, and executes the function "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database.

MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.CalculateInterestProcedure	(	decimal	principal,
		decimal	rate,
		int	days,
		int	roundUp,
		int	numOfDaysInYear
	)

Prepares, validates, and executes the function "core.calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)" on the database.

Parameters

principal	Enter argument value for "principal" parameter of the function "core.calculate_interest".
rate	Enter argument value for "rate" parameter of the function "core.calculate_interest".
days	Enter argument value for "days" parameter of the function "core.calculate_interest".
roundUp	Enter argument value for "round_up" parameter of the function "core.calculate_interest".
numOfDaysInYear	Enter argument value for "num_of_days_in_year" parameter of the function "core.calculate_interest".

Member Function Documentation

decimal MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.Execute

(

)

Prepares and executes the function "core.calculate_interest".

Member Data Documentation

override string MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.ObjectName => "calculate_interest"

The schema unqualified name of this PostgreSQL function.

override string MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.ObjectNamespace => "core"

The schema of this PostgreSQL function.

Property Documentation

long MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure._LoginId

getset

Login id of application user accessing this PostgreSQL function.

int MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure._UserId

getset

User id of application user accessing this table.

string MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.Catalog

getset

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

int MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.Days

getset

Maps to "days" argument of the function "core.calculate_interest".

int MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.NumOfDaysInYear

getset

Maps to "num_of_days_in_year" argument of the function "core.calculate_interest".

decimal MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.Principal

getset

Maps to "principal" argument of the function "core.calculate_interest".

decimal MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.Rate

getset

Maps to "rate" argument of the function "core.calculate_interest".

int MixERP.Net.Schemas.Core.Data.CalculateInterestProcedure.RoundUp

getset

Maps to "round_up" argument of the function "core.calculate_interest".

---

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

• C:/Users/nirvan/Desktop/mixerp/0. GitHub/src/Libraries/DAL/Core/CalculateInterestProcedure.cs