Provides simplified data access features to perform SCRUD operation on the database table "transactions.routines". More...

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

Public Member Functions
long	Count ()
	Performs SQL count on the table "transactions.routines". More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	Get ()
	Executes a select query on the table "transactions.routines" to return a all instances of the "Routine" class to export. More...

MixERP.Net.Entities.Transactions.Routine	Get (int routineId)
	Executes a select query on the table "transactions.routines" with a where filter on the column "routine_id" to return a single instance of the "Routine" class. More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	Get (int[] routineIds)
	Executes a select query on the table "transactions.routines" with a where filter on the column "routine_id" to return a multiple instances of the "Routine" class. More...

IEnumerable< PetaPoco.CustomField >	GetCustomFields (string resourceId)
	Custom fields are user defined form elements for transactions.routines. More...

IEnumerable< DisplayField >	GetDisplayFields ()
	Displayfields provide a minimal name/value context for data binding the row collection of transactions.routines. More...

void	AddOrEdit (MixERP.Net.Entities.Transactions.Routine routine, List< EntityParser.CustomField > customFields)
	Inserts or updates the instance of Routine class on the database table "transactions.routines". More...

object	Add (MixERP.Net.Entities.Transactions.Routine routine)
	Inserts the instance of Routine class on the database table "transactions.routines". More...

List< object >	BulkImport (List< MixERP.Net.Entities.Transactions.Routine > routines)
	Inserts or updates multiple instances of Routine class on the database table "transactions.routines"; More...

void	Update (MixERP.Net.Entities.Transactions.Routine routine, int routineId)
	Updates the row of the table "transactions.routines" with an instance of "Routine" class against the primary key value. More...

void	Delete (int routineId)
	Deletes the row of the table "transactions.routines" against the primary key value. More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	GetPagedResult ()
	Performs a select statement on table "transactions.routines" producing a paged result of 25. More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	GetPagedResult (long pageNumber)
	Performs a select statement on table "transactions.routines" producing a paged result of 25. More...

long	CountWhere (List< EntityParser.Filter > filters)
	Performs a filtered count on table "transactions.routines". More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	GetWhere (long pageNumber, List< EntityParser.Filter > filters)
	Performs a filtered select statement on table "transactions.routines" producing a paged result of 25. More...

long	CountFiltered (string filterName)
	Performs a filtered count on table "transactions.routines". More...

IEnumerable< MixERP.Net.Entities.Transactions.Routine >	GetFiltered (long pageNumber, string filterName)
	Performs a filtered select statement on table "transactions.routines" producing a paged result of 25. 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 table. Returns literal "transactions". More...

override string	ObjectName => "routines"
	The schema unqualified name of this table. Returns literal "routines". More...

Properties
long	LoginId `[get, set]`
	Login id of application user accessing this table. 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...

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

Provides simplified data access features to perform SCRUD operation on the database table "transactions.routines".

Member Function Documentation

object MixERP.Net.Schemas.Transactions.Data.Routine.Add ( MixERP.Net.Entities.Transactions.Routine routine )

Inserts the instance of Routine class on the database table "transactions.routines".

Parameters

routine The instance of "Routine" class to insert.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

void MixERP.Net.Schemas.Transactions.Data.Routine.AddOrEdit	(	MixERP.Net.Entities.Transactions.Routine	routine,
		List< EntityParser.CustomField >	customFields
	)

Inserts or updates the instance of Routine class on the database table "transactions.routines".

Parameters

routine	The instance of "Routine" class to insert or update.
customFields	The custom field collection.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

List<object> MixERP.Net.Schemas.Transactions.Data.Routine.BulkImport ( List< MixERP.Net.Entities.Transactions.Routine > routines )

Inserts or updates multiple instances of Routine class on the database table "transactions.routines";

Parameters

routines List of "Routine" class to import.

Returns

long MixERP.Net.Schemas.Transactions.Data.Routine.Count ( )

Performs SQL count on the table "transactions.routines".

Returns: Returns the number of rows of the table "transactions.routines".

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

long MixERP.Net.Schemas.Transactions.Data.Routine.CountFiltered ( string filterName )

