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

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

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

IEnumerable< MixERP.Net.Entities.Core.Filter >	Get ()
	Executes a select query on the table "core.filters" to return a all instances of the "Filter" class to export. More...

MixERP.Net.Entities.Core.Filter	Get (long filterId)
	Executes a select query on the table "core.filters" with a where filter on the column "filter_id" to return a single instance of the "Filter" class. More...

IEnumerable< MixERP.Net.Entities.Core.Filter >	Get (long[] filterIds)
	Executes a select query on the table "core.filters" with a where filter on the column "filter_id" to return a multiple instances of the "Filter" class. More...

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

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

void	AddOrEdit (MixERP.Net.Entities.Core.Filter filter, List< EntityParser.CustomField > customFields)
	Inserts or updates the instance of Filter class on the database table "core.filters". More...

object	Add (MixERP.Net.Entities.Core.Filter filter)
	Inserts the instance of Filter class on the database table "core.filters". More...

List< object >	BulkImport (List< MixERP.Net.Entities.Core.Filter > filters)
	Inserts or updates multiple instances of Filter class on the database table "core.filters"; More...

void	Update (MixERP.Net.Entities.Core.Filter filter, long filterId)
	Updates the row of the table "core.filters" with an instance of "Filter" class against the primary key value. More...

void	Delete (long filterId)
	Deletes the row of the table "core.filters" against the primary key value. More...

IEnumerable< MixERP.Net.Entities.Core.Filter >	GetPagedResult ()
	Performs a select statement on table "core.filters" producing a paged result of 25. More...

IEnumerable< MixERP.Net.Entities.Core.Filter >	GetPagedResult (long pageNumber)
	Performs a select statement on table "core.filters" producing a paged result of 25. More...

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

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

long	CountFiltered (string filterName)
	Performs a filtered count on table "core.filters". More...

IEnumerable< MixERP.Net.Entities.Core.Filter >	GetFiltered (long pageNumber, string filterName)
	Performs a filtered select statement on table "core.filters" producing a paged result of 25. More...

void	RecreateFilters (string objectName, string filterName, List< MixERP.Net.Entities.Core.Filter > filters)

void	MakeDefault (string objectName, string filterName)

void	RemoveDefault (string objectName)

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 table. Returns literal "core". More...

override string	ObjectName => "filters"
	The schema unqualified name of this table. Returns literal "filters". 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 "core.filters".

Member Function Documentation

object MixERP.Net.Schemas.Core.Data.Filter.Add ( MixERP.Net.Entities.Core.Filter filter )

Inserts the instance of Filter class on the database table "core.filters".

Parameters

filter The instance of "Filter" class to insert.

Exceptions

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

void MixERP.Net.Schemas.Core.Data.Filter.AddOrEdit	(	MixERP.Net.Entities.Core.Filter	filter,
		List< EntityParser.CustomField >	customFields
	)

Inserts or updates the instance of Filter class on the database table "core.filters".

Parameters

filter	The instance of "Filter" 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.Core.Data.Filter.BulkImport ( List< MixERP.Net.Entities.Core.Filter > filters )

Inserts or updates multiple instances of Filter class on the database table "core.filters";

Parameters

filters List of "Filter" class to import.

Returns

long MixERP.Net.Schemas.Core.Data.Filter.Count ( )

Performs SQL count on the table "core.filters".

Returns: Returns the number of rows of the table "core.filters".

Exceptions

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

long MixERP.Net.Schemas.Core.Data.Filter.CountFiltered ( string filterName )

Performs a filtered count on table "core.filters".

Parameters

filterName The named filter.

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

Exceptions

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

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

Performs a filtered count on table "core.filters".

Parameters

filters The list of filter conditions.

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

Exceptions

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

void MixERP.Net.Schemas.Core.Data.Filter.Delete ( long filterId )

Deletes the row of the table "core.filters" against the primary key value.

Parameters

filterId The value of the column "filter_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.Core.Filter> MixERP.Net.Schemas.Core.Data.Filter.Get ( )

Executes a select query on the table "core.filters" to return a all instances of the "Filter" class to export.

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

Exceptions

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

MixERP.Net.Entities.Core.Filter MixERP.Net.Schemas.Core.Data.Filter.Get ( long filterId )

Executes a select query on the table "core.filters" with a where filter on the column "filter_id" to return a single instance of the "Filter" class.

Parameters

filterId The column "filter_id" parameter used on where filter.

Returns: Returns a non-live, non-mapped instance of "Filter" 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.Core.Filter> MixERP.Net.Schemas.Core.Data.Filter.Get ( long[] filterIds )

Executes a select query on the table "core.filters" with a where filter on the column "filter_id" to return a multiple instances of the "Filter" class.

Parameters

filterIds Array of column "filter_id" parameter used on where filter.

Returns: Returns a non-live, non-mapped collection of "Filter" 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.Core.Data.Filter.GetCustomFields ( string resourceId )

Custom fields are user defined form elements for core.filters.

Returns: Returns an enumerable custom field collection for the table core.filters

Exceptions

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

IEnumerable<DisplayField> MixERP.Net.Schemas.Core.Data.Filter.GetDisplayFields ( )

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

Returns: Returns an enumerable name and value collection for the table core.filters

Exceptions

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

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

Performs a filtered select statement on table "core.filters" 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 "Filter" class.

Exceptions

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

IEnumerable<MixERP.Net.Entities.Core.Filter> MixERP.Net.Schemas.Core.Data.Filter.GetPagedResult ( )

Performs a select statement on table "core.filters" producing a paged result of 25.

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

Exceptions

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

IEnumerable<MixERP.Net.Entities.Core.Filter> MixERP.Net.Schemas.Core.Data.Filter.GetPagedResult ( long pageNumber )

Performs a select statement on table "core.filters" producing a paged result of 25.

Parameters

pageNumber Enter the page number to produce the paged result.

Returns: Returns collection of "Filter" class.

Exceptions

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

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

Performs a filtered select statement on table "core.filters" 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 "Filter" class.

Exceptions

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

void MixERP.Net.Schemas.Core.Data.Filter.Update	(	MixERP.Net.Entities.Core.Filter	filter,
		long	filterId
	)

Updates the row of the table "core.filters" with an instance of "Filter" class against the primary key value.

Parameters

filter	The instance of "Filter" class to update.
filterId	The value of the column "filter_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.Core.Data.Filter.ObjectName => "filters"

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

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

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

Property Documentation

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

getset

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

long MixERP.Net.Schemas.Core.Data.Filter.LoginId

getset

Login id of application user accessing this table.

int MixERP.Net.Schemas.Core.Data.Filter.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/Core/Filter.cs

Public Member Functions

Public Attributes

Properties

Detailed Description

Member Function Documentation

Member Data Documentation

Property Documentation