Performs a filtered count on table "transactions.routines".

Parameters

filterName The named filter.

Returns: Returns number of rows of "Routine" class using the filter.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

long MixERP.Net.Schemas.Transactions.Data.Routine.CountWhere ( List< EntityParser.Filter > filters )

Performs a filtered count on table "transactions.routines".

Parameters

filters The list of filter conditions.

Returns: Returns number of rows of "Routine" class using the filter.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

void MixERP.Net.Schemas.Transactions.Data.Routine.Delete ( int routineId )

Deletes the row of the table "transactions.routines" against the primary key value.

Parameters

routineId The value of the column "routine_id" which will be deleted.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.Get ( )

Executes a select query on the table "transactions.routines" to return a all instances of the "Routine" class to export.

Returns: Returns a non-live, non-mapped instances of "Routine" class.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

MixERP.Net.Entities.Transactions.Routine MixERP.Net.Schemas.Transactions.Data.Routine.Get ( int routineId )

Executes a select query on the table "transactions.routines" with a where filter on the column "routine_id" to return a single instance of the "Routine" class.

Parameters

routineId The column "routine_id" parameter used on where filter.

Returns: Returns a non-live, non-mapped instance of "Routine" class mapped to the database row.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.Get ( int[] routineIds )

Executes a select query on the table "transactions.routines" with a where filter on the column "routine_id" to return a multiple instances of the "Routine" class.

Parameters

routineIds Array of column "routine_id" parameter used on where filter.

Returns: Returns a non-live, non-mapped collection of "Routine" class mapped to the database row.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<PetaPoco.CustomField> MixERP.Net.Schemas.Transactions.Data.Routine.GetCustomFields ( string resourceId )

Custom fields are user defined form elements for transactions.routines.

Returns: Returns an enumerable custom field collection for the table transactions.routines

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<DisplayField> MixERP.Net.Schemas.Transactions.Data.Routine.GetDisplayFields ( )

Displayfields provide a minimal name/value context for data binding the row collection of transactions.routines.

Returns: Returns an enumerable name and value collection for the table transactions.routines

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.GetFiltered	(	long	pageNumber,
		string	filterName
	)

Performs a filtered select statement on table "transactions.routines" producing a paged result of 25.

Parameters

pageNumber	Enter the page number to produce the paged result.
filterName	The named filter.

Returns: Returns collection of "Routine" class.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.GetPagedResult ( )

Performs a select statement on table "transactions.routines" producing a paged result of 25.

Returns: Returns the first page of collection of "Routine" class.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.GetPagedResult ( long pageNumber )

Performs a select statement on table "transactions.routines" producing a paged result of 25.

Parameters

pageNumber Enter the page number to produce the paged result.

Returns: Returns collection of "Routine" class.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

IEnumerable<MixERP.Net.Entities.Transactions.Routine> MixERP.Net.Schemas.Transactions.Data.Routine.GetWhere	(	long	pageNumber,
		List< EntityParser.Filter >	filters
	)

Performs a filtered select statement on table "transactions.routines" producing a paged result of 25.

Parameters

pageNumber	Enter the page number to produce the paged result.
filters	The list of filter conditions.

Returns: Returns collection of "Routine" class.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

void MixERP.Net.Schemas.Transactions.Data.Routine.Update	(	MixERP.Net.Entities.Transactions.Routine	routine,
		int	routineId
	)

Updates the row of the table "transactions.routines" with an instance of "Routine" class against the primary key value.

Parameters

routine	The instance of "Routine" class to update.
routineId	The value of the column "routine_id" which will be updated.

Exceptions

UnauthorizedException Thown when the application user does not have sufficient privilege to perform this action.

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.Routine.ObjectName => "routines"

The schema unqualified name of this table. Returns literal "routines".

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

The schema of this table. Returns literal "transactions".

Property Documentation

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

getset

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

long MixERP.Net.Schemas.Transactions.Data.Routine.LoginId

getset

Login id of application user accessing this table.

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

getset

User id of application user accessing this table.

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

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

Public Member Functions

Public Attributes

Properties

Detailed Description

Member Function Documentation

Member Data Documentation

Property Documentation